FormDataSources


Description

Form data source configuration - Configuration table defining data sources for dynamic forms and custom data collection instruments. This table manages the relationship between forms and their underlying database tables, field mappings, and data validation rules to support flexible form design, custom healthcare documentation, and automated data integration across the healthcare management system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID uniqueidentifier 16 null

Data source primary key - Unique identifier for each form data source configuration
Name nvarchar 500 null

Data source name - Descriptive name for the form data source
CoreTable nvarchar 200 null

Core table name - Name of the primary database table for this data source
CustomTable nvarchar 200 null

Custom table name - Name of the custom/extended table for additional fields
DefaultFields nvarchar 1073741823 √ null

Default fields - JSON configuration of default fields and their properties
DateCreated datetime 16,3 √ null

Creation date - Date when this data source configuration was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created this configuration
DateUpdated datetime 16,3 √ null

Last update date - Date when this configuration was last modified
DeletedDate datetime 16,3 √ null

Deletion date - Date when this configuration was soft deleted
KeyField nvarchar 200 √ null

Primary key field - Name of the primary key field in the core table
ForeignKeyField nvarchar 200 √ null

Foreign key field - Name of the foreign key field linking core and custom tables
PrimaryField nvarchar 200 √ null

Primary display field - Main field used for display and identification
CoreRequiredFields nvarchar 1073741823 √ null

Required fields - JSON list of required fields for data validation

Indexes

Constraint Name Type Sort Column(s)
PK_FormDataSources Primary key Asc ID

Relationships

Close relationships within degrees of separation