tblMetastases


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CareID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblMetastases_tblMAIN_REFERRALSR
MetastaticSiteID int 4 null
ltblMetastaticSite.MetastaticSiteID FK_tblMetastases_ltblMetastaticSiteR
MetastaticStateID int 4 √ null
ltblMetastaticState.MetastaticStateID FK_tblMetastases_ltblMetastaticStateR
MetastaticTypeID int 4 √ null
ltblMetastaticType.MetastaticTypeID FK_tblMetastases_ltblMetastaticTypeR
OtherMets varchar 255 √ null
Position int 4 null

Indexes

Constraint Name Type Sort Column(s)
PK_tblMetastases Primary key Asc/Asc/Asc CareID + MetastaticSiteID + Position

Relationships

Close relationships within degrees of separation