Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| Name | nchar | 500 | √ | null |
|
|
Name field - Descriptive name or identifier for DynamicSources records |
|
| Query | nvarchar | 1073741823 | √ | null |
|
|
Text field - Query text information for DynamicSources records |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when deleted occurred or was recorded |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this dynamic source is currently available |
||
| Parameters | Unknown | 0 | null |
|
|
Parameters - JSON or XML definition of query parameters |
||
| SourceID | Unknown | 0 | null |
|
|
Primary key - DynamicSources unique identifier for each dynamic source |
||
| SourceName | Unknown | 0 | null |
|
|
Source name - Descriptive name of the dynamic data source |
||
| SourceQuery | Unknown | 0 | null |
|
|
Source query - SQL query or data retrieval logic |
||
| SourceType | Unknown | 0 | null |
|
|
Source type - Type of dynamic source (Query, View, Procedure, etc.) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_DynamicSources | Primary key | Asc | ID |