Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PATHOLOGY_ID | int | 4 | null |
|
|
Links record to Pathology |
||||
| R_PROX_MARG | real | 4 | √ | null |
|
|
Distance to Proximal Margin |
|||
| R_DIST_MARGIN | real | 4 | √ | null |
|
|
Distance to Distal Margin |
|||
| R_PERI_INV | varchar | 50 | √ | null |
|
|
Perineural |
|||
| R_DONUTS | varchar | 50 | √ | null |
|
|
Doughnut |
|||
| R_BARRETTS | varchar | 50 | √ | null |
|
|
Barretts |
|||
| R_DYSPLASIA | varchar | 50 | √ | null |
|
|
Dysplasia |
|||
| R_HELICOBACTER | varchar | 50 | √ | null |
|
|
Helicobacter |
|||
| R_LYMPH_SITE | varchar | 50 | √ | null |
|
|
Site of Nodes |
|||
| R_RESECTION_MAR | varchar | 50 | √ | null |
|
|
Complete Resection at all Margins |
|||
| L_LIVER_METS | varchar | 50 | √ | null |
|
|
Histologically Confirmed Liver Mets |
|||
| L_LOCAL_INV | varchar | 50 | √ | null |
|
|
Local Invasion |
|||
| R_PROX_INV | varchar | 50 | √ | null |
|
|
Proximal Margins |
|||
| R_DIST_INV | varchar | 50 | √ | null |
|
|
Distal Margins |
|||
| R_CUR_INV | varchar | 50 | √ | null |
|
|
Circumferential Margins |
|||
| R_NODE_SITE | varchar | 255 | √ | null |
|
|
Other Site(s) |
|||
| R_SPEC_LEN | real | 4 | √ | null |
|
|
Max Length of Specimen |
|||
| R_OESOPHAGUS_LEN | real | 4 | √ | null |
|
|
Length of Oesophagus |
|||
| R_WIDTH_TUMOUR | real | 4 | √ | null |
|
|
Max Tumour Width |
|||
| R_STOMACH_LEN | real | 4 | √ | null |
|
|
Length of Stomach |
|||
| R_LESSER_LEN | real | 4 | √ | null |
|
|
Length of Stomach (Lesser Curve) |
|||
| R_GREATER_LEN | real | 4 | √ | null |
|
|
Length of Stomach (Greater Curve) |
|||
| R_DUODENUM_LEN | real | 4 | √ | null |
|
|
Length of Duodenum |
|||
| R_GALL_LEN | real | 4 | √ | null |
|
|
Length of Gall Bladder |
|||
| R_BILE_LEN | real | 4 | √ | null |
|
|
Length of Bile Duct |
|||
| R_SIZE_PANCREAS_W | real | 4 | √ | null |
|
|
Size of Pancreas |
|||
| R_SIZE_PANCREAS_H | real | 4 | √ | null |
|
|
Size of Pancreas |
|||
| R_SIZE_PANCREAS_D | real | 4 | √ | null |
|
|
Size of Pancreas |
|||
| R_PINNED | varchar | 50 | √ | null |
|
|
Specimen Pinned |
|||
| R_SEROSAL_INV | varchar | 50 | √ | null |
|
|
Serosal |
|||
| R_CIRCUMF | real | 4 | √ | null |
|
|
Distance to Circumferential Margin |
|||
| L_THORACIC_NODES | int | 4 | √ | null |
|
|
No of Nodes Examined (Thoracic) |
|||
| L_THORACIC_POS | int | 4 | √ | null |
|
|
No of Positive Nodes |
|||
| L_ABDOMINAL_NODES | int | 4 | √ | null |
|
|
No of Nodes Examined (Abdominal) |
|||
| L_ABDOMINAL_POS | int | 4 | √ | null |
|
|
No of Positive Nodes |
|||
| L_LYMPH_SITE2 | varchar | 50 | √ | null |
|
|
Site of Nodes |
|||
| R_SPEC_TYPE | int | 4 | √ | null |
|
|
Type of Specimen |
|||
| R_OTHER_SPEC | varchar | 255 | √ | null |
|
|
Type of Specimen |
|||
| R_TUMOUR_TYPE | int | 4 | √ | null |
|
|
Type of Tumour |
|||
| R_LAUREN_CLASS | int | 4 | √ | null |
|
|
Lauren Classification |
|||
| R_OTHER_ORGANS | varchar | 255 | √ | null |
|
|
Other Organs |
|||
| R_NAMED_VESSEL | varchar | 50 | √ | null |
|
|
Named Vessel Identified |
|||
| R_WHICH_VESSEL | varchar | 255 | √ | null |
|
|
Which Vessel |
|||
| R_STENT | varchar | 50 | √ | null |
|
|
Stent in Place |
|||
| R_VESSEL_INV | varchar | 50 | √ | null |
|
|
Named Vessel |
|||
| L_SIEWERT | int | 4 | √ | null |
|
|
Siewert Classification |
|||
| L_TREATMENT_SITE | varchar | 2 | √ | null |
|
|
||||
| DIAG_CONFIRMED | varchar | 1 | √ | null |
|
|
||||
| HGD_LESION | int | 4 | √ | null |
|
|
||||
| TUMOUR_DIAMETER | decimal | 8,2 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblPATHOLOGY_UPPER_GI_1 | Primary key | Asc | PATHOLOGY_ID |
| IX_tblPATHOLOGY_UPPER_GI | Performance | Asc | PATHOLOGY_ID |