Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CareID | int | 4 | √ | null |
|
|
||||
| CNSContactID | int | 4 | null |
|
|
|||||
| WellbeingEventID | int | 4 | null |
|
|
|||||
| NHS Number | varchar | 10 | √ | null |
|
|
||||
| Hospital Number | varchar | 20 | √ | null |
|
|
||||
| Full Name | varchar | 111 | √ | null |
|
|
||||
| Date Of Birth | date | 20 | √ | null |
|
|
||||
| CNS/Support Worker | varchar | 50 | √ | null |
|
|
||||
| CNSNameOther | varchar | 50 | √ | null |
|
|
||||
| Role | nvarchar | 30 | √ | null |
|
|
||||
| Contact Orgnaisation | nvarchar | 500 | √ | null |
|
|
||||
| Date of Contact | date | 20 | √ | null |
|
|
||||
| Date of Diagnosis | date | 20 | √ | null |
|
|
||||
| Event Status | varchar | 50 | √ | null |
|
|
||||
| Reason Event not Offered | nvarchar | 100 | √ | null |
|
|
||||
| Suitable For Wellbeing Event | varchar | 50 | √ | null |
|
|
||||
| Wellbeing Event Name | varchar | 100 | √ | null |
|
|
||||
| Point Of Pathway | varchar | 50 | √ | null |
|
|
||||
| Other Point Of Pathway | varchar | 150 | √ | null |
|
|
||||
| Wellbeing Date Attended | date | 20 | √ | null |
|
|