Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| GYNAE_SUR_ID | int identity | 4 | √ | null |
|
|
Record Unique ID |
|||
| SURGERY_ID | int | 4 | null |
|
|
Surgery Record ID |
||||
| L_NOT_OP | varchar | 3 | √ | null |
|
|
Operation not performed |
|||
| L_NO_OP_REASON | int | 4 | √ | null |
|
|
Reason Operation not performed |
|||
| L_START_TIME | char | 5 | √ | null |
|
|
Start Time |
|||
| L_END_TIME | char | 5 | √ | null |
|
|
End Time (Wound Closure) |
|||
| L_INDICATION | varchar | 255 | √ | null |
|
|
Indication for Surgery |
|||
| R_INCISION | int | 4 | √ | null |
|
|
Incision |
|||
| L_CLOSURE | varchar | 255 | √ | null |
|
|
Closure (Textbox) |
|||
| R_CLOSURE | int | 4 | √ | null |
|
|
Closure (Drop down list) |
|||
| R_YEAR_REG | int | 4 | √ | null |
|
|
SpReg (Year) |
|||
| R_SUPERVISED | varchar | 3 | √ | null |
|
|
Supervised by Consultant |
|||
| R_RESIDUAL | int | 4 | √ | null |
|
|
Max. Size of Residual Disease |
|||
| R_IVU | int | 4 | √ | null |
|
|
IVU |
|||
| R_CXR | int | 4 | √ | null |
|
|
CXR |
|||
| R_ORGANS | int | 4 | √ | null |
|
|
Organs Involved |
|||
| R_CERVIX | int | 4 | √ | null |
|
|
Cervix |
|||
| R_OVARIES | varchar | 1 | √ | null |
|
|
Ovaries |
|||
| R_TUBE | int | 4 | √ | null |
|
|
Tubes |
|||
| R_UTERUS | int | 4 | √ | null |
|
|
Uterus |
|||
| R_VAGINA | int | 4 | √ | null |
|
|
Vagina |
|||
| R_VULVAL | int | 4 | √ | null |
|
|
Vulva |
|||
| R_URETHRA | int | 4 | √ | null |
|
|
Uretra |
|||
| R_BLADDER | int | 4 | √ | null |
|
|
Bladder |
|||
| R_BOWEL | int | 4 | √ | null |
|
|
Small Bowel |
|||
| R_APPENDIX | int | 4 | √ | null |
|
|
Appendix |
|||
| R_AS_COLON | int | 4 | √ | null |
|
|
Asc Colon |
|||
| R_DES_COLON | int | 4 | √ | null |
|
|
Des Colon |
|||
| R_TR_COLON | int | 4 | √ | null |
|
|
Trans Colon |
|||
| R_RECTUM | int | 4 | √ | null |
|
|
Rectum |
|||
| R_ANUS | int | 4 | √ | null |
|
|
Anus |
|||
| R_OMENTUM | int | 4 | √ | null |
|
|
Omentum |
|||
| R_PERITONIUM | int | 4 | √ | null |
|
|
Peritoneum |
|||
| R_ABDOM_PERI | int | 4 | √ | null |
|
|
Abdominal Peritoneum |
|||
| R_PELVIC_PERI | int | 4 | √ | null |
|
|
Pelvic Peritoneum |
|||
| R_SUB_PERI | int | 4 | √ | null |
|
|
Sub-Diaphragmic Peritoneum |
|||
| R_LIVER_SURFACE | int | 4 | √ | null |
|
|
Liver Surface |
|||
| R_LIVER_PAREN | int | 4 | √ | null |
|
|
Liver Parenchyma |
|||
| R_PELVIC_BONE | int | 4 | √ | null |
|
|
Pelvic Bone |
|||
| R_OTHER_ORGAN | varchar | 255 | √ | null |
|
|
Other Organs |
|||
| R_LATERAL_L | int | 4 | √ | null |
|
|
Left Lateral |
|||
| R_LATERAL_R | int | 4 | √ | null |
|
|
Right Lateral |
|||
| R_ANTERIOR | int | 4 | √ | null |
|
|
Central Anterior |
|||
| R_POSTERIOR | int | 4 | √ | null |
|
|
Central Posterior |
|||
| R_IPSILATERAL | int | 4 | √ | null |
|
|
Ipsilateral |
|||
| R_CONTRALATERAL | int | 4 | √ | null |
|
|
Contralateral |
|||
| R_SIZE | real | 4 | √ | null |
|
|
Size of Largest Tumour Mass (1) |
|||
| R_SIZE2 | real | 4 | √ | null |
|
|
Size of Largest Tumour Mass (2) |
|||
| R_ASCITES | int | 4 | √ | null |
|
|
Ascites Present & Sampled |
|||
| R_WASHINGS | int | 4 | √ | null |
|
|
Washings Taken |
|||
| R_AORTIC_PALP | int | 4 | √ | null |
|
|
Para-aortic Nodes Palpated |
|||
| R_OP_NO | int | 4 | √ | null |
|
|
Ovarian Op No. |
|||
| L_FINDINGS | text | 2147483647 | √ | null |
|
|
Findings Comments |
|||
| L_SPECIMENS | text | 2147483647 | √ | null |
|
|
Specimens |
|||
| L_DRAINS | text | 2147483647 | √ | null |
|
|
Drains |
|||
| L_POST_OP | text | 2147483647 | √ | null |
|
|
Post-Op Instructions |
|||
| L_COMMENTS | text | 2147483647 | √ | null |
|
|
Procedure Comments |
|||
| SENIOR_SURG_GRADE | varchar | 2 | √ | null |
|
|
Senior Surgeon Grade |
|||
| RISIDUAL | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblSURGERY_GYNAECOLOGY | Primary key | Asc | GYNAE_SUR_ID |
| IX_tblSURGERY_GYNAECOLOGY | Performance | Asc | SURGERY_ID |