Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PATHOLOGY_ID | int | 4 | null |
|
|
Links record to Pathology |
||||
| N_L15_R_CLASSIFICATION | varchar | 2 | √ | null |
|
|
Excision Margins - R Classification |
|||
| R_RESECTION_MAR | varchar | 3 | √ | null |
|
|
Complete Resection at all Margins |
|||
| R_SPECIMEN_TYPE | int | 4 | √ | null |
|
|
Specimen Type |
|||
| R_BRONCHUS_T3 | int | 4 | √ | null |
|
|
Main Bronchus < 20mm of carina |
|||
| R_BRONCHUS_T2 | int | 4 | √ | null |
|
|
Main Bronchus > 20mm of carina |
|||
| R_NON_ASSESS | int | 4 | √ | null |
|
|
Non-assessable |
|||
| R_RUL | int | 4 | √ | null |
|
|
Right Upper Lobe |
|||
| R_RML | int | 4 | √ | null |
|
|
Right Middle Lobe |
|||
| R_RLL | int | 4 | √ | null |
|
|
||||
| R_LUL | int | 4 | √ | null |
|
|
Left Upper Lobe |
|||
| R_LLL | int | 4 | √ | null |
|
|
Left Lower Lobe |
|||
| R_DISTANCE | real | 4 | √ | null |
|
|
Distance from Bronchial/Medial Resection Margin |
|||
| R_EXTENT | int | 4 | √ | null |
|
|
Extent of Atelectasis/Obstructive Pneumonitis |
|||
| R_VISCERAL | int | 4 | √ | null |
|
|
Visceral Pleura |
|||
| R_PARIETAL | int | 4 | √ | null |
|
|
Parietal Pleura / Chect Wall |
|||
| R_PLEURA | int | 4 | √ | null |
|
|
Mediastinal Pleura |
|||
| R_PERICARDIUM | int | 4 | √ | null |
|
|
Pericardium |
|||
| R_DIAPHRAM | int | 4 | √ | null |
|
|
Diaphram |
|||
| R_VESSEL | int | 4 | √ | null |
|
|
Great Vessel |
|||
| R_ATRIUM | int | 4 | √ | null |
|
|
Atrium, Heart |
|||
| R_EFFUSION | int | 4 | √ | null |
|
|
Malignant Pleural Effusion |
|||
| R_SEPARATE | int | 4 | √ | null |
|
|
Separate Tumour Nodules in same Lobe |
|||
| R_N1 | varchar | 10 | √ | null |
|
|
Ipsilateral Hilar/Intrapulmonary |
|||
| R_N2 | varchar | 10 | √ | null |
|
|
Ipsilateral Medastinal |
|||
| R_N3 | varchar | 10 | √ | null |
|
|
Contralateral Medastinal, Hilar, Ipsilateral or Contralateral Scalene, Supraclavicular |
|||
| R_BRONCHIAL | varchar | 10 | √ | null |
|
|
Bronchial |
|||
| R_MEDIASTINAL | varchar | 10 | √ | null |
|
|
Mediastinal |
|||
| R_VASCULAR | varchar | 10 | √ | null |
|
|
Vascular |
|||
| R_CHEST_WALL | varchar | 10 | √ | null |
|
|
Chest Wall |
|||
| R_OTHER_PATH | int | 4 | √ | null |
|
|
Other Pathology |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblPATHOLOGY_LUNG_1 | Primary key | Asc | PATHOLOGY_ID |
| IX_tblPATHOLOGY_LUNG | Performance | Asc | PATHOLOGY_ID |