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 that was submitted |
||
| Values | nvarchar | 1073741823 | √ | null |
|
|
Form values - JSON or serialized data containing all submitted form field values |
|
| EntryID | varchar | 100 | √ | null |
|
|
Entry identifier - Unique identifier for this form entry or submission |
|
| 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 |
|
|
Last modification date - Date when the 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 submission was deleted (soft delete) |
|
| 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 the form |
|
| IPAddress | varchar | 128 | √ | null |
|
|
IP address - IP address of the user who submitted the form |
|
| OperatingSystem | nvarchar | 256 | √ | null |
|
|
Operating system - Operating system of the user’s device |
|
| Browser | nvarchar | 256 | √ | null |
|
|
Browser information - Browser type and version used to submit the form |
|
| 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 identifier - ID of associated fillable PDF or document |
|
| IsLocked | bit | 1 | null |
|
|
Locked flag - Boolean indicating if the submission is locked from editing |
||
| IsDraft | bit | 1 | null |
|
|
Draft flag - Boolean indicating if this is a draft submission |
||
| Table | varchar | 50 | √ | null |
|
|
Associated table - Database table associated with this form submission |
|
| CreateByCategory | nvarchar | 30 | √ | null |
|
|
Creation category - Category or type of creation (Manual, Import, etc.) |
|
| FileType | int | 4 | √ | null |
|
|
File type - Type of file associated with the submission |
Relationships
Close relationships within degrees of separation
