Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each dynamic data source |
|
| Name | nchar | 500 | √ | null |
|
|
Data source name - Name of the dynamic data source |
|
| Query | nvarchar | 1073741823 | √ | null |
|
|
SQL query - SQL query that defines the data source |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if the data source is currently active |
||
| SourceID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each dynamic source |
||
| SourceName | Unknown | 0 | null |
|
|
Source name - Descriptive name for the data source |
||
| SourceQuery | Unknown | 0 | null |
|
|
Source query - SQL query or configuration that defines the data source |
||
| SourceType | Unknown | 0 | null |
|
|
Source type - Type of data source (SQL, View, Stored Procedure, etc.) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_DynamicSources | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
