FormDesigns


Description

Form design and layout management storing visual designs, layouts, and styling configurations for custom forms. This comprehensive system manages form appearance, user interface design, and user experience optimization for data collection forms.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 null
FormSignatures.FormDesignID FK_FormDigitalSignatures_FormDesigns R
FormSubmissions.FormDesignId FK_FormSubmissions_FormDesigns R

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

Relationships