tmpNOGCA_SURGERY


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NOGCASurgeryID int identity 4 √ null
CareID int 4 √ null
NHSNumber varchar 50 √ null
DateOfBirth smalldatetime 16 √ null
HospitalNumber varchar 50 √ null
TreatingHospital varchar 5 √ null
AdmissionDate smalldatetime 16 √ null
DateOfSurgery smalldatetime 16 √ null
SurgicalIntent varchar 1 √ null
PatientFitness varchar 3 √ null
Smoker int 4 √ null
MainProcedure varchar 2 √ null
SurgicalAccessThoracic varchar 2 √ null
SurgicalAccessAbdominal int 4 √ null
NodalDissection int 4 √ null
SurgicalComplications varchar 50 √ null
DeathInHospital varchar 1 √ null
ReturnToTheatre varchar 1 √ null
DischargeDate smalldatetime 16 √ null
SurgeonCount int 4 √ null
SurgeonList varchar 50 √ null
SurgicalPathway int 4 √ null
ERASPathwayCompleted int 4 √ null
Username varchar 50 √ null
TNMVersion nchar 2 √ null
TCategory nvarchar 10 √ null
NCategory nvarchar 10 √ null
MCategory nvarchar 10 √ null
NutSuppAdmission nvarchar 4 √ null
DieteticAfter nchar 2 √ null
NutSuppDischarge nvarchar 4 √ null
PrehabFormalPE nvarchar 4 √ null
PrehabPsychSupport nvarchar 4 √ null
PrehabRespMuscleTraining nvarchar 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tmpNOGCA_SURGERY Primary key Asc NOGCASurgeryID

Diagram producer might be missing

No diagrams were produced please see application output for any errors