tblSURGERY_UPPER_GI


Columns

Column Type Size Nulls Auto Default Children Parents Comments
UG_SUR_ID int identity 4 √ null
SURGERY_ID int 4 null
tblMAIN_SURGERY.SURGERY_ID FK_tblSURGERY_UPPER_GI_tblMAIN_SURGERYC
N_UG1_PHYSIO_SCORE real 4 √ null
N_UG2_OP_SCORE real 4 √ null
R_OUTCOME varchar 20 √ null
R_DELAY int 4 √ null
R_DELAY_REASON varchar 50 √ null
R_NODAL varchar 50 √ null
R_RECONSTRUCTION varchar 50 √ null
R_ENDO_MORB varchar 50 √ null
L_NUTRITIONAL_SUP varchar 50 √ null
L_MORBIDITY real 4 √ null
L_MORTALITY real 4 √ null
L_START_TIME char 5 √ null
L_END_TIME char 5 √ null
L_INDICATION varchar 255 √ null
L_INCISION varchar 255 √ null
L_CLOSURE varchar 255 √ null
L_PAIN int 4 √ null
L_PAIN_DETAIL varchar 255 √ null
L_THORACIC int 4 √ null
L_ABDOMINAL int 4 √ null
L_LIVER int 4 √ null
L_PANCREAS int 4 √ null
L_SPLEEN int 4 √ null
L_COLON int 4 √ null
L_OTHER_ORGAN int 4 √ null
L_ANAESTHETIC int 4 √ null
L_STENT_MULTIPLE varchar 1 √ null
L_STENT_TYPE int 4 √ null
L_STENT_PLACEMENT int 4 √ null
L_STENT_JUNCTION varchar 1 √ null
L_STENT_DEPLOYED varchar 1 √ 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
RETURN_TO_THEATRE varchar 1 √ null
ENDO_COMP_NO_COMP bit 1 √ null
ENDO_COMP_STRICTURE bit 1 √ null
ENDO_COMP_PERFORATION bit 1 √ null
ENDO_COMP_HAEMORRHAGE bit 1 √ null
ENDO_COMP_PANCREATITIS bit 1 √ null
ENDO_COMP_CHOLANGITIS bit 1 √ null
ENDO_COMP_OTHER_COMP bit 1 √ null
POST_OP_COMP_NONE bit 1 √ null
POST_OP_COMP_HAEMORR bit 1 √ null
EMR_ESD_USE int 4 √ null
EMR_ESD_RESULT int 4 √ null
EMR_PATHOLOGY int 4 √ null
WEIGHT real 4 √ null
HEIGHT real 4 √ null
SMOKER char 1 √ null
RADIO_PROC_TYPE int 4 √ null
BIL_STENT_INTENT int 4 √ null
PALLIATION_TYPE int 4 √ null
LIVER_TRANSPLANT varchar 1 √ null
PAL_TREAT_REASON int 4 √ null
ABLATIVE_THERAPY_TYPE varchar 1 √ null
RADIO_INSERTION int 4 √ null
NOGCA_BRACHYTHERAPY bit 1 √ null
SURGICAL_PATHWAY int 4 √ null
ltblSurgicalPathway.ID FK_tblSURGERY_UPPER_GI_ltblSurgicalPathwayR
ERAS_PATHWAY_COMPLETED int 4 √ null
ltblERASPathwayCompleted.ID FK_tblSURGERY_UPPER_GI_ltblERASPathwayCompletedR
LiverTransplantWaitingListIndicator int 4 √ null
ltblYNNK.YN_ID FK_tblSURGERY_UPPER_GI_LiverTransplantWaitingListIndicatorR
LiverSurgeryTypeID int 4 √ null
ltblLiverSurgeryType.LiverSurgeryTypeID FK_tblSURGERY_UPPER_GI_ltblLiverSurgeryTypeR
OtherAblativeSurgery varchar 50 √ null
SurgicalApproachType int 4 √ null
ltblSurgicalApproach.ID FK_tblSURGERY_UPPER_GI_ltblSurgicalApproachR
OpenApproachType int 4 √ null
ltblOpenApproach.ID FK_tblSURGERY_UPPER_GI_ltblOpenApproachR
MinimallyInvasiveApproachType int 4 √ null
ltblMinimallyInvasiveApproach.ID FK_tblSURGERY_UPPER_GI_ltblMinimallyInvasiveApproachR
AnastomosisType int 4 √ null
ltblAnastomosis.ID FK_tblSURGERY_UPPER_GI_ltblAnastomosisR
OesophagealConduitType int 4 √ null
ltblOesophagealConduit.ID FK_tblSURGERY_UPPER_GI_ltblOesophagealConduitR
NeckDissection int 4 √ null
ltblNeckDissection.ID FK_tblSURGERY_UPPER_GI_ltblNeckDissectionR
AdditionalComplications varchar 150 √ null
ChyleLeakSeverity int 4 √ null
ltblChyleLeakSeverity.ID FK_tblSURGERY_UPPER_GI_ltblChyleLeakSeverityR
LeakSeverity int 4 √ null
ltblLeakSeverity.ID FK_tblSURGERY_UPPER_GI_ltblLeakSeverityR
RecurrentNerveInjury int 4 √ null
ltblRecurrentNerveInjury.ID FK_tblSURGERY_UPPER_GI_ltblRecurrentNerveInjuryR
ConduitNecrosisFailure int 4 √ null
ltblConduitNecrosisFailure.ID FK_tblSURGERY_UPPER_GI_ltblConduitNecrosisFailureR
GradeOfComplications int 4 √ null
ltblGradeOfComplications.ID FK_tblSURGERY_UPPER_GI_ltblGradeOfComplicationsR
ChangeInLevelOfCare int 4 √ null
ltblChangeInLevelOfCare.ID FK_tblSURGERY_UPPER_GI_ltblChangeInLevelOfCareR
BloodProductUtilisation int 4 √ null
ltblBloodProductUtilisation.ID FK_tblSURGERY_UPPER_GI_ltblBloodProductUtilisationR
NumberOfUnitsTransfused int 4 √ null
ltblNumberOfUnitsTransfused.ID FK_tblSURGERY_UPPER_GI_ltblNumberOfUnitsTransfusedR
prehabFormProgofPE int 4 √ null
prehabPsychoSupport int 4 √ null
prehabRespMuscleTrain int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblSURGERY_UPPER_GI Primary key Asc UG_SUR_ID
IX_tblSURGERY_UPPER_GI Performance Asc SURGERY_ID

Relationships

Close relationships within degrees of separation