Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | uniqueidentifier | 16 | null |
|
|
Primary key - Unique GUID identifier for each report data source |
||
| Name | nvarchar | 500 | null |
|
|
Data source name - Name of the data source for identification in reports |
||
| ViewName | nvarchar | 500 | √ | null |
|
|
View name - Name of the database view associated with this data source |
|
| TablesQuery | nvarchar | 1073741823 | null |
|
|
Tables query - SQL query defining the tables and columns for this data source |
||
| JoinQuery | nvarchar | 1073741823 | √ | null |
|
|
Join query - SQL join statements for combining multiple tables in this data source |
|
| PrimaryKey | nvarchar | 500 | √ | null |
|
|
Primary key field - Name of the primary key field for this data source |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when this data source was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this data source |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Date when this data source was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this data source |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when this data source was deleted (soft delete) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ReportDataSources | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
