expSWCIS_PATHOLOGY_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SWCIS_ID int identity 4 √ null
PATHOLOGY_ID int 4 √ null
NHSNumber varchar 10 √ null
OrgCodeSubmitting varchar 5 √ null
CareSpellID varchar 50 √ null
InvestigationType varchar 2 √ null
SampleReceiptDate datetime 16,3 √ null
InvestigationResultDate datetime 16,3 √ null
ConsultantPathologist varchar 8 √ null
SiteCodeReporting varchar 5 √ null
PathologicalDiagnosis varchar 5 √ null
PathologicalLaterality varchar 1 √ null
InvasiveLesionSize real 4 √ null
SynchronousTumour varchar 50 √ null
PathologicalHistology varchar 10 √ null
PathologicalGradeDifferentiation varchar 2 √ null
CancerInvasion varchar 50 √ null
ExcisionMargin varchar 50 √ null
NumberNodes int 4 √ null
PositiveNodes int 4 √ null
PathologicalTStage varchar 5 √ null
PathologicalNStage varchar 5 √ null
PathologicalMStage varchar 5 √ null
PathologicalTNMStage varchar 20 √ null
ReportNumber varchar 50 √ null
ReportStatus int 4 √ null
SpecimenNature int 4 √ null
SiteCodeRequest varchar 5 √ null
RequestedBy varchar 8 √ null
MinTumourFreeVaginalMargin real 4 √ null
MinTumourFreeSkinMargin real 4 √ null
MinTumourFreeAnalMargin real 4 √ null
MinDeepSoftTissueMargin real 4 √ null
DepthInvasion real 4 √ null
DepthInvasionMicroCa real 4 √ null
DistanceResectionMargin real 4 √ null
TumourDeepMargin varchar 3 √ null
VaginalCuff varchar 50 √ null
VaginalInvolvement varchar 3 √ null
DistanceVaginalMargin real 4 √ null
ParametrialParacervial varchar 3 √ null
NatureVulvalSkinCode int 4 √ null
NatureVulvalSkin varchar 50 √ null
DepthMyometrialInfiltraionCode int 4 √ null
DepthMyometrialInfiltraion varchar 50 √ null
EndocervicalExtenstionCode int 4 √ null
EndocervicalExtenstion varchar 50 √ null
SerosalInvolvement varchar 3 √ null
ExtraNodalExteneration varchar 3 √ null
ExtranodalSpread varchar 3 √ null
OvarianMets varchar 50 √ null
OvarianCapsularCode int 4 √ null
OvarianCapsular varchar 50 √ null
OmentumCode int 4 √ null
Omentum varchar 50 √ null
ContralateralOvaryCode int 4 √ null
ContralateralOvary varchar 50 √ null
AscitesWashings varchar 50 √ null
Brushings varchar 50 √ null
PleuralFluid varchar 50 √ null
BackgroundNormal varchar 3 √ null
BackgroundAtypical varchar 3 √ null
BackgroundHyperplasia varchar 3 √ null
HyperplasiaType varchar 255 √ null
ParaAorticNodes varchar 50 √ null
NoGroinNodesLeft int 4 √ null
PosGorinNodesLeft int 4 √ null
NoGroinNodesRight int 4 √ null
PosGorinNodesRight int 4 √ null
NoPelvicNodesLeft int 4 √ null
PosPelvicNodesLeft int 4 √ null
NoPelvicNodesRight int 4 √ null
PosPelvicNodesRight int 4 √ null
NoIliacNodesLeft int 4 √ null
PosIliacNodesLeft int 4 √ null
NoIliacNodesRight int 4 √ null
PosIliacNodesRight int 4 √ null
NoSentinelNodes int 4 √ null
PosSentinelNodes int 4 √ null
FIGO varchar 50 √ null
Username varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_expSWCIS_PATHOLOGY_TEMP Primary key Asc SWCIS_ID
IX_expSWCIS_PATHOLOGY_TEMP Performance Asc Username

Diagram producer might be missing

No diagrams were produced please see application output for any errors