expNMBRA_OPERATION_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NMBRA_ID int identity 4 √ null
SURGERY_ID int 4 √ null
CARE_ID int 4 √ null
PATIENT_ID int 4 √ null
ASA int 4 √ null
DTT_DATE datetime 16,3 √ null
HospitalType int 4 null
SubmittingHospital varchar 5 null
TypePatient int 4 √ null
NHSNumber varchar 10 √ null
HospitalNumber varchar 10 √ null
DateBirth datetime 16,3 √ null
DateAdmission datetime 16,3 √ null
DateProcedure datetime 16,3 √ null
Mastectomy varchar 2 √ null
Axillary varchar 2 √ null
Reconstruction varchar 5 √ null
Symmetrisation varchar 2 √ null
PlannedAdjuvant varchar 20 √ null
SecondaryReconstruction varchar 2 √ null
ImmediateOffered varchar 2 √ null
ReasonImmediateNotOffered varchar 2 √ null
DelayedOffered varchar 2 √ null
DelayedAccepted varchar 2 √ null
ReasonDelayedNotOffered varchar 2 √ null
SiteCode varchar 5 √ null
DateDischarged datetime 16,3 √ null
ReturnTheatre varchar 2 √ null
TransferITU varchar 2 √ null
AdmissionDeath varchar 2 √ null
CompDonorSite varchar 2 √ null
CompFlap varchar 2 √ null
CompImplant varchar 2 √ null
CompDistant varchar 2 √ null
Username varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_expNMBRA_OPERATION_TEMP Primary key Asc NMBRA_ID
IX_expNMBRA_OPERATION_TEMP Performance Asc Username

Diagram producer might be missing

No diagrams were produced please see application output for any errors