Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each custom form, auto-incrementing integer |
|
| Name | nvarchar | 500 | null |
|
|
Form name - Display name of the custom form for identification (required field) |
||
| Level | nvarchar | 200 | √ | null |
|
|
Form level - Classification level or scope of the form (e.g., System, Agency, User) |
|
| CustomTable | nvarchar | 200 | √ | null |
|
|
Target table - Database table where form data will be stored |
|
| Description | nvarchar | 500 | √ | null |
|
|
Form description - Detailed description of the form purpose and usage |
|
| RedirectMessage | nvarchar | 500 | √ | null |
|
|
Success message - Message displayed to users after successful form submission |
|
| Url | nvarchar | 200 | √ | null |
|
|
Form URL - URL endpoint where the form is accessible |
|
| RedirectUrl | nvarchar | 200 | √ | null |
|
|
Redirect URL - URL to redirect users after form submission |
|
| Fields | nvarchar | 1073741823 | √ | null |
|
|
Field configuration - JSON or structured definition of form fields and their properties |
|
| KeyField | nvarchar | 200 | √ | null |
|
|
Primary key field - Name of the primary key field in the target table |
|
| ForeignKeyField | nvarchar | 200 | √ | null |
|
|
Foreign key field - Name of the foreign key field for relational data |
|
| IsDraft | bit | 1 | √ | null |
|
|
Draft status - Boolean indicating if form is in draft mode and not yet published |
|
| IsLocked | bit | 1 | √ | null |
|
|
Lock status - Boolean indicating if form is locked to prevent modifications |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When the custom form was first created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created the form |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When the form was most recently updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When the form was logically deleted |
|
| OneManyForm | bit | 1 | √ | null |
|
|
Relationship type - Boolean indicating if form supports one-to-many relationships |
|
| PrimaryField | nvarchar | 200 | √ | null |
|
|
Primary display field - Field to use as primary identifier in form displays |
|
| ShowTwoColumns | bit | 1 | √ | null |
|
|
Layout flag - Boolean indicating if form should display in two-column layout |
|
| fkDataSourceID | uniqueidentifier | 16 | √ | null |
|
|
Data source reference - Unique identifier linking to data source for form population |
|
| OnlyCustomFields | bit | 1 | √ | null |
|
|
Custom fields only - Boolean indicating if form shows only custom fields |
|
| OnlyCoreFields | bit | 1 | √ | null |
|
|
Core fields only - Boolean indicating if form shows only core system fields |
|
| HtmlDesignString | nvarchar | 1073741823 | √ | null |
|
|
HTML layout - Custom HTML design and layout for the form |
|
| ForExistingRecord | bit | 1 | ((0)) |
|
|
Edit mode flag - Boolean indicating if form is for editing existing records (required field, defaults to false) |
||
| int | 4 | √ | null |
|
|
Header/footer template - Reference to header and footer template for form styling |
||
| HeaderHtmlString | nvarchar | 1073741823 | √ | null |
|
|
Header HTML - Custom HTML content for form header |
|
| nvarchar | 1073741823 | √ | null |
|
|
Footer HTML - Custom HTML content for form footer |
||
| FormStyle | int | 4 | √ | null |
|
|
Style template - Numeric reference to form style template |
|
| PrintDataSourceId | uniqueidentifier | 16 | √ | null |
|
|
Print data source - Data source used for generating printable versions of the form |
|
| ShowToolBarItems | bit | 1 | ((0)) |
|
|
Toolbar visibility - Boolean controlling whether form toolbar items are displayed (required field, defaults to false) |
||
| CustomJs | nvarchar | 1073741823 | √ | null |
|
|
Custom JavaScript - Custom JavaScript code for form behavior and validation |
|
| IsSystem | bit | 1 | √ | null |
|
|
System form flag - Boolean indicating if this is a system-level form |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CustomFieldSettings | Primary key | Asc | pkID |