Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ConnectionString | Unknown | 0 | null |
|
|
Connection string - Database connection string for accessing the data source |
||
| Id | int identity | 4 | √ | null |
|
|
Identifier - Alternative primary key identifier |
|
| FilterName | nvarchar | 400 | √ | null |
|
|
Filter name - Name of the filter configuration |
|
| FilterDesc | nvarchar | 1073741823 | √ | null |
|
|
Filter description - Description of the filter functionality |
|
| Criteria | nvarchar | 1073741823 | √ | null |
|
|
Filter criteria - Default criteria for filtering data |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this data source |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the data source was created |
|
| DatasourceId | nvarchar | 100 | √ | null |
|
|
Data source identifier - Alternative identifier for the data source |
|
| DataSourceName | Unknown | 0 | null |
|
|
Data source name - Descriptive name of the data source |
||
| DateCreated | Unknown | 0 | null |
|
|
Creation timestamp - When this data source was first created |
||
| DateUpdated | Unknown | 0 | null |
|
|
Last modification timestamp - When this data source was most recently updated |
||
| DisplayFields | Unknown | 0 | null |
|
|
Display fields - Fields to display in filter builder interface |
||
| FilterFields | Unknown | 0 | null |
|
|
Filterable fields - Fields available for filtering operations |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if data source is currently active |
||
| JoinTables | Unknown | 0 | null |
|
|
Related tables - Configuration for joining related tables |
||
| ParentId | nvarchar | 100 | √ | null |
|
|
Parent reference - Reference to parent data source for hierarchical organization |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update |
|
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Update date - Date when the data source was last updated |
|
| ParentType | nvarchar | 100 | √ | null |
|
|
Parent type - Type of parent relationship |
|
| OrderNumber | int | 4 | √ | null |
|
|
Order number - Numeric order for displaying data sources |
|
| IsDefault | bit | 1 | null |
|
|
Default flag - Boolean indicating if this is the default data source |
||
| TableName | Unknown | 0 | null |
|
|
Primary table - Main table name for this data source |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FilterBuilderDataSource | Primary key | Asc | Id |