Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkCheckListStatusID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each checklist status record, auto-incrementing integer |
|
| fkCheckListID | int | 4 | null |
|
|
Checklist reference - Foreign key linking to CheckList.pkChecklistID for the checklist being tracked (required field) |
||
| fkLinkToID | int | 4 | √ | null |
|
|
Entity reference - Foreign key linking to the entity (case, patient, etc.) this checklist status applies to |
|
| isComplete | bit | 1 | √ | null |
|
|
Completion status - Boolean indicating if the entire checklist has been completed |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this status record |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation timestamp - When this status record was first created |
|
| patientID | int | 4 | √ | null |
|
|
Patient reference - Reference to patient if this checklist status is patient-specific |
|
| userID | int | 4 | √ | null |
|
|
User reference - Reference to user associated with this checklist status |
|
| CompletedDate | datetime | 16,3 | √ | null |
|
|
Completion timestamp - When the checklist was marked as fully completed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__CheckLis__1DA3C36701D809BA | Primary key | Asc | pkCheckListStatusID |
| unique_checklist | Must be unique | Asc/Asc | fkCheckListID + fkLinkToID |