Add Constraints to tables
VT-AOE-DMAD-Drew-Bennett opened this issue · 0 comments
VT-AOE-DMAD-Drew-Bennett commented
This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments.
Author(s)
Drew Bennett
Authoring Organization(s)
State of Vermont
Email Address
drew.bennett@vermont.gov
Use Case Title
Reduce duplication in CEDS by adding unique constraints
Use Case Overview
OrganizationPersonRole
ALTER TABLE CEDS.dbo.OrganizationPersonRole
ADD CONSTRAINT UN_OrganizationPersonRole_OrganizationId_PersonID_RoleID_EntryDate_ExitDate_DataCollectionID
UNIQUE(OrganizationId, PersonID, RoleID, EntryDate, ExitDate, DataCollectionID)