Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AdmitId | int | 4 | √ | null |
|
|
Admission reference - Links to patient admission or case |
|
| ServiceCoordinator | nvarchar | 1073741823 | √ | null |
|
|
Service coordinator - Name or identifier of the assigned service coordinator |
|
| CaseCoordinator | nvarchar | 1073741823 | √ | null |
|
|
Case coordinator - Name or identifier of the assigned case coordinator |
|
| ActiveServiceCoordinator | varchar | 2147483647 | √ | null |
|
|
Active service coordinator - Currently active service coordinator information |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_Coordinator | Performance | Asc | AdmitId |
Relationships
Close relationships within degrees of separation
