Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CareID | int | 4 | null |
|
|
|||
| NHS Number | varchar | 10 | null |
|
|
|||
| Hospital Number | varchar | 20 | √ | null |
|
|
||
| Full Name | varchar | 111 | √ | null |
|
|
||
| Cancer Site | varchar | 50 | √ | null |
|
|
||
| Record Type | varchar | 20 | √ | null |
|
|
||
| Diagnosis Date | date | 20 | √ | null |
|
|
||
| Metastatic Type | varchar | 50 | √ | null |
|
|
||
| Mets Location | varchar | 50 | √ | null |
|
|
||
| Mets State | varchar | 20 | √ | null |
|
|
||
| Other Mets Site | varchar | 50 | √ | null |
|
|
||
| SNOMED CT Morphology | varchar | 113 | √ | null |
|
|
||
| ICDO3 Details | varchar | 211 | √ | null |
|
|
||
| ICD10 Diagnosis | varchar | 203 | √ | null |
|
|
||
| Source of Referral for Outpatients | varchar | 100 | √ | null |
|
|
||
| Palliative Care Specialist Seen Indicator | varchar | 50 | √ | null |
|
|
||
| WHO Tumour Grade | varchar | 183 | √ | null |
|
|