Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
IMAGE_ID | int | 4 | null |
|
|
|||
CARE_ID | int | 4 | null |
|
|
|||
PATIENT_ID | int | 4 | null |
|
|
|||
N3_2_IMAGING_DATE | smalldatetime | 16 | √ | null |
|
|
||
N3_3_MODALITY | varchar | 4 | √ | null |
|
|
||
MOD_DESC | varchar | 50 | √ | null |
|
|
||
OTHER_MOD | varchar | 50 | √ | null |
|
|
||
N3_4_ANATOMICAL_SITE | varchar | 255 | √ | null |
|
|
||
L_SITE_2 | varchar | 255 | √ | null |
|
|
||
L_SITE_3 | varchar | 255 | √ | null |
|
|
||
L_IM_RESULT | varchar | 30 | √ | null |
|
|
||
R_CA125 | bit | 1 | null |
|
|
|||
R_CA125_RESULT | varchar | 255 | √ | null |
|
|
||
R_AFP | bit | 1 | null |
|
|
|||
R_AFP_RESULT | varchar | 255 | √ | null |
|
|
||
L_CEA | bit | 1 | null |
|
|
|||
L_CEA_RESULT | varchar | 255 | √ | null |
|
|
||
L_5H1AA_RESULT | varchar | 255 | √ | null |
|
|
||
L_5H1AA | bit | 1 | null |
|
|
|||
L_CEA_TM | bit | 1 | null |
|
|
|||
L_CA199_RESULT | varchar | 255 | √ | null |
|
|
||
L_CA199 | bit | 1 | null |
|
|
|||
L_PSA_RESULT | varchar | 255 | √ | null |
|
|
||
L_PSA | bit | 1 | null |
|
|
|||
L_HCG | bit | 1 | null |
|
|
|||
L_HCG_RESULT | varchar | 255 | √ | null |
|
|
||
L_LDH | bit | 1 | null |
|
|
|||
L_LDH_RESULT | varchar | 255 | √ | null |
|
|
||
L_OTHER_RESULT | varchar | 255 | √ | null |
|
|
||
L_OTHER_MARKER | bit | 1 | null |
|
|
|||
L_CANCER_SITE | varchar | 50 | √ | null |
|
|
||
L_NEW_CA_SITE | varchar | 20 | √ | null |
|
|
||
L_FBC | bit | 1 | null |
|
|
|||
L_FBC_RESULT | varchar | 255 | √ | null |
|
|
||
L_UE | bit | 1 | null |
|
|
|||
L_UE_RESULT | varchar | 255 | √ | null |
|
|
||
L_LFT | bit | 1 | null |
|
|
|||
L_LFT_RESULT | varchar | 255 | √ | null |
|
|
||
L_CALCIUM | bit | 1 | null |
|
|
|||
L_LFT_TM | bit | 1 | null |
|
|
|||
L_CALCIUM_RESULT | varchar | 255 | √ | null |
|
|
||
L_OTHER | bit | 1 | null |
|
|
|||
L_OTHER_LAB | varchar | 255 | √ | null |
|
|
||
L_B2M | bit | 1 | null |
|
|
|||
L_B2M_RESULT | varchar | 255 | √ | null |
|
|
||
L_IG | bit | 1 | null |
|
|
|||
L_IG_RESULT | varchar | 255 | √ | null |
|
|
||
L_T_STAGE | varchar | 3 | √ | null |
|
|
||
L_T_LETTER | varchar | 3 | √ | null |
|
|
||
L_N_STAGE | varchar | 3 | √ | null |
|
|
||
L_N_LETTER | varchar | 3 | √ | null |
|
|
||
L_M_STAGE | varchar | 3 | √ | null |
|
|
||
L_M_LETTER | varchar | 3 | √ | null |
|
|
||
L_INAP_REF | int | 4 | √ | null |
|
|
||
L_CREAT | bit | 1 | null |
|
|
|||
L_CREAT_RESULT | varchar | 255 | √ | null |
|
|
||
L_RENAL | bit | 1 | null |
|
|
|||
L_RENAL_RESULT | varchar | 255 | √ | null |
|
|
||
L_VIR | bit | 1 | null |
|
|
|||
L_VIR_RESULT | varchar | 255 | √ | null |
|
|
||
L_CRATECH | bit | 1 | null |
|
|
|||
L_CRATECH_RESULT | varchar | 255 | √ | null |
|
|
||
L_HB | bit | 1 | null |
|
|
|||
L_HB_RESULT | varchar | 255 | √ | null |
|
|
||
L_TESTOSTERONE | bit | 1 | null |
|
|
|||
L_TESTOSTERONE_RESULT | varchar | 255 | √ | null |
|
|
||
L_PSAD | bit | 1 | null |
|
|
|||
L_PSAD_RESULT | varchar | 255 | √ | null |
|
|
||
L_RESULTS | varchar | 8000 | √ | null |
|
|
||
L_IMAGING_REPORT_TEXT | text | 2147483647 | √ | null |
|
|
||
L_OTHER_IMAGING | varchar | 4 | √ | null |
|
|
||
PORTAL_INVASION_SELECTED | bit | 1 | null |
|
|
|||
MOD_ID | int | 4 | null |
|
|
|||
MOD_DESC_2 | varchar | 50 | √ | null |
|
|
||
OtherDescription | varchar | 50 | √ | null |
|
|
||
L_CEA_TM_RESULT | varchar | 255 | √ | null |
|
|
||
L_LDH_TM | bit | 1 | null |
|
|
|||
L_LDH_TM_RESULT | varchar | 255 | √ | null |
|
|
||
L_LFT_TM_RESULT | varchar | 255 | √ | 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_KCO | real | 4 | √ | null |
|
|
||
L_KCO_PER | real | 4 | √ | null |
|
|
||
L_PAO2 | real | 4 | √ | null |
|
|
||
L_PAO2_PER | real | 4 | √ | null |
|
|
||
L_DLCO | real | 4 | √ | null |
|
|
||
L_DLCO_PER | real | 4 | √ | null |
|
|
||
R_LVEF | real | 4 | √ | null |
|
|
||
R_LVEF_PER | real | 4 | √ | null |
|
|
||
CPET_TYPE | varchar | 100 | √ | null |
|
|
||
CPET_RESULT | int | 4 | √ | null |
|
|
||
L_9AMCORTISOL | bit | 1 | null |
|
|
|||
L_9AMCORTISOL_RESULTS | varchar | 255 | √ | null |
|
|
||
ALBUMIN_CB | bit | 1 | null |
|
|
|||
ALBUMIN_COMMENTS | nvarchar | 1000 | √ | null |
|
|
||
L_BENCE | bit | 1 | null |
|
|
|||
L_BENCE_RESULTS | varchar | 255 | √ | null |
|
|
||
R_BHCG | bit | 1 | null |
|
|
|||
R_BHCG_RESULT | varchar | 255 | √ | null |
|
|
||
L_CA153 | bit | 1 | null |
|
|
|||
L_CA153_RESULT | varchar | 255 | √ | null |
|
|
||
L_CALCITONIN | bit | 1 | null |
|
|
|||
L_CALCITONIN_RESULT | varchar | 255 | √ | null |
|
|
||
L_CLOTTING | bit | 1 | null |
|
|
|||
L_CLOTTING_RESULT | varchar | 255 | √ | null |
|
|
||
L_CRP | bit | 1 | null |
|
|
|||
L_CRP_RESULT | varchar | 255 | √ | null |
|
|
||
L_ECG | bit | 1 | null |
|
|
|||
L_ECG_RESULT | varchar | 255 | √ | null |
|
|
||
L_FT4 | bit | 1 | null |
|
|
|||
L_FT4_RESULTS | varchar | 255 | √ | null |
|
|
||
L_FSH | bit | 1 | null |
|
|
|||
L_FSH_RESULTS | varchar | 255 | √ | null |
|
|
||
L_GROUP | bit | 1 | null |
|
|
|||
L_GROUP_RESULT | varchar | 255 | √ | null |
|
|
||
L_GROWTH_HORMONE | bit | 1 | null |
|
|
|||
L_GROWTH_HORMONE_RESULTS | varchar | 255 | √ | null |
|
|
||
L_IGF_I | bit | 1 | null |
|
|
|||
L_IGF_I_RESULTS | varchar | 255 | √ | null |
|
|
||
LDH_MLT | bit | 1 | null |
|
|
|||
LDH_MLT_RESULT | varchar | 255 | √ | null |
|
|
||
L_LH | bit | 1 | null |
|
|
|||
L_LH_RESULTS | varchar | 255 | √ | null |
|
|
||
L_MYELOMA | bit | 1 | null |
|
|
|||
L_MYELOMA_RESULT | varchar | 255 | √ | null |
|
|
||
L_PFT | bit | 1 | null |
|
|
|||
L_PFT_RESULT | varchar | 255 | √ | null |
|
|
||
L_PHENYTOIN | bit | 1 | null |
|
|
|||
L_PHENYTOIN_RESULT | varchar | 255 | √ | null |
|
|
||
L_PROLACTIN | bit | 1 | null |
|
|
|||
L_PROLACTIN_RESULTS | varchar | 255 | √ | null |
|
|
||
L_PROTEIN | bit | 1 | null |
|
|
|||
L_PROTEIN_RESULTS | varchar | 255 | √ | null |
|
|
||
L_GLUCOSE | bit | 1 | null |
|
|
|||
L_RANDOM_GLUCOSE | varchar | 255 | √ | null |
|
|
||
L_SERUM | bit | 1 | null |
|
|
|||
L_SERUM_RESULTS | varchar | 255 | √ | null |
|
|
||
L_SODIUM | bit | 1 | null |
|
|
|||
L_SODIUM_RESULT | varchar | 255 | √ | null |
|
|
||
L_TESTOSTERONE_LAB | bit | 1 | null |
|
|
|||
L_TESTOSTERONE_LAB_RESULTS | varchar | 255 | √ | null |
|
|
||
L_THYROGLOBULIN | bit | 1 | null |
|
|
|||
L_THYROGLOBULIN_RESULT | varchar | 255 | √ | null |
|
|
||
L_TSH | bit | 1 | null |
|
|
|||
L_TSH_RESULTS | varchar | 255 | √ | null |
|
|
||
L_UFC | bit | 1 | null |
|
|
|||
L_UFC_RESULTS | varchar | 255 | √ | null |
|
|
||
L_XMATCH | bit | 1 | null |
|
|
|||
L_XMATCH_RESULT | varchar | 255 | √ | null |
|
|
||
L_LAB_COMMENTS | varchar | 8000 | √ | null |
|
|
||
FBC_PLATELET_COUNT | int | 4 | √ | null |
|
|
||
FBC_NEUTROPHIL_COUNT | real | 4 | √ | null |
|
|
||
FBC_BLOOD_BASOPHILS | int | 4 | √ | null |
|
|
||
FBC_WBC_COUNT | real | 4 | √ | null |
|
|
||
FBC_LYMPHOCYTE_COUNT | real | 4 | √ | null |
|
|
||
FBC_BLOOD_EOSINOPHILS | int | 4 | √ | null |
|
|
||
FBC_HB_CONCENTRATION | real | 4 | √ | null |
|
|
||
FBC_BLOOD_MYELOBLASTS | int | 4 | √ | null |
|
|
||
ALBUMIN_LEVEL | int | 4 | √ | null |
|
|
||
BETA2_MICROGLOBULIN_LEVEL | real | 4 | √ | null |
|
|
||
L_ALPTEST | bit | 1 | null |
|
|
|||
L_ALP_TEST_RESULT | varchar | 255 | √ | null |
|
|