Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| BREAST_SUR_ID | int identity | 4 | √ | null |
|
|
Unique Record ID (Auto) |
|||
| SURGERY_ID | int | 4 | null |
|
|
Links record to Surgery |
||||
| N_B8_LYMPH_NODE | varchar | 1 | √ | null |
|
|
Sentinel Node Result |
|||
| L_BREAST_PRO | int | 4 | √ | null |
|
|
Breast Procedure |
|||
| L_NODE_PRO | int | 4 | √ | null |
|
|
Lymph Node Procedure |
|||
| L_RECONSTRUCTION | int | 4 | √ | null |
|
|
Reconstruction |
|||
| L_SYMMETRISATION | int | 4 | √ | null |
|
|
Symmetrisation |
|||
| L_BREAST_PRO2 | int | 4 | √ | null |
|
|
Breast Procedure |
|||
| L_NODE_PRO2 | int | 4 | √ | null |
|
|
Lymph Node Procedure |
|||
| L_RECONSTRUCTION2 | int | 4 | √ | null |
|
|
Reconstruction |
|||
| L_SYMMETRISATION2 | int | 4 | √ | null |
|
|
Symmetrisation |
|||
| L_LATERALITY | varchar | 5 | √ | null |
|
|
Laterality |
|||
| L_LATERALITY2 | varchar | 5 | √ | null |
|
|
Laterality |
|||
| L_OUTCOME | int | 4 | √ | null |
|
|
Outcome of this Op |
|||
| L_CANCELLED | int | 4 | √ | null |
|
|
Operation cancelled/delayed |
|||
| L_CANCEL_OP | varchar | 255 | √ | null |
|
|
Reason operation cancelled/delayed |
|||
| L_START_TIME | char | 5 | √ | null |
|
|
Start Time (Knife to Skin) |
|||
| L_END_TIME | char | 5 | √ | null |
|
|
End Time (Wound Closure) |
|||
| L_GUIDED | varchar | 5 | √ | null |
|
|
Wire Guided |
|||
| L_ANAESTHETIC | varchar | 50 | √ | null |
|
|
Anaesthetic |
|||
| L_INDICATION | varchar | 255 | √ | null |
|
|
Indication for Surgery |
|||
| L_INCISION | varchar | 255 | √ | null |
|
|
Incision |
|||
| L_CLOSURE | varchar | 255 | √ | null |
|
|
Closure |
|||
| L_AXILLARY | int | 4 | √ | null |
|
|
Axillary Drainage Seen |
|||
| L_NO_NODES | int | 4 | √ | null |
|
|
No of Nodes Identified |
|||
| L_NO_SN_REMOVED | int | 4 | √ | null |
|
|
No of Sentinel Nodes Removed |
|||
| L_NO_NODES_REMOVED | int | 4 | √ | null |
|
|
No of Other Nodes Removed |
|||
| R_PT_TYPE | int | 4 | √ | null |
|
|
Patient Type |
|||
| R_PLANNED | varchar | 2 | √ | null |
|
|
Planned Secondary Reconstruction |
|||
| R_IMMEDIATE_OFFERED | varchar | 5 | √ | null |
|
|
Was Immediate Reconstruction Offered |
|||
| R_NOT_IMMEDIATE | varchar | 2 | √ | null |
|
|
If not offered, why not |
|||
| R_DELAY_OFFERED | varchar | 5 | √ | null |
|
|
Was Delayed Reconstruction Offered |
|||
| R_ACCEPTED | varchar | 5 | √ | null |
|
|
If offered, has it been accepted |
|||
| R_NOT_OFFERED | varchar | 2 | √ | null |
|
|
In not offered, why not |
|||
| R_SITE_COMPS | int | 4 | √ | null |
|
|
Mastectomy/Flap Donor Site |
|||
| R_FLAP_COMPS | int | 4 | √ | null |
|
|
Flap Related |
|||
| R_IMPLANT_COMPS | int | 4 | √ | null |
|
|
Implant/Expander Related |
|||
| L_FINDINGS | text | 2147483647 | √ | null |
|
|
Findings |
|||
| 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 |
|
|
||||
| SNOMEDProc | int | 4 | √ | null |
|
|
||||
| SNOMEDProc2 | int | 4 | √ | null |
|
|
||||
| SNOMEDReconstruction | int | 4 | √ | null |
|
|
||||
| SNOMEDReconstruction2 | int | 4 | √ | null |
|
|
||||
| SNOMEDSymmetrisation | int | 4 | √ | null |
|
|
||||
| SNOMEDSymmetrisation2 | int | 4 | √ | null |
|
|
||||
| SNOMEDLymph | int | 4 | √ | null |
|
|
||||
| SNOMEDLymph2 | int | 4 | √ | null |
|
|
||||
| OtherOutcomeOfOp | varchar | 50 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblSURGERY_BREAST | Primary key | Asc | BREAST_SUR_ID |
| IX_tblSURGERY_BREAST | Performance | Asc | SURGERY_ID |