Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ConnectionString | Unknown | 0 | null |
|
|
Connection string - Connection details for accessing the data source |
|||||
| pkDataSourceID | int identity | 4 | √ | null |
|
|
Primary key - DataSources unique identifier for each record |
||||
| DataSourceName | varchar | 100 | √ | null |
|
|
Data source name - Descriptive name of the data source |
||||
| DataSourceType | varchar | 50 | √ | null |
|
|
Data source type - Type of data source (Database, API, File, etc.) |
||||
| DataSource | varchar | 100 | √ | null |
|
|
Text field - DataSource text information for DataSources records |
||||
| Deleted | bit | 1 | √ | null |
|
|
Boolean flag - Indicates whether specific condition or feature is enabled/active |
||||
| Criteria | nvarchar | 1073741823 | √ | null |
|
|
Text field - Criteria text information for DataSources records |
||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this data source is currently available |
|||||
| IsiManagerOnly | bit | 1 | √ | null |
|
|
Boolean flag - Indicates whether specific condition or feature is enabled/active |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__DataSour__7771EC97560A9D62 | Primary key | Asc | pkDataSourceID |