cf_Form


Description

Custom form instances representing individual form instances created from form templates. This table manages actual form instances with their data, status, and relationships to templates, enabling dynamic form creation, data collection, and form lifecycle management for healthcare documentation and data entry.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Description Unknown 0 null

Form description - Detailed description of the form’s purpose and usage
Id int identity 4 √ null
cf_Control.FormId FK_cf_Control_cf_Form C

Primary key - Unique identifier for each form instance
IsActive Unknown 0 null

Active status - Boolean flag indicating if the form is available for use
Name Unknown 0 null

Form name - Unique name identifier for the form
Title nvarchar 100 √ null

Form title - Title or name of the form instance
FormTemplateId int 4 null
cf_FormTemplate.Id FK_cf_Form_cf_FormTemplate R

Template reference - Links to cf_FormTemplate used to create this form
OrderPosition int 4 √ null

Display order - Numeric position for ordering forms in lists and menus
Action nvarchar 2000 √ null

Form action - URL or action handler for form submission
Method nvarchar 100 √ null

HTTP method - HTTP method for form submission (GET, POST, etc.)
ClaimId int 4 √ null

Claim reference - Links to claim if this form is associated with a specific claim
UserId int 4 √ null

User reference - Links to user who created or owns this form instance

Indexes

Constraint Name Type Sort Column(s)
PK__cf_Form__3214EC0770D07D1D Primary key Asc Id
IX_FormClaimID Performance Asc ClaimId

Relationships

Close relationships within degrees of separation