Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each form design, auto-incrementing integer |
|||||||
| Description | nvarchar | 1024 | √ | null |
|
|
Form description - Detailed description of the form design |
|||||||
| FillableFileId | nvarchar | 100 | √ | null |
|
|
Fillable file reference - Reference to fillable PDF or document template |
|||||||
| IsLockable | bit | 1 | null |
|
|
Lockable flag - Boolean indicating if form can be locked |
||||||||
| CaseType | nvarchar | 2000 | √ | null |
|
|
Case type - Type of case this form design applies to |
|||||||
| CheckList | nvarchar | 2000 | √ | null |
|
|
Checklist configuration - Checklist items associated with this form design |
|||||||
| Fields | nvarchar | 1073741823 | √ | null |
|
|
Form fields - Configuration of fields in the form design |
|||||||
| CreatedDate | datetime | 16,3 | null |
|
|
Creation date - Date when the form design was created |
||||||||
| CreatedBy | int | 4 | null |
|
|
Creator user ID - Reference to user who created this design |
||||||||
| DateCreated | Unknown | 0 | null |
|
|
Creation timestamp - When this design was first created |
||||||||
| DateUpdated | Unknown | 0 | null |
|
|
Last modification timestamp - When this design was most recently updated |
||||||||
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this design was logically deleted |
|||||||
| DeletedBy | int | 4 | √ | null |
|
|
Deletion user - User who deleted this form design |
|||||||
| AutomaticallyLock | bit | 1 | null |
|
|
Automatic lock flag - Boolean indicating if form should be automatically locked |
||||||||
| DesignName | Unknown | 0 | null |
|
|
Design name - Descriptive name of the form design |
||||||||
| FormId | Unknown | 0 | null |
|
|
Form reference - Reference to the custom form this design applies to |
||||||||
| IsDefault | Unknown | 0 | null |
|
|
Default design flag - Boolean indicating if this is the default design for the form |
||||||||
| IsRememberSignature | bit | 1 | null |
|
|
Remember signature flag - Boolean indicating if signatures should be remembered |
||||||||
| IsHideTypeSignature | bit | 1 | null |
|
|
Hide type signature - Boolean indicating if typed signatures should be hidden |
||||||||
| GetFormId | int | 4 | √ | (NULL) |
|
|
Get form identifier - Identifier for retrieving form data |
|||||||
| DataSourceId | int | 4 | √ | null |
|
|
Data source reference - Reference to data source for form population |
|||||||
| LayerItemMarketId | int | 4 | √ | null |
|
|
Layer item market reference - Reference to layer item in marketplace |
|||||||
| CategoryID | varchar | 250 | √ | null |
|
|
Category reference - Reference to form category |
|||||||
| CustomDataSourceId | uniqueidentifier | 16 | √ | null |
|
|
Custom data source reference - Reference to custom data source |
|||||||
| DefaultFormStatus | varchar | 20 | √ | null |
|
|
Default form status - Default status for forms using this design |
|||||||
| IsResponsive | Unknown | 0 | null |
|
|
Responsive design flag - Boolean indicating if design is responsive for mobile devices |
||||||||
| JavaScriptCode | Unknown | 0 | null |
|
|
JavaScript code - Client-side JavaScript for form behavior and validation |
||||||||
| LayoutHtml | Unknown | 0 | null |
|
|
HTML layout - HTML structure and layout for the form |
||||||||
| Name | nvarchar | 256 | null |
|
|
Form name - Display name of the form design |
||||||||
| Status | int | 4 | null |
|
|
Form status - Current status of the form design |
||||||||
| Location | int | 4 | null |
|
|
Form location - Location or context where form is used |
||||||||
| Type | int | 4 | null |
|
|
Form type - Classification type of the form design |
||||||||
| WebFormId | int | 4 | √ | null |
|
|
Web form reference - Reference to web-based version of the form |
|||||||
| VisitCode | nvarchar | 2000 | √ | null |
|
|
Visit code - Code associated with visit types for this form |
|||||||
| PaySource | nvarchar | 2000 | √ | null |
|
|
Payment source - Payment source configuration for the form |
|||||||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
Modification date - Date when form design was last modified |
|||||||
| ModifiedBy | int | 4 | √ | null |
|
|
Modifier user - User who last modified the form design |
|||||||
| SignaturesConfigurations | nvarchar | 1073741823 | √ | null |
|
|
Signature configurations - Configuration for digital signatures |
|||||||
| SignatureOrder | bit | 1 | ((0)) |
|
|
Signature order - Order in which signatures should be collected |
||||||||
| PublishToId | int | 4 | √ | (NULL) |
|
|
Publish target reference - Reference to publication target |
|||||||
| PublishBy | int | 4 | √ | null |
|
|
Publisher user - User who published the form design |
|||||||
| PrintFormId | int | 4 | √ | null |
|
|
Print form reference - Reference to printable version of the form |
|||||||
| RequireSignatureOnSubmit | bit | 1 | ((0)) |
|
|
Require signature on submit - Boolean indicating if signature is required on submission |
||||||||
| OneManyForm | bit | 1 | √ | null |
|
|
One-to-many form flag - Boolean indicating if form supports one-to-many relationships |
|||||||
| ShortcutPdf | bit | 1 | √ | null |
|
|
Shortcut PDF - PDF shortcut configuration for the form |
|||||||
| Role | nvarchar | 2000 | √ | null |
|
|
Form role - Role or permission level required to use this form |
|||||||
| StyleCss | Unknown | 0 | null |
|
|
CSS styling - Cascading style sheet definitions for form appearance |
||||||||
| TeamsHaveFullAccess | varchar | 200 | √ | null |
|
|
Teams full access flag - Boolean indicating if teams have full access |
|||||||
| ThemeId | Unknown | 0 | null |
|
|
Theme reference - Reference to theme or style template |
||||||||
| UpdatedBy | Unknown | 0 | null |
|
|
Last modifier - User ID who made the most recent update |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FormDesigns | Primary key | Asc | ID |
| IX_FormDesigns_Location | Performance | Asc | Location |
| IX_FormDesigns_WebFormId | Performance | Asc | WebFormId |