newNBOCAP_TUMOUR


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 null
PATIENT_ID int 4 √ null
NHSNumber varchar 10 √ null
DateOfBirth smalldatetime 16 √ null
OrganisationFirstSeen varchar 50 √ null
DateOfDiagnosis smalldatetime 16 √ null
SourceOfReferral varchar 3 √ null
ClinicalNurseSpecialistIndication varchar 3 √ null
ICD10MajorSite varchar 5 √ null
SynchronousCancer varchar 30 √ null
PerformanceStatus varchar 3 √ null
CarePlanIntent varchar 3 √ null
PlannedCancerTreatmentType varchar 30 √ null
NoCancerTreatmentReason varchar 3 √ null
TCategory varchar 5 √ null
NCategory varchar 5 √ null
MCategory varchar 5 √ null
MonitoringIntent varchar 3 √ null
Username varchar 50 √ null
ERR_CarePlanIntent int 4 √ null
ERR_DateOfDiagnosis int 4 √ null
ERR_ICD10MajorSite int 4 √ null
ERR_TCategory int 4 √ null
ERR_NCategory int 4 √ null
ERR_MCategory int 4 √ null
ERR_PlannedCancerTreatmentType int 4 √ null
ERR_NoCancerTreatmentReason int 4 √ null
ERR_OrganisationFirstSeen int 4 √ null
ERR_PerformanceStatus int 4 √ null
ERR_SourceOfReferral int 4 √ null
TumourHeightAboveAnalVerge varchar 50 √ null
ERR_TumourHeightAboveAnalVerge int 4 √ null
MDTMeetingType varchar 4 √ null
TNMVersion varchar 2 √ null

Indexes

Constraint Name Type Sort Column(s)
CIX_newNBOCAP_TUMOUR_Username_CARE_ID Performance Asc/Asc Username + CARE_ID

Diagram producer might be missing

No diagrams were produced please see application output for any errors