ltblSNOMed


Columns

Column Type Size Nulls Auto Default Children Parents Comments
M_CODE varchar 50 null
SNOMED.M_CODE Implied ConstraintR
SNOMED_BRAIN.M_CODE Implied ConstraintR
SNOMED_BREAST.M_CODE Implied ConstraintR
SNOMED_COLORECTAL.M_CODE Implied ConstraintR
SNOMED_CUP.M_CODE Implied ConstraintR
SNOMED_DERMATOLOGY.M_CODE Implied ConstraintR
SNOMED_GYNAECOLOGY.M_CODE Implied ConstraintR
SNOMED_HAEMATOLOGY.M_CODE Implied ConstraintR
SNOMED_HEAD_NECK.M_CODE Implied ConstraintR
SNOMED_LUNG.M_CODE Implied ConstraintR
SNOMED_MAP.M_CODE Implied ConstraintR
SNOMED_OTHER.M_CODE Implied ConstraintR
SNOMED_SARCOMA.M_CODE Implied ConstraintR
SNOMED_UGI.M_CODE Implied ConstraintR
SNOMED_UROLOGY.M_CODE Implied ConstraintR
M_DESC varchar 255 null
M_GROUP int 4 √ null
VERSION varchar 50 √ null
IsBCC bit 1 null

Indexes

Constraint Name Type Sort Column(s)
PK_ltblSNOMed Primary key Asc M_CODE
IX_ltblSNOMed Performance Asc M_DESC

Relationships

Close relationships within degrees of separation