tblUNPLANNED_RETURN_TO_THEATRE


Columns

Column Type Size Nulls Auto Default Children Parents Comments
UNPLANNED_RETURN_ID int identity 4 null
SURGERY_ID int 4 null
tblMAIN_SURGERY.SURGERY_ID FK_tblUNPLANNED_RETURN_TO_THEATRE_tblMAIN_SURGERYR
DATE_OF_SURGERY datetime 16,3 null
CON_ID int 4 null
ltblCONSULTANTS.CON_ID FK_tblUNPLANNED_RETURN_TO_THEATRE_ltblCONSULTANTSR
PROC_CODE varchar 5 null
ltblPROCEDURES.PROC_CODE FK_tblUNPLANNED_RETURN_TO_THEATRE_ltblPROCEDURESR
LAT_CODE varchar 1 null
ltblLATERALITY.LAT_CODE FK_tblUNPLANNED_RETURN_TO_THEATRE_ltblLATERALITYR
COMMENTS varchar 2147483647 null
SnomedRTT int 4 null

Indexes

Constraint Name Type Sort Column(s)
PK_tblUNPLANNED_RETURN_TO_THEATRE Primary key Asc UNPLANNED_RETURN_ID

Relationships