Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkChecklistFieldValueID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each checklist field value, auto-incrementing integer |
|
| fkCheckListItemID | int | 4 | null |
|
|
Checklist item reference - Foreign key linking to the specific checklist item this value belongs to (required field) |
||
| fkLinkToID | int | 4 | √ | null |
|
|
Entity link reference - Foreign key linking to the entity (case, patient, etc.) this checklist item applies to |
|
| DateValue | smalldatetime | 16 | √ | null |
|
|
Date response - Date value entered for date-type checklist items |
|
| TextValue | nvarchar | 1000 | √ | null |
|
|
Text response - Text value entered for text-type checklist items |
|
| IntValue | int | 4 | √ | null |
|
|
Numeric response - Integer value entered for numeric-type checklist items |
|
| Deleted | bit | 1 | √ | null |
|
|
Soft delete flag - Boolean indicating if this field value is logically deleted |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this field value entry |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation timestamp - When this field value was first created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update to this field value |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last modification timestamp - When this field value was most recently updated |
|
| DueDate | smalldatetime | 16 | √ | null |
|
|
Due date - When this checklist item is due for completion |
|
| BitValue | bit | 1 | √ | null |
|
|
Boolean response - Boolean value for yes/no or true/false checklist items |
|
| isComplete | bit | 1 | √ | null |
|
|
Completion status - Boolean indicating if this checklist item has been completed |
|
| AssignedUserID | int | 4 | √ | null |
|
|
Assigned user - User ID of person assigned to complete this specific checklist item |
|
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Reference to patient if this checklist item is patient-specific |
|
| UserID | int | 4 | √ | null |
|
|
User reference - Reference to user associated with this checklist item |
|
| CompletedDate | datetime | 16,3 | √ | null |
|
|
Completion timestamp - When this checklist item was marked as completed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ChecklistFieldValues | Primary key | Asc | pkChecklistFieldValueID |