Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
|||
| N2_4_PRIORITY_TYPE | varchar | 2 | √ | null |
|
|
||
| N2_5_DECISION_DATE | smalldatetime | 16 | √ | null |
|
|
||
| N2_9_FIRST_SEEN_DATE | smalldatetime | 16 | √ | null |
|
|
||
| CON_DESC | varchar | 50 | √ | null |
|
|
||
| TYPE_DESC | varchar | 50 | √ | null |
|
|
||
| N4_1_DIAGNOSIS_DATE | smalldatetime | 16 | √ | null |
|
|
||
| DIAG_DESC | varchar | 150 | √ | null |
|
|
||
| STATUS_DESC | varchar | 100 | √ | null |
|
|
||
| PRIORITY_DESC | varchar | 60 | √ | null |
|
|
||
| N6_9_SITE_CLASSIFICATION | varchar | 2 | √ | null |
|
|
||
| PathologicalTStage | varchar | 5 | √ | null |
|
|
||
| PathologicalNStage | varchar | 5 | √ | null |
|
|
||
| PathologicalMStage | varchar | 5 | √ | null |
|
|
||
| L_LUMP_NECK | bit | 1 | √ | null |
|
|
||
| L_LUMP_PARTOID | bit | 1 | √ | null |
|
|
||
| L_OTOLOGIA | bit | 1 | √ | null |
|
|
||
| L_SWELLING | bit | 1 | √ | null |
|
|
||
| L_LESION | bit | 1 | √ | null |
|
|
||
| L_THROAT | bit | 1 | √ | null |
|
|
||
| L_DYSPHAGIA | int | 4 | √ | null |
|
|
||
| L_MOUTH | bit | 1 | √ | null |
|
|
||
| L_PALSY | bit | 1 | √ | null |
|
|
||
| L_LYMPHODENOPATHY | bit | 1 | √ | null |
|
|
||
| L_DYSPHONIA | bit | 1 | √ | null |
|
|
||
| L_PHARYNX | bit | 1 | √ | null |
|
|
||
| L_CM_ACUTE | bit | 1 | √ | null |
|
|
||
| L_CM_ALCOHOL | bit | 1 | √ | null |
|
|
||
| L_CM_ANAEMIA | bit | 1 | √ | null |
|
|
||
| L_CM_ANGINA | bit | 1 | √ | null |
|
|
||
| L_CM_ASPRIN | bit | 1 | √ | null |
|
|
||
| L_CM_BOWEL | bit | 1 | √ | null |
|
|
||
| L_CM_CARDIAC | bit | 1 | √ | null |
|
|
||
| CerebrovascularDisease | bit | 1 | √ | null |
|
|
||
| L_CM_CHRONIC | bit | 1 | √ | null |
|
|
||
| L_CM_CIRRHOSIS | bit | 1 | √ | null |
|
|
||
| L_CM_CLOTTING | bit | 1 | √ | null |
|
|
||
| L_CM_COAD | bit | 1 | √ | null |
|
|
||
| L_CM_CVA | bit | 1 | √ | null |
|
|
||
| L_CM_DIABETES1 | bit | 1 | √ | null |
|
|
||
| L_CM_DIABETES2 | bit | 1 | √ | null |
|
|
||
| L_CM_FAILURE | bit | 1 | √ | null |
|
|
||
| L_CM_HEART | bit | 1 | √ | null |
|
|
||
| L_CM_HYPERTENSION | bit | 1 | √ | null |
|
|
||
| L_CM_LIVER | bit | 1 | √ | null |
|
|
||
| L_CM_MENTAL | bit | 1 | √ | null |
|
|
||
| L_CM_NEURO | bit | 1 | √ | null |
|
|
||
| L_CM_OTHER | bit | 1 | √ | null |
|
|
||
| L_CM_PERIPHERAL | bit | 1 | √ | null |
|
|
||
| L_CM_RENAL | bit | 1 | √ | null |
|
|
||
| L_CM_RESPIRATORY | bit | 1 | √ | null |
|
|
||
| L_CM_SERUM | bit | 1 | √ | null |
|
|
||
| L_CM_STEROIDS | bit | 1 | √ | null |
|
|
||
| L_CM_VASCULAR | bit | 1 | √ | null |
|
|
||
| L_CM_WARFARIN | bit | 1 | √ | null |
|
|
||
| L_OTHER_MORBIDITIES | varchar | 255 | √ | null |
|
|