Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkChecklistVisitCodeID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each visit code association |
|
| fkChecklistID | int | 4 | √ | null |
|
|
Checklist reference - Links to CheckList table for the associated checklist |
|
| Acid | int | 4 | √ | null |
|
|
Attendance code reference - Links to AttendanceCode table for the triggering visit code |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CheckListVisitCode | Primary key | Asc | pkChecklistVisitCodeID |
Relationships
Close relationships within degrees of separation
