Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| caseSiteID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each case-site association |
||||
| caseID | int | 4 | √ | null |
|
|
Case reference - Links to the patient case (PatientAdministration.AdmitID) |
||||
| createdBy | Unknown | 0 | null |
|
|
Created by user - UserID of the person who created this association |
|||||
| siteID | int | 4 | √ | null |
|
|
Site reference - Links to the service delivery site |
||||
| patientID | int | 4 | √ | null |
|
|
Patient reference - Links to the patient associated with this case-site relationship |
||||
| DateActive | datetime | 16,3 | √ | null |
|
|
Activation date - Date when the case-site association became active |
||||
| dateCreated | Unknown | 0 | null |
|
|
Creation date - Date when the case-site association was established |
|||||
| DateInactive | datetime | 16,3 | √ | null |
|
|
Inactivation date - Date when the case-site association was deactivated |
||||
| dateUpdated | Unknown | 0 | null |
|
|
Update date - Date of the last modification to this association |
|||||
| deleted | Unknown | 0 | null |
|
|
Deletion flag - Boolean indicator for soft deletion to maintain audit trail |
|||||
| siteStatus | varchar | 20 | √ | null |
|
|
Site status - Current status of the site assignment (Active, Inactive, etc.) |
||||
| siteComments | varchar | 500 | √ | null |
|
|
Site comments - Additional notes or comments about the case-site association |
||||
| updatedBy | Unknown | 0 | null |
|
|
Updated by user - UserID of the person who last modified this association |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__CaseSite__654CE0F2 | Primary key | Asc | caseSiteID |
| IX_CaseID | Performance | Asc/Asc | caseID + patientID |
| IX_SiteID | Performance | Asc | siteID |
Relationships
Close relationships within degrees of separation
