Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
PATHOLOGY_ID | int | 4 | null |
|
|
|||||
CARE_ID | int | 4 | null |
|
|
|||||
TEMP_ID | varchar | 255 | √ | null |
|
|
||||
N8_1_PATHOLOGY_TYPE | varchar | 2 | √ | null |
|
|
||||
N8_2_RECEIPT_DATE | smalldatetime | 16 | √ | null |
|
|
||||
N8_3_RESULT_DATE | smalldatetime | 16 | √ | null |
|
|
||||
N8_4_PATHOLOGIST | varchar | 8 | √ | null |
|
|
||||
N8_5_ORG_CODE | varchar | 5 | √ | null |
|
|
||||
L_NEOADJUVANT_THERAPY | varchar | 1 | √ | null |
|
|
||||
N8_6_DIAGNOSIS | varchar | 5 | √ | null |
|
|
||||
N8_7_TUMOUR_LATERALITY | varchar | 1 | √ | null |
|
|
||||
N8_8_INVASIVE_LESION | real | 4 | √ | null |
|
|
||||
N8_9_SYNC_TUMOUR | varchar | 1 | √ | null |
|
|
||||
L_HISTOLOGY_GROUP | int | 4 | √ | null |
|
|
||||
N8_10_HISTOLOGY | varchar | 10 | √ | null |
|
|
||||
N8_11_GRADE_DIFF | varchar | 2 | √ | null |
|
|
||||
N8_12_CANCER_INVASION | varchar | 2 | √ | null |
|
|
||||
N8_13_EXCISION_MARGINS | varchar | 2 | √ | null |
|
|
||||
N8_14_NODES | int | 4 | √ | null |
|
|
||||
N8_15_POSITIVE_NODES | int | 4 | √ | null |
|
|
||||
N8_16_PATH_T_STAGE | varchar | 5 | √ | null |
|
|
||||
N8_17_PATH_N_STAGE | varchar | 5 | √ | null |
|
|
||||
N8_18_PATH_M_STAGE | varchar | 5 | √ | null |
|
|
||||
N8_20_REPORT_NUMBER | varchar | 50 | √ | null |
|
|
||||
N8_21_REPORT_STATUS | int | 4 | √ | null |
|
|
||||
N8_22_SPECIMEN_NATURE | int | 4 | √ | null |
|
|
||||
N8_23_REQUEST_ORG | varchar | 5 | √ | null |
|
|
||||
N8_24_REQUEST_BY | varchar | 8 | √ | null |
|
|
||||
L_PATH_T_LETTER | varchar | 3 | √ | null |
|
|
||||
L_PATH_N_LETTER | varchar | 6 | √ | null |
|
|
||||
L_PATH_M_LETTER | varchar | 3 | √ | null |
|
|
||||
L_ADEQUACY_MARGINS | int | 4 | √ | null |
|
|
||||
L_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
SAMPLE_DATE | smalldatetime | 16 | √ | null |
|
|
||||
L_PATHOLOGY_TEXT | varchar | 2147483647 | √ | null |
|
|
||||
L_PATHOLOGY_TOPOGRAPHY | varchar | 18 | √ | null |
|
|
||||
L_TNM_STAGE_GROUPING | varchar | 20 | √ | null |
|
|
||||
GERM_CELL_NON_CNS_ID | int | 4 | √ | null |
|
|
||||
INPC_ID | int | 4 | √ | null |
|
|
||||
CRCN_ID | int | 4 | √ | null |
|
|
||||
ROOT_SAMPLE_DATE_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
ROOT_RECEIPT_DATE_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
ROOT_RESULT_DATE_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
R_NECROSIS | varchar | 3 | √ | null |
|
|
||||
R_VENOUS | varchar | 50 | √ | null |
|
|
||||
R_ADRENAL | varchar | 3 | √ | null |
|
|
||||
R_SEMINAL | varchar | 3 | √ | null |
|
|
||||
R_WEIGHT | real | 4 | √ | null |
|
|
||||
R_SIZE_W | real | 4 | √ | null |
|
|
||||
R_SIZE_D | real | 4 | √ | null |
|
|
||||
R_SIZE_H | real | 4 | √ | null |
|
|
||||
R_TESTIS_W | real | 4 | √ | null |
|
|
||||
R_TESTIS_D | real | 4 | √ | null |
|
|
||||
R_TESTIS_H | real | 4 | √ | null |
|
|
||||
R_TUMOUR_W | real | 4 | √ | null |
|
|
||||
R_TUMOUR_D | real | 4 | √ | null |
|
|
||||
R_TUMOUR_H | real | 4 | √ | null |
|
|
||||
R_POS_APEX | varchar | 3 | √ | null |
|
|
||||
R_POS_BLADDER | varchar | 3 | √ | null |
|
|
||||
R_POS_POST | varchar | 3 | √ | null |
|
|
||||
R_POS_ANT | varchar | 3 | √ | null |
|
|
||||
R_POS_OTHER | varchar | 3 | √ | null |
|
|
||||
R_POS_RADIAL | varchar | 3 | √ | null |
|
|
||||
R_POS_SITE | varchar | 255 | √ | null |
|
|
||||
R_GROWTH | int | 4 | √ | null |
|
|
||||
R_HISTOLOGY | int | 4 | √ | null |
|
|
||||
R_OTHER_HISTOLOGY | varchar | 255 | √ | null |
|
|
||||
R_TUMOUR | varchar | 50 | √ | null |
|
|
||||
R_NO_TUMOURS | int | 4 | √ | null |
|
|
||||
R_CIS | varchar | 3 | √ | null |
|
|
||||
R_NO_CORES | varchar | 50 | √ | null |
|
|
||||
R_SPECIMEN_TYPE | int | 4 | √ | null |
|
|
||||
R_ABOVE_DIAPHRAM | varchar | 15 | √ | null |
|
|
||||
R_BELOW_DIAPHRAM | varchar | 15 | √ | null |
|
|
||||
R_ORGANS | varchar | 3 | √ | null |
|
|
||||
R_NODAL | varchar | 3 | √ | null |
|
|
||||
R_NODE_SITE | varchar | 255 | √ | null |
|
|
||||
R_ECS | varchar | 3 | √ | null |
|
|
||||
R_BX_SITE | varchar | 255 | √ | null |
|
|
||||
R_LOCATION_PENILE | int | 4 | √ | null |
|
|
||||
R_LOCATION_RENAL | int | 4 | √ | null |
|
|
||||
R_TESTIS_FEATURE | int | 4 | √ | null |
|
|
||||
R_TESTIS_INVASION | int | 4 | √ | null |
|
|
||||
R_BLOCKS | int | 4 | √ | null |
|
|
||||
R_R1 | varchar | 3 | √ | null |
|
|
||||
R_R2 | varchar | 3 | √ | null |
|
|
||||
R_R3 | varchar | 3 | √ | null |
|
|
||||
R_L1 | varchar | 3 | √ | null |
|
|
||||
R_L2 | varchar | 3 | √ | null |
|
|
||||
R_L3 | varchar | 3 | √ | null |
|
|
||||
R_CIRCUMFERENTIAL | varchar | 3 | √ | null |
|
|
||||
R_APICAL | varchar | 3 | √ | null |
|
|
||||
R_BASE | varchar | 3 | √ | null |
|
|
||||
R_GLEASON_SCORE_1 | int | 4 | √ | null |
|
|
||||
R_GLEASON_SCORE_2 | int | 4 | √ | null |
|
|
||||
R_SCARRING | varchar | 3 | √ | null |
|
|
||||
R_TESTIS | varchar | 3 | √ | null |
|
|
||||
R_ITGCN | varchar | 3 | √ | null |
|
|
||||
R_PELVIC_NODE_L | int | 4 | √ | null |
|
|
||||
R_PELVIC_NODE_R | int | 4 | √ | null |
|
|
||||
R_PELVIC_TUMOUR_L | int | 4 | √ | null |
|
|
||||
R_PELVIC_TUMOUR_R | int | 4 | √ | null |
|
|
||||
R_OBTURATOR_NODE_L | int | 4 | √ | null |
|
|
||||
R_OBTURATOR_NODE_R | int | 4 | √ | null |
|
|
||||
R_OBTURATOR_TUMOUR_L | int | 4 | √ | null |
|
|
||||
R_OBTURATOR_TUMOUR_R | int | 4 | √ | null |
|
|
||||
R_SENTINEL_NODE_L | int | 4 | √ | null |
|
|
||||
R_SENTINEL_NODE_R | int | 4 | √ | null |
|
|
||||
R_SENTINEL_TUMOUR_L | int | 4 | √ | null |
|
|
||||
R_SENTINEL_TUMOUR_R | int | 4 | √ | null |
|
|
||||
R_SUPERFICIAL_NODE_L | int | 4 | √ | null |
|
|
||||
R_SUPERFICIAL_NODE_R | int | 4 | √ | null |
|
|
||||
R_SUPERFICIAL_TUMOUR_L | int | 4 | √ | null |
|
|
||||
R_SUPERFICIAL_TUMOUR_R | int | 4 | √ | null |
|
|
||||
R_DEEP_NODE_L | int | 4 | √ | null |
|
|
||||
R_DEEP_NODE_R | int | 4 | √ | null |
|
|
||||
R_DEEP_TUMOUR_L | int | 4 | √ | null |
|
|
||||
R_DEEP_TUMOUR_R | int | 4 | √ | null |
|
|
||||
R_OTHER_NODE_L | int | 4 | √ | null |
|
|
||||
R_OTHER_NODE_R | int | 4 | √ | null |
|
|
||||
R_OTHER_TUMOUR_L | int | 4 | √ | null |
|
|
||||
R_OTHER_TUMOUR_R | int | 4 | √ | null |
|
|
||||
R_SIZE_TUMOUR_RCC | real | 4 | √ | null |
|
|
||||
R_TUMOUR_GRADE | char | 2 | √ | null |
|
|
||||
RMH_ID | int | 4 | √ | null |
|
|
||||
WILMS_RENAL_ID | int | 4 | √ | null |
|
|
||||
S_CATEGORY_ID | int | 4 | √ | null |
|
|
||||
EXTRA_NODAL_METS_ID | int | 4 | √ | null |
|
|
||||
SUB_STAGE_ID | int | 4 | √ | null |
|
|
||||
EXTRA_NODAL_LIVER | int | 4 | √ | null |
|
|
||||
EXTRA_NODAL_BRAIN | int | 4 | √ | null |
|
|
||||
EXTRA_NODAL_MEDIASTINAL | int | 4 | √ | null |
|
|
||||
EXTRA_NODAL_NECK | int | 4 | √ | null |
|
|
||||
EXTRA_NODAL_LUNG | int | 4 | √ | null |
|
|
||||
PROST_CORES_POSITIVE | int | 4 | √ | null |
|
|
||||
PROST_PERINEURAL_INV | varchar | 1 | √ | null |
|
|
||||
PROST_GREATEST_PERC_CANCER | int | 4 | √ | null |
|
|
||||
PROST_ORGAN_CONFINED | varchar | 1 | √ | null |
|
|
||||
PROST_EXCISION_MARGINS | int | 4 | √ | null |
|
|
||||
MARGIN_SITE | int | 4 | √ | null |
|
|
||||
BIOPSY_RESULT | int | 4 | √ | null |
|
|
||||
POST_OP_HIST_DIAGNOSIS | int | 4 | √ | null |
|
|
||||
MULTI_TUMOUR_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
NUCLEAR_GRADE | int | 4 | √ | null |
|
|
||||
rn | bigint | 8 | √ | null |
|
|