Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
|||
| SURGERY_ID | int | 4 | null |
|
|
|||
| Operation Not Performed | varchar | 3 | √ | null |
|
|
||
| Reason Operation Not Performed | varchar | 100 | √ | null |
|
|
||
| ASA Grade | varchar | 100 | √ | null |
|
|
||
| Start Time | varchar | 30 | √ | null |
|
|
||
| End Time (Wound Closure) | varchar | 30 | √ | null |
|
|
||
| Procedure Comments | text | 2147483647 | √ | null |
|
|
||
| Indication for Surgery | varchar | 255 | √ | null |
|
|
||
| Incision | varchar | 255 | √ | null |
|
|
||
| Findings | text | 2147483647 | √ | null |
|
|
||
| Specimens | text | 2147483647 | √ | null |
|
|
||
| Drains | text | 2147483647 | √ | null |
|
|
||
| Closure | varchar | 255 | √ | null |
|
|
||
| Post-Op Instructions | text | 2147483647 | √ | null |
|
|
||
| Surgeon | varchar | 50 | √ | null |
|
|
||
| Surgeon Grade | varchar | 50 | √ | null |
|
|
||
| Assistant | varchar | 50 | √ | null |
|
|
||
| Assistant Grade | varchar | 50 | √ | null |
|
|
||
| Assistant 2 | varchar | 50 | √ | null |
|
|
||
| Main Procedure | varchar | 255 | √ | null |
|
|
||
| Primary Procedure (SNOMED) | nvarchar | 500 | √ | null |
|
|
||
| Sub Procedure 1 | varchar | 255 | √ | null |
|
|
||
| Sub Procedure 1 (SNOMED) | nvarchar | 500 | √ | null |
|
|
||
| Sub Procedure 2 | varchar | 255 | √ | null |
|
|
||
| Sub Procedure 2 (SNOMED) | nvarchar | 500 | √ | null |
|
|
||
| Excision Type (CNS) | varchar | 50 | √ | null |
|
|
||
| Tumour Location (CNS) | varchar | 50 | √ | null |
|
|
||
| Procedure Comments (CNS) | text | 2147483647 | √ | null |
|
|
||
| Intra-Op Smear (CNS) | varchar | 3 | √ | null |
|
|
||
| Smear Details (CNS) | text | 2147483647 | √ | null |
|
|
||
| Smear Reported to (CNS) | varchar | 59 | √ | null |
|
|
||
| Anti-Cancer/Radioactive Implants (CNS) | varchar | 3 | √ | null |
|
|
||
| Implant Details (CNS) | text | 2147483647 | √ | null |
|
|