Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AdmitId | int | 4 | √ | null |
|
|
Admission reference - Reference to admission or case record for coordinator assignment |
|
| ServiceCoordinator | nvarchar | 1073741823 | √ | null |
|
|
Service coordinator details - Information about the assigned service coordinator |
|
| CaseCoordinator | nvarchar | 1073741823 | √ | null |
|
|
Case coordinator details - Information about the assigned case coordinator |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_Coordinator | Performance | Asc | AdmitId |