Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each form instance, auto-incrementing integer |
||||
| Title | nvarchar | 100 | √ | null |
|
|
Form title - Display title of the form instance for user interface and identification |
||||
| FormTemplateId | int | 4 | null |
|
|
Template reference - Foreign key linking to cf_FormTemplate for the base template used to create this form (required field) |
|||||
| OrderPosition | int | 4 | √ | null |
|
|
Display order - Numeric position for ordering forms in lists and user interfaces |
||||
| Action | nvarchar | 2000 | √ | null |
|
|
Form action - URL or action endpoint where form data is submitted for processing |
||||
| Method | nvarchar | 100 | √ | null |
|
|
HTTP method - HTTP method (GET, POST, etc.) used for form submission |
||||
| ClaimId | int | 4 | √ | null |
|
|
Claim reference - Optional reference to claim or case associated with this form for business context |
||||
| UserId | int | 4 | √ | null |
|
|
User reference - Reference to user who created or owns this form instance |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__cf_Form__3214EC0770D07D1D | Primary key | Asc | Id |