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 | 255 | √ | null |
|
|
||
ASA Grade | varchar | 100 | √ | null |
|
|
||
Start Time | char | 5 | √ | null |
|
|
||
End Time (Wound Closure) | char | 5 | √ | 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 |
|
|
||
Assistant 2 Grade | varchar | 50 | √ | null |
|
|
||
Primary Procedure | varchar | 100 | √ | null |
|
|
||
Primary Procedure Laterality | varchar | 5 | √ | null |
|
|
||
Primary Procedure Lymph Node Procedure | varchar | 50 | √ | null |
|
|
||
Primary Procedure Reconstruction | varchar | 100 | √ | null |
|
|
||
Primary Procedure Symmetrisation | varchar | 50 | √ | null |
|
|
||
Breast Procedure | varchar | 100 | √ | null |
|
|
||
Breast Procedure Laterality | varchar | 5 | √ | null |
|
|
||
Breast Procedure Lymph Node Procedure | varchar | 50 | √ | null |
|
|
||
Breast Procedure Reconstruction | varchar | 100 | √ | null |
|
|
||
Breast Procedure Symmetrisation | varchar | 50 | √ | null |
|
|