Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CANCER_SITE | varchar | 50 | √ | null |
|
|
||
| IMAGE_ID | int | 4 | null |
|
|
|||
| CARE_ID | int | 4 | null |
|
|
|||
| IMAGING_DATE | varchar | 10 | null |
|
|
|||
| ISOIMAGINGDATE | varchar | 10 | √ | null |
|
|
||
| MODALITY | varchar | 4 | √ | null |
|
|
||
| MOD_DESC | varchar | 50 | √ | null |
|
|
||
| OTHER_MOD | varchar | 50 | √ | null |
|
|
||
| INVESTIGATION_TYPE | varchar | 830 | √ | null |
|
|
||
| SITESNAME | varchar | 766 | null |
|
|
|||
| L_SITE_2 | varchar | 255 | √ | null |
|
|
||
| L_SITE_3 | varchar | 255 | √ | null |
|
|
||
| IM_RESULT | varchar | 30 | null |
|
|
|||
| L_T_STAGE | varchar | 3 | √ | null |
|
|
||
| L_N_STAGE | varchar | 3 | √ | null |
|
|
||
| L_M_STAGE | varchar | 3 | √ | null |
|
|
||
| TNM | varchar | 21 | √ | null |
|
|
||
| L_RESULTS | text | 2147483647 | √ | null |
|
|
||
| L_FBC_RESULT | varchar | 255 | √ | null |
|
|
||
| L_UE_RESULT | varchar | 255 | √ | null |
|
|
||
| L_LFT_RESULT | varchar | 255 | √ | null |
|
|
||
| L_CALCIUM_RESULT | varchar | 255 | √ | null |
|
|
||
| L_LDH_RESULT | varchar | 255 | √ | null |
|
|
||
| L_B2M_RESULT | varchar | 255 | √ | null |
|
|
||
| L_IG_RESULT | varchar | 255 | √ | null |
|
|
||
| L_OTHER_LAB | varchar | 255 | √ | null |
|
|
||
| L_IMAGING_REPORT_TEXT | text | 2147483647 | √ | null |
|
|
||
| L_CLOTTING | bit | 1 | null |
|
|
|||
| L_9AMCORTISOL | bit | 1 | null |
|
|
|||
| L_ALBUMIN | bit | 1 | null |
|
|
|||
| ALBUMIN_CB | bit | 1 | null |
|
|
|||
| L_CA153 | bit | 1 | null |
|
|
|||
| L_CALCITONIN | bit | 1 | null |
|
|
|||
| L_CALCIUM | bit | 1 | null |
|
|
|||
| L_CEA | bit | 1 | null |
|
|
|||
| L_CREAT | bit | 1 | null |
|
|
|||
| L_CRP | bit | 1 | null |
|
|
|||
| L_ECG | bit | 1 | null |
|
|
|||
| L_FBC | bit | 1 | null |
|
|
|||
| L_FSH | bit | 1 | null |
|
|
|||
| L_FT4 | bit | 1 | null |
|
|
|||
| L_GLUCOSE | bit | 1 | null |
|
|
|||
| L_GROUP | bit | 1 | null |
|
|
|||
| L_GROWTH_HORMONE | bit | 1 | null |
|
|
|||
| L_IGF_I | bit | 1 | null |
|
|
|||
| L_LFT | bit | 1 | null |
|
|
|||
| L_LH | bit | 1 | null |
|
|
|||
| L_OTHER | bit | 1 | null |
|
|
|||
| L_PFT | bit | 1 | null |
|
|
|||
| L_PHENYTOIN | bit | 1 | null |
|
|
|||
| L_PROLACTIN | bit | 1 | null |
|
|
|||
| L_PROTEIN | bit | 1 | null |
|
|
|||
| L_RENAL | bit | 1 | null |
|
|
|||
| L_SERUM | bit | 1 | null |
|
|
|||
| L_SODIUM | bit | 1 | null |
|
|
|||
| L_THYROGLOBULIN | bit | 1 | null |
|
|
|||
| L_TSH | bit | 1 | null |
|
|
|||
| L_UE | bit | 1 | null |
|
|
|||
| L_UFC | bit | 1 | null |
|
|
|||
| L_UNITS | int | 4 | √ | null |
|
|
||
| L_XMATCH | bit | 1 | null |
|
|
|||
| R_BHCG | bit | 1 | null |
|
|
|||
| L_B2M | bit | 1 | null |
|
|
|||
| L_BENCE | bit | 1 | null |
|
|
|||
| L_IG | bit | 1 | null |
|
|
|||
| LDH_MLT | bit | 1 | null |
|
|
|||
| L_MYELOMA | bit | 1 | null |
|
|
|||
| L_TESTOSTERONE_LAB | bit | 1 | null |
|
|
|||
| L_VIR | bit | 1 | null |
|
|
|||
| R_AFP | bit | 1 | null |
|
|
|||
| R_CA125 | bit | 1 | null |
|
|
|||
| L_CA199 | bit | 1 | null |
|
|
|||
| L_CRATECH | bit | 1 | null |
|
|
|||
| L_CEA_TM | bit | 1 | null |
|
|
|||
| L_HB | bit | 1 | null |
|
|
|||
| L_HCG | bit | 1 | null |
|
|
|||
| L_LDH_TM | bit | 1 | null |
|
|
|||
| L_LFT_TM | bit | 1 | null |
|
|
|||
| L_PSA | bit | 1 | null |
|
|
|||
| L_PSAD | bit | 1 | null |
|
|
|||
| L_TESTOSTERONE | bit | 1 | null |
|
|
|||
| L_5H1AA | bit | 1 | null |
|
|
|||
| L_OTHER_MARKER | bit | 1 | null |
|
|
|||
| ALBUMIN_LEVEL | int | 4 | √ | null |
|
|
||
| BETA2_MICROGLOBULIN_LEVEL | real | 4 | √ | null |
|
|
||
| N_L5_FEV1_AMOUNT | real | 4 | √ | null |
|
|
||
| N_L6_FEV1_PER | real | 4 | √ | null |
|
|
||
| L_FVC | real | 4 | √ | null |
|
|
||
| L_FVC_PER | real | 4 | √ | null |
|
|
||
| L_DLCO | real | 4 | √ | null |
|
|
||
| L_DLCO_PER | real | 4 | √ | null |
|
|
||
| L_KCO | real | 4 | √ | null |
|
|
||
| L_KCO_PER | real | 4 | √ | null |
|
|
||
| L_PAO2 | real | 4 | √ | null |
|
|
||
| L_PAO2_PER | real | 4 | √ | null |
|
|
||
| R_LVEF | real | 4 | √ | null |
|
|
||
| R_LVEF_PER | real | 4 | √ | null |
|
|
||
| L_SIDE | varchar | 50 | √ | null |
|
|
||
| L_SITE | varchar | 50 | √ | null |
|
|
||
| SideSite | varchar | 357 | null |
|
|
|||
| L_FINDINGS | varchar | 3 | √ | null |
|
|
||
| N3_5_LESION_SIZE | real | 4 | √ | null |
|
|
||
| ImagingReportText | text | 2147483647 | √ | null |
|
|
||
| L_OTHER_IMAGING | varchar | 4 | √ | null |
|
|
||
| MOD_DESC_2 | varchar | 50 | √ | null |
|
|
||
| L_ALPTEST | bit | 1 | null |
|
|
|||
| L_ALP_TEST_RESULT | varchar | 255 | √ | null |
|
|