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 | 3 | √ | 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 | 8000 | √ | 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 |
|
|