tblNonPrimaryPathway


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NonPrimaryPathwayID int identity 4 √ null
NonPrimaryPathwayMets.NonPrimaryPathwayID Implied ConstraintR
NonPrimaryPathwayOV.NonPrimaryPathwayID Implied ConstraintR
tblNonPrimaryMetastases.NonPrimaryPathwayID FK_tblNonPrimaryMetastases_tblNonPrimaryPathwayR
CareID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblNonPrimaryPathway_tblMAIN_REFERRALSR
DiagnosisDate date 20 √ null
NonPrimaryPathwayTypeID int 4 √ null
ltblNonPrimaryPathwayType.NonPrimaryPathwayTypeID FK_tblNonPrimaryPathway_ltblNonPrimaryPathwayTypeR
NonPrimaryWHOTumourGradeID int 4 √ null
ltblNonPrimaryWHOTumourGrade.NonPrimaryWHOTumourGradeID FK_tblNonPrimaryPathway_ltblNonPrimaryWHOTumourGradeR
NonPrimaryMorphologySNOMedCT int 4 √ null
ltblSNOMedCT.CT_Snomed_ID FK_tblNonPrimaryPathway_ltblSNOMedCTR
NonPrimaryMorphologyICD03Group int 4 √ null
ltblHAEM_ICD03_GROUP.GroupID FK_tblNonPrimaryPathway_ltblHAEM_ICD03_GROUPR
NonPrimaryMorphologyICD03 int 4 √ null
ltblHAEM_ICD03.ICD03ID FK_tblNonPrimaryPathway_ltblHAEM_ICD03R
NonPrimaryDiagnosisID_1 int 4 √ null
ltblDIAGNOSIS.ID FK_tblNonPrimaryPathway_NonPrimaryDiagnosisID_1R
NonPrimaryDiagnosisID_2 int 4 √ null
ltblDIAGNOSIS.ID FK_tblNonPrimaryPathway_NonPrimaryDiagnosisID_2R
ACTION_ID int 4 √ null
SourceReferralOutpatients varchar 2 √ null
ltblOUT_PATIENT_REFERRAL.REF_CODE FK_tblNonPrimaryPathway_ltblOUT_PATIENT_REFERRALR
PalliativeCareSpecialistSeenIndicator int 4 √ null
ltblYNNK.YN_ID FK_tblNonPrimaryPathway_ltblYNNKR
ROOT_CAUSE_COMMENTS varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblNonPrimaryPathway Primary key Asc NonPrimaryPathwayID

Relationships

Close relationships within degrees of separation