Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
SURGERY_ID | int | 4 | null |
|
|
|||||
CARE_ID | int | 4 | null |
|
|
|||||
TEMP_ID | varchar | 255 | √ | null |
|
|
||||
N7_1_SITE_CODE | varchar | 5 | √ | null |
|
|
||||
N_SITE_CODE_DTT | varchar | 5 | √ | null |
|
|
||||
N7_2_CONSULTANT | varchar | 8 | √ | null |
|
|
||||
N7_3_SPECIALTY | int | 4 | √ | null |
|
|
||||
N7_4_TREATMENT_INTENT | int | 4 | √ | null |
|
|
||||
N7_5_DECISION_DATE | smalldatetime | 16 | √ | null |
|
|
||||
N7_8_ADMISSION_DATE | smalldatetime | 16 | √ | null |
|
|
||||
N7_9_SURGERY_DATE | smalldatetime | 16 | √ | null |
|
|
||||
L_PROCEDURE_SITE | int | 4 | √ | null |
|
|
||||
L_PROCEDURE_TYPE | int | 4 | √ | null |
|
|
||||
L_PROCEDURE | int | 4 | √ | null |
|
|
||||
L_PROCEDURE_SITE2 | int | 4 | √ | null |
|
|
||||
L_PROCEDURE_TYPE2 | int | 4 | √ | null |
|
|
||||
L_PROCEDURE2 | int | 4 | √ | null |
|
|
||||
L_PROCEDURE_SITE3 | int | 4 | √ | null |
|
|
||||
L_PROCEDURE_TYPE3 | int | 4 | √ | null |
|
|
||||
L_PROCEDURE3 | int | 4 | √ | null |
|
|
||||
L_PROCEDURE_SITE4 | int | 4 | √ | null |
|
|
||||
L_PROCEDURE_TYPE4 | int | 4 | √ | null |
|
|
||||
L_PROCEDURE4 | int | 4 | √ | null |
|
|
||||
N7_10_PROCEDURE_1 | varchar | 5 | √ | null |
|
|
||||
N7_11_PROCEDURE_2 | varchar | 5 | √ | null |
|
|
||||
N7_11_PROCEDURE_3 | varchar | 5 | √ | null |
|
|
||||
N7_11_PROCEDURE_4 | varchar | 5 | √ | null |
|
|
||||
N7_12_DISCHARGE_DATE | smalldatetime | 16 | √ | null |
|
|
||||
N7_13_DISCHARGE_DESTINATION | int | 4 | √ | null |
|
|
||||
N_TREATMENT_EVENT | varchar | 2 | √ | null |
|
|
||||
N_TREATMENT_SETTING | varchar | 2 | √ | null |
|
|
||||
L_TRIAL | int | 4 | √ | null |
|
|
||||
L_SURGEON | varchar | 8 | √ | null |
|
|
||||
L_SURGEON_NAME | varchar | 50 | √ | null |
|
|
||||
L_GRADE | varchar | 50 | √ | null |
|
|
||||
L_ASSISTANT_1 | varchar | 8 | √ | null |
|
|
||||
L_ASSISTANT_NAME_1 | varchar | 50 | √ | null |
|
|
||||
L_GRADE_1 | varchar | 50 | √ | null |
|
|
||||
L_ASSISTANT_2 | varchar | 8 | √ | null |
|
|
||||
L_ASSISTANT_NAME_2 | varchar | 50 | √ | null |
|
|
||||
L_GRADE_2 | varchar | 50 | √ | null |
|
|
||||
L_ANAESTHETIST_NAME | varchar | 50 | √ | null |
|
|
||||
L_ANAESTHETIST | varchar | 50 | √ | null |
|
|
||||
L_ANAESTHETIST_NAME_2 | varchar | 50 | √ | null |
|
|
||||
L_ANAESTHETIST_2 | varchar | 50 | √ | null |
|
|
||||
L_URGENCY | varchar | 50 | √ | null |
|
|
||||
L_ANASTOMOSIS | varchar | 50 | √ | null |
|
|
||||
L_BLOOD_LOSS | real | 4 | √ | null |
|
|
||||
L_SUPPORT | varchar | 50 | √ | null |
|
|
||||
L_COMPLICATIONS | int | 4 | √ | null |
|
|
||||
L_COMPLICATIONS2 | int | 4 | √ | null |
|
|
||||
L_COMPLICATIONS3 | int | 4 | √ | null |
|
|
||||
L_OTHER_COMP | varchar | 255 | √ | null |
|
|
||||
L_POST_COMP | varchar | 255 | √ | null |
|
|
||||
L_TRANSFER | varchar | 20 | √ | null |
|
|
||||
L_DAYS | int | 4 | √ | null |
|
|
||||
L_RETURN_ITU | varchar | 50 | √ | null |
|
|
||||
L_REASON_RETURN | varchar | 255 | √ | null |
|
|
||||
L_DAYS_BACK | int | 4 | √ | null |
|
|
||||
DEFINITIVE_TREATMENT | int | 4 | √ | null |
|
|
||||
CWT_PROFORMA | int | 4 | √ | null |
|
|
||||
L_DISCHARGE_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
BREAST_SUR_ID | int | 4 | null |
|
|
|||||
N_B8_LYMPH_NODE | varchar | 1 | √ | null |
|
|
||||
L_BREAST_PRO | int | 4 | √ | null |
|
|
||||
L_NODE_PRO | int | 4 | √ | null |
|
|
||||
L_RECONSTRUCTION | int | 4 | √ | null |
|
|
||||
L_SYMMETRISATION | int | 4 | √ | null |
|
|
||||
L_BREAST_PRO2 | int | 4 | √ | null |
|
|
||||
L_NODE_PRO2 | int | 4 | √ | null |
|
|
||||
L_RECONSTRUCTION2 | int | 4 | √ | null |
|
|
||||
L_SYMMETRISATION2 | int | 4 | √ | null |
|
|
||||
L_LATERALITY | varchar | 5 | √ | null |
|
|
||||
L_LATERALITY2 | varchar | 5 | √ | null |
|
|
||||
L_OUTCOME | int | 4 | √ | null |
|
|
||||
L_CANCELLED | int | 4 | √ | null |
|
|
||||
L_CANCEL_OP | varchar | 255 | √ | null |
|
|
||||
ASAGrade | int | 4 | √ | null |
|
|
||||
L_START_TIME | char | 5 | √ | null |
|
|
||||
L_END_TIME | char | 5 | √ | null |
|
|
||||
L_GUIDED | varchar | 5 | √ | null |
|
|
||||
L_ANAESTHETIC | varchar | 50 | √ | null |
|
|
||||
L_INDICATION | varchar | 255 | √ | null |
|
|
||||
L_INCISION | varchar | 255 | √ | null |
|
|
||||
L_CLOSURE | varchar | 255 | √ | null |
|
|
||||
L_AXILLARY | int | 4 | √ | null |
|
|
||||
L_NO_NODES | int | 4 | √ | null |
|
|
||||
L_NO_SN_REMOVED | int | 4 | √ | null |
|
|
||||
L_NO_NODES_REMOVED | int | 4 | √ | null |
|
|
||||
R_PT_TYPE | int | 4 | √ | null |
|
|
||||
R_PLANNED | varchar | 2 | √ | null |
|
|
||||
R_IMMEDIATE_OFFERED | varchar | 5 | √ | null |
|
|
||||
R_NOT_IMMEDIATE | varchar | 2 | √ | null |
|
|
||||
R_DELAY_OFFERED | varchar | 5 | √ | null |
|
|
||||
R_ACCEPTED | varchar | 5 | √ | null |
|
|
||||
R_NOT_OFFERED | varchar | 2 | √ | null |
|
|
||||
R_SITE_COMPS | int | 4 | √ | null |
|
|
||||
R_FLAP_COMPS | int | 4 | √ | null |
|
|
||||
R_IMPLANT_COMPS | int | 4 | √ | null |
|
|
||||
L_FINDINGS | text | 2147483647 | √ | null |
|
|
||||
L_SPECIMENS | text | 2147483647 | √ | null |
|
|
||||
L_DRAINS | text | 2147483647 | √ | null |
|
|
||||
L_POST_OP | text | 2147483647 | √ | null |
|
|
||||
L_COMMENTS | text | 2147483647 | √ | null |
|
|