Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
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 |
|
|
||
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 |
|
|
||
Username | varchar | 50 | √ | null |
|
|