Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PATHOLOGY_ID | int | 4 | null |
|
|
Links record to Pathology |
||||
| N_SK16_PERINEURAL | varchar | 1 | √ | null |
|
|
Perineural Invasion |
|||
| N_SK25_SPECIMEN_TYPE | varchar | 3 | √ | null |
|
|
Specimen Type |
|||
| R_SIZE_W | real | 4 | √ | null |
|
|
Size of Specimen |
|||
| R_SIZE_D | real | 4 | √ | null |
|
|
Size of Specimen |
|||
| R_SIZE_H | real | 4 | √ | null |
|
|
Size of Specimen |
|||
| R_THICKNESS | varchar | 20 | √ | null |
|
|
Breslow Thickness |
|||
| R_CLARK_LEVEL | int | 4 | √ | null |
|
|
Clark Level |
|||
| R_GROWTH_NODULAR | int | 4 | √ | null |
|
|
Nodular |
|||
| R_GROWTH_SUPER | int | 4 | √ | null |
|
|
Superficial |
|||
| R_GROWTH_INFIL | int | 4 | √ | null |
|
|
Infiltrative/Morphoeic |
|||
| R_GROWTH_MICRO | int | 4 | √ | null |
|
|
Micronodular |
|||
| R_GROWTH_OTHER | int | 4 | √ | null |
|
|
Other |
|||
| R_PERIPHERAL_MARGIN | int | 4 | √ | null |
|
|
Peripheral Margin |
|||
| R_DISTANCE_PERIPHERAL | real | 4 | √ | null |
|
|
Distance to Nearest Peripheral Margin |
|||
| R_DEEP_MARGIN | int | 4 | √ | null |
|
|
Deep Margin |
|||
| R_DISTANCE_DEEP | real | 4 | √ | null |
|
|
Distance to Nearest Deep |
|||
| R_NODULE | int | 4 | √ | null |
|
|
Nodule |
|||
| R_NODULE_BREADTH | real | 4 | √ | null |
|
|
Size of Nodule |
|||
| R_NODULE_HEIGHT | real | 4 | √ | null |
|
|
Size of Nodule |
|||
| R_BORDER | int | 4 | √ | null |
|
|
Border of Lesion |
|||
| R_PIGMENTATION | int | 4 | √ | null |
|
|
Pigmentation of Lesion |
|||
| R_GROWTH_PHASE | int | 4 | √ | null |
|
|
Radial Growth Phase |
|||
| R_VGP | int | 4 | √ | null |
|
|
Vertical Growth Phase |
|||
| R_ULCERATION | real | 4 | √ | null |
|
|
Ulceration |
|||
| R_REGRESSION | int | 4 | √ | null |
|
|
Regression |
|||
| R_MICROSATELLITES | int | 4 | √ | null |
|
|
Microsatellites |
|||
| R_NAEVUS | int | 4 | √ | null |
|
|
Co-existing Naevus |
|||
| R_DYSPLASTIC | int | 4 | √ | null |
|
|
Dysplastic |
|||
| R_MITOTIC_RATE | real | 4 | √ | null |
|
|
Mitotic Rate |
|||
| R_LYMPHOCYTES | int | 4 | √ | null |
|
|
Infiltrating Lymphocytes |
|||
| L_AJCC | int | 4 | √ | null |
|
|
AJCC Staging |
|||
| L_INVASION_LAT | int | 4 | √ | null |
|
|
||||
| L_NODE_1 | int | 4 | √ | null |
|
|
||||
| L_NODE_POS_1 | int | 4 | √ | null |
|
|
||||
| L_NODE_1_DESC | varchar | 50 | √ | null |
|
|
||||
| L_NODE_2 | int | 4 | √ | null |
|
|
||||
| L_NODE_POS_2 | int | 4 | √ | null |
|
|
||||
| L_NODE_2_DESC | varchar | 50 | √ | null |
|
|
||||
| L_NODE_3 | int | 4 | √ | null |
|
|
||||
| L_NODE_POS_3 | int | 4 | √ | null |
|
|
||||
| L_NODE_3_DESC | varchar | 50 | √ | null |
|
|
||||
| L_NODE_4 | int | 4 | √ | null |
|
|
||||
| L_NODE_POS_4 | int | 4 | √ | null |
|
|
||||
| L_NODE_4_DESC | varchar | 50 | √ | null |
|
|
||||
| LESION_INDICATOR | varchar | 4 | √ | null |
|
|
||||
| OPERATING_CLINICIAN_GRADE | varchar | 3 | √ | null |
|
|
||||
| BRAFStatus | int | 4 | √ | null |
|
|
||||
| L_AJCC_TEXT | varchar | 4 | √ | null |
|
|
||||
| SENTINAL_NODE_BIOPSY_PERFORMED | varchar | 1 | √ | null |
|
|
||||
| SENTINAL_NODE_BIOPSY_OUTCOME | varchar | 1 | √ | null |
|
|
||||
| FINAL_EXCISION_MARGIN | real | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblPATHOLOGY_DERMATOLOGY_1 | Primary key | Asc | PATHOLOGY_ID |
| IX_tblPATHOLOGY_DERMATOLOGY | Performance | Asc | PATHOLOGY_ID |