Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CareID | int | 4 | null |
|
|
|||||||
| TriagedBy | int | 4 | √ | null |
|
|
||||||
| TriageDate | date | 20 | √ | null |
|
|
||||||
| ContactWithPatient | bit | 1 | √ | ((0)) |
|
|
||||||
| ContactWithRelative | bit | 1 | √ | ((0)) |
|
|
||||||
| ContactWithCarer | bit | 1 | √ | ((0)) |
|
|
||||||
| ContactWithHCP | bit | 1 | √ | ((0)) |
|
|
||||||
| ContactWithOther | bit | 1 | √ | ((0)) |
|
|
||||||
| OutcomeID | int | 4 | √ | null |
|
|
||||||
| OutcomeOther | varchar | 50 | √ | null |
|
|
||||||
| Arrangements | varchar | 2500 | √ | null |
|
|
||||||
| Comments | varchar | 2500 | √ | null |
|
|
||||||
| ACTION_ID | int | 4 | √ | null |
|
|
||||||
| TriagedByOther | varchar | 30 | √ | null |
|
|
||||||
| HCPDetails | varchar | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblCNSTriage | Primary key | Asc | CareID |