Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkCheckListStatusID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each checklist status record |
|
| fkCheckListID | int | 4 | null |
|
|
Checklist reference - Links to CheckList table for the tracked checklist |
||
| fkLinkToID | int | 4 | √ | null |
|
|
Entity reference - Links to the entity this status applies to (Patient, Case, etc.) |
|
| isComplete | bit | 1 | √ | null |
|
|
Completion flag - Boolean indicating if the checklist is complete |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this status record |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when the status record was created |
|
| patientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table if status is patient-specific |
|
| userID | int | 4 | √ | null |
|
|
User reference - Links to AccessUser table for the user associated with this status |
|
| CompletedDate | datetime | 16,3 | √ | null |
|
|
Completion date - Date and time when the checklist was completed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__CheckLis__1DA3C36701D809BA | Primary key | Asc | pkCheckListStatusID |
| unique_checklist | Must be unique | Asc/Asc | fkCheckListID + fkLinkToID |
Relationships
Close relationships within degrees of separation
