Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DataSourceID | Unknown | 0 | null |
|
|
Primary key - ComboBoxDataSources unique identifier for each data source |
||
| DisplayField | Unknown | 0 | null |
|
|
Display field - Database field used as the display text in the combo box |
||
| Id | int identity | 4 | √ | null |
|
|
Data field - Id information for ComboBoxDataSources business operations |
|
| DataSourceName | nvarchar | 100 | √ | null |
|
|
Data source name - Descriptive name of the data source |
|
| DataSourceType | nvarchar | 100 | √ | null |
|
|
Type classification - Category or classification type for ComboBoxDataSources records |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this data source is currently available |
||
| SQLQuery | Unknown | 0 | null |
|
|
SQL query - Query used to retrieve data for the combo box |
||
| ValueField | nvarchar | 100 | √ | null |
|
|
Value field - Database field used as the value in the combo box |
|
| TextField | nvarchar | 100 | √ | null |
|
|
Text field - TextField text information for ComboBoxDataSources records |
|
| Criteria | nvarchar | 1073741823 | √ | null |
|
|
Text field - Criteria text information for ComboBoxDataSources records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ComboBoxDataSources | Primary key | Asc | Id |