tblASSESSMENT_HN_INV_ORD


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AssessmentID int 4 null
tblASSESSMENT_HN_INV_ORD_SITES.AssessmentID FK_tblASSESSMENT_HN_INV_ORD_SITES_tblASSESSMENT_HN_INV_ORDC
tblASSESSMENT_HEAD_NECK.ASSESSMENT_ID FK_tblASSESSMENT_HN_INV_ORD_tblASSESSMENT_HEAD_NECKC
OrderedInvestigationID int 4 null
tblASSESSMENT_HN_INV_ORD_SITES.OrderedInvestigationID FK_tblASSESSMENT_HN_INV_ORD_SITES_tblASSESSMENT_HN_INV_ORDC
ltblInvestigationsOrdered.ID FK_tblASSESSMENT_HN_INV_ORD_ltblInvestigationsOrderedC

Indexes

Constraint Name Type Sort Column(s)
PK_tblASSESSMENT_HN_INV_ORD Primary key Asc/Asc AssessmentID + OrderedInvestigationID

Relationships