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 |
|
|
||||
| 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 | 1 | √ | 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 | char | 1 | √ | null |
|
|
||||
| L_PATH_N_LETTER | char | 1 | √ | null |
|
|
||||
| L_PATH_M_LETTER | char | 1 | √ | null |
|
|
||||
| L_ADEQUACY_MARGINS | int | 4 | √ | null |
|
|
||||
| L_COMMENTS | text | 2147483647 | √ | null |
|
|