Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ConnectionString | Unknown | 0 | null |
|
|
Connection string - Database connection string for data access |
||
| ID | uniqueidentifier | 16 | null |
|
|
Primary key - Unique identifier for each form data source, auto-incrementing integer |
||
| Name | nvarchar | 500 | null |
|
|
Data source name - Display name of the data source |
||
| CoreTable | nvarchar | 200 | null |
|
|
Core table - Primary table for core system data (required field) |
||
| CreatedDate | Unknown | 0 | null |
|
|
Creation date - Date when the data source was created |
||
| CustomTable | nvarchar | 200 | null |
|
|
Custom table - Table for custom field data (required field) |
||
| DataSourceId | Unknown | 0 | null |
|
|
Data source identifier - Alternative identifier for the data source |
||
| DataSourceName | Unknown | 0 | null |
|
|
Data source name - Descriptive name of the form data source |
||
| DefaultFields | nvarchar | 1073741823 | √ | null |
|
|
Default fields - Default fields to include in forms using this data source |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this data source was first created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this data source |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this data source was most recently updated |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this data source was logically deleted |
|
| ForeignKeyField | nvarchar | 200 | √ | null |
|
|
Foreign key field - Field linking core and custom tables |
|
| CoreRequiredFields | nvarchar | 1073741823 | √ | null |
|
|
Core required fields - List of required fields in the core table |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if data source is currently active |
||
| KeyField | nvarchar | 200 | √ | null |
|
|
Primary key field - Name of the primary key field in the core table |
|
| ModifiedBy | Unknown | 0 | null |
|
|
Modifier user ID - User who last modified the data source |
||
| ModifiedDate | Unknown | 0 | null |
|
|
Modification timestamp - When the data source was last modified |
||
| PrimaryField | nvarchar | 200 | √ | null |
|
|
Primary field - Primary field for data source identification |
|
| Status | Unknown | 0 | null |
|
|
Data source status - Current status of the data source |
||
| UpdatedBy | Unknown | 0 | null |
|
|
Last modifier - User ID who made the most recent update |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FormDataSources | Primary key | Asc | ID |