Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
|||
| PATIENT_ID | int | 4 | √ | null |
|
|
||
| N1_10_DATE_BIRTH | datetime | 16,3 | √ | null |
|
|
||
| N1_3_ORG_CODE_SEEN | varchar | 10 | √ | null |
|
|
||
| N4_1_DIAGNOSIS_DATE | datetime | 16,3 | √ | null |
|
|
||
| N2_16_OP_REFERRAL | varchar | 3 | √ | null |
|
|
||
| L_INDICATOR_CODE | varchar | 3 | √ | null |
|
|
||
| N4_2_DIAGNOSIS_CODE | varchar | 10 | √ | null |
|
|
||
| R_SYNC_TUMOUR | varchar | 3 | √ | null |
|
|
||
| R_SYNC_APPENDIX | varchar | 3 | √ | null |
|
|
||
| R_SYNC_CAECUM | varchar | 3 | √ | null |
|
|
||
| R_SYNC_ASCENDING | varchar | 3 | √ | null |
|
|
||
| R_SYNC_HEPATIC | varchar | 3 | √ | null |
|
|
||
| R_SYNC_TRANSVERSE | varchar | 3 | √ | null |
|
|
||
| R_SYNC_SPLENIC | varchar | 3 | √ | null |
|
|
||
| R_SYNC_DESCENDING | varchar | 3 | √ | null |
|
|
||
| R_SYNC_SIGMOID | varchar | 3 | √ | null |
|
|
||
| R_SYNC_RECTUM | varchar | 3 | √ | null |
|
|
||
| ClinicalTStage | varchar | 5 | √ | null |
|
|
||
| ClinicalTLetter | varchar | 5 | √ | null |
|
|
||
| ClinicalNStage | varchar | 5 | √ | null |
|
|
||
| ClinicalMStage | varchar | 5 | √ | null |
|
|
||
| Username | varchar | 50 | √ | null |
|
|
||
| TNM_UNKNOWN | bit | 1 | √ | null |
|
|
||
| R_TUMOUR_HEIGHT | varchar | 50 | √ | null |
|
|
||
| MDTMeetingType | varchar | 4 | √ | null |
|
|
||
| TNMVersion | varchar | 2 | √ | null |
|
|
||
| ClinicalNLetter | varchar | 5 | √ | null |
|
|
||
| ClinicalMLetter | varchar | 5 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors