Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CareID | int | 4 | √ | null |
|
|
||||
| CNSContactID | int | 4 | null |
|
|
|||||
| WellbeingEventID | int | 4 | √ | null |
|
|
||||
| HasWellbeingEvent | bit | 1 | √ | null |
|
|
||||
| PatientSurname | varchar | 60 | √ | null |
|
|
||||
| PatientForename | varchar | 50 | √ | null |
|
|
||||
| NHSNumber | varchar | 10 | √ | null |
|
|
||||
| DateOfBirth | date | 20 | √ | null |
|
|
||||
| HospitalNumber | varchar | 20 | √ | null |
|
|
||||
| CNSID | int | 4 | √ | null |
|
|
||||
| CNSName | varchar | 50 | √ | null |
|
|
||||
| CNSNameOther | varchar | 50 | √ | null |
|
|
||||
| CNSRoleID | tinyint | 1 | √ | null |
|
|
||||
| CNSRole | nvarchar | 30 | √ | null |
|
|
||||
| ContactOrganisation | nvarchar | 500 | √ | null |
|
|
||||
| DateSeen | date | 20 | √ | null |
|
|
||||
| DateOfDiagnosis | smalldatetime | 16 | √ | null |
|
|
||||
| DiagnosisCode | varchar | 50 | √ | null |
|
|
||||
| DiagnosisDescription | varchar | 150 | √ | null |
|
|
||||
| OrgCodeDiagnosis | nvarchar | 500 | √ | null |
|
|
||||
| WellbeingEvent | varchar | 50 | √ | null |
|
|
||||
| ReasonEventNotOffered | nvarchar | 100 | √ | null |
|
|
||||
| SuitableForWellbeingEvent | varchar | 50 | √ | null |
|
|
||||
| WellbeingEventName | varchar | 100 | √ | null |
|
|
||||
| PointOfPathway | varchar | 50 | √ | null |
|
|
||||
| OtherPointOfPathway | varchar | 150 | √ | null |
|
|
||||
| WellbeingDateAttended | date | 20 | √ | null |
|
|
||||
| ReasonWellbeingEventNotOffered | nvarchar | 100 | √ | null |
|
|
||||
| CancerSiteID | int | 4 | √ | null |
|
|
||||
| CancerSiteDesc | varchar | 50 | √ | null |
|
|