tblASSESSMENT_HN_INV_ORD_SITES


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AssessmentID int 4 null
tblASSESSMENT_HN_INV_ORD.AssessmentID FK_tblASSESSMENT_HN_INV_ORD_SITES_tblASSESSMENT_HN_INV_ORDC
OrderedInvestigationID int 4 null
tblASSESSMENT_HN_INV_ORD.OrderedInvestigationID FK_tblASSESSMENT_HN_INV_ORD_SITES_tblASSESSMENT_HN_INV_ORDC
InvestigationSiteID int 4 null
ltblInvestigationSite.ID FK_tblASSESSMENT_HN_INV_ORD_SITES_ltblInvestigationSiteC

Indexes

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

Relationships