Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PATHOLOGY_ID | int | 4 | null |
|
|
Links record to Pathology |
||||
| R_FIGO | varchar | 3 | √ | null |
|
|
FIGO |
|||
| R_FIGO2 | varchar | 3 | √ | null |
|
|
FIGO |
|||
| R_SIZE | real | 4 | √ | null |
|
|
Invasive Tumour Thickness |
|||
| R_DEPTH_MIC | real | 4 | √ | null |
|
|
Depth of Invasion for Microinvasive Carcinoma |
|||
| R_DISTANCE | real | 4 | √ | null |
|
|
Distance from Closest Resection Margin |
|||
| R_VAGINAL | varchar | 3 | √ | null |
|
|
Vaginal Involvement |
|||
| R_DISTANCE_VAGINAL | real | 4 | √ | null |
|
|
Distance from Closest Vaginal Resection Margin |
|||
| R_PARAMETRIAL | varchar | 3 | √ | null |
|
|
Parametrial/Paracervical Involvement |
|||
| R_AORTIC_NODES | int | 4 | √ | null |
|
|
Para-aortic Nodes |
|||
| R_EXTRANODAL | varchar | 3 | √ | null |
|
|
Extranodal Spread |
|||
| 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_ILIAC_NODE_L | int | 4 | √ | null |
|
|
No Nodes Examined (Iliac Left) |
|||
| R_ILIAC_NODE_R | int | 4 | √ | null |
|
|
No Nodes Examined (Iliac Right) |
|||
| R_ILIAC_TUMOUR_L | int | 4 | √ | null |
|
|
No of Positive Nodes (Left) |
|||
| R_ILIAC_TUMOUR_R | int | 4 | √ | null |
|
|
No of Positive Nodes (Right) |
|||
| R_GROIN_NODE_L | int | 4 | √ | null |
|
|
No Nodes Examined (Groin Left) |
|||
| R_GROIN_NODE_R | int | 4 | √ | null |
|
|
No Nodes Examined (Groin Right) |
|||
| R_GROIN_TUMOUR_L | int | 4 | √ | null |
|
|
No of Positive Nodes (Left) |
|||
| R_GROIN_TUMOUR_R | int | 4 | √ | null |
|
|
No of Positive Nodes (Right) |
|||
| R_SENTINEL_NODE | int | 4 | √ | null |
|
|
No Nodes Examined (Sentinel) |
|||
| R_SENTINEL_TUMOUR | int | 4 | √ | null |
|
|
No of Positive Nodes |
|||
| R_UTERUS_LEN | real | 4 | √ | null |
|
|
Dimensions of Uterus |
|||
| R_UTERUS_TRAN | real | 4 | √ | null |
|
|
Dimensions of Uterus |
|||
| R_UTERUS_AP | real | 4 | √ | null |
|
|
Dimensions of Uterus |
|||
| R_CUFF | int | 4 | √ | null |
|
|
Vaginal Cuff |
|||
| R_CUFF_LENGTH | real | 4 | √ | null |
|
|
Length of Vaginal Cuff |
|||
| R_CIN | int | 4 | √ | null |
|
|
Cervical Intraepithelial Neoplasia |
|||
| R_CGIN | int | 4 | √ | null |
|
|
Cervical Glandular Intraepithelial Neoplasia |
|||
| R_ENDO | int | 4 | √ | null |
|
|
Endometrium |
|||
| R_MYO | int | 4 | √ | null |
|
|
Myometrium |
|||
| R_OVARY_L | int | 4 | √ | null |
|
|
Left Ovary |
|||
| R_OVARY_R | int | 4 | √ | null |
|
|
Right Ovary |
|||
| R_TUBE_L | int | 4 | √ | null |
|
|
Left Tube |
|||
| R_TUBE_R | int | 4 | √ | null |
|
|
Right Tube |
|||
| R_UTERUS | int | 4 | √ | null |
|
|
Uterus |
|||
| R_CERVIX | int | 4 | √ | null |
|
|
Cervix |
|||
| R_MYO_INVASION | varchar | 3 | √ | null |
|
|
Obvious Myometrial Invasion |
|||
| R_DEPTH_MYO | int | 4 | √ | null |
|
|
Depth of Myometrial Invasion |
|||
| R_ENDOCERVICAL | int | 4 | √ | null |
|
|
Endocervical Extension |
|||
| R_SEROSAL | varchar | 3 | √ | null |
|
|
Serosal Involvement |
|||
| R_OVARIAN_METS | int | 4 | √ | null |
|
|
Ovarian Metastases |
|||
| R_WASH_ASCITES | int | 4 | √ | null |
|
|
Peritoneal Washings/Ascites |
|||
| R_ENDO_NORMAL | varchar | 3 | √ | null |
|
|
Appearance of Background Endometrium - Normal |
|||
| R_ENDO_ATYPICAL | varchar | 3 | √ | null |
|
|
Appearance of Background Endometrium - Atypical |
|||
| R_HYPERPLASIA | varchar | 3 | √ | null |
|
|
Hyperplasia |
|||
| R_HYPERPLASIA_TYPE | varchar | 255 | √ | null |
|
|
Hyperplasia Type |
|||
| R_SKIN_MARGIN | real | 4 | √ | null |
|
|
Min. Tumour-free Skin Margin |
|||
| R_VAGINAL_MARGIN | real | 4 | √ | null |
|
|
Min. Tumour-free Vaginal Margin |
|||
| R_ANAL_MARGIN | real | 4 | √ | null |
|
|
Min. Tumour-free Anal Margin |
|||
| R_DEEP_SOFT | real | 4 | √ | null |
|
|
Min Deep Soft Tissue Margin |
|||
| R_RESECTION_MARGIN | varchar | 3 | √ | null |
|
|
Tumour at Deep Resection Margins |
|||
| R_ADJACENT_SKIN | int | 4 | √ | null |
|
|
Nature of Adjacent Vulval Skin |
|||
| R_NODAL_EXT | varchar | 3 | √ | null |
|
|
Extranodal Extension |
|||
| R_SPEC_L | real | 4 | √ | null |
|
|
Size of Specimen |
|||
| R_SPEC_W | real | 4 | √ | null |
|
|
Size of Specimen |
|||
| R_SPEC_D | real | 4 | √ | null |
|
|
Size of Specimen |
|||
| R_RESIDUAL | varchar | 3 | √ | null |
|
|
Residual Tumour |
|||
| R_TUMOUR_L | real | 4 | √ | null |
|
|
Dimensions of Tumour |
|||
| R_TUMOUR_W | real | 4 | √ | null |
|
|
Dimensions of Tumour |
|||
| R_TUMOUR_D | real | 4 | √ | null |
|
|
Dimensions of Tumour |
|||
| R_CAPSULAR | int | 4 | √ | null |
|
|
Ovarian Capsular |
|||
| R_OMENTUM | int | 4 | √ | null |
|
|
Omentum |
|||
| R_CONTRA_OVARY | int | 4 | √ | null |
|
|
Contralateral Ovary |
|||
| R_OTHER_PERITONEAL | int | 4 | √ | null |
|
|
Other Peritoneal Biopsy/Brushing |
|||
| R_FLUID | int | 4 | √ | null |
|
|
Pleural Fluid |
|||
| R_MITOSES | real | 4 | √ | null |
|
|
Mitoses |
|||
| R_OVARY_L_L | real | 4 | √ | null |
|
|
Dimensions of Ovary (Left) |
|||
| R_OVARY_L_W | real | 4 | √ | null |
|
|
Dimensions of Ovary (Left) |
|||
| R_OVARY_L_D | real | 4 | √ | null |
|
|
Dimensions of Ovary (Left) |
|||
| R_OVARY_R_L | real | 4 | √ | null |
|
|
Dimensions of Ovary (Right) |
|||
| R_OVARY_R_W | real | 4 | √ | null |
|
|
Dimensions of Ovary (Right) |
|||
| R_OVARY_R_D | real | 4 | √ | null |
|
|
Dimensions of Ovary (Right) |
|||
| L_CYTOLOGY | varchar | 255 | √ | null |
|
|
Cytology |
|||
| R_FIGO3 | varchar | 3 | √ | null |
|
|
||||
| NODAL_STATUS_ID | int | 4 | √ | null |
|
|
||||
| R_FIGO4 | varchar | 5 | √ | null |
|
|
||||
| R_FIGO_STAGINGTYPE | varchar | 5 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblPATHOLOGY_GYNAECOLOGY_1 | Primary key | Asc | PATHOLOGY_ID |
| IX_tblPATHOLOGY_GYNAECOLOGY | Performance | Asc | PATHOLOGY_ID |