Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PALLIATIVE_ID | int | 4 | null |
|
|
|||
| PATIENT_ID | int | 4 | √ | null |
|
|
||
| NHS Number | varchar | 10 | √ | null |
|
|
||
| Hospital Number | varchar | 20 | √ | null |
|
|
||
| Full Name | varchar | 111 | √ | null |
|
|
||
| Referral Type | varchar | 50 | √ | null |
|
|
||
| Date of Diagnosis | smalldatetime | 16 | √ | null |
|
|
||
| Main Diagnosis Cancer Site | varchar | 50 | √ | null |
|
|
||
| Main Diagnosis Primary | varchar | 203 | √ | null |
|
|
||
| Main Diagnosis Secondary | varchar | 203 | √ | null |
|
|
||
| Secondary Diagnosis Type | varchar | 50 | √ | null |
|
|
||
| Secondary Diagnosis Cancer Site | varchar | 50 | √ | null |
|
|
||
| Secondary Diagnosis Primary | varchar | 203 | √ | null |
|
|
||
| Secondary Diagnosis Secondary | varchar | 203 | √ | null |
|
|
||
| Other Diagnosis Cancer Site | varchar | 50 | √ | null |
|
|
||
| Other Diagnosis Primary | varchar | 203 | √ | null |
|
|
||
| Other Diagnosis Secondary | varchar | 203 | √ | null |
|
|
||
| Metastases Liver | varchar | 20 | √ | null |
|
|
||
| Metastases Brain | varchar | 20 | √ | null |
|
|
||
| Metastases Lung | varchar | 20 | √ | null |
|
|
||
| Metastases Skin | varchar | 20 | √ | null |
|
|
||
| Metastases Bone Marrow | varchar | 20 | √ | null |
|
|
||
| Metastases Lymph Nodes | varchar | 20 | √ | null |
|
|
||
| Metastases Other | varchar | 20 | √ | null |
|
|
||
| Metastases Other Comment | varchar | 255 | √ | null |
|
|
||
| Metastases Unknown | varchar | 20 | √ | null |
|
|
||
| Metastases Bone (excluding bone marrow) | varchar | 20 | √ | null |
|
|
||
| Metastases Adrenal | varchar | 20 | √ | null |
|
|
||
| Type of Metastases | varchar | 50 | √ | null |
|
|