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 |
|
|
||
Username | varchar | 50 | √ | null |
|
|
||
ERASPathwayCompleted | int | 4 | √ | null |
|
|
||
ErrAbdominalAccess | bit | 1 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_tmpRPT_NOGCA_SURGERY | Primary key | Asc | NOGCASurgeryID |
Diagram producer might be missing
No diagrams were produced please see application output for any errors