Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each form submission |
||||
| FormDesignId | int | 4 | null |
|
|
Form design reference - Links to the form design template used for this submission |
|||||
| Values | nvarchar | 1073741823 | √ | null |
|
|
Form values - JSON or XML data containing all form field values and responses |
||||
| EntryID | varchar | 100 | √ | null |
|
|
Entry identifier - External identifier for linking to related records |
||||
| SubmitDate | datetime | 16,3 | null |
|
|
Submission date - Date and time when the form was submitted |
|||||
| SubmitBy | int | 4 | null |
|
|
Submitted by user - UserID of the person who submitted the form |
|||||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
Modification date - Date when the form submission was last modified |
||||
| ModifiedBy | int | 4 | √ | null |
|
|
Modified by user - UserID of the person who last modified the submission |
||||
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the form submission was soft-deleted |
||||
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by user - UserID of the person who deleted the submission |
||||
| Referrer | nvarchar | 520 | √ | null |
|
|
Referrer URL - URL of the page that referred to this form |
||||
| IPAddress | varchar | 128 | √ | null |
|
|
IP address - IP address of the user who submitted the form |
||||
| OperatingSystem | nvarchar | 256 | √ | null |
|
|
Operating system - Operating system information from the user’s device |
||||
| Browser | nvarchar | 256 | √ | null |
|
|
Browser information - Web browser details from the user’s session |
||||
| City | nvarchar | 256 | √ | null |
|
|
User city - Geographic city location of the form submitter |
||||
| Country | nvarchar | 256 | √ | null |
|
|
User country - Geographic country location of the form submitter |
||||
| FillableFileId | nvarchar | 100 | √ | null |
|
|
Fillable file reference - Links to associated fillable PDF or document file |
||||
| IsLocked | bit | 1 | null |
|
|
Lock status - Boolean indicating if the form submission is locked from editing |
|||||
| IsDraft | bit | 1 | ((0)) |
|
|
Draft status - Boolean indicating if this is a draft submission |
|||||
| Table | varchar | 50 | √ | null |
|
|
Target table - Database table where this form data should be stored |
||||
| CreateByCategory | nvarchar | 30 | √ | null |
|
|
Creation category - Category or method used to create this form submission |
||||
| FileType | int | 4 | √ | null |
|
|
File type - Type of file associated with this form submission |
||||
| FormStatus | varchar | 20 | √ | null |
|
|
Form status - Current processing status of the form submission |
||||
| AdmitId | int | 4 | √ | null |
|
|
Admission reference - Links to patient admission/case if applicable |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FormSubmissions | Primary key | Asc | ID |
| IX_FormSubmissions | Performance | Asc/Asc/Asc | DeletedDate + SubmitDate + IsDraft |
| IX_FormSubmissions_EntryId | Performance | Asc/Asc | EntryID + DeletedDate |
| IX_FormSubmissions_FormDesignId | Performance | Asc | FormDesignId |
Relationships
Close relationships within degrees of separation
