SNOMEDCTConcepts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
SNOMEDCTMap.SNOMEDCodeID FK_SNOMEDCTMap_SNOMEDCTConceptsR
tblBRAIN_MDT.SNOMEDDiagnosisID FK_tblBRAIN_MDT_SNOMEDCTConceptsR
tblBREAST_MDT.SNOMEDDiagnosisID FK_tblBREAST_MDT_SNOMEDCTConceptsR
tblCOLORECTAL_MDT.SNOMEDDiagnosisID FK_tblCOLORECTAL_MDT_SNOMEDCTConceptsR
tblCUP_MDT.SNOMEDDiagnosisID FK_tblCUP_MDT_SNOMEDCTConceptsR
tblGYNAECOLOGY_MDT.SNOMEDDiagnosisID FK_tblGYNAECOLOGY_MDT_SNOMEDCTConceptsR
tblHAEMATOLOGY_MDT.SNOMEDDiagnosisID FK_tblHAEMATOLOGY_MDT_SNOMEDCTConceptsR
tblHEAD_NECK_MDT.SNOMEDDiagnosisID FK_tblHEAD_NECK_MDT_SNOMEDCTConceptsR
tblLUNG_MDT.SNOMEDDiagnosisID FK_tblLUNG_MDT_SNOMEDCTConceptsR
tblMAIN_REFERRALS.SNOMEDCTDiagnosisID FK_tblMAIN_REFERRALS_SNOMEDCTConceptsR
tblMAIN_SURGERY.SNOMEDProcedure FK_tblMAIN_SURGERY_SNOMEDProcedure_SNOMEDCTConceptsR
tblMAIN_SURGERY.SNOMEDProcedure2 FK_tblMAIN_SURGERY_SNOMEDProcedure2_SNOMEDCTConceptsR
tblMAIN_SURGERY.SNOMEDProcedure3 FK_tblMAIN_SURGERY_SNOMEDProcedure3_SNOMEDCTConceptsR
tblOTHER_MDT.SNOMEDDiagnosisID FK_tblOTHER_MDT_SNOMEDCTConceptsR
tblPAEDIATRIC_MDT.SNOMEDDiagnosisID FK_tblPAEDIATRIC_MDT_SNOMEDCTConceptsR
tblSARCOMA_MDT.SNOMEDDiagnosisID FK_tblSARCOMA_MDT_SNOMEDCTConceptsR
tblSKIN_MDT.SNOMEDDiagnosisID FK_tblSKIN_MDT_SNOMEDCTConceptsR
tblUGI_MDT.SNOMEDDiagnosisID FK_tblUGI_MDT_SNOMEDCTConceptsR
tblUROLOGY_MDT.SNOMEDDiagnosisID FK_tblUROLOGY_MDT_SNOMEDCTConceptsR
SNOMEDCode bigint 8 null
Description nvarchar 500 null
IsDeleted bit 1 null

Indexes

Constraint Name Type Sort Column(s)
PK_SNOMEDCTConcepts Primary key Asc ID

Relationships