Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
SWCIS_ID | int identity | 4 | √ | null |
|
|
||
SURGERY_ID | int | 4 | √ | null |
|
|
||
Procedure1 | int | 4 | √ | null |
|
|
||
Procedure2 | int | 4 | √ | null |
|
|
||
Procedure3 | int | 4 | √ | null |
|
|
||
Procedure4 | int | 4 | √ | null |
|
|
||
Procedure5 | int | 4 | √ | null |
|
|
||
Procedure6 | int | 4 | √ | null |
|
|
||
Procedure7 | int | 4 | √ | null |
|
|
||
Procedure8 | int | 4 | √ | null |
|
|
||
Procedure9 | int | 4 | √ | null |
|
|
||
NHSNumber | varchar | 10 | √ | null |
|
|
||
OrgCodeSubmitting | varchar | 5 | √ | null |
|
|
||
CareSpellID | varchar | 50 | √ | null |
|
|
||
SiteCode | varchar | 5 | √ | null |
|
|
||
Consultant | varchar | 8 | √ | null |
|
|
||
Specialty | int | 4 | √ | null |
|
|
||
TreatmentIntent | varchar | 1 | √ | null |
|
|
||
DecisionTreatDate | datetime | 16,3 | √ | null |
|
|
||
AdmissionDate | datetime | 16,3 | √ | null |
|
|
||
SurgeryDate | datetime | 16,3 | √ | null |
|
|
||
PrimaryProcedure | varchar | 50 | √ | null |
|
|
||
SubProcedure1 | varchar | 50 | √ | null |
|
|
||
SubProcedure2 | varchar | 50 | √ | null |
|
|
||
SubProcedure3 | varchar | 50 | √ | null |
|
|
||
SubProcedure4 | varchar | 50 | √ | null |
|
|
||
SubProcedure5 | varchar | 50 | √ | null |
|
|
||
SubProcedure6 | varchar | 50 | √ | null |
|
|
||
SubProcedure7 | varchar | 50 | √ | null |
|
|
||
SubProcedure8 | varchar | 50 | √ | null |
|
|
||
DischargeDate | datetime | 16,3 | √ | null |
|
|
||
DischargeDestnation | int | 4 | √ | null |
|
|
||
ASA | int | 4 | √ | null |
|
|
||
GradeSurgeon | varchar | 50 | √ | null |
|
|
||
SpRegYear | int | 4 | √ | null |
|
|
||
SupervisedOp | varchar | 3 | √ | null |
|
|
||
IVUCode | int | 4 | √ | null |
|
|
||
IVU | varchar | 50 | √ | null |
|
|
||
CXRCode | int | 4 | √ | null |
|
|
||
CXR | varchar | 50 | √ | null |
|
|
||
IncisionCode | int | 4 | √ | null |
|
|
||
Incision | varchar | 50 | √ | null |
|
|
||
LeftLateral | int | 4 | √ | null |
|
|
||
RightLateral | int | 4 | √ | null |
|
|
||
CentralAnterior | int | 4 | √ | null |
|
|
||
CentralPosterior | int | 4 | √ | null |
|
|
||
IpsilateralNodeCode | int | 4 | √ | null |
|
|
||
IpsilateralNode | varchar | 50 | √ | null |
|
|
||
ContralateralNodeCode | int | 4 | √ | null |
|
|
||
ContralateralNode | varchar | 50 | √ | null |
|
|
||
TumourSize | varchar | 50 | √ | null |
|
|
||
WoundClosureCode | int | 4 | √ | null |
|
|
||
WoundClosure | varchar | 50 | √ | null |
|
|
||
ResidualMassCode | int | 4 | √ | null |
|
|
||
ResidualMass | varchar | 50 | √ | null |
|
|
||
OvarianOpNo | int | 4 | √ | null |
|
|
||
Ascites | int | 4 | √ | null |
|
|
||
Washings | int | 4 | √ | null |
|
|
||
NodesPalpatedCode | int | 4 | √ | null |
|
|
||
NodesPalpated | varchar | 50 | √ | null |
|
|
||
Cervix | int | 4 | √ | null |
|
|
||
Ovaries | varchar | 1 | √ | null |
|
|
||
Tubes | int | 4 | √ | null |
|
|
||
Uterus | int | 4 | √ | null |
|
|
||
Vaginal | int | 4 | √ | null |
|
|
||
Vulva | int | 4 | √ | null |
|
|
||
Uretra | int | 4 | √ | null |
|
|
||
Bladder | int | 4 | √ | null |
|
|
||
SmallBowel | int | 4 | √ | null |
|
|
||
Appendix | int | 4 | √ | null |
|
|
||
AscColon | int | 4 | √ | null |
|
|
||
TransColon | int | 4 | √ | null |
|
|
||
DescColon | int | 4 | √ | null |
|
|
||
Rectum | int | 4 | √ | null |
|
|
||
Anus | int | 4 | √ | null |
|
|
||
Omentum | int | 4 | √ | null |
|
|
||
Peritoneum | int | 4 | √ | null |
|
|
||
AbdoPeritoneum | int | 4 | √ | null |
|
|
||
PelvicPeritoneum | int | 4 | √ | null |
|
|
||
SubDiaphramPeritoneum | int | 4 | √ | null |
|
|
||
LiverSurface | int | 4 | √ | null |
|
|
||
LiverParenchyma | int | 4 | √ | null |
|
|
||
PelvicBone | int | 4 | √ | null |
|
|
||
OtherOrgan | varchar | 255 | √ | null |
|
|
||
CancerSite | varchar | 50 | √ | null |
|
|
||
Username | varchar | 50 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_expSWCIS_SURGERY_TEMP | Primary key | Asc | SWCIS_ID |
IX_expSWCIS_SURGERY_TEMP | Performance | Asc | Username |
Diagram producer might be missing
No diagrams were produced please see application output for any errors