Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PATHOLOGY_ID | int | 4 | null |
|
|
Links record to Pathology |
||||
| R_NECROSIS | varchar | 3 | √ | null |
|
|
Presence of Necrosis |
|||
| R_VENOUS | varchar | 50 | √ | null |
|
|
Tumour in Renal Veins |
|||
| R_ADRENAL | varchar | 3 | √ | null |
|
|
Adrenal Invasion |
|||
| R_SEMINAL | varchar | 3 | √ | null |
|
|
Seminal Vesical Involvement |
|||
| R_WEIGHT | real | 4 | √ | null |
|
|
Weight of TURT/TURBT |
|||
| R_SIZE_W | real | 4 | √ | null |
|
|
Size of Prostate |
|||
| R_SIZE_D | real | 4 | √ | null |
|
|
Size of Prostate |
|||
| R_SIZE_H | real | 4 | √ | null |
|
|
Size of Prostate |
|||
| R_TESTIS_W | real | 4 | √ | null |
|
|
Size of Testis |
|||
| R_TESTIS_D | real | 4 | √ | null |
|
|
Size of Testis |
|||
| R_TESTIS_H | real | 4 | √ | null |
|
|
Size of Testis |
|||
| R_TUMOUR_W | real | 4 | √ | null |
|
|
Size of Tumour |
|||
| R_TUMOUR_D | real | 4 | √ | null |
|
|
Size of Tumour |
|||
| R_TUMOUR_H | real | 4 | √ | null |
|
|
Size of Tumour |
|||
| R_POS_APEX | varchar | 3 | √ | null |
|
|
Apex |
|||
| R_POS_BLADDER | varchar | 3 | √ | null |
|
|
Bladder Neck |
|||
| R_POS_POST | varchar | 3 | √ | null |
|
|
Posterior |
|||
| R_POS_ANT | varchar | 3 | √ | null |
|
|
Anterior |
|||
| R_POS_OTHER | varchar | 3 | √ | null |
|
|
Other |
|||
| R_POS_RADIAL | varchar | 3 | √ | null |
|
|
||||
| R_POS_SITE | varchar | 255 | √ | null |
|
|
Site of Positivity |
|||
| R_GROWTH | int | 4 | √ | null |
|
|
Tumour Growth Pattern |
|||
| R_HISTOLOGY | int | 4 | √ | null |
|
|
Operative Histology |
|||
| R_OTHER_HISTOLOGY | varchar | 255 | √ | null |
|
|
Other Histology |
|||
| R_TUMOUR | varchar | 50 | √ | null |
|
|
Tumour Type |
|||
| R_NUCLEAR | varchar | 255 | √ | null |
|
|
Nuclear Grade |
|||
| R_NO_TUMOURS | int | 4 | √ | null |
|
|
No of Tumours |
|||
| R_CIS | varchar | 3 | √ | null |
|
|
Associated CIS |
|||
| R_NO_CORES | varchar | 50 | √ | null |
|
|
No. of Cores Involved |
|||
| R_SPECIMEN_TYPE | int | 4 | √ | null |
|
|
Specimen Type |
|||
| R_ABOVE_DIAPHRAM | varchar | 15 | √ | null |
|
|
Invasion below the diaphram |
|||
| R_BELOW_DIAPHRAM | varchar | 15 | √ | null |
|
|
Invasion above the diaphram |
|||
| R_ORGANS | varchar | 3 | √ | null |
|
|
Adjacent Organs Present |
|||
| R_NODAL | varchar | 3 | √ | null |
|
|
Nodal Dissection |
|||
| R_NODE_SITE | varchar | 255 | √ | null |
|
|
Site of Nodes |
|||
| R_ECS | varchar | 3 | √ | null |
|
|
Extracapsular Spread |
|||
| R_BX_SITE | varchar | 255 | √ | null |
|
|
Site of Biopsy |
|||
| R_LOCATION_PENILE | int | 4 | √ | null |
|
|
Site of Tumour |
|||
| R_LOCATION_RENAL | int | 4 | √ | null |
|
|
Site of Tumour |
|||
| R_TESTIS_FEATURE | int | 4 | √ | null |
|
|
Features |
|||
| R_TESTIS_INVASION | int | 4 | √ | null |
|
|
Invasion |
|||
| R_BLOCKS | int | 4 | √ | null |
|
|
No of Blocks Taken |
|||
| R_R1 | varchar | 3 | √ | null |
|
|
Needle Biopsy - Right 1 |
|||
| R_R2 | varchar | 3 | √ | null |
|
|
Needle Biopsy - Right 2 |
|||
| R_R3 | varchar | 3 | √ | null |
|
|
Needle Biopsy - Right 3 |
|||
| R_L1 | varchar | 3 | √ | null |
|
|
Needle Biopsy - Left 1 |
|||
| R_L2 | varchar | 3 | √ | null |
|
|
Needle Biopsy - Left 2 |
|||
| R_L3 | varchar | 3 | √ | null |
|
|
Needle Biopsy - Left 3 |
|||
| R_CIRCUMFERENTIAL | varchar | 3 | √ | null |
|
|
Circumferential |
|||
| R_APICAL | varchar | 3 | √ | null |
|
|
Apical |
|||
| R_BASE | varchar | 3 | √ | null |
|
|
Base |
|||
| R_GLEASON_SCORE_1 | int | 4 | √ | null |
|
|
Gleason Score |
|||
| R_GLEASON_SCORE_2 | int | 4 | √ | null |
|
|
Gleason Score |
|||
| R_SCARRING | varchar | 3 | √ | null |
|
|
Areas of Scarring only |
|||
| R_TESTIS | varchar | 3 | √ | null |
|
|
Biopsy of Contralateral Testis |
|||
| R_ITGCN | varchar | 3 | √ | null |
|
|
ITGCN present |
|||
| R_PELVIC_NODE_L | int | 4 | √ | null |
|
|
No Nodes Examined (Pelvic Left) |
|||
| R_PELVIC_NODE_R | int | 4 | √ | null |
|
|
No Nodes Examined (Pelvic Right) |
|||
| R_PELVIC_TUMOUR_L | int | 4 | √ | null |
|
|
No of Positive Nodes (Left) |
|||
| R_PELVIC_TUMOUR_R | int | 4 | √ | null |
|
|
No of Positive Nodes (Right) |
|||
| R_OBTURATOR_NODE_L | int | 4 | √ | null |
|
|
No Nodes Examined (Obturator Left) |
|||
| R_OBTURATOR_NODE_R | int | 4 | √ | null |
|
|
No Nodes Examined (Obturator Right) |
|||
| R_OBTURATOR_TUMOUR_L | int | 4 | √ | null |
|
|
No of Positive Nodes (Left) |
|||
| R_OBTURATOR_TUMOUR_R | int | 4 | √ | null |
|
|
No of Positive Nodes (Right) |
|||
| R_SENTINEL_NODE_L | int | 4 | √ | null |
|
|
No Nodes Examined (Sentinel Left) |
|||
| R_SENTINEL_NODE_R | int | 4 | √ | null |
|
|
No Nodes Examined (Sentinel Right) |
|||
| R_SENTINEL_TUMOUR_L | int | 4 | √ | null |
|
|
No of Positive Nodes (Left) |
|||
| R_SENTINEL_TUMOUR_R | int | 4 | √ | null |
|
|
No of Positive Nodes (Right) |
|||
| R_SUPERFICIAL_NODE_L | int | 4 | √ | null |
|
|
No Nodes Examined (Superficial Inguinal Left) |
|||
| R_SUPERFICIAL_NODE_R | int | 4 | √ | null |
|
|
No Nodes Examined (Superficial Inguinal Right) |
|||
| R_SUPERFICIAL_TUMOUR_L | int | 4 | √ | null |
|
|
No of Positive Nodes (Left) |
|||
| R_SUPERFICIAL_TUMOUR_R | int | 4 | √ | null |
|
|
No of Positive Nodes (Right) |
|||
| R_DEEP_NODE_L | int | 4 | √ | null |
|
|
No Nodes Examined (Deep Inguinal Left) |
|||
| R_DEEP_NODE_R | int | 4 | √ | null |
|
|
No Nodes Examined (Deep Inguinal Right) |
|||
| R_DEEP_TUMOUR_L | int | 4 | √ | null |
|
|
No of Positive Nodes (Left) |
|||
| R_DEEP_TUMOUR_R | int | 4 | √ | null |
|
|
No of Positive Nodes (Right) |
|||
| R_OTHER_NODE_L | int | 4 | √ | null |
|
|
No Nodes Examined (Other Left) |
|||
| R_OTHER_NODE_R | int | 4 | √ | null |
|
|
No Nodes Examined (Other Right) |
|||
| R_OTHER_TUMOUR_L | int | 4 | √ | null |
|
|
No of Positive Nodes (Left) |
|||
| R_OTHER_TUMOUR_R | int | 4 | √ | null |
|
|
No of Positive Nodes (Right) |
|||
| R_SIZE_TUMOUR_RCC | real | 4 | √ | null |
|
|
||||
| R_TUMOUR_GRADE | char | 2 | √ | null |
|
|
||||
| RMH_ID | int | 4 | √ | null |
|
|
||||
| WILMS_RENAL_ID | int | 4 | √ | null |
|
|
||||
| S_CATEGORY_ID | int | 4 | √ | null |
|
|
||||
| EXTRA_NODAL_METS_ID | int | 4 | √ | null |
|
|
||||
| SUB_STAGE_ID | int | 4 | √ | null |
|
|
||||
| EXTRA_NODAL_LIVER | int | 4 | √ | null |
|
|
||||
| EXTRA_NODAL_BRAIN | int | 4 | √ | null |
|
|
||||
| EXTRA_NODAL_MEDIASTINAL | int | 4 | √ | null |
|
|
||||
| EXTRA_NODAL_NECK | int | 4 | √ | null |
|
|
||||
| EXTRA_NODAL_LUNG | int | 4 | √ | null |
|
|
||||
| PROST_CORES_POSITIVE | int | 4 | √ | null |
|
|
||||
| PROST_PERINEURAL_INV | varchar | 1 | √ | null |
|
|
||||
| PROST_GREATEST_PERC_CANCER | int | 4 | √ | null |
|
|
||||
| PROST_ORGAN_CONFINED | varchar | 1 | √ | null |
|
|
||||
| PROST_EXCISION_MARGINS | int | 4 | √ | null |
|
|
||||
| MARGIN_SITE | int | 4 | √ | null |
|
|
||||
| BIOPSY_RESULT | int | 4 | √ | null |
|
|
||||
| POST_OP_HIST_DIAGNOSIS | int | 4 | √ | null |
|
|
||||
| PROSTATE_CONFIRMED | int | 4 | √ | null |
|
|
||||
| MULTI_TUMOUR_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
| NUCLEAR_GRADE | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblPATHOLOGY_UROLOGY | Primary key | Asc | PATHOLOGY_ID |
| IX_tblPATHOLOGY_UROLOGY | Performance | Asc | PATHOLOGY_ID |