--
--  database integrity initialization
--

ALTER TABLE Actor ADD CONSTRAINT FK_ActCivID_Ref FOREIGN KEY (ActCivID) REFERENCES RefValues (RefID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActStaID_Ref FOREIGN KEY (ActStaID) REFERENCES RefValues (RefID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActSitID_Sit FOREIGN KEY (ActSitID) REFERENCES Site (SitID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActAdeID_Ref FOREIGN KEY (ActAdeID) REFERENCES RefValues (RefID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActDeptID_Dpt FOREIGN KEY (ActDeptID) REFERENCES Department (DptID);
ALTER TABLE MvaActSector ADD CONSTRAINT FK_MC_ActSector_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE MvaActLngID ADD CONSTRAINT FK_MC_ActLngID_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE MvaActLngID ADD CONSTRAINT FK_MT_ActLngID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActManager_Act FOREIGN KEY (ActManager) REFERENCES Actor (ActID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActBackup_Act FOREIGN KEY (ActBackup) REFERENCES Actor (ActID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActAssistant_Act FOREIGN KEY (ActAssistant) REFERENCES Actor (ActID);
ALTER TABLE MvaActCsoID ADD CONSTRAINT FK_MC_ActCsoID_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE MvaActCsoID ADD CONSTRAINT FK_MT_ActCsoID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaActCpoID ADD CONSTRAINT FK_MC_ActCpoID_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE MvaActCpoID ADD CONSTRAINT FK_MT_ActCpoID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaActNcoID ADD CONSTRAINT FK_MC_ActNcoID_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE MvaActNcoID ADD CONSTRAINT FK_MT_ActNcoID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaActRoles ADD CONSTRAINT FK_MC_ActRoles_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE MvaActRoles ADD CONSTRAINT FK_MT_ActRoles_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActDecisionProfile_Ref FOREIGN KEY (ActDecisionProfile) REFERENCES RefValues (RefID);
ALTER TABLE MvaActDshIDs ADD CONSTRAINT FK_MC_ActDshIDs_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE MvaActDshIDs ADD CONSTRAINT FK_MT_ActDshIDs_Dsh FOREIGN KEY (MvaText) REFERENCES Dashboard (DshID) ON DELETE SET NULL;
ALTER TABLE Actor ADD CONSTRAINT FK_ActCtrID_Ref FOREIGN KEY (ActCtrID) REFERENCES RefValues (RefID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActCotID_Ref FOREIGN KEY (ActCotID) REFERENCES RefValues (RefID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActDashID_Dsh FOREIGN KEY (ActDashID) REFERENCES Dashboard (DshID) ON DELETE SET NULL;
ALTER TABLE Actor ADD CONSTRAINT FK_ActSyncType_Ref FOREIGN KEY (ActSyncType) REFERENCES RefValues (RefID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActSyncModel_Sym FOREIGN KEY (ActSyncModel) REFERENCES SyncModel (SymID) ON DELETE SET NULL;
ALTER TABLE Actor ADD CONSTRAINT FK_ActLngPrinc_Ref FOREIGN KEY (ActLngPrinc) REFERENCES RefValues (RefID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActTzoID_Ref FOREIGN KEY (ActTzoID) REFERENCES RefValues (RefID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActTymID_Ref FOREIGN KEY (ActTymID) REFERENCES RefValues (RefID);
ALTER TABLE MvaActPermLics ADD CONSTRAINT FK_MC_ActPermLics_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE MvaActFloatLics ADD CONSTRAINT FK_MC_ActFloatLics_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE MvaActSyncOptions ADD CONSTRAINT FK_MC_ActSyncOptions_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE Actor ADD CONSTRAINT FK_ActPartitionID_Prt FOREIGN KEY (ActPartitionID) REFERENCES Partition (PrtID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActEmpSta_Ref FOREIGN KEY (ActEmpSta) REFERENCES RefValues (RefID);
ALTER TABLE MvaActPrevPwds ADD CONSTRAINT FK_MC_ActPrevPwds_Act FOREIGN KEY (MvaColID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE Actor ADD CONSTRAINT FK_ActCreID_Act FOREIGN KEY (ActCreID) REFERENCES Actor (ActID);
ALTER TABLE Actor ADD CONSTRAINT FK_ActModID_Act FOREIGN KEY (ActModID) REFERENCES Actor (ActID);

ALTER TABLE Attachment ADD CONSTRAINT FK_AttIcon_Ref FOREIGN KEY (AttIcon) REFERENCES RefValues (RefID);
ALTER TABLE Attachment ADD CONSTRAINT FK_AttCreID_Act FOREIGN KEY (AttCreID) REFERENCES Actor (ActID);
ALTER TABLE Attachment ADD CONSTRAINT FK_AttModID_Act FOREIGN KEY (AttModID) REFERENCES Actor (ActID);

ALTER TABLE MvaAdzPartitionID ADD CONSTRAINT FK_MC_AdzPartitionID_Adz FOREIGN KEY (MvaColID) REFERENCES AutoDisplayZone (AdzID) ON DELETE CASCADE;
ALTER TABLE MvaAdzPartitionID ADD CONSTRAINT FK_MT_AdzPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE AutoDisplayZone ADD CONSTRAINT FK_AdzCreID_Act FOREIGN KEY (AdzCreID) REFERENCES Actor (ActID);
ALTER TABLE AutoDisplayZone ADD CONSTRAINT FK_AdzModID_Act FOREIGN KEY (AdzModID) REFERENCES Actor (ActID);

ALTER TABLE Base ADD CONSTRAINT FK_BasCreID_Act FOREIGN KEY (BasCreID) REFERENCES Actor (ActID);
ALTER TABLE Base ADD CONSTRAINT FK_BasModID_Act FOREIGN KEY (BasModID) REFERENCES Actor (ActID);

ALTER TABLE CounterFactory ADD CONSTRAINT FK_CntCreID_Act FOREIGN KEY (CntCreID) REFERENCES Actor (ActID);
ALTER TABLE CounterFactory ADD CONSTRAINT FK_CntModID_Act FOREIGN KEY (CntModID) REFERENCES Actor (ActID);

ALTER TABLE Dashboard ADD CONSTRAINT FK_DshType_Ref FOREIGN KEY (DshType) REFERENCES RefValues (RefID);
ALTER TABLE MvaDshPages ADD CONSTRAINT FK_MC_DshPages_Dsh FOREIGN KEY (MvaColID) REFERENCES Dashboard (DshID) ON DELETE CASCADE;
ALTER TABLE MvaDshPages ADD CONSTRAINT FK_MT_DshPages_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Dashboard ADD CONSTRAINT FK_DshActor_Act FOREIGN KEY (DshActor) REFERENCES Actor (ActID);
ALTER TABLE Dashboard ADD CONSTRAINT FK_DshCreID_Act FOREIGN KEY (DshCreID) REFERENCES Actor (ActID);
ALTER TABLE Dashboard ADD CONSTRAINT FK_DshModID_Act FOREIGN KEY (DshModID) REFERENCES Actor (ActID);

ALTER TABLE DashboardPage ADD CONSTRAINT FK_DspPage_Ref FOREIGN KEY (DspPage) REFERENCES RefValues (RefID);
ALTER TABLE DashboardPage ADD CONSTRAINT FK_DspDshID_Dsh FOREIGN KEY (DspDshID) REFERENCES Dashboard (DshID) ON DELETE CASCADE;
ALTER TABLE DashboardPage ADD CONSTRAINT FK_DspCreID_Act FOREIGN KEY (DspCreID) REFERENCES Actor (ActID);
ALTER TABLE DashboardPage ADD CONSTRAINT FK_DspModID_Act FOREIGN KEY (DspModID) REFERENCES Actor (ActID);

ALTER TABLE DataExtraction ADD CONSTRAINT FK_DexCreID_Act FOREIGN KEY (DexCreID) REFERENCES Actor (ActID);
ALTER TABLE DataExtraction ADD CONSTRAINT FK_DexModID_Act FOREIGN KEY (DexModID) REFERENCES Actor (ActID);

ALTER TABLE Department ADD CONSTRAINT FK_DptType_Ref FOREIGN KEY (DptType) REFERENCES RefValues (RefID);
ALTER TABLE Department ADD CONSTRAINT FK_DptEnt_Ref FOREIGN KEY (DptEnt) REFERENCES RefValues (RefID);
ALTER TABLE Department ADD CONSTRAINT FK_DptCreID_Act FOREIGN KEY (DptCreID) REFERENCES Actor (ActID);
ALTER TABLE Department ADD CONSTRAINT FK_DptModID_Act FOREIGN KEY (DptModID) REFERENCES Actor (ActID);

ALTER TABLE DIExecution ADD CONSTRAINT FK_DieModelID_Dim FOREIGN KEY (DieModelID) REFERENCES DIModel (DimID);
ALTER TABLE DIExecution ADD CONSTRAINT FK_DieFlag_Ref FOREIGN KEY (DieFlag) REFERENCES RefValues (RefID);
ALTER TABLE DIExecution ADD CONSTRAINT FK_DieCreID_Act FOREIGN KEY (DieCreID) REFERENCES Actor (ActID);
ALTER TABLE DIExecution ADD CONSTRAINT FK_DieModID_Act FOREIGN KEY (DieModID) REFERENCES Actor (ActID);

ALTER TABLE DIModel ADD CONSTRAINT FK_DimOrigin_Ref FOREIGN KEY (DimOrigin) REFERENCES RefValues (RefID);
ALTER TABLE DIModel ADD CONSTRAINT FK_DimCreID_Act FOREIGN KEY (DimCreID) REFERENCES Actor (ActID);
ALTER TABLE DIModel ADD CONSTRAINT FK_DimModID_Act FOREIGN KEY (DimModID) REFERENCES Actor (ActID);

ALTER TABLE DITranscode ADD CONSTRAINT FK_DitCreID_Act FOREIGN KEY (DitCreID) REFERENCES Actor (ActID);
ALTER TABLE DITranscode ADD CONSTRAINT FK_DitModID_Act FOREIGN KEY (DitModID) REFERENCES Actor (ActID);

ALTER TABLE EntIdentical ADD CONSTRAINT FK_EidCreID_Act FOREIGN KEY (EidCreID) REFERENCES Actor (ActID);
ALTER TABLE EntIdentical ADD CONSTRAINT FK_EidModID_Act FOREIGN KEY (EidModID) REFERENCES Actor (ActID);

ALTER TABLE ExternalNotification ADD CONSTRAINT FK_ExnActID_Act FOREIGN KEY (ExnActID) REFERENCES Actor (ActID);
ALTER TABLE ExternalNotification ADD CONSTRAINT FK_ExnSymID_Sym FOREIGN KEY (ExnSymID) REFERENCES SyncModel (SymID);
ALTER TABLE ExternalNotification ADD CONSTRAINT FK_ExnCreID_Act FOREIGN KEY (ExnCreID) REFERENCES Actor (ActID);
ALTER TABLE ExternalNotification ADD CONSTRAINT FK_ExnModID_Act FOREIGN KEY (ExnModID) REFERENCES Actor (ActID);

ALTER TABLE Field ADD CONSTRAINT FK_FldObjID_Obj FOREIGN KEY (FldObjID) REFERENCES Objects (ObjID) ON DELETE CASCADE;
ALTER TABLE Field ADD CONSTRAINT FK_FldFltID_Ref FOREIGN KEY (FldFltID) REFERENCES RefValues (RefID);
ALTER TABLE Field ADD CONSTRAINT FK_FldTabID_Tab FOREIGN KEY (FldTabID) REFERENCES Tables (TabID);
ALTER TABLE Field ADD CONSTRAINT FK_FldDisplayPolicy_Ref FOREIGN KEY (FldDisplayPolicy) REFERENCES RefValues (RefID);
ALTER TABLE Field ADD CONSTRAINT FK_FldIndexPolicy_Ref FOREIGN KEY (FldIndexPolicy) REFERENCES RefValues (RefID);
ALTER TABLE Field ADD CONSTRAINT FK_FldCreID_Act FOREIGN KEY (FldCreID) REFERENCES Actor (ActID);
ALTER TABLE Field ADD CONSTRAINT FK_FldModID_Act FOREIGN KEY (FldModID) REFERENCES Actor (ActID);

ALTER TABLE FlOption ADD CONSTRAINT FK_OptGroup_Ref FOREIGN KEY (OptGroup) REFERENCES RefValues (RefID);
ALTER TABLE FlOption ADD CONSTRAINT FK_OptType_Ref FOREIGN KEY (OptType) REFERENCES RefValues (RefID);
ALTER TABLE MvaOptValueList ADD CONSTRAINT FK_MC_OptValueList_Opt FOREIGN KEY (MvaColID) REFERENCES FlOption (OptID) ON DELETE CASCADE;
ALTER TABLE FlOption ADD CONSTRAINT FK_OptCreID_Act FOREIGN KEY (OptCreID) REFERENCES Actor (ActID);
ALTER TABLE FlOption ADD CONSTRAINT FK_OptModID_Act FOREIGN KEY (OptModID) REFERENCES Actor (ActID);

ALTER TABLE FlTask ADD CONSTRAINT FK_TskRepetition_Ref FOREIGN KEY (TskRepetition) REFERENCES RefValues (RefID);
ALTER TABLE MvaTskDaysOfWeek ADD CONSTRAINT FK_MC_TskDaysOfWeek_Tsk FOREIGN KEY (MvaColID) REFERENCES FlTask (TskID) ON DELETE CASCADE;
ALTER TABLE MvaTskDaysOfWeek ADD CONSTRAINT FK_MT_TskDaysOfWeek_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE FlTask ADD CONSTRAINT FK_TskInstance_Ref FOREIGN KEY (TskInstance) REFERENCES RefValues (RefID);
ALTER TABLE MvaTskActions ADD CONSTRAINT FK_MC_TskActions_Tsk FOREIGN KEY (MvaColID) REFERENCES FlTask (TskID) ON DELETE CASCADE;
ALTER TABLE MvaTskActions ADD CONSTRAINT FK_MT_TskActions_Tsk FOREIGN KEY (MvaText) REFERENCES FlTask (TskID);
ALTER TABLE FlTask ADD CONSTRAINT FK_TskBase_Bas FOREIGN KEY (TskBase) REFERENCES Base (BasID);
ALTER TABLE FlTask ADD CONSTRAINT FK_TskCreID_Act FOREIGN KEY (TskCreID) REFERENCES Actor (ActID);
ALTER TABLE FlTask ADD CONSTRAINT FK_TskModID_Act FOREIGN KEY (TskModID) REFERENCES Actor (ActID);

ALTER TABLE FlTaskLog ADD CONSTRAINT FK_TslTskID_Tsk FOREIGN KEY (TslTskID) REFERENCES FlTask (TskID) ON DELETE CASCADE;
ALTER TABLE FlTaskLog ADD CONSTRAINT FK_TslCreID_Act FOREIGN KEY (TslCreID) REFERENCES Actor (ActID);
ALTER TABLE FlTaskLog ADD CONSTRAINT FK_TslModID_Act FOREIGN KEY (TslModID) REFERENCES Actor (ActID);

ALTER TABLE History ADD CONSTRAINT FK_HisActID_Act FOREIGN KEY (HisActID) REFERENCES Actor (ActID);
ALTER TABLE History ADD CONSTRAINT FK_HisPerID_Per FOREIGN KEY (HisPerID) REFERENCES Person (PerID);
ALTER TABLE History ADD CONSTRAINT FK_HisSilID_Sil FOREIGN KEY (HisSilID) REFERENCES Silhouette (SilID);
ALTER TABLE History ADD CONSTRAINT FK_HisJouID_Jou FOREIGN KEY (HisJouID) REFERENCES Journalist (JouID);
ALTER TABLE History ADD CONSTRAINT FK_HisOldRefValue_Ref FOREIGN KEY (HisOldRefValue) REFERENCES RefValues (RefID);
ALTER TABLE MvaHisOldMvaTextValue ADD CONSTRAINT FK_MC_HisOldMvaTextValue_Hi0 FOREIGN KEY (MvaColID) REFERENCES History (HisID) ON DELETE CASCADE;
ALTER TABLE MvaHisOldMvaDateTimeValue ADD CONSTRAINT FK_MC_HisOldMvaDateTimeValu1 FOREIGN KEY (MvaColID) REFERENCES History (HisID) ON DELETE CASCADE;
ALTER TABLE MvaHisOldMvaIntValue ADD CONSTRAINT FK_MC_HisOldMvaIntValue_His FOREIGN KEY (MvaColID) REFERENCES History (HisID) ON DELETE CASCADE;
ALTER TABLE MvaHisOldMvaFloatValue ADD CONSTRAINT FK_MC_HisOldMvaFloatValue_H2 FOREIGN KEY (MvaColID) REFERENCES History (HisID) ON DELETE CASCADE;
ALTER TABLE History ADD CONSTRAINT FK_HisNewRefValue_Ref FOREIGN KEY (HisNewRefValue) REFERENCES RefValues (RefID);
ALTER TABLE MvaHisNewMvaTextValue ADD CONSTRAINT FK_MC_HisNewMvaTextValue_Hi3 FOREIGN KEY (MvaColID) REFERENCES History (HisID) ON DELETE CASCADE;
ALTER TABLE MvaHisNewMvaDateTimeValue ADD CONSTRAINT FK_MC_HisNewMvaDateTimeValu4 FOREIGN KEY (MvaColID) REFERENCES History (HisID) ON DELETE CASCADE;
ALTER TABLE MvaHisNewMvaIntValue ADD CONSTRAINT FK_MC_HisNewMvaIntValue_His FOREIGN KEY (MvaColID) REFERENCES History (HisID) ON DELETE CASCADE;
ALTER TABLE MvaHisNewMvaFloatValue ADD CONSTRAINT FK_MC_HisNewMvaFloatValue_H5 FOREIGN KEY (MvaColID) REFERENCES History (HisID) ON DELETE CASCADE;
ALTER TABLE History ADD CONSTRAINT FK_HisCreID_Act FOREIGN KEY (HisCreID) REFERENCES Actor (ActID);
ALTER TABLE History ADD CONSTRAINT FK_HisModID_Act FOREIGN KEY (HisModID) REFERENCES Actor (ActID);

ALTER TABLE InformationPanel ADD CONSTRAINT FK_InpIssuerID_Act FOREIGN KEY (InpIssuerID) REFERENCES Actor (ActID);
ALTER TABLE InformationPanel ADD CONSTRAINT FK_InpCatID_Ref FOREIGN KEY (InpCatID) REFERENCES RefValues (RefID);
ALTER TABLE InformationPanel ADD CONSTRAINT FK_InpTypID_Ref FOREIGN KEY (InpTypID) REFERENCES RefValues (RefID);
ALTER TABLE MvaInpReceiver ADD CONSTRAINT FK_MC_InpReceiver_Inp FOREIGN KEY (MvaColID) REFERENCES InformationPanel (InpID) ON DELETE CASCADE;
ALTER TABLE MvaInpReceiver ADD CONSTRAINT FK_MT_InpReceiver_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaInpActWhoHaveRead ADD CONSTRAINT FK_MC_InpActWhoHaveRead_Inp FOREIGN KEY (MvaColID) REFERENCES InformationPanel (InpID) ON DELETE CASCADE;
ALTER TABLE MvaInpActWhoHaveRead ADD CONSTRAINT FK_MT_InpActWhoHaveRead_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE InformationPanel ADD CONSTRAINT FK_InpCreID_Act FOREIGN KEY (InpCreID) REFERENCES Actor (ActID);
ALTER TABLE InformationPanel ADD CONSTRAINT FK_InpModID_Act FOREIGN KEY (InpModID) REFERENCES Actor (ActID);

ALTER TABLE Label ADD CONSTRAINT FK_LblCodeLng_Ref FOREIGN KEY (LblCodeLng) REFERENCES RefValues (RefID);
ALTER TABLE Label ADD CONSTRAINT FK_LblCreID_Act FOREIGN KEY (LblCreID) REFERENCES Actor (ActID);
ALTER TABLE Label ADD CONSTRAINT FK_LblModID_Act FOREIGN KEY (LblModID) REFERENCES Actor (ActID);

ALTER TABLE LinkZoneField ADD CONSTRAINT FK_LzfAdzID_Adz FOREIGN KEY (LzfAdzID) REFERENCES AutoDisplayZone (AdzID) ON DELETE CASCADE;
ALTER TABLE LinkZoneField ADD CONSTRAINT FK_LzfFldID_Fld FOREIGN KEY (LzfFldID) REFERENCES Field (FldID) ON DELETE CASCADE;
ALTER TABLE LinkZoneField ADD CONSTRAINT FK_LzfCreID_Act FOREIGN KEY (LzfCreID) REFERENCES Actor (ActID);
ALTER TABLE LinkZoneField ADD CONSTRAINT FK_LzfModID_Act FOREIGN KEY (LzfModID) REFERENCES Actor (ActID);

ALTER TABLE List ADD CONSTRAINT FK_LstObjID_Obj FOREIGN KEY (LstObjID) REFERENCES Objects (ObjID) ON DELETE CASCADE;
ALTER TABLE List ADD CONSTRAINT FK_LstCreID_Act FOREIGN KEY (LstCreID) REFERENCES Actor (ActID);
ALTER TABLE List ADD CONSTRAINT FK_LstModID_Act FOREIGN KEY (LstModID) REFERENCES Actor (ActID);

ALTER TABLE MatchCodeFields ADD CONSTRAINT FK_McfFldID_Fld FOREIGN KEY (McfFldID) REFERENCES Field (FldID);
ALTER TABLE MatchCodeFields ADD CONSTRAINT FK_McfWfaID_Wfa FOREIGN KEY (McfWfaID) REFERENCES WorkflowAction (WfaID);
ALTER TABLE MatchCodeFields ADD CONSTRAINT FK_McfMcrID_Mcr FOREIGN KEY (McfMcrID) REFERENCES MatchCodeRules (McrID) ON DELETE CASCADE;
ALTER TABLE MatchCodeFields ADD CONSTRAINT FK_McfCreID_Act FOREIGN KEY (McfCreID) REFERENCES Actor (ActID);
ALTER TABLE MatchCodeFields ADD CONSTRAINT FK_McfModID_Act FOREIGN KEY (McfModID) REFERENCES Actor (ActID);

ALTER TABLE MatchCodeRules ADD CONSTRAINT FK_McrObjID_Obj FOREIGN KEY (McrObjID) REFERENCES Objects (ObjID);
ALTER TABLE MatchCodeRules ADD CONSTRAINT FK_McrCreID_Act FOREIGN KEY (McrCreID) REFERENCES Actor (ActID);
ALTER TABLE MatchCodeRules ADD CONSTRAINT FK_McrModID_Act FOREIGN KEY (McrModID) REFERENCES Actor (ActID);

ALTER TABLE MatchCodeTemplate ADD CONSTRAINT FK_McoObjID_Obj FOREIGN KEY (McoObjID) REFERENCES Objects (ObjID);
ALTER TABLE MvaMcoMcfID ADD CONSTRAINT FK_MC_McoMcfID_Mco FOREIGN KEY (MvaColID) REFERENCES MatchCodeTemplate (McoID) ON DELETE CASCADE;
ALTER TABLE MvaMcoMcfID ADD CONSTRAINT FK_MT_McoMcfID_Mcf FOREIGN KEY (MvaText) REFERENCES MatchCodeFields (McfID) ON DELETE CASCADE;
ALTER TABLE MatchCodeTemplate ADD CONSTRAINT FK_McoCreID_Act FOREIGN KEY (McoCreID) REFERENCES Actor (ActID);
ALTER TABLE MatchCodeTemplate ADD CONSTRAINT FK_McoModID_Act FOREIGN KEY (McoModID) REFERENCES Actor (ActID);

ALTER TABLE Menu ADD CONSTRAINT FK_MenSfwID_Sfw FOREIGN KEY (MenSfwID) REFERENCES Software (SfwID) ON DELETE CASCADE;
ALTER TABLE Menu ADD CONSTRAINT FK_MenMainList_Lst FOREIGN KEY (MenMainList) REFERENCES List (LstID) ON DELETE SET NULL;
ALTER TABLE Menu ADD CONSTRAINT FK_MenCreID_Act FOREIGN KEY (MenCreID) REFERENCES Actor (ActID);
ALTER TABLE Menu ADD CONSTRAINT FK_MenModID_Act FOREIGN KEY (MenModID) REFERENCES Actor (ActID);

ALTER TABLE MenuByRole ADD CONSTRAINT FK_MbrRole_Ref FOREIGN KEY (MbrRole) REFERENCES RefValues (RefID);
ALTER TABLE MenuByRole ADD CONSTRAINT FK_MbrMenID_Men FOREIGN KEY (MbrMenID) REFERENCES Menu (MenID) ON DELETE CASCADE;
ALTER TABLE MenuByRole ADD CONSTRAINT FK_MbrCreID_Act FOREIGN KEY (MbrCreID) REFERENCES Actor (ActID);
ALTER TABLE MenuByRole ADD CONSTRAINT FK_MbrModID_Act FOREIGN KEY (MbrModID) REFERENCES Actor (ActID);

ALTER TABLE MenuElement ADD CONSTRAINT FK_MelMenID_Men FOREIGN KEY (MelMenID) REFERENCES Menu (MenID) ON DELETE CASCADE;
ALTER TABLE MenuElement ADD CONSTRAINT FK_MelCreID_Act FOREIGN KEY (MelCreID) REFERENCES Actor (ActID);
ALTER TABLE MenuElement ADD CONSTRAINT FK_MelModID_Act FOREIGN KEY (MelModID) REFERENCES Actor (ActID);

ALTER TABLE Messages ADD CONSTRAINT FK_MsgCtyID_Ref FOREIGN KEY (MsgCtyID) REFERENCES RefValues (RefID);
ALTER TABLE MvaMsgAttID ADD CONSTRAINT FK_MC_MsgAttID_Msg FOREIGN KEY (MvaColID) REFERENCES Messages (MsgID) ON DELETE CASCADE;
ALTER TABLE Messages ADD CONSTRAINT FK_MsgObjID_Obj FOREIGN KEY (MsgObjID) REFERENCES Objects (ObjID);
ALTER TABLE Messages ADD CONSTRAINT FK_MsgEvtID_Evt FOREIGN KEY (MsgEvtID) REFERENCES Event (EvtID);
ALTER TABLE Messages ADD CONSTRAINT FK_MsgLngRef_Ref FOREIGN KEY (MsgLngRef) REFERENCES RefValues (RefID);
ALTER TABLE Messages ADD CONSTRAINT FK_MsgType_Ref FOREIGN KEY (MsgType) REFERENCES RefValues (RefID);
ALTER TABLE MvaMsgMergedDocID ADD CONSTRAINT FK_MC_MsgMergedDocID_Msg FOREIGN KEY (MvaColID) REFERENCES Messages (MsgID) ON DELETE CASCADE;
ALTER TABLE MvaMsgMergedDocID ADD CONSTRAINT FK_MT_MsgMergedDocID_Doc FOREIGN KEY (MvaText) REFERENCES Document (DocID);
ALTER TABLE MvaMsgDocID ADD CONSTRAINT FK_MC_MsgDocID_Msg FOREIGN KEY (MvaColID) REFERENCES Messages (MsgID) ON DELETE CASCADE;
ALTER TABLE MvaMsgDocID ADD CONSTRAINT FK_MT_MsgDocID_Doc FOREIGN KEY (MvaText) REFERENCES Document (DocID);
ALTER TABLE MvaMsgAttFileName ADD CONSTRAINT FK_MC_MsgAttFileName_Msg FOREIGN KEY (MvaColID) REFERENCES Messages (MsgID) ON DELETE CASCADE;
ALTER TABLE MvaMsgPartitionID ADD CONSTRAINT FK_MC_MsgPartitionID_Msg FOREIGN KEY (MvaColID) REFERENCES Messages (MsgID) ON DELETE CASCADE;
ALTER TABLE MvaMsgPartitionID ADD CONSTRAINT FK_MT_MsgPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Messages ADD CONSTRAINT FK_MsgCreID_Act FOREIGN KEY (MsgCreID) REFERENCES Actor (ActID);
ALTER TABLE Messages ADD CONSTRAINT FK_MsgModID_Act FOREIGN KEY (MsgModID) REFERENCES Actor (ActID);

ALTER TABLE MetaDataFieldChange ADD CONSTRAINT FK_MfcMocID_Moc FOREIGN KEY (MfcMocID) REFERENCES MetaDataObjectChange (MocID) ON DELETE CASCADE;
ALTER TABLE MetaDataFieldChange ADD CONSTRAINT FK_MfcFldID_Fld FOREIGN KEY (MfcFldID) REFERENCES Field (FldID);
ALTER TABLE MetaDataFieldChange ADD CONSTRAINT FK_MfcCreID_Act FOREIGN KEY (MfcCreID) REFERENCES Actor (ActID);
ALTER TABLE MetaDataFieldChange ADD CONSTRAINT FK_MfcModID_Act FOREIGN KEY (MfcModID) REFERENCES Actor (ActID);

ALTER TABLE MetaDataObjectChange ADD CONSTRAINT FK_MocObjID_Obj FOREIGN KEY (MocObjID) REFERENCES Objects (ObjID);
ALTER TABLE MetaDataObjectChange ADD CONSTRAINT FK_MocMdtID_Mdt FOREIGN KEY (MocMdtID) REFERENCES MetaDataTransfer (MdtID) ON DELETE CASCADE;
ALTER TABLE MetaDataObjectChange ADD CONSTRAINT FK_MocPolitique_Ref FOREIGN KEY (MocPolitique) REFERENCES RefValues (RefID);
ALTER TABLE MetaDataObjectChange ADD CONSTRAINT FK_MocCreID_Act FOREIGN KEY (MocCreID) REFERENCES Actor (ActID);
ALTER TABLE MetaDataObjectChange ADD CONSTRAINT FK_MocModID_Act FOREIGN KEY (MocModID) REFERENCES Actor (ActID);

ALTER TABLE MetaDataTransfer ADD CONSTRAINT FK_MdtStatus_Ref FOREIGN KEY (MdtStatus) REFERENCES RefValues (RefID);
ALTER TABLE MetaDataTransfer ADD CONSTRAINT FK_MdtCreID_Act FOREIGN KEY (MdtCreID) REFERENCES Actor (ActID);
ALTER TABLE MetaDataTransfer ADD CONSTRAINT FK_MdtModID_Act FOREIGN KEY (MdtModID) REFERENCES Actor (ActID);

ALTER TABLE MvaObjRolesEdit ADD CONSTRAINT FK_MC_ObjRolesEdit_Obj FOREIGN KEY (MvaColID) REFERENCES Objects (ObjID) ON DELETE CASCADE;
ALTER TABLE MvaObjRoles ADD CONSTRAINT FK_MC_ObjRoles_Obj FOREIGN KEY (MvaColID) REFERENCES Objects (ObjID) ON DELETE CASCADE;
ALTER TABLE MvaObjRoles ADD CONSTRAINT FK_MT_ObjRoles_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaObjRolesRead ADD CONSTRAINT FK_MC_ObjRolesRead_Obj FOREIGN KEY (MvaColID) REFERENCES Objects (ObjID) ON DELETE CASCADE;
ALTER TABLE MvaObjRolesCreate ADD CONSTRAINT FK_MC_ObjRolesCreate_Obj FOREIGN KEY (MvaColID) REFERENCES Objects (ObjID) ON DELETE CASCADE;
ALTER TABLE MvaObjRolesDelete ADD CONSTRAINT FK_MC_ObjRolesDelete_Obj FOREIGN KEY (MvaColID) REFERENCES Objects (ObjID) ON DELETE CASCADE;
ALTER TABLE MvaObjConnexObjs ADD CONSTRAINT FK_MC_ObjConnexObjs_Obj FOREIGN KEY (MvaColID) REFERENCES Objects (ObjID) ON DELETE CASCADE;
ALTER TABLE Objects ADD CONSTRAINT FK_ObjCreID_Act FOREIGN KEY (ObjCreID) REFERENCES Actor (ActID);
ALTER TABLE Objects ADD CONSTRAINT FK_ObjModID_Act FOREIGN KEY (ObjModID) REFERENCES Actor (ActID);

ALTER TABLE Operation ADD CONSTRAINT FK_OpeOpgID_Opg FOREIGN KEY (OpeOpgID) REFERENCES OperationGroup (OpgID) ON DELETE CASCADE;
ALTER TABLE Operation ADD CONSTRAINT FK_OpeResult_Ref FOREIGN KEY (OpeResult) REFERENCES RefValues (RefID);
ALTER TABLE Operation ADD CONSTRAINT FK_OpeType_Obj FOREIGN KEY (OpeType) REFERENCES Objects (ObjID);
ALTER TABLE Operation ADD CONSTRAINT FK_OpeCreID_Act FOREIGN KEY (OpeCreID) REFERENCES Actor (ActID);
ALTER TABLE Operation ADD CONSTRAINT FK_OpeModID_Act FOREIGN KEY (OpeModID) REFERENCES Actor (ActID);

ALTER TABLE OperationGroup ADD CONSTRAINT FK_OpgType_Ref FOREIGN KEY (OpgType) REFERENCES RefValues (RefID);
ALTER TABLE OperationGroup ADD CONSTRAINT FK_OpgCreID_Act FOREIGN KEY (OpgCreID) REFERENCES Actor (ActID);
ALTER TABLE OperationGroup ADD CONSTRAINT FK_OpgModID_Act FOREIGN KEY (OpgModID) REFERENCES Actor (ActID);

ALTER TABLE Partition ADD CONSTRAINT FK_PrtMode_Ref FOREIGN KEY (PrtMode) REFERENCES RefValues (RefID);
ALTER TABLE Partition ADD CONSTRAINT FK_PrtParentPart_Prt FOREIGN KEY (PrtParentPart) REFERENCES Partition (PrtID);
ALTER TABLE Partition ADD CONSTRAINT FK_PrtCreID_Act FOREIGN KEY (PrtCreID) REFERENCES Actor (ActID);
ALTER TABLE Partition ADD CONSTRAINT FK_PrtModID_Act FOREIGN KEY (PrtModID) REFERENCES Actor (ActID);

ALTER TABLE PerIdentical ADD CONSTRAINT FK_PidCreID_Act FOREIGN KEY (PidCreID) REFERENCES Actor (ActID);
ALTER TABLE PerIdentical ADD CONSTRAINT FK_PidModID_Act FOREIGN KEY (PidModID) REFERENCES Actor (ActID);

ALTER TABLE RefLocale ADD CONSTRAINT FK_RelRefID_Ref FOREIGN KEY (RelRefID) REFERENCES RefValues (RefID) ON DELETE CASCADE;
ALTER TABLE RefLocale ADD CONSTRAINT FK_RelLngID_Ref FOREIGN KEY (RelLngID) REFERENCES RefValues (RefID);
ALTER TABLE RefLocale ADD CONSTRAINT FK_RelCreID_Act FOREIGN KEY (RelCreID) REFERENCES Actor (ActID);
ALTER TABLE RefLocale ADD CONSTRAINT FK_RelModID_Act FOREIGN KEY (RelModID) REFERENCES Actor (ActID);

ALTER TABLE RefValues ADD CONSTRAINT FK_RefTabID_Tab FOREIGN KEY (RefTabID) REFERENCES Tables (TabID) ON DELETE CASCADE;
ALTER TABLE RefValues ADD CONSTRAINT FK_RefCreID_Act FOREIGN KEY (RefCreID) REFERENCES Actor (ActID);
ALTER TABLE RefValues ADD CONSTRAINT FK_RefModID_Act FOREIGN KEY (RefModID) REFERENCES Actor (ActID);

ALTER TABLE Requester ADD CONSTRAINT FK_ReqTyrID_Ref FOREIGN KEY (ReqTyrID) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqLngID_Ref FOREIGN KEY (ReqLngID) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqType1_Ref FOREIGN KEY (ReqType1) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqType2_Ref FOREIGN KEY (ReqType2) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqType3_Ref FOREIGN KEY (ReqType3) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqType4_Ref FOREIGN KEY (ReqType4) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqType5_Ref FOREIGN KEY (ReqType5) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqType6_Ref FOREIGN KEY (ReqType6) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqType7_Ref FOREIGN KEY (ReqType7) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqType8_Ref FOREIGN KEY (ReqType8) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqType9_Ref FOREIGN KEY (ReqType9) REFERENCES RefValues (RefID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqObjID_Obj FOREIGN KEY (ReqObjID) REFERENCES Objects (ObjID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqPopObj1_Obj FOREIGN KEY (ReqPopObj1) REFERENCES Objects (ObjID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqPopObj2_Obj FOREIGN KEY (ReqPopObj2) REFERENCES Objects (ObjID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqPopObj3_Obj FOREIGN KEY (ReqPopObj3) REFERENCES Objects (ObjID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqPopObj4_Obj FOREIGN KEY (ReqPopObj4) REFERENCES Objects (ObjID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqPopObj5_Obj FOREIGN KEY (ReqPopObj5) REFERENCES Objects (ObjID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqCreID_Act FOREIGN KEY (ReqCreID) REFERENCES Actor (ActID);
ALTER TABLE Requester ADD CONSTRAINT FK_ReqModID_Act FOREIGN KEY (ReqModID) REFERENCES Actor (ActID);

ALTER TABLE Site ADD CONSTRAINT FK_SitKosID_Ref FOREIGN KEY (SitKosID) REFERENCES RefValues (RefID);
ALTER TABLE Site ADD CONSTRAINT FK_SitCtrID_Ref FOREIGN KEY (SitCtrID) REFERENCES RefValues (RefID);
ALTER TABLE Site ADD CONSTRAINT FK_SitAreID_Ref FOREIGN KEY (SitAreID) REFERENCES RefValues (RefID);
ALTER TABLE Site ADD CONSTRAINT FK_SitActID_Act FOREIGN KEY (SitActID) REFERENCES Actor (ActID);
ALTER TABLE Site ADD CONSTRAINT FK_SitCreID_Act FOREIGN KEY (SitCreID) REFERENCES Actor (ActID);
ALTER TABLE Site ADD CONSTRAINT FK_SitModID_Act FOREIGN KEY (SitModID) REFERENCES Actor (ActID);

ALTER TABLE SLA ADD CONSTRAINT FK_SlaSssID_Ref FOREIGN KEY (SlaSssID) REFERENCES RefValues (RefID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaObjID_Obj FOREIGN KEY (SlaObjID) REFERENCES Objects (ObjID);
ALTER TABLE MvaSlaFldID ADD CONSTRAINT FK_MC_SlaFldID_Sla FOREIGN KEY (MvaColID) REFERENCES SLA (SlaID) ON DELETE CASCADE;
ALTER TABLE MvaSlaFldID ADD CONSTRAINT FK_MT_SlaFldID_Fld FOREIGN KEY (MvaText) REFERENCES Field (FldID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaTzoID_Ref FOREIGN KEY (SlaTzoID) REFERENCES RefValues (RefID);
ALTER TABLE MvaSlaJouID ADD CONSTRAINT FK_MC_SlaJouID_Sla FOREIGN KEY (MvaColID) REFERENCES SLA (SlaID) ON DELETE CASCADE;
ALTER TABLE MvaSlaJouID ADD CONSTRAINT FK_MT_SlaJouID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaMsgAlarm_Msg FOREIGN KEY (SlaMsgAlarm) REFERENCES Messages (MsgID);
ALTER TABLE MvaSlaHolidays ADD CONSTRAINT FK_MC_SlaHolidays_Sla FOREIGN KEY (MvaColID) REFERENCES SLA (SlaID) ON DELETE CASCADE;
ALTER TABLE SLA ADD CONSTRAINT FK_SlaMsgOver_Msg FOREIGN KEY (SlaMsgOver) REFERENCES Messages (MsgID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaMainFields_Fld FOREIGN KEY (SlaMainFields) REFERENCES Field (FldID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaField1_Fld FOREIGN KEY (SlaField1) REFERENCES Field (FldID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaField2_Fld FOREIGN KEY (SlaField2) REFERENCES Field (FldID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaField3_Fld FOREIGN KEY (SlaField3) REFERENCES Field (FldID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaMsgDelay_Msg FOREIGN KEY (SlaMsgDelay) REFERENCES Messages (MsgID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaMsgFinalAlert_Msg FOREIGN KEY (SlaMsgFinalAlert) REFERENCES Messages (MsgID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaMsgDelayAlert_Msg FOREIGN KEY (SlaMsgDelayAlert) REFERENCES Messages (MsgID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaMsgOverAlert_Msg FOREIGN KEY (SlaMsgOverAlert) REFERENCES Messages (MsgID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaCreID_Act FOREIGN KEY (SlaCreID) REFERENCES Actor (ActID);
ALTER TABLE SLA ADD CONSTRAINT FK_SlaModID_Act FOREIGN KEY (SlaModID) REFERENCES Actor (ActID);

ALTER TABLE SLAAlarm ADD CONSTRAINT FK_SllTalID_Ref FOREIGN KEY (SllTalID) REFERENCES RefValues (RefID);
ALTER TABLE SLAAlarm ADD CONSTRAINT FK_SllSlsID_Sls FOREIGN KEY (SllSlsID) REFERENCES SLAState (SlsID);
ALTER TABLE MvaSllActID ADD CONSTRAINT FK_MC_SllActID_Sll FOREIGN KEY (MvaColID) REFERENCES SLAAlarm (SllID) ON DELETE CASCADE;
ALTER TABLE MvaSllActID ADD CONSTRAINT FK_MT_SllActID_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE SLAAlarm ADD CONSTRAINT FK_SllCause_Ref FOREIGN KEY (SllCause) REFERENCES RefValues (RefID);

ALTER TABLE SLAState ADD CONSTRAINT FK_SlsSLAID_Sla FOREIGN KEY (SlsSLAID) REFERENCES SLA (SlaID);
ALTER TABLE MvaSlsFieldActor ADD CONSTRAINT FK_MC_SlsFieldActor_Sls FOREIGN KEY (MvaColID) REFERENCES SLAState (SlsID) ON DELETE CASCADE;
ALTER TABLE MvaSlsFieldActor ADD CONSTRAINT FK_MT_SlsFieldActor_Fld FOREIGN KEY (MvaText) REFERENCES Field (FldID);
ALTER TABLE MvaSlsRoles ADD CONSTRAINT FK_MC_SlsRoles_Sls FOREIGN KEY (MvaColID) REFERENCES SLAState (SlsID) ON DELETE CASCADE;
ALTER TABLE MvaSlsRoles ADD CONSTRAINT FK_MT_SlsRoles_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE SLAState ADD CONSTRAINT FK_SlsValue1_Ref FOREIGN KEY (SlsValue1) REFERENCES RefValues (RefID) ON DELETE SET NULL;
ALTER TABLE SLAState ADD CONSTRAINT FK_SlsValue2_Ref FOREIGN KEY (SlsValue2) REFERENCES RefValues (RefID) ON DELETE SET NULL;
ALTER TABLE SLAState ADD CONSTRAINT FK_SlsValue3_Ref FOREIGN KEY (SlsValue3) REFERENCES RefValues (RefID) ON DELETE SET NULL;
ALTER TABLE SLAState ADD CONSTRAINT FK_SlsCreID_Act FOREIGN KEY (SlsCreID) REFERENCES Actor (ActID);
ALTER TABLE SLAState ADD CONSTRAINT FK_SlsModID_Act FOREIGN KEY (SlsModID) REFERENCES Actor (ActID);

ALTER TABLE SMSTemplate ADD CONSTRAINT FK_SmtCreID_Act FOREIGN KEY (SmtCreID) REFERENCES Actor (ActID);
ALTER TABLE SMSTemplate ADD CONSTRAINT FK_SmtModID_Act FOREIGN KEY (SmtModID) REFERENCES Actor (ActID);

ALTER TABLE MvaSfwRoleHidden ADD CONSTRAINT FK_MC_SfwRoleHidden_Sfw FOREIGN KEY (MvaColID) REFERENCES Software (SfwID) ON DELETE CASCADE;
ALTER TABLE MvaSfwRoleHidden ADD CONSTRAINT FK_MT_SfwRoleHidden_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Software ADD CONSTRAINT FK_SfwCreID_Act FOREIGN KEY (SfwCreID) REFERENCES Actor (ActID);
ALTER TABLE Software ADD CONSTRAINT FK_SfwModID_Act FOREIGN KEY (SfwModID) REFERENCES Actor (ActID);

ALTER TABLE Supplier ADD CONSTRAINT FK_SplCtrID_Ref FOREIGN KEY (SplCtrID) REFERENCES RefValues (RefID);
ALTER TABLE MvaSplFamilles ADD CONSTRAINT FK_MC_SplFamilles_Spl FOREIGN KEY (MvaColID) REFERENCES Supplier (SplID) ON DELETE CASCADE;
ALTER TABLE MvaSplFamilles ADD CONSTRAINT FK_MT_SplFamilles_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Supplier ADD CONSTRAINT FK_SplStatut_Ref FOREIGN KEY (SplStatut) REFERENCES RefValues (RefID);
ALTER TABLE Supplier ADD CONSTRAINT FK_SplCreID_Act FOREIGN KEY (SplCreID) REFERENCES Actor (ActID);
ALTER TABLE Supplier ADD CONSTRAINT FK_SplModID_Act FOREIGN KEY (SplModID) REFERENCES Actor (ActID);

ALTER TABLE Synchronization ADD CONSTRAINT FK_SynActID_Act FOREIGN KEY (SynActID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE Synchronization ADD CONSTRAINT FK_SynCreID_Act FOREIGN KEY (SynCreID) REFERENCES Actor (ActID);
ALTER TABLE Synchronization ADD CONSTRAINT FK_SynModID_Act FOREIGN KEY (SynModID) REFERENCES Actor (ActID);

ALTER TABLE SyncModel ADD CONSTRAINT FK_SymType_Ref FOREIGN KEY (SymType) REFERENCES RefValues (RefID);
ALTER TABLE SyncModel ADD CONSTRAINT FK_SymCreID_Act FOREIGN KEY (SymCreID) REFERENCES Actor (ActID);
ALTER TABLE SyncModel ADD CONSTRAINT FK_SymModID_Act FOREIGN KEY (SymModID) REFERENCES Actor (ActID);

ALTER TABLE Tables ADD CONSTRAINT FK_TabCreID_Act FOREIGN KEY (TabCreID) REFERENCES Actor (ActID);
ALTER TABLE Tables ADD CONSTRAINT FK_TabModID_Act FOREIGN KEY (TabModID) REFERENCES Actor (ActID);

ALTER TABLE TrashReport ADD CONSTRAINT FK_TrpDieID_Die FOREIGN KEY (TrpDieID) REFERENCES DIExecution (DieID);
ALTER TABLE TrashReport ADD CONSTRAINT FK_TrpObjID_Obj FOREIGN KEY (TrpObjID) REFERENCES Objects (ObjID);
ALTER TABLE TrashReport ADD CONSTRAINT FK_TrpCreID_Act FOREIGN KEY (TrpCreID) REFERENCES Actor (ActID);
ALTER TABLE TrashReport ADD CONSTRAINT FK_TrpModID_Act FOREIGN KEY (TrpModID) REFERENCES Actor (ActID);

ALTER TABLE TrashReportLine ADD CONSTRAINT FK_TrlTrpID_Trp FOREIGN KEY (TrlTrpID) REFERENCES TrashReport (TrpID);
ALTER TABLE TrashReportLine ADD CONSTRAINT FK_TrlErrorCodeID_Ref FOREIGN KEY (TrlErrorCodeID) REFERENCES RefValues (RefID);
ALTER TABLE TrashReportLine ADD CONSTRAINT FK_TrlErrorField_Fld FOREIGN KEY (TrlErrorField) REFERENCES Field (FldID);
ALTER TABLE TrashReportLine ADD CONSTRAINT FK_TrlCreID_Act FOREIGN KEY (TrlCreID) REFERENCES Actor (ActID);
ALTER TABLE TrashReportLine ADD CONSTRAINT FK_TrlModID_Act FOREIGN KEY (TrlModID) REFERENCES Actor (ActID);

ALTER TABLE WallUserConfig ADD CONSTRAINT FK_WucTypObj_Obj FOREIGN KEY (WucTypObj) REFERENCES Objects (ObjID);
ALTER TABLE WallUserConfig ADD CONSTRAINT FK_WucSe2Id_Se2 FOREIGN KEY (WucSe2Id) REFERENCES Selection2 (Se2ID);
ALTER TABLE WallUserConfig ADD CONSTRAINT FK_WucActID_Act FOREIGN KEY (WucActID) REFERENCES Actor (ActID);
ALTER TABLE WallUserConfig ADD CONSTRAINT FK_WucCreID_Act FOREIGN KEY (WucCreID) REFERENCES Actor (ActID);
ALTER TABLE WallUserConfig ADD CONSTRAINT FK_WucModID_Act FOREIGN KEY (WucModID) REFERENCES Actor (ActID);

ALTER TABLE Workflow ADD CONSTRAINT FK_WkfObjID_Obj FOREIGN KEY (WkfObjID) REFERENCES Objects (ObjID);
ALTER TABLE Workflow ADD CONSTRAINT FK_WkfStatus_Ref FOREIGN KEY (WkfStatus) REFERENCES RefValues (RefID);
ALTER TABLE Workflow ADD CONSTRAINT FK_WkfMsgID_Msg FOREIGN KEY (WkfMsgID) REFERENCES Messages (MsgID);
ALTER TABLE Workflow ADD CONSTRAINT FK_WkfCreID_Act FOREIGN KEY (WkfCreID) REFERENCES Actor (ActID);
ALTER TABLE Workflow ADD CONSTRAINT FK_WkfModID_Act FOREIGN KEY (WkfModID) REFERENCES Actor (ActID);

ALTER TABLE WorkflowAction ADD CONSTRAINT FK_WfaType_Ref FOREIGN KEY (WfaType) REFERENCES RefValues (RefID);
ALTER TABLE WorkflowAction ADD CONSTRAINT FK_WfaCreID_Act FOREIGN KEY (WfaCreID) REFERENCES Actor (ActID);
ALTER TABLE WorkflowAction ADD CONSTRAINT FK_WfaModID_Act FOREIGN KEY (WfaModID) REFERENCES Actor (ActID);

ALTER TABLE XPage ADD CONSTRAINT FK_XpgTargetObject_Ref FOREIGN KEY (XpgTargetObject) REFERENCES RefValues (RefID);
ALTER TABLE XPage ADD CONSTRAINT FK_XpgClass_Obj FOREIGN KEY (XpgClass) REFERENCES Objects (ObjID);
ALTER TABLE XPage ADD CONSTRAINT FK_XpgCreID_Act FOREIGN KEY (XpgCreID) REFERENCES Actor (ActID);
ALTER TABLE XPage ADD CONSTRAINT FK_XpgModID_Act FOREIGN KEY (XpgModID) REFERENCES Actor (ActID);

ALTER TABLE XPageField ADD CONSTRAINT FK_XpfXPageID_Xpg FOREIGN KEY (XpfXPageID) REFERENCES XPage (XpgID);
ALTER TABLE XPageField ADD CONSTRAINT FK_XpfFieldType_Ref FOREIGN KEY (XpfFieldType) REFERENCES RefValues (RefID);
ALTER TABLE XPageField ADD CONSTRAINT FK_XpfCreID_Act FOREIGN KEY (XpfCreID) REFERENCES Actor (ActID);
ALTER TABLE XPageField ADD CONSTRAINT FK_XpfModID_Act FOREIGN KEY (XpfModID) REFERENCES Actor (ActID);

ALTER TABLE XPageSource ADD CONSTRAINT FK_XpsTarget_Ref FOREIGN KEY (XpsTarget) REFERENCES RefValues (RefID);
ALTER TABLE XPageSource ADD CONSTRAINT FK_XpsDel_Ref FOREIGN KEY (XpsDel) REFERENCES RefValues (RefID);
ALTER TABLE XPageSource ADD CONSTRAINT FK_XpsEdit_Ref FOREIGN KEY (XpsEdit) REFERENCES RefValues (RefID);
ALTER TABLE XPageSource ADD CONSTRAINT FK_XpsCreID_Act FOREIGN KEY (XpsCreID) REFERENCES Actor (ActID);
ALTER TABLE XPageSource ADD CONSTRAINT FK_XpsModID_Act FOREIGN KEY (XpsModID) REFERENCES Actor (ActID);

ALTER TABLE XPageUser ADD CONSTRAINT FK_XpuLoginName_Act FOREIGN KEY (XpuLoginName) REFERENCES Actor (ActID);
ALTER TABLE XPageUser ADD CONSTRAINT FK_XpuCreID_Act FOREIGN KEY (XpuCreID) REFERENCES Actor (ActID);
ALTER TABLE XPageUser ADD CONSTRAINT FK_XpuModID_Act FOREIGN KEY (XpuModID) REFERENCES Actor (ActID);

ALTER TABLE ZipCodeEntry ADD CONSTRAINT FK_ZipCountry_Ref FOREIGN KEY (ZipCountry) REFERENCES RefValues (RefID);
ALTER TABLE ZipCodeEntry ADD CONSTRAINT FK_ZipCreID_Act FOREIGN KEY (ZipCreID) REFERENCES Actor (ActID);
ALTER TABLE ZipCodeEntry ADD CONSTRAINT FK_ZipModID_Act FOREIGN KEY (ZipModID) REFERENCES Actor (ActID);

ALTER TABLE AbstractAction ADD CONSTRAINT FK_AbsCreID_Act FOREIGN KEY (AbsCreID) REFERENCES Actor (ActID);
ALTER TABLE AbstractAction ADD CONSTRAINT FK_AbsModID_Act FOREIGN KEY (AbsModID) REFERENCES Actor (ActID);

ALTER TABLE Action ADD CONSTRAINT FK_AacCreID_Act FOREIGN KEY (AacCreID) REFERENCES Actor (ActID);
ALTER TABLE Action ADD CONSTRAINT FK_AacModID_Act FOREIGN KEY (AacModID) REFERENCES Actor (ActID);

ALTER TABLE AutomationLog ADD CONSTRAINT FK_AulActionID_Ref FOREIGN KEY (AulActionID) REFERENCES RefValues (RefID);
ALTER TABLE AutomationLog ADD CONSTRAINT FK_AulCreID_Act FOREIGN KEY (AulCreID) REFERENCES Actor (ActID);
ALTER TABLE AutomationLog ADD CONSTRAINT FK_AulModID_Act FOREIGN KEY (AulModID) REFERENCES Actor (ActID);

ALTER TABLE AutomationParameter ADD CONSTRAINT FK_AupTypID_Ref FOREIGN KEY (AupTypID) REFERENCES RefValues (RefID);
ALTER TABLE AutomationParameter ADD CONSTRAINT FK_AupAbsID_Abs FOREIGN KEY (AupAbsID) REFERENCES AbstractAction (AbsID) ON DELETE CASCADE;
ALTER TABLE AutomationParameter ADD CONSTRAINT FK_AupAacID_Aac FOREIGN KEY (AupAacID) REFERENCES Action (AacID) ON DELETE CASCADE;
ALTER TABLE AutomationParameter ADD CONSTRAINT FK_AupCreID_Act FOREIGN KEY (AupCreID) REFERENCES Actor (ActID);
ALTER TABLE AutomationParameter ADD CONSTRAINT FK_AupModID_Act FOREIGN KEY (AupModID) REFERENCES Actor (ActID);

ALTER TABLE AutomationRequester ADD CONSTRAINT FK_AurTemID_Tem FOREIGN KEY (AurTemID) REFERENCES TemplateCondition (TemID) ON DELETE CASCADE;
ALTER TABLE AutomationRequester ADD CONSTRAINT FK_AurAcoID_Aco FOREIGN KEY (AurAcoID) REFERENCES Condition (AcoID) ON DELETE CASCADE;
ALTER TABLE AutomationRequester ADD CONSTRAINT FK_AurCreID_Act FOREIGN KEY (AurCreID) REFERENCES Actor (ActID);
ALTER TABLE AutomationRequester ADD CONSTRAINT FK_AurModID_Act FOREIGN KEY (AurModID) REFERENCES Actor (ActID);

ALTER TABLE AutomationTrigger ADD CONSTRAINT FK_TrgAopID_Ref FOREIGN KEY (TrgAopID) REFERENCES RefValues (RefID);
ALTER TABLE AutomationTrigger ADD CONSTRAINT FK_TrgRulID_Rul FOREIGN KEY (TrgRulID) REFERENCES Rules (RulID) ON DELETE CASCADE;
ALTER TABLE AutomationTrigger ADD CONSTRAINT FK_TrgCreID_Act FOREIGN KEY (TrgCreID) REFERENCES Actor (ActID);
ALTER TABLE AutomationTrigger ADD CONSTRAINT FK_TrgModID_Act FOREIGN KEY (TrgModID) REFERENCES Actor (ActID);

ALTER TABLE Condition ADD CONSTRAINT FK_AcoRulID_Rul FOREIGN KEY (AcoRulID) REFERENCES Rules (RulID) ON DELETE CASCADE;
ALTER TABLE Condition ADD CONSTRAINT FK_AcoCreID_Act FOREIGN KEY (AcoCreID) REFERENCES Actor (ActID);
ALTER TABLE Condition ADD CONSTRAINT FK_AcoModID_Act FOREIGN KEY (AcoModID) REFERENCES Actor (ActID);

ALTER TABLE Process ADD CONSTRAINT FK_PrsStatus_Ref FOREIGN KEY (PrsStatus) REFERENCES RefValues (RefID);
ALTER TABLE Process ADD CONSTRAINT FK_PrsObject_Ref FOREIGN KEY (PrsObject) REFERENCES RefValues (RefID);
ALTER TABLE MvaPrsPartitionID ADD CONSTRAINT FK_MC_PrsPartitionID_Prs FOREIGN KEY (MvaColID) REFERENCES Process (PrsID) ON DELETE CASCADE;
ALTER TABLE MvaPrsPartitionID ADD CONSTRAINT FK_MT_PrsPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Process ADD CONSTRAINT FK_PrsCategory_Ref FOREIGN KEY (PrsCategory) REFERENCES RefValues (RefID);
ALTER TABLE Process ADD CONSTRAINT FK_PrsCreID_Act FOREIGN KEY (PrsCreID) REFERENCES Actor (ActID);
ALTER TABLE Process ADD CONSTRAINT FK_PrsModID_Act FOREIGN KEY (PrsModID) REFERENCES Actor (ActID);

ALTER TABLE ProcessInstance ADD CONSTRAINT FK_PriExecActID_Act FOREIGN KEY (PriExecActID) REFERENCES Actor (ActID);
ALTER TABLE ProcessInstance ADD CONSTRAINT FK_PriStatus_Ref FOREIGN KEY (PriStatus) REFERENCES RefValues (RefID);
ALTER TABLE ProcessInstance ADD CONSTRAINT FK_PriProcessObjType_Obj FOREIGN KEY (PriProcessObjType) REFERENCES Objects (ObjID);
ALTER TABLE ProcessInstance ADD CONSTRAINT FK_PriProcessID_Prs FOREIGN KEY (PriProcessID) REFERENCES Process (PrsID);
ALTER TABLE ProcessInstance ADD CONSTRAINT FK_PriType_Ref FOREIGN KEY (PriType) REFERENCES RefValues (RefID);
ALTER TABLE ProcessInstance ADD CONSTRAINT FK_PriCreID_Act FOREIGN KEY (PriCreID) REFERENCES Actor (ActID);
ALTER TABLE ProcessInstance ADD CONSTRAINT FK_PriModID_Act FOREIGN KEY (PriModID) REFERENCES Actor (ActID);

ALTER TABLE ProcessTask ADD CONSTRAINT FK_PtaProcessID_Prs FOREIGN KEY (PtaProcessID) REFERENCES Process (PrsID);
ALTER TABLE ProcessTask ADD CONSTRAINT FK_PtaIntAtvID_Ref FOREIGN KEY (PtaIntAtvID) REFERENCES RefValues (RefID);
ALTER TABLE MvaPtaRefDocID ADD CONSTRAINT FK_MC_PtaRefDocID_Pta FOREIGN KEY (MvaColID) REFERENCES ProcessTask (PtaID) ON DELETE CASCADE;
ALTER TABLE MvaPtaRefDocID ADD CONSTRAINT FK_MT_PtaRefDocID_Doc FOREIGN KEY (MvaText) REFERENCES Document (DocID);
ALTER TABLE ProcessTask ADD CONSTRAINT FK_PtaActorRule_Ref FOREIGN KEY (PtaActorRule) REFERENCES RefValues (RefID);
ALTER TABLE ProcessTask ADD CONSTRAINT FK_PtaActorRuleActID_Act FOREIGN KEY (PtaActorRuleActID) REFERENCES Actor (ActID);
ALTER TABLE ProcessTask ADD CONSTRAINT FK_PtaIntStiID_Ref FOREIGN KEY (PtaIntStiID) REFERENCES RefValues (RefID);
ALTER TABLE MvaPtaIntRefMsgID ADD CONSTRAINT FK_MC_PtaIntRefMsgID_Pta FOREIGN KEY (MvaColID) REFERENCES ProcessTask (PtaID) ON DELETE CASCADE;
ALTER TABLE ProcessTask ADD CONSTRAINT FK_PtaCreID_Act FOREIGN KEY (PtaCreID) REFERENCES Actor (ActID);
ALTER TABLE ProcessTask ADD CONSTRAINT FK_PtaModID_Act FOREIGN KEY (PtaModID) REFERENCES Actor (ActID);

ALTER TABLE RequesterParameter ADD CONSTRAINT FK_RepTypID_Ref FOREIGN KEY (RepTypID) REFERENCES RefValues (RefID);
ALTER TABLE RequesterParameter ADD CONSTRAINT FK_RepAurID_Aur FOREIGN KEY (RepAurID) REFERENCES AutomationRequester (AurID) ON DELETE CASCADE;
ALTER TABLE RequesterParameter ADD CONSTRAINT FK_RepCreID_Act FOREIGN KEY (RepCreID) REFERENCES Actor (ActID);
ALTER TABLE RequesterParameter ADD CONSTRAINT FK_RepModID_Act FOREIGN KEY (RepModID) REFERENCES Actor (ActID);

ALTER TABLE Rules ADD CONSTRAINT FK_RulModeID_Ref FOREIGN KEY (RulModeID) REFERENCES RefValues (RefID);
ALTER TABLE Rules ADD CONSTRAINT FK_RulCreID_Act FOREIGN KEY (RulCreID) REFERENCES Actor (ActID);
ALTER TABLE Rules ADD CONSTRAINT FK_RulModID_Act FOREIGN KEY (RulModID) REFERENCES Actor (ActID);

ALTER TABLE Signature ADD CONSTRAINT FK_SigRulID_Rul FOREIGN KEY (SigRulID) REFERENCES Rules (RulID) ON DELETE CASCADE;
ALTER TABLE Signature ADD CONSTRAINT FK_SigCreID_Act FOREIGN KEY (SigCreID) REFERENCES Actor (ActID);
ALTER TABLE Signature ADD CONSTRAINT FK_SigModID_Act FOREIGN KEY (SigModID) REFERENCES Actor (ActID);

ALTER TABLE TemplateCondition ADD CONSTRAINT FK_TemCreID_Act FOREIGN KEY (TemCreID) REFERENCES Actor (ActID);
ALTER TABLE TemplateCondition ADD CONSTRAINT FK_TemModID_Act FOREIGN KEY (TemModID) REFERENCES Actor (ActID);

ALTER TABLE DecisionData ADD CONSTRAINT FK_DdaType_Ref FOREIGN KEY (DdaType) REFERENCES RefValues (RefID);
ALTER TABLE DecisionData ADD CONSTRAINT FK_DdaStatus_Ref FOREIGN KEY (DdaStatus) REFERENCES RefValues (RefID);
ALTER TABLE DecisionData ADD CONSTRAINT FK_DdaObjID_Obj FOREIGN KEY (DdaObjID) REFERENCES Objects (ObjID);
ALTER TABLE MvaDdaAuthRoles ADD CONSTRAINT FK_MC_DdaAuthRoles_Dda FOREIGN KEY (MvaColID) REFERENCES DecisionData (DdaID) ON DELETE CASCADE;
ALTER TABLE MvaDdaAuthRoles ADD CONSTRAINT FK_MT_DdaAuthRoles_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE DecisionData ADD CONSTRAINT FK_DdaIcon_Ref FOREIGN KEY (DdaIcon) REFERENCES RefValues (RefID);
ALTER TABLE DecisionData ADD CONSTRAINT FK_DdaCreID_Act FOREIGN KEY (DdaCreID) REFERENCES Actor (ActID);
ALTER TABLE DecisionData ADD CONSTRAINT FK_DdaModID_Act FOREIGN KEY (DdaModID) REFERENCES Actor (ActID);

ALTER TABLE DecisionFamilyProfile ADD CONSTRAINT FK_DfpFamilyName_Ref FOREIGN KEY (DfpFamilyName) REFERENCES RefValues (RefID);
ALTER TABLE DecisionFamilyProfile ADD CONSTRAINT FK_DfpProfile_Ref FOREIGN KEY (DfpProfile) REFERENCES RefValues (RefID);
ALTER TABLE DecisionFamilyProfile ADD CONSTRAINT FK_DfpCreID_Act FOREIGN KEY (DfpCreID) REFERENCES Actor (ActID);
ALTER TABLE DecisionFamilyProfile ADD CONSTRAINT FK_DfpModID_Act FOREIGN KEY (DfpModID) REFERENCES Actor (ActID);

ALTER TABLE DecisionIndicator ADD CONSTRAINT FK_DinBeanName_Ref FOREIGN KEY (DinBeanName) REFERENCES RefValues (RefID);
ALTER TABLE DecisionIndicator ADD CONSTRAINT FK_DinVarDirection_Ref FOREIGN KEY (DinVarDirection) REFERENCES RefValues (RefID);
ALTER TABLE DecisionIndicator ADD CONSTRAINT FK_DinType_Ref FOREIGN KEY (DinType) REFERENCES RefValues (RefID);
ALTER TABLE DecisionIndicator ADD CONSTRAINT FK_DinCreID_Act FOREIGN KEY (DinCreID) REFERENCES Actor (ActID);
ALTER TABLE DecisionIndicator ADD CONSTRAINT FK_DinModID_Act FOREIGN KEY (DinModID) REFERENCES Actor (ActID);

ALTER TABLE DecisionIndicatorOrder ADD CONSTRAINT FK_DioCreID_Act FOREIGN KEY (DioCreID) REFERENCES Actor (ActID);
ALTER TABLE DecisionIndicatorOrder ADD CONSTRAINT FK_DioModID_Act FOREIGN KEY (DioModID) REFERENCES Actor (ActID);

ALTER TABLE DecisionIndicatorValue ADD CONSTRAINT FK_DivCreID_Act FOREIGN KEY (DivCreID) REFERENCES Actor (ActID);
ALTER TABLE DecisionIndicatorValue ADD CONSTRAINT FK_DivModID_Act FOREIGN KEY (DivModID) REFERENCES Actor (ActID);

ALTER TABLE HelpDoc ADD CONSTRAINT FK_HelCreID_Act FOREIGN KEY (HelCreID) REFERENCES Actor (ActID);
ALTER TABLE HelpDoc ADD CONSTRAINT FK_HelModID_Act FOREIGN KEY (HelModID) REFERENCES Actor (ActID);

ALTER TABLE Paragraph ADD CONSTRAINT FK_ParStyle_Ref FOREIGN KEY (ParStyle) REFERENCES RefValues (RefID);
ALTER TABLE Paragraph ADD CONSTRAINT FK_ParParent_Hel FOREIGN KEY (ParParent) REFERENCES HelpDoc (HelID) ON DELETE CASCADE;
ALTER TABLE Paragraph ADD CONSTRAINT FK_ParCreID_Act FOREIGN KEY (ParCreID) REFERENCES Actor (ActID);
ALTER TABLE Paragraph ADD CONSTRAINT FK_ParModID_Act FOREIGN KEY (ParModID) REFERENCES Actor (ActID);

ALTER TABLE Cart ADD CONSTRAINT FK_CrtSolID_Sol FOREIGN KEY (CrtSolID) REFERENCES Solicitation (SolID);
ALTER TABLE MvaCrtFaqID ADD CONSTRAINT FK_MC_CrtFaqID_Crt FOREIGN KEY (MvaColID) REFERENCES Cart (CrtID) ON DELETE CASCADE;
ALTER TABLE MvaCrtFaqID ADD CONSTRAINT FK_MT_CrtFaqID_Faq FOREIGN KEY (MvaText) REFERENCES FAQ (FaqID);
ALTER TABLE Cart ADD CONSTRAINT FK_CrtStatus_Ref FOREIGN KEY (CrtStatus) REFERENCES RefValues (RefID);
ALTER TABLE Cart ADD CONSTRAINT FK_CrtActID_Act FOREIGN KEY (CrtActID) REFERENCES Actor (ActID);
ALTER TABLE Cart ADD CONSTRAINT FK_CrtCreID_Act FOREIGN KEY (CrtCreID) REFERENCES Actor (ActID);
ALTER TABLE Cart ADD CONSTRAINT FK_CrtModID_Act FOREIGN KEY (CrtModID) REFERENCES Actor (ActID);

ALTER TABLE Comments ADD CONSTRAINT FK_CmtActID_Act FOREIGN KEY (CmtActID) REFERENCES Actor (ActID);
ALTER TABLE Comments ADD CONSTRAINT FK_CmtType_Ref FOREIGN KEY (CmtType) REFERENCES RefValues (RefID);
ALTER TABLE Comments ADD CONSTRAINT FK_CmtFahID_Fah FOREIGN KEY (CmtFahID) REFERENCES FAQHeader (FahID);
ALTER TABLE Comments ADD CONSTRAINT FK_CmtStatus_Ref FOREIGN KEY (CmtStatus) REFERENCES RefValues (RefID);
ALTER TABLE Comments ADD CONSTRAINT FK_CmtLngID_Ref FOREIGN KEY (CmtLngID) REFERENCES RefValues (RefID);
ALTER TABLE Comments ADD CONSTRAINT FK_CmtCreID_Act FOREIGN KEY (CmtCreID) REFERENCES Actor (ActID);
ALTER TABLE Comments ADD CONSTRAINT FK_CmtModID_Act FOREIGN KEY (CmtModID) REFERENCES Actor (ActID);

ALTER TABLE FAQ ADD CONSTRAINT FK_FaqLngID_Ref FOREIGN KEY (FaqLngID) REFERENCES RefValues (RefID);
ALTER TABLE FAQ ADD CONSTRAINT FK_FaqFahID_Fah FOREIGN KEY (FaqFahID) REFERENCES FAQHeader (FahID) ON DELETE CASCADE;
ALTER TABLE MvaFaqPartitionID ADD CONSTRAINT FK_MC_FaqPartitionID_Faq FOREIGN KEY (MvaColID) REFERENCES FAQ (FaqID) ON DELETE CASCADE;
ALTER TABLE MvaFaqPartitionID ADD CONSTRAINT FK_MT_FaqPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE FAQ ADD CONSTRAINT FK_FaqCreID_Act FOREIGN KEY (FaqCreID) REFERENCES Actor (ActID);
ALTER TABLE FAQ ADD CONSTRAINT FK_FaqModID_Act FOREIGN KEY (FaqModID) REFERENCES Actor (ActID);

ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahActID_Act FOREIGN KEY (FahActID) REFERENCES Actor (ActID);
ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahCatID_Ref FOREIGN KEY (FahCatID) REFERENCES RefValues (RefID);
ALTER TABLE MvaFahKeyID ADD CONSTRAINT FK_MC_FahKeyID_Fah FOREIGN KEY (MvaColID) REFERENCES FAQHeader (FahID) ON DELETE CASCADE;
ALTER TABLE MvaFahKeyID ADD CONSTRAINT FK_MT_FahKeyID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahCatLev1_Ref FOREIGN KEY (FahCatLev1) REFERENCES RefValues (RefID);
ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahSource_Ref FOREIGN KEY (FahSource) REFERENCES RefValues (RefID);
ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahStatus_Ref FOREIGN KEY (FahStatus) REFERENCES RefValues (RefID);
ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahOwnrActID_Act FOREIGN KEY (FahOwnrActID) REFERENCES Actor (ActID);
ALTER TABLE MvaFahPblChannel ADD CONSTRAINT FK_MC_FahPblChannel_Fah FOREIGN KEY (MvaColID) REFERENCES FAQHeader (FahID) ON DELETE CASCADE;
ALTER TABLE MvaFahPblChannel ADD CONSTRAINT FK_MT_FahPblChannel_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaFahCntctActID ADD CONSTRAINT FK_MC_FahCntctActID_Fah FOREIGN KEY (MvaColID) REFERENCES FAQHeader (FahID) ON DELETE CASCADE;
ALTER TABLE MvaFahCntctActID ADD CONSTRAINT FK_MT_FahCntctActID_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE MvaFahCntctCorID ADD CONSTRAINT FK_MC_FahCntctCorID_Fah FOREIGN KEY (MvaColID) REFERENCES FAQHeader (FahID) ON DELETE CASCADE;
ALTER TABLE MvaFahCntctCorID ADD CONSTRAINT FK_MT_FahCntctCorID_Cor FOREIGN KEY (MvaText) REFERENCES Correspondent (CorID);
ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahPrdID_Prd FOREIGN KEY (FahPrdID) REFERENCES Product (PrdID);
ALTER TABLE MvaFahAttID ADD CONSTRAINT FK_MC_FahAttID_Fah FOREIGN KEY (MvaColID) REFERENCES FAQHeader (FahID) ON DELETE CASCADE;
ALTER TABLE MvaFahAttFileName ADD CONSTRAINT FK_MC_FahAttFileName_Fah FOREIGN KEY (MvaColID) REFERENCES FAQHeader (FahID) ON DELETE CASCADE;
ALTER TABLE MvaFahAudienceID ADD CONSTRAINT FK_MC_FahAudienceID_Fah FOREIGN KEY (MvaColID) REFERENCES FAQHeader (FahID) ON DELETE CASCADE;
ALTER TABLE MvaFahAudienceID ADD CONSTRAINT FK_MT_FahAudienceID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahSameAsFah_Fah FOREIGN KEY (FahSameAsFah) REFERENCES FAQHeader (FahID);
ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahFromFahID_Fah FOREIGN KEY (FahFromFahID) REFERENCES FAQHeader (FahID);
ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahCreID_Act FOREIGN KEY (FahCreID) REFERENCES Actor (ActID);
ALTER TABLE FAQHeader ADD CONSTRAINT FK_FahModID_Act FOREIGN KEY (FahModID) REFERENCES Actor (ActID);

ALTER TABLE FAQHeaderTagCode ADD CONSTRAINT FK_FhtFahID_Fah FOREIGN KEY (FhtFahID) REFERENCES FAQHeader (FahID);
ALTER TABLE FAQHeaderTagCode ADD CONSTRAINT FK_FhtCreID_Act FOREIGN KEY (FhtCreID) REFERENCES Actor (ActID);
ALTER TABLE FAQHeaderTagCode ADD CONSTRAINT FK_FhtModID_Act FOREIGN KEY (FhtModID) REFERENCES Actor (ActID);

ALTER TABLE FAQLink ADD CONSTRAINT FK_FqlFahID1_Fah FOREIGN KEY (FqlFahID1) REFERENCES FAQHeader (FahID);
ALTER TABLE FAQLink ADD CONSTRAINT FK_FqlFahID2_Fah FOREIGN KEY (FqlFahID2) REFERENCES FAQHeader (FahID);
ALTER TABLE FAQLink ADD CONSTRAINT FK_FqlCreID_Act FOREIGN KEY (FqlCreID) REFERENCES Actor (ActID);
ALTER TABLE FAQLink ADD CONSTRAINT FK_FqlModID_Act FOREIGN KEY (FqlModID) REFERENCES Actor (ActID);

ALTER TABLE Score ADD CONSTRAINT FK_ScoFahID_Fah FOREIGN KEY (ScoFahID) REFERENCES FAQHeader (FahID);
ALTER TABLE Score ADD CONSTRAINT FK_ScoActID_Act FOREIGN KEY (ScoActID) REFERENCES Actor (ActID);
ALTER TABLE Score ADD CONSTRAINT FK_ScoCreID_Act FOREIGN KEY (ScoCreID) REFERENCES Actor (ActID);
ALTER TABLE Score ADD CONSTRAINT FK_ScoModID_Act FOREIGN KEY (ScoModID) REFERENCES Actor (ActID);

ALTER TABLE Tag ADD CONSTRAINT FK_TagLngID_Ref FOREIGN KEY (TagLngID) REFERENCES RefValues (RefID);
ALTER TABLE Tag ADD CONSTRAINT FK_TagCreID_Act FOREIGN KEY (TagCreID) REFERENCES Actor (ActID);
ALTER TABLE Tag ADD CONSTRAINT FK_TagModID_Act FOREIGN KEY (TagModID) REFERENCES Actor (ActID);

ALTER TABLE CalcMethod ADD CONSTRAINT FK_CmeCreID_Act FOREIGN KEY (CmeCreID) REFERENCES Actor (ActID);
ALTER TABLE CalcMethod ADD CONSTRAINT FK_CmeModID_Act FOREIGN KEY (CmeModID) REFERENCES Actor (ActID);

ALTER TABLE DynamicFilter ADD CONSTRAINT FK_DfiCreID_Act FOREIGN KEY (DfiCreID) REFERENCES Actor (ActID);
ALTER TABLE DynamicFilter ADD CONSTRAINT FK_DfiModID_Act FOREIGN KEY (DfiModID) REFERENCES Actor (ActID);

ALTER TABLE Snapshot ADD CONSTRAINT FK_SnaCmeID_Cme FOREIGN KEY (SnaCmeID) REFERENCES CalcMethod (CmeID) ON DELETE CASCADE;
ALTER TABLE MvaSnaParams ADD CONSTRAINT FK_MC_SnaParams_Sna FOREIGN KEY (MvaColID) REFERENCES Snapshot (SnaID) ON DELETE CASCADE;
ALTER TABLE Snapshot ADD CONSTRAINT FK_SnaFreq_Ref FOREIGN KEY (SnaFreq) REFERENCES RefValues (RefID);
ALTER TABLE Snapshot ADD CONSTRAINT FK_SnaTzoID_Ref FOREIGN KEY (SnaTzoID) REFERENCES RefValues (RefID);
ALTER TABLE Snapshot ADD CONSTRAINT FK_SnaLngID_Ref FOREIGN KEY (SnaLngID) REFERENCES RefValues (RefID);
ALTER TABLE Snapshot ADD CONSTRAINT FK_SnaShsID_Ref FOREIGN KEY (SnaShsID) REFERENCES RefValues (RefID);
ALTER TABLE Snapshot ADD CONSTRAINT FK_SnaCreID_Act FOREIGN KEY (SnaCreID) REFERENCES Actor (ActID);
ALTER TABLE Snapshot ADD CONSTRAINT FK_SnaModID_Act FOREIGN KEY (SnaModID) REFERENCES Actor (ActID);

ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiSnaID_Sna FOREIGN KEY (SdiSnaID) REFERENCES Snapshot (SnaID) ON DELETE CASCADE;
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiSdtID_Ref FOREIGN KEY (SdiSdtID) REFERENCES RefValues (RefID);
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiGranularity1_Ref FOREIGN KEY (SdiGranularity1) REFERENCES RefValues (RefID);
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiGranularity2_Ref FOREIGN KEY (SdiGranularity2) REFERENCES RefValues (RefID);
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiGranularity3_Ref FOREIGN KEY (SdiGranularity3) REFERENCES RefValues (RefID);
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiGranularity4_Ref FOREIGN KEY (SdiGranularity4) REFERENCES RefValues (RefID);
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiFilter1Type_Ref FOREIGN KEY (SdiFilter1Type) REFERENCES RefValues (RefID);
ALTER TABLE MvaSdiFilter1Values ADD CONSTRAINT FK_MC_SdiFilter1Values_Sdi FOREIGN KEY (MvaColID) REFERENCES SnapshotDisplay (SdiID) ON DELETE CASCADE;
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiFilter2Type_Ref FOREIGN KEY (SdiFilter2Type) REFERENCES RefValues (RefID);
ALTER TABLE MvaSdiFilter2Values ADD CONSTRAINT FK_MC_SdiFilter2Values_Sdi FOREIGN KEY (MvaColID) REFERENCES SnapshotDisplay (SdiID) ON DELETE CASCADE;
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiFilter3Type_Ref FOREIGN KEY (SdiFilter3Type) REFERENCES RefValues (RefID);
ALTER TABLE MvaSdiFilter3Values ADD CONSTRAINT FK_MC_SdiFilter3Values_Sdi FOREIGN KEY (MvaColID) REFERENCES SnapshotDisplay (SdiID) ON DELETE CASCADE;
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiFilter4Type_Ref FOREIGN KEY (SdiFilter4Type) REFERENCES RefValues (RefID);
ALTER TABLE MvaSdiFilter4Values ADD CONSTRAINT FK_MC_SdiFilter4Values_Sdi FOREIGN KEY (MvaColID) REFERENCES SnapshotDisplay (SdiID) ON DELETE CASCADE;
ALTER TABLE MvaSdiMergedTables ADD CONSTRAINT FK_MC_SdiMergedTables_Sdi FOREIGN KEY (MvaColID) REFERENCES SnapshotDisplay (SdiID) ON DELETE CASCADE;
ALTER TABLE MvaSdiMergedTables ADD CONSTRAINT FK_MT_SdiMergedTables_Sdi FOREIGN KEY (MvaText) REFERENCES SnapshotDisplay (SdiID);
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiFilter1DfiID_Dfi FOREIGN KEY (SdiFilter1DfiID) REFERENCES DynamicFilter (DfiID) ON DELETE SET NULL;
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiFilter2DfiID_Dfi FOREIGN KEY (SdiFilter2DfiID) REFERENCES DynamicFilter (DfiID) ON DELETE SET NULL;
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiFilter3DfiID_Dfi FOREIGN KEY (SdiFilter3DfiID) REFERENCES DynamicFilter (DfiID) ON DELETE SET NULL;
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiFilter4DfiID_Dfi FOREIGN KEY (SdiFilter4DfiID) REFERENCES DynamicFilter (DfiID) ON DELETE SET NULL;
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiFmtGreenHcoID_Ref FOREIGN KEY (SdiFmtGreenHcoID) REFERENCES RefValues (RefID);
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiFmtRedHcoID_Ref FOREIGN KEY (SdiFmtRedHcoID) REFERENCES RefValues (RefID);
ALTER TABLE MvaSdiPartitionID ADD CONSTRAINT FK_MC_SdiPartitionID_Sdi FOREIGN KEY (MvaColID) REFERENCES SnapshotDisplay (SdiID) ON DELETE CASCADE;
ALTER TABLE MvaSdiPartitionID ADD CONSTRAINT FK_MT_SdiPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiCreID_Act FOREIGN KEY (SdiCreID) REFERENCES Actor (ActID);
ALTER TABLE SnapshotDisplay ADD CONSTRAINT FK_SdiModID_Act FOREIGN KEY (SdiModID) REFERENCES Actor (ActID);

ALTER TABLE MvaSpaDisplays ADD CONSTRAINT FK_MC_SpaDisplays_Spa FOREIGN KEY (MvaColID) REFERENCES SnapshotPanel (SpaID) ON DELETE CASCADE;
ALTER TABLE MvaSpaDisplays ADD CONSTRAINT FK_MT_SpaDisplays_Sdi FOREIGN KEY (MvaText) REFERENCES SnapshotDisplay (SdiID) ON DELETE CASCADE;
ALTER TABLE SnapshotPanel ADD CONSTRAINT FK_SpaCreID_Act FOREIGN KEY (SpaCreID) REFERENCES Actor (ActID);
ALTER TABLE SnapshotPanel ADD CONSTRAINT FK_SpaModID_Act FOREIGN KEY (SpaModID) REFERENCES Actor (ActID);

ALTER TABLE StatRecords ADD CONSTRAINT FK_SreSnaID_Sna FOREIGN KEY (SreSnaID) REFERENCES Snapshot (SnaID) ON DELETE CASCADE;
ALTER TABLE StatRecords ADD CONSTRAINT FK_SreAxis1Ref_Ref FOREIGN KEY (SreAxis1Ref) REFERENCES RefValues (RefID);
ALTER TABLE StatRecords ADD CONSTRAINT FK_SreAxis2Ref_Ref FOREIGN KEY (SreAxis2Ref) REFERENCES RefValues (RefID);
ALTER TABLE StatRecords ADD CONSTRAINT FK_SreAxis3Ref_Ref FOREIGN KEY (SreAxis3Ref) REFERENCES RefValues (RefID);
ALTER TABLE StatRecords ADD CONSTRAINT FK_SreCreID_Act FOREIGN KEY (SreCreID) REFERENCES Actor (ActID);
ALTER TABLE StatRecords ADD CONSTRAINT FK_SreModID_Act FOREIGN KEY (SreModID) REFERENCES Actor (ActID);

ALTER TABLE Appetence ADD CONSTRAINT FK_AptPerID_Per FOREIGN KEY (AptPerID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE Appetence ADD CONSTRAINT FK_AptSilID_Sil FOREIGN KEY (AptSilID) REFERENCES Silhouette (SilID) ON DELETE CASCADE;
ALTER TABLE Appetence ADD CONSTRAINT FK_AptQualification_Ref FOREIGN KEY (AptQualification) REFERENCES RefValues (RefID);
ALTER TABLE Appetence ADD CONSTRAINT FK_AptCreID_Act FOREIGN KEY (AptCreID) REFERENCES Actor (ActID);
ALTER TABLE Appetence ADD CONSTRAINT FK_AptModID_Act FOREIGN KEY (AptModID) REFERENCES Actor (ActID);

ALTER TABLE Axis ADD CONSTRAINT FK_AxeFldID_Fld FOREIGN KEY (AxeFldID) REFERENCES Field (FldID);
ALTER TABLE Axis ADD CONSTRAINT FK_AxeCreID_Act FOREIGN KEY (AxeCreID) REFERENCES Actor (ActID);
ALTER TABLE Axis ADD CONSTRAINT FK_AxeModID_Act FOREIGN KEY (AxeModID) REFERENCES Actor (ActID);

ALTER TABLE MvaCpgAttID ADD CONSTRAINT FK_MC_CpgAttID_Cpg FOREIGN KEY (MvaColID) REFERENCES Campaign (CpgID) ON DELETE CASCADE;
ALTER TABLE MvaCpgAttFileName ADD CONSTRAINT FK_MC_CpgAttFileName_Cpg FOREIGN KEY (MvaColID) REFERENCES Campaign (CpgID) ON DELETE CASCADE;
ALTER TABLE MvaCpgStgID ADD CONSTRAINT FK_MC_CpgStgID_Cpg FOREIGN KEY (MvaColID) REFERENCES Campaign (CpgID) ON DELETE CASCADE;
ALTER TABLE MvaCpgStgID ADD CONSTRAINT FK_MT_CpgStgID_Stg FOREIGN KEY (MvaText) REFERENCES Stage (StgID) ON DELETE CASCADE;
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgLevel_Ref FOREIGN KEY (CpgLevel) REFERENCES RefValues (RefID);
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgIndicUnit1_Ref FOREIGN KEY (CpgIndicUnit1) REFERENCES RefValues (RefID);
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgIndicUnit2_Ref FOREIGN KEY (CpgIndicUnit2) REFERENCES RefValues (RefID);
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgIndicUnit3_Ref FOREIGN KEY (CpgIndicUnit3) REFERENCES RefValues (RefID);
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgIndicUnit4_Ref FOREIGN KEY (CpgIndicUnit4) REFERENCES RefValues (RefID);
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgIndicUnit5_Ref FOREIGN KEY (CpgIndicUnit5) REFERENCES RefValues (RefID);
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgEnt_Ref FOREIGN KEY (CpgEnt) REFERENCES RefValues (RefID);
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgDept_Dpt FOREIGN KEY (CpgDept) REFERENCES Department (DptID);
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgYear_Ref FOREIGN KEY (CpgYear) REFERENCES RefValues (RefID);
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgCreID_Act FOREIGN KEY (CpgCreID) REFERENCES Actor (ActID);
ALTER TABLE Campaign ADD CONSTRAINT FK_CpgModID_Act FOREIGN KEY (CpgModID) REFERENCES Actor (ActID);

ALTER TABLE Categorization ADD CONSTRAINT FK_CtnCampID_Cpg FOREIGN KEY (CtnCampID) REFERENCES Campaign (CpgID);
ALTER TABLE Categorization ADD CONSTRAINT FK_CtnStageID_Stg FOREIGN KEY (CtnStageID) REFERENCES Stage (StgID);
ALTER TABLE Categorization ADD CONSTRAINT FK_CtnFactLn_Ine FOREIGN KEY (CtnFactLn) REFERENCES InvoiceEntry (IneID);
ALTER TABLE Categorization ADD CONSTRAINT FK_CtnCreID_Act FOREIGN KEY (CtnCreID) REFERENCES Actor (ActID);
ALTER TABLE Categorization ADD CONSTRAINT FK_CtnModID_Act FOREIGN KEY (CtnModID) REFERENCES Actor (ActID);

ALTER TABLE Competitor ADD CONSTRAINT FK_CptIplID_Ref FOREIGN KEY (CptIplID) REFERENCES RefValues (RefID);
ALTER TABLE MvaCptRopID ADD CONSTRAINT FK_MC_CptRopID_Cpt FOREIGN KEY (MvaColID) REFERENCES Competitor (CptID) ON DELETE CASCADE;
ALTER TABLE MvaCptRopID ADD CONSTRAINT FK_MT_CptRopID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaCptAttID ADD CONSTRAINT FK_MC_CptAttID_Cpt FOREIGN KEY (MvaColID) REFERENCES Competitor (CptID) ON DELETE CASCADE;
ALTER TABLE MvaCptAttFileName ADD CONSTRAINT FK_MC_CptAttFileName_Cpt FOREIGN KEY (MvaColID) REFERENCES Competitor (CptID) ON DELETE CASCADE;
ALTER TABLE Competitor ADD CONSTRAINT FK_CptCreID_Act FOREIGN KEY (CptCreID) REFERENCES Actor (ActID);
ALTER TABLE Competitor ADD CONSTRAINT FK_CptModID_Act FOREIGN KEY (CptModID) REFERENCES Actor (ActID);

ALTER TABLE Contribution ADD CONSTRAINT FK_CtbCampID_Cpg FOREIGN KEY (CtbCampID) REFERENCES Campaign (CpgID);
ALTER TABLE Contribution ADD CONSTRAINT FK_CtbDeptID_Dpt FOREIGN KEY (CtbDeptID) REFERENCES Department (DptID);
ALTER TABLE Contribution ADD CONSTRAINT FK_CtbCreID_Act FOREIGN KEY (CtbCreID) REFERENCES Actor (ActID);
ALTER TABLE Contribution ADD CONSTRAINT FK_CtbModID_Act FOREIGN KEY (CtbModID) REFERENCES Actor (ActID);

ALTER TABLE Criteria ADD CONSTRAINT FK_CriFobID_Obj FOREIGN KEY (CriFobID) REFERENCES Objects (ObjID);
ALTER TABLE Criteria ADD CONSTRAINT FK_CriFldID_Fld FOREIGN KEY (CriFldID) REFERENCES Field (FldID);
ALTER TABLE MvaCriChx ADD CONSTRAINT FK_MC_CriChx_Cri FOREIGN KEY (MvaColID) REFERENCES Criteria (CriID) ON DELETE CASCADE;
ALTER TABLE Criteria ADD CONSTRAINT FK_CriOpe_Ref FOREIGN KEY (CriOpe) REFERENCES RefValues (RefID);
ALTER TABLE Criteria ADD CONSTRAINT FK_CriCreID_Act FOREIGN KEY (CriCreID) REFERENCES Actor (ActID);
ALTER TABLE Criteria ADD CONSTRAINT FK_CriModID_Act FOREIGN KEY (CriModID) REFERENCES Actor (ActID);

ALTER TABLE Criteria2 ADD CONSTRAINT FK_Cr2Se2ID_Se2 FOREIGN KEY (Cr2Se2ID) REFERENCES Selection2 (Se2ID) ON DELETE CASCADE;
ALTER TABLE Criteria2 ADD CONSTRAINT FK_Cr2ParentID_Cr2 FOREIGN KEY (Cr2ParentID) REFERENCES Criteria2 (Cr2ID);
ALTER TABLE Criteria2 ADD CONSTRAINT FK_Cr2FobID_Obj FOREIGN KEY (Cr2FobID) REFERENCES Objects (ObjID);
ALTER TABLE Criteria2 ADD CONSTRAINT FK_Cr2FldID_Fld FOREIGN KEY (Cr2FldID) REFERENCES Field (FldID);
ALTER TABLE Criteria2 ADD CONSTRAINT FK_Cr2Ope_Ref FOREIGN KEY (Cr2Ope) REFERENCES RefValues (RefID);
ALTER TABLE MvaCr2Chx ADD CONSTRAINT FK_MC_Cr2Chx_Cr2 FOREIGN KEY (MvaColID) REFERENCES Criteria2 (Cr2ID) ON DELETE CASCADE;
ALTER TABLE Criteria2 ADD CONSTRAINT FK_Cr2Condition_Se2 FOREIGN KEY (Cr2Condition) REFERENCES Selection2 (Se2ID);
ALTER TABLE Criteria2 ADD CONSTRAINT FK_Cr2CardOpe_Ref FOREIGN KEY (Cr2CardOpe) REFERENCES RefValues (RefID);
ALTER TABLE Criteria2 ADD CONSTRAINT FK_Cr2CreID_Act FOREIGN KEY (Cr2CreID) REFERENCES Actor (ActID);
ALTER TABLE Criteria2 ADD CONSTRAINT FK_Cr2ModID_Act FOREIGN KEY (Cr2ModID) REFERENCES Actor (ActID);

ALTER TABLE Document ADD CONSTRAINT FK_DocObjID_Obj FOREIGN KEY (DocObjID) REFERENCES Objects (ObjID);
ALTER TABLE Document ADD CONSTRAINT FK_DocType_Ref FOREIGN KEY (DocType) REFERENCES RefValues (RefID);
ALTER TABLE Document ADD CONSTRAINT FK_DocActID_Act FOREIGN KEY (DocActID) REFERENCES Actor (ActID);
ALTER TABLE MvaDocRolesID ADD CONSTRAINT FK_MC_DocRolesID_Doc FOREIGN KEY (MvaColID) REFERENCES Document (DocID) ON DELETE CASCADE;
ALTER TABLE MvaDocRolesID ADD CONSTRAINT FK_MT_DocRolesID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaDocDocID ADD CONSTRAINT FK_MC_DocDocID_Doc FOREIGN KEY (MvaColID) REFERENCES Document (DocID) ON DELETE CASCADE;
ALTER TABLE Document ADD CONSTRAINT FK_DocCatID_Ref FOREIGN KEY (DocCatID) REFERENCES RefValues (RefID);
ALTER TABLE Document ADD CONSTRAINT FK_DocLngID_Ref FOREIGN KEY (DocLngID) REFERENCES RefValues (RefID);
ALTER TABLE MvaDocPartitionID ADD CONSTRAINT FK_MC_DocPartitionID_Doc FOREIGN KEY (MvaColID) REFERENCES Document (DocID) ON DELETE CASCADE;
ALTER TABLE MvaDocPartitionID ADD CONSTRAINT FK_MT_DocPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Document ADD CONSTRAINT FK_DocCreID_Act FOREIGN KEY (DocCreID) REFERENCES Actor (ActID);
ALTER TABLE Document ADD CONSTRAINT FK_DocModID_Act FOREIGN KEY (DocModID) REFERENCES Actor (ActID);

ALTER TABLE Editor ADD CONSTRAINT FK_EdiCtrID_Ref FOREIGN KEY (EdiCtrID) REFERENCES RefValues (RefID);
ALTER TABLE Editor ADD CONSTRAINT FK_EdiCreID_Act FOREIGN KEY (EdiCreID) REFERENCES Actor (ActID);
ALTER TABLE Editor ADD CONSTRAINT FK_EdiModID_Act FOREIGN KEY (EdiModID) REFERENCES Actor (ActID);

ALTER TABLE EditorialPlanning ADD CONSTRAINT FK_EdpJou_Jou FOREIGN KEY (EdpJou) REFERENCES Journalist (JouID) ON DELETE SET NULL;
ALTER TABLE EditorialPlanning ADD CONSTRAINT FK_EdpSupID_Sup FOREIGN KEY (EdpSupID) REFERENCES Support (SupID) ON DELETE CASCADE;
ALTER TABLE EditorialPlanning ADD CONSTRAINT FK_EdpCreID_Act FOREIGN KEY (EdpCreID) REFERENCES Actor (ActID);
ALTER TABLE EditorialPlanning ADD CONSTRAINT FK_EdpModID_Act FOREIGN KEY (EdpModID) REFERENCES Actor (ActID);

ALTER TABLE Event ADD CONSTRAINT FK_EvtCategory_Ref FOREIGN KEY (EvtCategory) REFERENCES RefValues (RefID);
ALTER TABLE Event ADD CONSTRAINT FK_EvtWopID_Wop FOREIGN KEY (EvtWopID) REFERENCES WebOperation (WopID);
ALTER TABLE MvaEvtActors ADD CONSTRAINT FK_MC_EvtActors_Evt FOREIGN KEY (MvaColID) REFERENCES Event (EvtID) ON DELETE CASCADE;
ALTER TABLE MvaEvtActors ADD CONSTRAINT FK_MT_EvtActors_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE Event ADD CONSTRAINT FK_EvtCtrID_Ref FOREIGN KEY (EvtCtrID) REFERENCES RefValues (RefID);
ALTER TABLE MvaEvtPartitionID ADD CONSTRAINT FK_MC_EvtPartitionID_Evt FOREIGN KEY (MvaColID) REFERENCES Event (EvtID) ON DELETE CASCADE;
ALTER TABLE MvaEvtPartitionID ADD CONSTRAINT FK_MT_EvtPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Event ADD CONSTRAINT FK_EvtCreID_Act FOREIGN KEY (EvtCreID) REFERENCES Actor (ActID);
ALTER TABLE Event ADD CONSTRAINT FK_EvtModID_Act FOREIGN KEY (EvtModID) REFERENCES Actor (ActID);

ALTER TABLE ExpenseCategory ADD CONSTRAINT FK_ExcCampID_Cpg FOREIGN KEY (ExcCampID) REFERENCES Campaign (CpgID);
ALTER TABLE ExpenseCategory ADD CONSTRAINT FK_ExcPosteID_Ref FOREIGN KEY (ExcPosteID) REFERENCES RefValues (RefID);
ALTER TABLE ExpenseCategory ADD CONSTRAINT FK_ExcCreID_Act FOREIGN KEY (ExcCreID) REFERENCES Actor (ActID);
ALTER TABLE ExpenseCategory ADD CONSTRAINT FK_ExcModID_Act FOREIGN KEY (ExcModID) REFERENCES Actor (ActID);

ALTER TABLE Form ADD CONSTRAINT FK_FrmEventID_Evt FOREIGN KEY (FrmEventID) REFERENCES Event (EvtID);
ALTER TABLE Form ADD CONSTRAINT FK_FrmResponderObj_Obj FOREIGN KEY (FrmResponderObj) REFERENCES Objects (ObjID);
ALTER TABLE Form ADD CONSTRAINT FK_FrmCategory_Ref FOREIGN KEY (FrmCategory) REFERENCES RefValues (RefID);
ALTER TABLE Form ADD CONSTRAINT FK_FrmEveStChMode_Ref FOREIGN KEY (FrmEveStChMode) REFERENCES RefValues (RefID);
ALTER TABLE Form ADD CONSTRAINT FK_FrmStatus_Ref FOREIGN KEY (FrmStatus) REFERENCES RefValues (RefID);
ALTER TABLE Form ADD CONSTRAINT FK_FrmLngID_Ref FOREIGN KEY (FrmLngID) REFERENCES RefValues (RefID);
ALTER TABLE Form ADD CONSTRAINT FK_FrmParStatus_Ref FOREIGN KEY (FrmParStatus) REFERENCES RefValues (RefID);
ALTER TABLE Form ADD CONSTRAINT FK_FrmParStatusRule_Ref FOREIGN KEY (FrmParStatusRule) REFERENCES RefValues (RefID);
ALTER TABLE Form ADD CONSTRAINT FK_FrmCreID_Act FOREIGN KEY (FrmCreID) REFERENCES Actor (ActID);
ALTER TABLE Form ADD CONSTRAINT FK_FrmModID_Act FOREIGN KEY (FrmModID) REFERENCES Actor (ActID);

ALTER TABLE FormQuestion ADD CONSTRAINT FK_FqtCategory_Ref FOREIGN KEY (FqtCategory) REFERENCES RefValues (RefID);
ALTER TABLE FormQuestion ADD CONSTRAINT FK_FqtType_Ref FOREIGN KEY (FqtType) REFERENCES RefValues (RefID);
ALTER TABLE FormQuestion ADD CONSTRAINT FK_FqtRefTable_Tab FOREIGN KEY (FqtRefTable) REFERENCES Tables (TabID);
ALTER TABLE FormQuestion ADD CONSTRAINT FK_FqtDispType_Ref FOREIGN KEY (FqtDispType) REFERENCES RefValues (RefID);
ALTER TABLE FormQuestion ADD CONSTRAINT FK_FqtStoreInObjID_Obj FOREIGN KEY (FqtStoreInObjID) REFERENCES Objects (ObjID);
ALTER TABLE FormQuestion ADD CONSTRAINT FK_FqtStoreInFldID_Fld FOREIGN KEY (FqtStoreInFldID) REFERENCES Field (FldID);
ALTER TABLE FormQuestion ADD CONSTRAINT FK_FqtCreID_Act FOREIGN KEY (FqtCreID) REFERENCES Actor (ActID);
ALTER TABLE FormQuestion ADD CONSTRAINT FK_FqtModID_Act FOREIGN KEY (FqtModID) REFERENCES Actor (ActID);

ALTER TABLE FormResponse ADD CONSTRAINT FK_FrpFormID_Frm FOREIGN KEY (FrpFormID) REFERENCES Form (FrmID) ON DELETE CASCADE;
ALTER TABLE FormResponse ADD CONSTRAINT FK_FrpPersonID_Per FOREIGN KEY (FrpPersonID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE FormResponse ADD CONSTRAINT FK_FrpStatus_Ref FOREIGN KEY (FrpStatus) REFERENCES RefValues (RefID);
ALTER TABLE FormResponse ADD CONSTRAINT FK_FrpCreID_Act FOREIGN KEY (FrpCreID) REFERENCES Actor (ActID);
ALTER TABLE FormResponse ADD CONSTRAINT FK_FrpModID_Act FOREIGN KEY (FrpModID) REFERENCES Actor (ActID);

ALTER TABLE FormReturn ADD CONSTRAINT FK_FrnFormID_Frm FOREIGN KEY (FrnFormID) REFERENCES Form (FrmID) ON DELETE CASCADE;
ALTER TABLE FormReturn ADD CONSTRAINT FK_FrnCreID_Act FOREIGN KEY (FrnCreID) REFERENCES Actor (ActID);
ALTER TABLE FormReturn ADD CONSTRAINT FK_FrnModID_Act FOREIGN KEY (FrnModID) REFERENCES Actor (ActID);

ALTER TABLE GuestList ADD CONSTRAINT FK_GliActID_Act FOREIGN KEY (GliActID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE MvaGliGuests ADD CONSTRAINT FK_MC_GliGuests_Gli FOREIGN KEY (MvaColID) REFERENCES GuestList (GliID) ON DELETE CASCADE;
ALTER TABLE MvaGliGuests ADD CONSTRAINT FK_MT_GliGuests_Per FOREIGN KEY (MvaText) REFERENCES Person (PerID);
ALTER TABLE GuestList ADD CONSTRAINT FK_GliSguID_Ref FOREIGN KEY (GliSguID) REFERENCES RefValues (RefID);
ALTER TABLE GuestList ADD CONSTRAINT FK_GliEvtID_Evt FOREIGN KEY (GliEvtID) REFERENCES Event (EvtID);
ALTER TABLE GuestList ADD CONSTRAINT FK_GliCreID_Act FOREIGN KEY (GliCreID) REFERENCES Actor (ActID);
ALTER TABLE GuestList ADD CONSTRAINT FK_GliModID_Act FOREIGN KEY (GliModID) REFERENCES Actor (ActID);

ALTER TABLE Invoice ADD CONSTRAINT FK_InvSupplID_Spl FOREIGN KEY (InvSupplID) REFERENCES Supplier (SplID);
ALTER TABLE Invoice ADD CONSTRAINT FK_InvPayClass_Ref FOREIGN KEY (InvPayClass) REFERENCES RefValues (RefID);
ALTER TABLE Invoice ADD CONSTRAINT FK_InvEntID_Ref FOREIGN KEY (InvEntID) REFERENCES RefValues (RefID);
ALTER TABLE Invoice ADD CONSTRAINT FK_InvStatus_Ref FOREIGN KEY (InvStatus) REFERENCES RefValues (RefID);
ALTER TABLE Invoice ADD CONSTRAINT FK_InvCreID_Act FOREIGN KEY (InvCreID) REFERENCES Actor (ActID);
ALTER TABLE Invoice ADD CONSTRAINT FK_InvModID_Act FOREIGN KEY (InvModID) REFERENCES Actor (ActID);

ALTER TABLE InvoiceEntry ADD CONSTRAINT FK_IneSupplId_Spl FOREIGN KEY (IneSupplId) REFERENCES Supplier (SplID);
ALTER TABLE InvoiceEntry ADD CONSTRAINT FK_IneExpId_Ref FOREIGN KEY (IneExpId) REFERENCES RefValues (RefID);
ALTER TABLE InvoiceEntry ADD CONSTRAINT FK_IneCreID_Act FOREIGN KEY (IneCreID) REFERENCES Actor (ActID);
ALTER TABLE InvoiceEntry ADD CONSTRAINT FK_IneModID_Act FOREIGN KEY (IneModID) REFERENCES Actor (ActID);

ALTER TABLE Journalist ADD CONSTRAINT FK_JouCivID_Ref FOREIGN KEY (JouCivID) REFERENCES RefValues (RefID);
ALTER TABLE Journalist ADD CONSTRAINT FK_JouPerCtrID_Ref FOREIGN KEY (JouPerCtrID) REFERENCES RefValues (RefID);
ALTER TABLE Journalist ADD CONSTRAINT FK_JouProCtrID_Ref FOREIGN KEY (JouProCtrID) REFERENCES RefValues (RefID);
ALTER TABLE MvaJouSupID ADD CONSTRAINT FK_MC_JouSupID_Jou FOREIGN KEY (MvaColID) REFERENCES Journalist (JouID) ON DELETE CASCADE;
ALTER TABLE MvaJouSupID ADD CONSTRAINT FK_MT_JouSupID_Sup FOREIGN KEY (MvaText) REFERENCES Support (SupID) ON DELETE CASCADE;
ALTER TABLE Journalist ADD CONSTRAINT FK_JouJfuID_Ref FOREIGN KEY (JouJfuID) REFERENCES RefValues (RefID);
ALTER TABLE MvaJouHeaID ADD CONSTRAINT FK_MC_JouHeaID_Jou FOREIGN KEY (MvaColID) REFERENCES Journalist (JouID) ON DELETE CASCADE;
ALTER TABLE MvaJouHeaID ADD CONSTRAINT FK_MT_JouHeaID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaJouIntID ADD CONSTRAINT FK_MC_JouIntID_Jou FOREIGN KEY (MvaColID) REFERENCES Journalist (JouID) ON DELETE CASCADE;
ALTER TABLE MvaJouIntID ADD CONSTRAINT FK_MT_JouIntID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaJouJevID ADD CONSTRAINT FK_MC_JouJevID_Jou FOREIGN KEY (MvaColID) REFERENCES Journalist (JouID) ON DELETE CASCADE;
ALTER TABLE MvaJouJevID ADD CONSTRAINT FK_MT_JouJevID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Journalist ADD CONSTRAINT FK_JouCreID_Act FOREIGN KEY (JouCreID) REFERENCES Actor (ActID);
ALTER TABLE Journalist ADD CONSTRAINT FK_JouModID_Act FOREIGN KEY (JouModID) REFERENCES Actor (ActID);

ALTER TABLE LinkFormQuestion ADD CONSTRAINT FK_LfqFormID_Frm FOREIGN KEY (LfqFormID) REFERENCES Form (FrmID) ON DELETE CASCADE;
ALTER TABLE LinkFormQuestion ADD CONSTRAINT FK_LfqFormQuestionID_Fqt FOREIGN KEY (LfqFormQuestionID) REFERENCES FormQuestion (FqtID);
ALTER TABLE LinkFormQuestion ADD CONSTRAINT FK_LfqCreID_Act FOREIGN KEY (LfqCreID) REFERENCES Actor (ActID);
ALTER TABLE LinkFormQuestion ADD CONSTRAINT FK_LfqModID_Act FOREIGN KEY (LfqModID) REFERENCES Actor (ActID);

ALTER TABLE LinkScriptElement ADD CONSTRAINT FK_LseScriptID_Scr FOREIGN KEY (LseScriptID) REFERENCES Script (ScrID) ON DELETE CASCADE;
ALTER TABLE LinkScriptElement ADD CONSTRAINT FK_LseScriptElementID_Sce FOREIGN KEY (LseScriptElementID) REFERENCES ScriptElement (SceID);
ALTER TABLE LinkScriptElement ADD CONSTRAINT FK_LsePageID_Scp FOREIGN KEY (LsePageID) REFERENCES ScriptPage (ScpID) ON DELETE SET NULL;
ALTER TABLE LinkScriptElement ADD CONSTRAINT FK_LseCreID_Act FOREIGN KEY (LseCreID) REFERENCES Actor (ActID);
ALTER TABLE LinkScriptElement ADD CONSTRAINT FK_LseModID_Act FOREIGN KEY (LseModID) REFERENCES Actor (ActID);

ALTER TABLE LinkScriptElementObjection ADD CONSTRAINT FK_LsoScriptElementID_Sce FOREIGN KEY (LsoScriptElementID) REFERENCES ScriptElement (SceID) ON DELETE CASCADE;
ALTER TABLE LinkScriptElementObjection ADD CONSTRAINT FK_LsoObjectionID_Oba FOREIGN KEY (LsoObjectionID) REFERENCES ObjectionArgument (ObaID);
ALTER TABLE LinkScriptElementObjection ADD CONSTRAINT FK_LsoCreID_Act FOREIGN KEY (LsoCreID) REFERENCES Actor (ActID);
ALTER TABLE LinkScriptElementObjection ADD CONSTRAINT FK_LsoModID_Act FOREIGN KEY (LsoModID) REFERENCES Actor (ActID);

ALTER TABLE MvaMarKeywordID ADD CONSTRAINT FK_MC_MarKeywordID_Mar FOREIGN KEY (MvaColID) REFERENCES Market (MarID) ON DELETE CASCADE;
ALTER TABLE MvaMarKeywordID ADD CONSTRAINT FK_MT_MarKeywordID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaMarAttID ADD CONSTRAINT FK_MC_MarAttID_Mar FOREIGN KEY (MvaColID) REFERENCES Market (MarID) ON DELETE CASCADE;
ALTER TABLE MvaMarAttFileName ADD CONSTRAINT FK_MC_MarAttFileName_Mar FOREIGN KEY (MvaColID) REFERENCES Market (MarID) ON DELETE CASCADE;
ALTER TABLE Market ADD CONSTRAINT FK_MarMcaID_Ref FOREIGN KEY (MarMcaID) REFERENCES RefValues (RefID);
ALTER TABLE Market ADD CONSTRAINT FK_MarCreID_Act FOREIGN KEY (MarCreID) REFERENCES Actor (ActID);
ALTER TABLE Market ADD CONSTRAINT FK_MarModID_Act FOREIGN KEY (MarModID) REFERENCES Actor (ActID);

ALTER TABLE MvaMatAttID ADD CONSTRAINT FK_MC_MatAttID_Mat FOREIGN KEY (MvaColID) REFERENCES Materiel (MatID) ON DELETE CASCADE;
ALTER TABLE MvaMatAttFileName ADD CONSTRAINT FK_MC_MatAttFileName_Mat FOREIGN KEY (MvaColID) REFERENCES Materiel (MatID) ON DELETE CASCADE;
ALTER TABLE Materiel ADD CONSTRAINT FK_MatCreID_Act FOREIGN KEY (MatCreID) REFERENCES Actor (ActID);
ALTER TABLE Materiel ADD CONSTRAINT FK_MatModID_Act FOREIGN KEY (MatModID) REFERENCES Actor (ActID);

ALTER TABLE MeasuringMedia ADD CONSTRAINT FK_MemSupID_Sup FOREIGN KEY (MemSupID) REFERENCES Support (SupID) ON DELETE CASCADE;
ALTER TABLE MeasuringMedia ADD CONSTRAINT FK_MemCptID_Cpt FOREIGN KEY (MemCptID) REFERENCES Competitor (CptID) ON DELETE CASCADE;
ALTER TABLE MeasuringMedia ADD CONSTRAINT FK_MemPagID_Ref FOREIGN KEY (MemPagID) REFERENCES RefValues (RefID);
ALTER TABLE MeasuringMedia ADD CONSTRAINT FK_MemAtyID_Ref FOREIGN KEY (MemAtyID) REFERENCES RefValues (RefID);
ALTER TABLE MvaMemAttID ADD CONSTRAINT FK_MC_MemAttID_Mem FOREIGN KEY (MvaColID) REFERENCES MeasuringMedia (MemID) ON DELETE CASCADE;
ALTER TABLE MvaMemAttFileName ADD CONSTRAINT FK_MC_MemAttFileName_Mem FOREIGN KEY (MvaColID) REFERENCES MeasuringMedia (MemID) ON DELETE CASCADE;
ALTER TABLE MeasuringMedia ADD CONSTRAINT FK_MemCreID_Act FOREIGN KEY (MemCreID) REFERENCES Actor (ActID);
ALTER TABLE MeasuringMedia ADD CONSTRAINT FK_MemModID_Act FOREIGN KEY (MemModID) REFERENCES Actor (ActID);

ALTER TABLE MvaNepAttID ADD CONSTRAINT FK_MC_NepAttID_Nep FOREIGN KEY (MvaColID) REFERENCES NewsPress (NepID) ON DELETE CASCADE;
ALTER TABLE MvaNepAttFileName ADD CONSTRAINT FK_MC_NepAttFileName_Nep FOREIGN KEY (MvaColID) REFERENCES NewsPress (NepID) ON DELETE CASCADE;
ALTER TABLE NewsPress ADD CONSTRAINT FK_NepCreID_Act FOREIGN KEY (NepCreID) REFERENCES Actor (ActID);
ALTER TABLE NewsPress ADD CONSTRAINT FK_NepModID_Act FOREIGN KEY (NepModID) REFERENCES Actor (ActID);

ALTER TABLE Note ADD CONSTRAINT FK_NotActID_Act FOREIGN KEY (NotActID) REFERENCES Actor (ActID);
ALTER TABLE Note ADD CONSTRAINT FK_NotCfiID_Ref FOREIGN KEY (NotCfiID) REFERENCES RefValues (RefID);
ALTER TABLE MvaNotAttID ADD CONSTRAINT FK_MC_NotAttID_Not FOREIGN KEY (MvaColID) REFERENCES Note (NotID) ON DELETE CASCADE;
ALTER TABLE MvaNotAttFileName ADD CONSTRAINT FK_MC_NotAttFileName_Not FOREIGN KEY (MvaColID) REFERENCES Note (NotID) ON DELETE CASCADE;
ALTER TABLE Note ADD CONSTRAINT FK_NotObjID_Obj FOREIGN KEY (NotObjID) REFERENCES Objects (ObjID);
ALTER TABLE Note ADD CONSTRAINT FK_NotCreID_Act FOREIGN KEY (NotCreID) REFERENCES Actor (ActID);
ALTER TABLE Note ADD CONSTRAINT FK_NotModID_Act FOREIGN KEY (NotModID) REFERENCES Actor (ActID);

ALTER TABLE ObjectionArgument ADD CONSTRAINT FK_ObaLanguage_Ref FOREIGN KEY (ObaLanguage) REFERENCES RefValues (RefID);
ALTER TABLE ObjectionArgument ADD CONSTRAINT FK_ObaMoreRefDoc0_Doc FOREIGN KEY (ObaMoreRefDoc0) REFERENCES Document (DocID);
ALTER TABLE ObjectionArgument ADD CONSTRAINT FK_ObaMoreRefDoc1_Doc FOREIGN KEY (ObaMoreRefDoc1) REFERENCES Document (DocID);
ALTER TABLE ObjectionArgument ADD CONSTRAINT FK_ObaMoreRefDoc2_Doc FOREIGN KEY (ObaMoreRefDoc2) REFERENCES Document (DocID);
ALTER TABLE ObjectionArgument ADD CONSTRAINT FK_ObaCreID_Act FOREIGN KEY (ObaCreID) REFERENCES Actor (ActID);
ALTER TABLE ObjectionArgument ADD CONSTRAINT FK_ObaModID_Act FOREIGN KEY (ObaModID) REFERENCES Actor (ActID);

ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtPersonID_Per FOREIGN KEY (PvtPersonID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtEventID_Evt FOREIGN KEY (PvtEventID) REFERENCES Event (EvtID) ON DELETE CASCADE;
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtSrpID_Srp FOREIGN KEY (PvtSrpID) REFERENCES ScriptResponse (SrpID) ON DELETE SET NULL;
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtTMK_Ref FOREIGN KEY (PvtTMK) REFERENCES RefValues (RefID);
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtActID_Act FOREIGN KEY (PvtActID) REFERENCES Actor (ActID);
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtInsStatus_Ref FOREIGN KEY (PvtInsStatus) REFERENCES RefValues (RefID);
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtParStatus_Ref FOREIGN KEY (PvtParStatus) REFERENCES RefValues (RefID);
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtPerInsRep_Per FOREIGN KEY (PvtPerInsRep) REFERENCES Person (PerID);
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtPerParRep_Per FOREIGN KEY (PvtPerParRep) REFERENCES Person (PerID);
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtPerParAcc_Per FOREIGN KEY (PvtPerParAcc) REFERENCES Person (PerID);
ALTER TABLE MvaPvtPartitionID ADD CONSTRAINT FK_MC_PvtPartitionID_Pvt FOREIGN KEY (MvaColID) REFERENCES PersonEvent (PvtID) ON DELETE CASCADE;
ALTER TABLE MvaPvtPartitionID ADD CONSTRAINT FK_MT_PvtPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtCreID_Act FOREIGN KEY (PvtCreID) REFERENCES Actor (ActID);
ALTER TABLE PersonEvent ADD CONSTRAINT FK_PvtModID_Act FOREIGN KEY (PvtModID) REFERENCES Actor (ActID);

ALTER TABLE Population ADD CONSTRAINT FK_PopSelID_Sel FOREIGN KEY (PopSelID) REFERENCES Selection (SelID) ON DELETE SET NULL;
ALTER TABLE Population ADD CONSTRAINT FK_PopSjoID_Sjo FOREIGN KEY (PopSjoID) REFERENCES SelectionJournalist (SjoID) ON DELETE SET NULL;
ALTER TABLE Population ADD CONSTRAINT FK_PopReqID_Req FOREIGN KEY (PopReqID) REFERENCES Requester (ReqID) ON DELETE SET NULL;
ALTER TABLE Population ADD CONSTRAINT FK_PopParentPopID_Pop FOREIGN KEY (PopParentPopID) REFERENCES Population (PopID);
ALTER TABLE Population ADD CONSTRAINT FK_PopSplitFieldID_Fld FOREIGN KEY (PopSplitFieldID) REFERENCES Field (FldID);
ALTER TABLE Population ADD CONSTRAINT FK_PopStatus_Ref FOREIGN KEY (PopStatus) REFERENCES RefValues (RefID);
ALTER TABLE Population ADD CONSTRAINT FK_PopObj1_Obj FOREIGN KEY (PopObj1) REFERENCES Objects (ObjID);
ALTER TABLE Population ADD CONSTRAINT FK_PopObj2_Obj FOREIGN KEY (PopObj2) REFERENCES Objects (ObjID);
ALTER TABLE Population ADD CONSTRAINT FK_PopObj3_Obj FOREIGN KEY (PopObj3) REFERENCES Objects (ObjID);
ALTER TABLE Population ADD CONSTRAINT FK_PopObj4_Obj FOREIGN KEY (PopObj4) REFERENCES Objects (ObjID);
ALTER TABLE Population ADD CONSTRAINT FK_PopObj5_Obj FOREIGN KEY (PopObj5) REFERENCES Objects (ObjID);
ALTER TABLE Population ADD CONSTRAINT FK_PopSe2ID_Se2 FOREIGN KEY (PopSe2ID) REFERENCES Selection2 (Se2ID) ON DELETE SET NULL;
ALTER TABLE Population ADD CONSTRAINT FK_PopEvtID_Evt FOREIGN KEY (PopEvtID) REFERENCES Event (EvtID);
ALTER TABLE Population ADD CONSTRAINT FK_PopGenType_Ref FOREIGN KEY (PopGenType) REFERENCES RefValues (RefID);
ALTER TABLE Population ADD CONSTRAINT FK_PopEmlID_Ema FOREIGN KEY (PopEmlID) REFERENCES EMailing (EmaID);
ALTER TABLE Population ADD CONSTRAINT FK_PopLstID_Lst FOREIGN KEY (PopLstID) REFERENCES List (LstID);
ALTER TABLE Population ADD CONSTRAINT FK_PopMassEmailingID_Eml FOREIGN KEY (PopMassEmailingID) REFERENCES MassEmailing (EmlID) ON DELETE SET NULL;
ALTER TABLE MvaPopPartitionID ADD CONSTRAINT FK_MC_PopPartitionID_Pop FOREIGN KEY (MvaColID) REFERENCES Population (PopID) ON DELETE CASCADE;
ALTER TABLE MvaPopPartitionID ADD CONSTRAINT FK_MT_PopPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Population ADD CONSTRAINT FK_PopCreID_Act FOREIGN KEY (PopCreID) REFERENCES Actor (ActID);
ALTER TABLE Population ADD CONSTRAINT FK_PopModID_Act FOREIGN KEY (PopModID) REFERENCES Actor (ActID);

ALTER TABLE PopulationEntry ADD CONSTRAINT FK_PpePopID_Pop FOREIGN KEY (PpePopID) REFERENCES Population (PopID) ON DELETE CASCADE;
ALTER TABLE PopulationEntry ADD CONSTRAINT FK_PpePerID_Per FOREIGN KEY (PpePerID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE PopulationEntry ADD CONSTRAINT FK_PpeEntID_Ent FOREIGN KEY (PpeEntID) REFERENCES Enterprise (EntID) ON DELETE CASCADE;
ALTER TABLE PopulationEntry ADD CONSTRAINT FK_PpeSilID_Sil FOREIGN KEY (PpeSilID) REFERENCES Silhouette (SilID) ON DELETE CASCADE;
ALTER TABLE PopulationEntry ADD CONSTRAINT FK_PpeSupID_Sup FOREIGN KEY (PpeSupID) REFERENCES Support (SupID) ON DELETE CASCADE;
ALTER TABLE PopulationEntry ADD CONSTRAINT FK_PpeJouID_Jou FOREIGN KEY (PpeJouID) REFERENCES Journalist (JouID) ON DELETE CASCADE;
ALTER TABLE MvaPpePartitionID ADD CONSTRAINT FK_MC_PpePartitionID_Ppe FOREIGN KEY (MvaColID) REFERENCES PopulationEntry (PpeID) ON DELETE CASCADE;
ALTER TABLE MvaPpePartitionID ADD CONSTRAINT FK_MT_PpePartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE PopulationEntry ADD CONSTRAINT FK_PpeCreID_Act FOREIGN KEY (PpeCreID) REFERENCES Actor (ActID);
ALTER TABLE PopulationEntry ADD CONSTRAINT FK_PpeModID_Act FOREIGN KEY (PpeModID) REFERENCES Actor (ActID);

ALTER TABLE Pricing ADD CONSTRAINT FK_PrcParent_Prc FOREIGN KEY (PrcParent) REFERENCES Pricing (PrcID) ON DELETE SET NULL;
ALTER TABLE Pricing ADD CONSTRAINT FK_PrcCreID_Act FOREIGN KEY (PrcCreID) REFERENCES Actor (ActID);
ALTER TABLE Pricing ADD CONSTRAINT FK_PrcModID_Act FOREIGN KEY (PrcModID) REFERENCES Actor (ActID);

ALTER TABLE PricingLine ADD CONSTRAINT FK_PrlPricing_Prc FOREIGN KEY (PrlPricing) REFERENCES Pricing (PrcID) ON DELETE CASCADE;
ALTER TABLE PricingLine ADD CONSTRAINT FK_PrlPrdID_Prd FOREIGN KEY (PrlPrdID) REFERENCES Product (PrdID) ON DELETE CASCADE;
ALTER TABLE PricingLine ADD CONSTRAINT FK_PrlRopID_Ref FOREIGN KEY (PrlRopID) REFERENCES RefValues (RefID);
ALTER TABLE PricingLine ADD CONSTRAINT FK_PrlFamilyID_Prf FOREIGN KEY (PrlFamilyID) REFERENCES ProductFamily (PrfID) ON DELETE CASCADE;
ALTER TABLE PricingLine ADD CONSTRAINT FK_PrlCreID_Act FOREIGN KEY (PrlCreID) REFERENCES Actor (ActID);
ALTER TABLE PricingLine ADD CONSTRAINT FK_PrlModID_Act FOREIGN KEY (PrlModID) REFERENCES Actor (ActID);

ALTER TABLE Product ADD CONSTRAINT FK_PrdActID_Act FOREIGN KEY (PrdActID) REFERENCES Actor (ActID);
ALTER TABLE Product ADD CONSTRAINT FK_PrdRopID_Ref FOREIGN KEY (PrdRopID) REFERENCES RefValues (RefID);
ALTER TABLE MvaPrdAttID ADD CONSTRAINT FK_MC_PrdAttID_Prd FOREIGN KEY (MvaColID) REFERENCES Product (PrdID) ON DELETE CASCADE;
ALTER TABLE MvaPrdAttFileName ADD CONSTRAINT FK_MC_PrdAttFileName_Prd FOREIGN KEY (MvaColID) REFERENCES Product (PrdID) ON DELETE CASCADE;
ALTER TABLE MvaPrdCptID ADD CONSTRAINT FK_MC_PrdCptID_Prd FOREIGN KEY (MvaColID) REFERENCES Product (PrdID) ON DELETE CASCADE;
ALTER TABLE MvaPrdCptID ADD CONSTRAINT FK_MT_PrdCptID_Cpt FOREIGN KEY (MvaText) REFERENCES Competitor (CptID) ON DELETE CASCADE;
ALTER TABLE Product ADD CONSTRAINT FK_PrdPkgID_Ref FOREIGN KEY (PrdPkgID) REFERENCES RefValues (RefID);
ALTER TABLE Product ADD CONSTRAINT FK_PrdTvaID_Ref FOREIGN KEY (PrdTvaID) REFERENCES RefValues (RefID);
ALTER TABLE Product ADD CONSTRAINT FK_PrdFamilyID_Prf FOREIGN KEY (PrdFamilyID) REFERENCES ProductFamily (PrfID) ON DELETE SET NULL;
ALTER TABLE Product ADD CONSTRAINT FK_PrdTypID_Ref FOREIGN KEY (PrdTypID) REFERENCES RefValues (RefID);
ALTER TABLE Product ADD CONSTRAINT FK_PrdTprID_Ref FOREIGN KEY (PrdTprID) REFERENCES RefValues (RefID);
ALTER TABLE MvaPrdQualification ADD CONSTRAINT FK_MC_PrdQualification_Prd FOREIGN KEY (MvaColID) REFERENCES Product (PrdID) ON DELETE CASCADE;
ALTER TABLE MvaPrdQualification ADD CONSTRAINT FK_MT_PrdQualification_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaPrdPartitionID ADD CONSTRAINT FK_MC_PrdPartitionID_Prd FOREIGN KEY (MvaColID) REFERENCES Product (PrdID) ON DELETE CASCADE;
ALTER TABLE MvaPrdPartitionID ADD CONSTRAINT FK_MT_PrdPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Product ADD CONSTRAINT FK_PrdCreID_Act FOREIGN KEY (PrdCreID) REFERENCES Actor (ActID);
ALTER TABLE Product ADD CONSTRAINT FK_PrdModID_Act FOREIGN KEY (PrdModID) REFERENCES Actor (ActID);

ALTER TABLE ProductFamily ADD CONSTRAINT FK_PrfActID_Act FOREIGN KEY (PrfActID) REFERENCES Actor (ActID);
ALTER TABLE ProductFamily ADD CONSTRAINT FK_PrfColor_Ref FOREIGN KEY (PrfColor) REFERENCES RefValues (RefID);
ALTER TABLE MvaPrfQualification ADD CONSTRAINT FK_MC_PrfQualification_Prf FOREIGN KEY (MvaColID) REFERENCES ProductFamily (PrfID) ON DELETE CASCADE;
ALTER TABLE MvaPrfQualification ADD CONSTRAINT FK_MT_PrfQualification_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE ProductFamily ADD CONSTRAINT FK_PrfLngID_Ref FOREIGN KEY (PrfLngID) REFERENCES RefValues (RefID);
ALTER TABLE ProductFamily ADD CONSTRAINT FK_PrfCreID_Act FOREIGN KEY (PrfCreID) REFERENCES Actor (ActID);
ALTER TABLE ProductFamily ADD CONSTRAINT FK_PrfModID_Act FOREIGN KEY (PrfModID) REFERENCES Actor (ActID);

ALTER TABLE ProductGroupEntry ADD CONSTRAINT FK_PgePrdID_Prd FOREIGN KEY (PgePrdID) REFERENCES Product (PrdID);
ALTER TABLE ProductGroupEntry ADD CONSTRAINT FK_PgeGrpPrdID_Prd FOREIGN KEY (PgeGrpPrdID) REFERENCES Product (PrdID) ON DELETE CASCADE;
ALTER TABLE ProductGroupEntry ADD CONSTRAINT FK_PgeCreID_Act FOREIGN KEY (PgeCreID) REFERENCES Actor (ActID);
ALTER TABLE ProductGroupEntry ADD CONSTRAINT FK_PgeModID_Act FOREIGN KEY (PgeModID) REFERENCES Actor (ActID);

ALTER TABLE QuestionResponse ADD CONSTRAINT FK_QrsLfqID_Lfq FOREIGN KEY (QrsLfqID) REFERENCES LinkFormQuestion (LfqID);
ALTER TABLE QuestionResponse ADD CONSTRAINT FK_QrsRefValID_Ref FOREIGN KEY (QrsRefValID) REFERENCES RefValues (RefID);
ALTER TABLE QuestionResponse ADD CONSTRAINT FK_QrsCreID_Act FOREIGN KEY (QrsCreID) REFERENCES Actor (ActID);
ALTER TABLE QuestionResponse ADD CONSTRAINT FK_QrsModID_Act FOREIGN KEY (QrsModID) REFERENCES Actor (ActID);

ALTER TABLE Script ADD CONSTRAINT FK_ScrEventID_Evt FOREIGN KEY (ScrEventID) REFERENCES Event (EvtID);
ALTER TABLE Script ADD CONSTRAINT FK_ScrResponderObj_Obj FOREIGN KEY (ScrResponderObj) REFERENCES Objects (ObjID);
ALTER TABLE Script ADD CONSTRAINT FK_ScrCategory_Ref FOREIGN KEY (ScrCategory) REFERENCES RefValues (RefID);
ALTER TABLE Script ADD CONSTRAINT FK_ScrEveStChMode_Ref FOREIGN KEY (ScrEveStChMode) REFERENCES RefValues (RefID);
ALTER TABLE Script ADD CONSTRAINT FK_ScrJSPPage_Ref FOREIGN KEY (ScrJSPPage) REFERENCES RefValues (RefID);
ALTER TABLE Script ADD CONSTRAINT FK_ScrLanguage_Ref FOREIGN KEY (ScrLanguage) REFERENCES RefValues (RefID);
ALTER TABLE Script ADD CONSTRAINT FK_ScrParStatus_Ref FOREIGN KEY (ScrParStatus) REFERENCES RefValues (RefID);
ALTER TABLE Script ADD CONSTRAINT FK_ScrParStatusRule_Ref FOREIGN KEY (ScrParStatusRule) REFERENCES RefValues (RefID);
ALTER TABLE Script ADD CONSTRAINT FK_ScrCreID_Act FOREIGN KEY (ScrCreID) REFERENCES Actor (ActID);
ALTER TABLE Script ADD CONSTRAINT FK_ScrModID_Act FOREIGN KEY (ScrModID) REFERENCES Actor (ActID);

ALTER TABLE ScriptElement ADD CONSTRAINT FK_SceCategory_Ref FOREIGN KEY (SceCategory) REFERENCES RefValues (RefID);
ALTER TABLE ScriptElement ADD CONSTRAINT FK_SceType_Ref FOREIGN KEY (SceType) REFERENCES RefValues (RefID);
ALTER TABLE ScriptElement ADD CONSTRAINT FK_SceRefTable_Tab FOREIGN KEY (SceRefTable) REFERENCES Tables (TabID);
ALTER TABLE ScriptElement ADD CONSTRAINT FK_SceDispType_Ref FOREIGN KEY (SceDispType) REFERENCES RefValues (RefID);
ALTER TABLE ScriptElement ADD CONSTRAINT FK_SceStoreInObjID_Obj FOREIGN KEY (SceStoreInObjID) REFERENCES Objects (ObjID);
ALTER TABLE ScriptElement ADD CONSTRAINT FK_SceStoreInFldID_Fld FOREIGN KEY (SceStoreInFldID) REFERENCES Field (FldID);
ALTER TABLE ScriptElement ADD CONSTRAINT FK_SceLanguage_Ref FOREIGN KEY (SceLanguage) REFERENCES RefValues (RefID);
ALTER TABLE ScriptElement ADD CONSTRAINT FK_SceJSPPage_Ref FOREIGN KEY (SceJSPPage) REFERENCES RefValues (RefID);
ALTER TABLE ScriptElement ADD CONSTRAINT FK_SceCreID_Act FOREIGN KEY (SceCreID) REFERENCES Actor (ActID);
ALTER TABLE ScriptElement ADD CONSTRAINT FK_SceModID_Act FOREIGN KEY (SceModID) REFERENCES Actor (ActID);

ALTER TABLE ScriptElementResponse ADD CONSTRAINT FK_SerLseID_Lse FOREIGN KEY (SerLseID) REFERENCES LinkScriptElement (LseID);
ALTER TABLE ScriptElementResponse ADD CONSTRAINT FK_SerSrpID_Srp FOREIGN KEY (SerSrpID) REFERENCES ScriptResponse (SrpID) ON DELETE CASCADE;
ALTER TABLE ScriptElementResponse ADD CONSTRAINT FK_SerRefValID_Ref FOREIGN KEY (SerRefValID) REFERENCES RefValues (RefID);
ALTER TABLE ScriptElementResponse ADD CONSTRAINT FK_SerCreID_Act FOREIGN KEY (SerCreID) REFERENCES Actor (ActID);
ALTER TABLE ScriptElementResponse ADD CONSTRAINT FK_SerModID_Act FOREIGN KEY (SerModID) REFERENCES Actor (ActID);

ALTER TABLE ScriptElementTransition ADD CONSTRAINT FK_SetCreID_Act FOREIGN KEY (SetCreID) REFERENCES Actor (ActID);
ALTER TABLE ScriptElementTransition ADD CONSTRAINT FK_SetModID_Act FOREIGN KEY (SetModID) REFERENCES Actor (ActID);

ALTER TABLE ScriptPage ADD CONSTRAINT FK_ScpScriptID_Scr FOREIGN KEY (ScpScriptID) REFERENCES Script (ScrID) ON DELETE CASCADE;
ALTER TABLE ScriptPage ADD CONSTRAINT FK_ScpCreID_Act FOREIGN KEY (ScpCreID) REFERENCES Actor (ActID);
ALTER TABLE ScriptPage ADD CONSTRAINT FK_ScpModID_Act FOREIGN KEY (ScpModID) REFERENCES Actor (ActID);

ALTER TABLE ScriptResponse ADD CONSTRAINT FK_SrpScriptID_Scr FOREIGN KEY (SrpScriptID) REFERENCES Script (ScrID);
ALTER TABLE ScriptResponse ADD CONSTRAINT FK_SrpCreID_Act FOREIGN KEY (SrpCreID) REFERENCES Actor (ActID);
ALTER TABLE ScriptResponse ADD CONSTRAINT FK_SrpModID_Act FOREIGN KEY (SrpModID) REFERENCES Actor (ActID);

ALTER TABLE Segment ADD CONSTRAINT FK_SegColor_Ref FOREIGN KEY (SegColor) REFERENCES RefValues (RefID);
ALTER TABLE Segment ADD CONSTRAINT FK_SegRefValue_Ref FOREIGN KEY (SegRefValue) REFERENCES RefValues (RefID);
ALTER TABLE Segment ADD CONSTRAINT FK_SegAxeID_Axe FOREIGN KEY (SegAxeID) REFERENCES Axis (AxeID);
ALTER TABLE Segment ADD CONSTRAINT FK_SegCreID_Act FOREIGN KEY (SegCreID) REFERENCES Actor (ActID);
ALTER TABLE Segment ADD CONSTRAINT FK_SegModID_Act FOREIGN KEY (SegModID) REFERENCES Actor (ActID);

ALTER TABLE Selection ADD CONSTRAINT FK_SelMaxTyp_Ref FOREIGN KEY (SelMaxTyp) REFERENCES RefValues (RefID);
ALTER TABLE Selection ADD CONSTRAINT FK_SelColor_Ref FOREIGN KEY (SelColor) REFERENCES RefValues (RefID);
ALTER TABLE Selection ADD CONSTRAINT FK_SelTarget_Ref FOREIGN KEY (SelTarget) REFERENCES RefValues (RefID);
ALTER TABLE MvaSelTargets ADD CONSTRAINT FK_MC_SelTargets_Sel FOREIGN KEY (MvaColID) REFERENCES Selection (SelID) ON DELETE CASCADE;
ALTER TABLE MvaSelTargets ADD CONSTRAINT FK_MT_SelTargets_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Selection ADD CONSTRAINT FK_SelCreID_Act FOREIGN KEY (SelCreID) REFERENCES Actor (ActID);
ALTER TABLE Selection ADD CONSTRAINT FK_SelModID_Act FOREIGN KEY (SelModID) REFERENCES Actor (ActID);

ALTER TABLE Selection2 ADD CONSTRAINT FK_Se2Model_Smd FOREIGN KEY (Se2Model) REFERENCES SelectionModel (SmdID);
ALTER TABLE Selection2 ADD CONSTRAINT FK_Se2Cr2ID_Cr2 FOREIGN KEY (Se2Cr2ID) REFERENCES Criteria2 (Cr2ID) ON DELETE SET NULL;
ALTER TABLE Selection2 ADD CONSTRAINT FK_Se2Event_Evt FOREIGN KEY (Se2Event) REFERENCES Event (EvtID);
ALTER TABLE MvaSe2PartitionID ADD CONSTRAINT FK_MC_Se2PartitionID_Se2 FOREIGN KEY (MvaColID) REFERENCES Selection2 (Se2ID) ON DELETE CASCADE;
ALTER TABLE MvaSe2PartitionID ADD CONSTRAINT FK_MT_Se2PartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Selection2 ADD CONSTRAINT FK_Se2CreID_Act FOREIGN KEY (Se2CreID) REFERENCES Actor (ActID);
ALTER TABLE Selection2 ADD CONSTRAINT FK_Se2ModID_Act FOREIGN KEY (Se2ModID) REFERENCES Actor (ActID);

ALTER TABLE SelectionJournalist ADD CONSTRAINT FK_SjoType_Ref FOREIGN KEY (SjoType) REFERENCES RefValues (RefID);
ALTER TABLE SelectionJournalist ADD CONSTRAINT FK_SjoCreID_Act FOREIGN KEY (SjoCreID) REFERENCES Actor (ActID);
ALTER TABLE SelectionJournalist ADD CONSTRAINT FK_SjoModID_Act FOREIGN KEY (SjoModID) REFERENCES Actor (ActID);

ALTER TABLE SelectionModel ADD CONSTRAINT FK_SmdObjID_Obj FOREIGN KEY (SmdObjID) REFERENCES Objects (ObjID);
ALTER TABLE SelectionModel ADD CONSTRAINT FK_SmdObj1_Obj FOREIGN KEY (SmdObj1) REFERENCES Objects (ObjID);
ALTER TABLE SelectionModel ADD CONSTRAINT FK_SmdObj2_Obj FOREIGN KEY (SmdObj2) REFERENCES Objects (ObjID);
ALTER TABLE SelectionModel ADD CONSTRAINT FK_SmdObj3_Obj FOREIGN KEY (SmdObj3) REFERENCES Objects (ObjID);
ALTER TABLE SelectionModel ADD CONSTRAINT FK_SmdObj4_Obj FOREIGN KEY (SmdObj4) REFERENCES Objects (ObjID);
ALTER TABLE SelectionModel ADD CONSTRAINT FK_SmdObj5_Obj FOREIGN KEY (SmdObj5) REFERENCES Objects (ObjID);
ALTER TABLE SelectionModel ADD CONSTRAINT FK_SmdLstID_Lst FOREIGN KEY (SmdLstID) REFERENCES List (LstID);
ALTER TABLE MvaSmdPartitionID ADD CONSTRAINT FK_MC_SmdPartitionID_Smd FOREIGN KEY (MvaColID) REFERENCES SelectionModel (SmdID) ON DELETE CASCADE;
ALTER TABLE MvaSmdPartitionID ADD CONSTRAINT FK_MT_SmdPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE SelectionModel ADD CONSTRAINT FK_SmdOrigin_Ref FOREIGN KEY (SmdOrigin) REFERENCES RefValues (RefID);
ALTER TABLE SelectionModel ADD CONSTRAINT FK_SmdCreID_Act FOREIGN KEY (SmdCreID) REFERENCES Actor (ActID);
ALTER TABLE SelectionModel ADD CONSTRAINT FK_SmdModID_Act FOREIGN KEY (SmdModID) REFERENCES Actor (ActID);

ALTER TABLE Stage ADD CONSTRAINT FK_StgPopID_Pop FOREIGN KEY (StgPopID) REFERENCES Population (PopID);
ALTER TABLE MvaStgAttFileName ADD CONSTRAINT FK_MC_StgAttFileName_Stg FOREIGN KEY (MvaColID) REFERENCES Stage (StgID) ON DELETE CASCADE;
ALTER TABLE MvaStgAttID ADD CONSTRAINT FK_MC_StgAttID_Stg FOREIGN KEY (MvaColID) REFERENCES Stage (StgID) ON DELETE CASCADE;
ALTER TABLE Stage ADD CONSTRAINT FK_StgEvtID_Evt FOREIGN KEY (StgEvtID) REFERENCES Event (EvtID);
ALTER TABLE Stage ADD CONSTRAINT FK_StgIndicUnit1_Ref FOREIGN KEY (StgIndicUnit1) REFERENCES RefValues (RefID);
ALTER TABLE Stage ADD CONSTRAINT FK_StgIndicUnit2_Ref FOREIGN KEY (StgIndicUnit2) REFERENCES RefValues (RefID);
ALTER TABLE Stage ADD CONSTRAINT FK_StgIndicUnit3_Ref FOREIGN KEY (StgIndicUnit3) REFERENCES RefValues (RefID);
ALTER TABLE Stage ADD CONSTRAINT FK_StgIndicUnit4_Ref FOREIGN KEY (StgIndicUnit4) REFERENCES RefValues (RefID);
ALTER TABLE Stage ADD CONSTRAINT FK_StgIndicUnit5_Ref FOREIGN KEY (StgIndicUnit5) REFERENCES RefValues (RefID);
ALTER TABLE Stage ADD CONSTRAINT FK_StgCreID_Act FOREIGN KEY (StgCreID) REFERENCES Actor (ActID);
ALTER TABLE Stage ADD CONSTRAINT FK_StgModID_Act FOREIGN KEY (StgModID) REFERENCES Actor (ActID);

ALTER TABLE Support ADD CONSTRAINT FK_SupEdiID_Edi FOREIGN KEY (SupEdiID) REFERENCES Editor (EdiID) ON DELETE SET NULL;
ALTER TABLE Support ADD CONSTRAINT FK_SupCtrID_Ref FOREIGN KEY (SupCtrID) REFERENCES RefValues (RefID);
ALTER TABLE Support ADD CONSTRAINT FK_SupFrqID_Ref FOREIGN KEY (SupFrqID) REFERENCES RefValues (RefID);
ALTER TABLE Support ADD CONSTRAINT FK_SupTarID_Ref FOREIGN KEY (SupTarID) REFERENCES RefValues (RefID);
ALTER TABLE Support ADD CONSTRAINT FK_SupSutID_Ref FOREIGN KEY (SupSutID) REFERENCES RefValues (RefID);
ALTER TABLE MvaSupAttID ADD CONSTRAINT FK_MC_SupAttID_Sup FOREIGN KEY (MvaColID) REFERENCES Support (SupID) ON DELETE CASCADE;
ALTER TABLE MvaSupAttFileName ADD CONSTRAINT FK_MC_SupAttFileName_Sup FOREIGN KEY (MvaColID) REFERENCES Support (SupID) ON DELETE CASCADE;
ALTER TABLE MvaSupJevID ADD CONSTRAINT FK_MC_SupJevID_Sup FOREIGN KEY (MvaColID) REFERENCES Support (SupID) ON DELETE CASCADE;
ALTER TABLE MvaSupJevID ADD CONSTRAINT FK_MT_SupJevID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Support ADD CONSTRAINT FK_SupCreID_Act FOREIGN KEY (SupCreID) REFERENCES Actor (ActID);
ALTER TABLE Support ADD CONSTRAINT FK_SupModID_Act FOREIGN KEY (SupModID) REFERENCES Actor (ActID);

ALTER TABLE Alert ADD CONSTRAINT FK_AlrActID_Act FOREIGN KEY (AlrActID) REFERENCES Actor (ActID);
ALTER TABLE Alert ADD CONSTRAINT FK_AlrMsgID_Msg FOREIGN KEY (AlrMsgID) REFERENCES Messages (MsgID);
ALTER TABLE Alert ADD CONSTRAINT FK_AlrStlID_Ref FOREIGN KEY (AlrStlID) REFERENCES RefValues (RefID);
ALTER TABLE Alert ADD CONSTRAINT FK_AlrCreID_Act FOREIGN KEY (AlrCreID) REFERENCES Actor (ActID);
ALTER TABLE Alert ADD CONSTRAINT FK_AlrModID_Act FOREIGN KEY (AlrModID) REFERENCES Actor (ActID);

ALTER TABLE EMailing ADD CONSTRAINT FK_EmaPopID_Pop FOREIGN KEY (EmaPopID) REFERENCES Population (PopID) ON DELETE SET NULL;
ALTER TABLE EMailing ADD CONSTRAINT FK_EmaHtmlMsgID_Msg FOREIGN KEY (EmaHtmlMsgID) REFERENCES Messages (MsgID);
ALTER TABLE EMailing ADD CONSTRAINT FK_EmaStateID_Ref FOREIGN KEY (EmaStateID) REFERENCES RefValues (RefID);
ALTER TABLE EMailing ADD CONSTRAINT FK_EmaSenderID_Act FOREIGN KEY (EmaSenderID) REFERENCES Actor (ActID);
ALTER TABLE MvaEmaHtmlCtlGrpID ADD CONSTRAINT FK_MC_EmaHtmlCtlGrpID_Ema FOREIGN KEY (MvaColID) REFERENCES EMailing (EmaID) ON DELETE CASCADE;
ALTER TABLE MvaEmaTextCtlGrpID ADD CONSTRAINT FK_MC_EmaTextCtlGrpID_Ema FOREIGN KEY (MvaColID) REFERENCES EMailing (EmaID) ON DELETE CASCADE;
ALTER TABLE EMailing ADD CONSTRAINT FK_EmaTextMsgID_Msg FOREIGN KEY (EmaTextMsgID) REFERENCES Messages (MsgID);
ALTER TABLE MvaEmaNltID ADD CONSTRAINT FK_MC_EmaNltID_Ema FOREIGN KEY (MvaColID) REFERENCES EMailing (EmaID) ON DELETE CASCADE;
ALTER TABLE MvaEmaNltID ADD CONSTRAINT FK_MT_EmaNltID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE EMailing ADD CONSTRAINT FK_EmaPopTypID_Ref FOREIGN KEY (EmaPopTypID) REFERENCES RefValues (RefID);
ALTER TABLE EMailing ADD CONSTRAINT FK_EmaTagName_Ref FOREIGN KEY (EmaTagName) REFERENCES RefValues (RefID);
ALTER TABLE EMailing ADD CONSTRAINT FK_EmaReplyToID_Act FOREIGN KEY (EmaReplyToID) REFERENCES Actor (ActID);
ALTER TABLE EMailing ADD CONSTRAINT FK_EmaCreID_Act FOREIGN KEY (EmaCreID) REFERENCES Actor (ActID);
ALTER TABLE EMailing ADD CONSTRAINT FK_EmaModID_Act FOREIGN KEY (EmaModID) REFERENCES Actor (ActID);

ALTER TABLE EmailingStats ADD CONSTRAINT FK_EstEmlStatus_Ref FOREIGN KEY (EstEmlStatus) REFERENCES RefValues (RefID);
ALTER TABLE EmailingStats ADD CONSTRAINT FK_EstEmlID_Eml FOREIGN KEY (EstEmlID) REFERENCES MassEmailing (EmlID);
ALTER TABLE EmailingStats ADD CONSTRAINT FK_EstElnID_Eln FOREIGN KEY (EstElnID) REFERENCES EMailLink (ElnID);
ALTER TABLE EmailingStats ADD CONSTRAINT FK_EstCreID_Act FOREIGN KEY (EstCreID) REFERENCES Actor (ActID);
ALTER TABLE EmailingStats ADD CONSTRAINT FK_EstModID_Act FOREIGN KEY (EstModID) REFERENCES Actor (ActID);

ALTER TABLE EMailLink ADD CONSTRAINT FK_ElnEmlID_Eml FOREIGN KEY (ElnEmlID) REFERENCES MassEmailing (EmlID) ON DELETE CASCADE;
ALTER TABLE EMailLink ADD CONSTRAINT FK_ElnWopID_Wop FOREIGN KEY (ElnWopID) REFERENCES WebOperation (WopID) ON DELETE SET NULL;
ALTER TABLE EMailLink ADD CONSTRAINT FK_ElnEvtID_Evt FOREIGN KEY (ElnEvtID) REFERENCES Event (EvtID) ON DELETE SET NULL;
ALTER TABLE EMailLink ADD CONSTRAINT FK_ElnPopID_Pop FOREIGN KEY (ElnPopID) REFERENCES Population (PopID) ON DELETE SET NULL;
ALTER TABLE EMailLink ADD CONSTRAINT FK_ElnInsStatus_Ref FOREIGN KEY (ElnInsStatus) REFERENCES RefValues (RefID);
ALTER TABLE EMailLink ADD CONSTRAINT FK_ElnCreID_Act FOREIGN KEY (ElnCreID) REFERENCES Actor (ActID) ON DELETE SET NULL;
ALTER TABLE EMailLink ADD CONSTRAINT FK_ElnModID_Act FOREIGN KEY (ElnModID) REFERENCES Actor (ActID) ON DELETE SET NULL;

ALTER TABLE EMailMessage ADD CONSTRAINT FK_EmmMsgID_Msg FOREIGN KEY (EmmMsgID) REFERENCES Messages (MsgID) ON DELETE CASCADE;
ALTER TABLE EMailMessage ADD CONSTRAINT FK_EmmEmlID_Eml FOREIGN KEY (EmmEmlID) REFERENCES MassEmailing (EmlID) ON DELETE CASCADE;
ALTER TABLE EMailMessage ADD CONSTRAINT FK_EmmCreID_Act FOREIGN KEY (EmmCreID) REFERENCES Actor (ActID);
ALTER TABLE EMailMessage ADD CONSTRAINT FK_EmmModID_Act FOREIGN KEY (EmmModID) REFERENCES Actor (ActID);

ALTER TABLE EMailOutServer ADD CONSTRAINT FK_EosType_Ref FOREIGN KEY (EosType) REFERENCES RefValues (RefID);
ALTER TABLE EMailOutServer ADD CONSTRAINT FK_EosSmtpProtocol_Ref FOREIGN KEY (EosSmtpProtocol) REFERENCES RefValues (RefID);
ALTER TABLE EMailOutServer ADD CONSTRAINT FK_EosCreID_Act FOREIGN KEY (EosCreID) REFERENCES Actor (ActID);
ALTER TABLE EMailOutServer ADD CONSTRAINT FK_EosModID_Act FOREIGN KEY (EosModID) REFERENCES Actor (ActID);

ALTER TABLE EMailSender ADD CONSTRAINT FK_EsnType_Ref FOREIGN KEY (EsnType) REFERENCES RefValues (RefID);
ALTER TABLE EMailSender ADD CONSTRAINT FK_EsnStatus_Ref FOREIGN KEY (EsnStatus) REFERENCES RefValues (RefID);
ALTER TABLE EMailSender ADD CONSTRAINT FK_EsnActorID_Act FOREIGN KEY (EsnActorID) REFERENCES Actor (ActID);
ALTER TABLE EMailSender ADD CONSTRAINT FK_EsnBounceAccessType_Ref FOREIGN KEY (EsnBounceAccessType) REFERENCES RefValues (RefID);
ALTER TABLE EMailSender ADD CONSTRAINT FK_EsnDefaultServer_Eos FOREIGN KEY (EsnDefaultServer) REFERENCES EMailOutServer (EosID);
ALTER TABLE EMailSender ADD CONSTRAINT FK_EsnCreID_Act FOREIGN KEY (EsnCreID) REFERENCES Actor (ActID);
ALTER TABLE EMailSender ADD CONSTRAINT FK_EsnModID_Act FOREIGN KEY (EsnModID) REFERENCES Actor (ActID);

ALTER TABLE EMailSent ADD CONSTRAINT FK_EmsEmaID_Ema FOREIGN KEY (EmsEmaID) REFERENCES EMailing (EmaID);
ALTER TABLE EMailSent ADD CONSTRAINT FK_EmsPerID_Per FOREIGN KEY (EmsPerID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE EMailSent ADD CONSTRAINT FK_EmsJouID_Jou FOREIGN KEY (EmsJouID) REFERENCES Journalist (JouID) ON DELETE CASCADE;
ALTER TABLE EMailSent ADD CONSTRAINT FK_EmsSilID_Sil FOREIGN KEY (EmsSilID) REFERENCES Silhouette (SilID) ON DELETE CASCADE;
ALTER TABLE EMailSent ADD CONSTRAINT FK_EmsEmlID_Eml FOREIGN KEY (EmsEmlID) REFERENCES MassEmailing (EmlID);
ALTER TABLE EMailSent ADD CONSTRAINT FK_EmsBounceReasons_Ref FOREIGN KEY (EmsBounceReasons) REFERENCES RefValues (RefID);
ALTER TABLE EMailSent ADD CONSTRAINT FK_EmsCreID_Act FOREIGN KEY (EmsCreID) REFERENCES Actor (ActID);
ALTER TABLE EMailSent ADD CONSTRAINT FK_EmsModID_Act FOREIGN KEY (EmsModID) REFERENCES Actor (ActID);

ALTER TABLE EMailSnippet ADD CONSTRAINT FK_EmtLanguage_Ref FOREIGN KEY (EmtLanguage) REFERENCES RefValues (RefID);
ALTER TABLE EMailSnippet ADD CONSTRAINT FK_EmtCreID_Act FOREIGN KEY (EmtCreID) REFERENCES Actor (ActID);
ALTER TABLE EMailSnippet ADD CONSTRAINT FK_EmtModID_Act FOREIGN KEY (EmtModID) REFERENCES Actor (ActID);

ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblOriID_Ori FOREIGN KEY (IblOriID) REFERENCES Origin (OriID) ON DELETE SET NULL;
ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblWopID_Wop FOREIGN KEY (IblWopID) REFERENCES WebOperation (WopID) ON DELETE SET NULL;
ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblTimeRange_Ref FOREIGN KEY (IblTimeRange) REFERENCES RefValues (RefID);
ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblPreviousLog_Ibl FOREIGN KEY (IblPreviousLog) REFERENCES InBoundLog (IblID) ON DELETE SET NULL;
ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblElnID_Eln FOREIGN KEY (IblElnID) REFERENCES EMailLink (ElnID);
ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblCivID_Ref FOREIGN KEY (IblCivID) REFERENCES RefValues (RefID);
ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblPerID_Per FOREIGN KEY (IblPerID) REFERENCES Person (PerID);
ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblSilID_Sil FOREIGN KEY (IblSilID) REFERENCES Silhouette (SilID);
ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblEmlID_Eml FOREIGN KEY (IblEmlID) REFERENCES MassEmailing (EmlID) ON DELETE SET NULL;
ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblCreID_Act FOREIGN KEY (IblCreID) REFERENCES Actor (ActID);
ALTER TABLE InBoundLog ADD CONSTRAINT FK_IblModID_Act FOREIGN KEY (IblModID) REFERENCES Actor (ActID);

ALTER TABLE MailCustomization ADD CONSTRAINT FK_McsCreID_Act FOREIGN KEY (McsCreID) REFERENCES Actor (ActID);
ALTER TABLE MailCustomization ADD CONSTRAINT FK_McsModID_Act FOREIGN KEY (McsModID) REFERENCES Actor (ActID);

ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlOwner_Act FOREIGN KEY (EmlOwner) REFERENCES Actor (ActID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlStatus_Ref FOREIGN KEY (EmlStatus) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlType_Ref FOREIGN KEY (EmlType) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlDstSelPer_Se2 FOREIGN KEY (EmlDstSelPer) REFERENCES Selection2 (Se2ID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlDstSelSil_Se2 FOREIGN KEY (EmlDstSelSil) REFERENCES Selection2 (Se2ID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlDstPopPer_Pop FOREIGN KEY (EmlDstPopPer) REFERENCES Population (PopID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlDstPopSil_Pop FOREIGN KEY (EmlDstPopSil) REFERENCES Population (PopID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlDstSubsPer_Ref FOREIGN KEY (EmlDstSubsPer) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlDstSubsSil_Ref FOREIGN KEY (EmlDstSubsSil) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlTypeDst_Ref FOREIGN KEY (EmlTypeDst) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltPopPer_Pop FOREIGN KEY (EmlFltPopPer) REFERENCES Population (PopID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltPopSil_Pop FOREIGN KEY (EmlFltPopSil) REFERENCES Population (PopID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltPopOp_Ref FOREIGN KEY (EmlFltPopOp) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltReadEmlID_Eml FOREIGN KEY (EmlFltReadEmlID) REFERENCES MassEmailing (EmlID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltReadMsgOp_Ref FOREIGN KEY (EmlFltReadMsgOp) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltLinkEmlID_Eml FOREIGN KEY (EmlFltLinkEmlID) REFERENCES MassEmailing (EmlID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltLinkOp_Ref FOREIGN KEY (EmlFltLinkOp) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltSubs_Ref FOREIGN KEY (EmlFltSubs) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltSubsOp_Ref FOREIGN KEY (EmlFltSubsOp) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltEvtID_Evt FOREIGN KEY (EmlFltEvtID) REFERENCES Event (EvtID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFltEvtOp_Ref FOREIGN KEY (EmlFltEvtOp) REFERENCES RefValues (RefID);
ALTER TABLE MvaEmlMsgID ADD CONSTRAINT FK_MC_EmlMsgID_Eml FOREIGN KEY (MvaColID) REFERENCES MassEmailing (EmlID) ON DELETE CASCADE;
ALTER TABLE MvaEmlMsgID ADD CONSTRAINT FK_MT_EmlMsgID_Msg FOREIGN KEY (MvaText) REFERENCES Messages (MsgID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlSndEnsID_Esn FOREIGN KEY (EmlSndEnsID) REFERENCES EMailSender (EsnID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlSndFldID_Fld FOREIGN KEY (EmlSndFldID) REFERENCES Field (FldID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlSndTestGrp_Pop FOREIGN KEY (EmlSndTestGrp) REFERENCES Population (PopID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlSndEosID_Eos FOREIGN KEY (EmlSndEosID) REFERENCES EMailOutServer (EosID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFlwEvtID_Evt FOREIGN KEY (EmlFlwEvtID) REFERENCES Event (EvtID);
ALTER TABLE MvaEmlMailSendField ADD CONSTRAINT FK_MC_EmlMailSendField_Eml FOREIGN KEY (MvaColID) REFERENCES MassEmailing (EmlID) ON DELETE CASCADE;
ALTER TABLE MvaEmlMailSendField ADD CONSTRAINT FK_MT_EmlMailSendField_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlDstPopTest_Pop FOREIGN KEY (EmlDstPopTest) REFERENCES Population (PopID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFinalPerPopID_Pop FOREIGN KEY (EmlFinalPerPopID) REFERENCES Population (PopID) ON DELETE SET NULL;
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlFinalSilPopID_Pop FOREIGN KEY (EmlFinalSilPopID) REFERENCES Population (PopID) ON DELETE SET NULL;
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlCreID_Act FOREIGN KEY (EmlCreID) REFERENCES Actor (ActID);
ALTER TABLE MassEmailing ADD CONSTRAINT FK_EmlModID_Act FOREIGN KEY (EmlModID) REFERENCES Actor (ActID);

ALTER TABLE Origin ADD CONSTRAINT FK_OriCreID_Act FOREIGN KEY (OriCreID) REFERENCES Actor (ActID);
ALTER TABLE Origin ADD CONSTRAINT FK_OriModID_Act FOREIGN KEY (OriModID) REFERENCES Actor (ActID);

ALTER TABLE OutBoundLog ADD CONSTRAINT FK_OblOdrID_Odr FOREIGN KEY (OblOdrID) REFERENCES OutDoor (OdrID) ON DELETE SET NULL;
ALTER TABLE OutBoundLog ADD CONSTRAINT FK_OblOriID_Ori FOREIGN KEY (OblOriID) REFERENCES Origin (OriID) ON DELETE SET NULL;
ALTER TABLE OutBoundLog ADD CONSTRAINT FK_OblWopID_Wop FOREIGN KEY (OblWopID) REFERENCES WebOperation (WopID) ON DELETE SET NULL;
ALTER TABLE OutBoundLog ADD CONSTRAINT FK_OblTimeRange_Ref FOREIGN KEY (OblTimeRange) REFERENCES RefValues (RefID);
ALTER TABLE OutBoundLog ADD CONSTRAINT FK_OblCreID_Act FOREIGN KEY (OblCreID) REFERENCES Actor (ActID);
ALTER TABLE OutBoundLog ADD CONSTRAINT FK_OblModID_Act FOREIGN KEY (OblModID) REFERENCES Actor (ActID);

ALTER TABLE OutDoor ADD CONSTRAINT FK_OdrCreID_Act FOREIGN KEY (OdrCreID) REFERENCES Actor (ActID);
ALTER TABLE OutDoor ADD CONSTRAINT FK_OdrModID_Act FOREIGN KEY (OdrModID) REFERENCES Actor (ActID);

ALTER TABLE MvaPubAttID ADD CONSTRAINT FK_MC_PubAttID_Pub FOREIGN KEY (MvaColID) REFERENCES Publication (PubID) ON DELETE CASCADE;
ALTER TABLE MvaPubAttNames ADD CONSTRAINT FK_MC_PubAttNames_Pub FOREIGN KEY (MvaColID) REFERENCES Publication (PubID) ON DELETE CASCADE;
ALTER TABLE MvaPubLastPublishErrors ADD CONSTRAINT FK_MC_PubLastPublishErrors_6 FOREIGN KEY (MvaColID) REFERENCES Publication (PubID) ON DELETE CASCADE;
ALTER TABLE Publication ADD CONSTRAINT FK_PubSendStatus_Ref FOREIGN KEY (PubSendStatus) REFERENCES RefValues (RefID);
ALTER TABLE Publication ADD CONSTRAINT FK_PubCreID_Act FOREIGN KEY (PubCreID) REFERENCES Actor (ActID);
ALTER TABLE Publication ADD CONSTRAINT FK_PubModID_Act FOREIGN KEY (PubModID) REFERENCES Actor (ActID);

ALTER TABLE PublicationOutlet ADD CONSTRAINT FK_PboOutletType_Ref FOREIGN KEY (PboOutletType) REFERENCES RefValues (RefID);
ALTER TABLE MvaPboAuthActors ADD CONSTRAINT FK_MC_PboAuthActors_Pbo FOREIGN KEY (MvaColID) REFERENCES PublicationOutlet (PboID) ON DELETE CASCADE;
ALTER TABLE MvaPboAuthActors ADD CONSTRAINT FK_MT_PboAuthActors_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE MvaPboAuthRoles ADD CONSTRAINT FK_MC_PboAuthRoles_Pbo FOREIGN KEY (MvaColID) REFERENCES PublicationOutlet (PboID) ON DELETE CASCADE;
ALTER TABLE MvaPboAuthRoles ADD CONSTRAINT FK_MT_PboAuthRoles_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE PublicationOutlet ADD CONSTRAINT FK_PboCreID_Act FOREIGN KEY (PboCreID) REFERENCES Actor (ActID);
ALTER TABLE PublicationOutlet ADD CONSTRAINT FK_PboModID_Act FOREIGN KEY (PboModID) REFERENCES Actor (ActID);

ALTER TABLE PublicationStats ADD CONSTRAINT FK_PbsPubID_Pub FOREIGN KEY (PbsPubID) REFERENCES Publication (PubID);
ALTER TABLE PublicationStats ADD CONSTRAINT FK_PbsPboID_Pbo FOREIGN KEY (PbsPboID) REFERENCES PublicationOutlet (PboID);
ALTER TABLE PublicationStats ADD CONSTRAINT FK_PbsStatus_Ref FOREIGN KEY (PbsStatus) REFERENCES RefValues (RefID);
ALTER TABLE PublicationStats ADD CONSTRAINT FK_PbsCreID_Act FOREIGN KEY (PbsCreID) REFERENCES Actor (ActID);
ALTER TABLE PublicationStats ADD CONSTRAINT FK_PbsModID_Act FOREIGN KEY (PbsModID) REFERENCES Actor (ActID);

ALTER TABLE Questions ADD CONSTRAINT FK_QueAtyID_Ref FOREIGN KEY (QueAtyID) REFERENCES RefValues (RefID);
ALTER TABLE MvaQueAnsID ADD CONSTRAINT FK_MC_QueAnsID_Que FOREIGN KEY (MvaColID) REFERENCES Questions (QueID) ON DELETE CASCADE;
ALTER TABLE Questions ADD CONSTRAINT FK_QuePerFldID_Fld FOREIGN KEY (QuePerFldID) REFERENCES Field (FldID);
ALTER TABLE Questions ADD CONSTRAINT FK_QueSilFldID_Fld FOREIGN KEY (QueSilFldID) REFERENCES Field (FldID);
ALTER TABLE Questions ADD CONSTRAINT FK_QueTheme_Ref FOREIGN KEY (QueTheme) REFERENCES RefValues (RefID);
ALTER TABLE Questions ADD CONSTRAINT FK_QueCreID_Act FOREIGN KEY (QueCreID) REFERENCES Actor (ActID);
ALTER TABLE Questions ADD CONSTRAINT FK_QueModID_Act FOREIGN KEY (QueModID) REFERENCES Actor (ActID);

ALTER TABLE MvaRmmMatchSubject ADD CONSTRAINT FK_MC_RmmMatchSubject_Rmm FOREIGN KEY (MvaColID) REFERENCES ReturnedMailModel (RmmID) ON DELETE CASCADE;
ALTER TABLE MvaRmmMatchText ADD CONSTRAINT FK_MC_RmmMatchText_Rmm FOREIGN KEY (MvaColID) REFERENCES ReturnedMailModel (RmmID) ON DELETE CASCADE;
ALTER TABLE MvaRmmMatchHeaders ADD CONSTRAINT FK_MC_RmmMatchHeaders_Rmm FOREIGN KEY (MvaColID) REFERENCES ReturnedMailModel (RmmID) ON DELETE CASCADE;
ALTER TABLE ReturnedMailModel ADD CONSTRAINT FK_RmmAddrLocation_Ref FOREIGN KEY (RmmAddrLocation) REFERENCES RefValues (RefID);
ALTER TABLE MvaRmmAddrHeaders ADD CONSTRAINT FK_MC_RmmAddrHeaders_Rmm FOREIGN KEY (MvaColID) REFERENCES ReturnedMailModel (RmmID) ON DELETE CASCADE;
ALTER TABLE ReturnedMailModel ADD CONSTRAINT FK_RmmCreID_Act FOREIGN KEY (RmmCreID) REFERENCES Actor (ActID);
ALTER TABLE ReturnedMailModel ADD CONSTRAINT FK_RmmModID_Act FOREIGN KEY (RmmModID) REFERENCES Actor (ActID);

ALTER TABLE Silhouette ADD CONSTRAINT FK_SilCivID_Ref FOREIGN KEY (SilCivID) REFERENCES RefValues (RefID);
ALTER TABLE MvaSilNltID ADD CONSTRAINT FK_MC_SilNltID_Sil FOREIGN KEY (MvaColID) REFERENCES Silhouette (SilID) ON DELETE CASCADE;
ALTER TABLE MvaSilNltID ADD CONSTRAINT FK_MT_SilNltID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Silhouette ADD CONSTRAINT FK_SilCtyID_Ref FOREIGN KEY (SilCtyID) REFERENCES RefValues (RefID);
ALTER TABLE MvaSilQueID ADD CONSTRAINT FK_MC_SilQueID_Sil FOREIGN KEY (MvaColID) REFERENCES Silhouette (SilID) ON DELETE CASCADE;
ALTER TABLE MvaSilQueID ADD CONSTRAINT FK_MT_SilQueID_Que FOREIGN KEY (MvaText) REFERENCES Questions (QueID) ON DELETE CASCADE;
ALTER TABLE Silhouette ADD CONSTRAINT FK_SilOrigin_Ref FOREIGN KEY (SilOrigin) REFERENCES RefValues (RefID);
ALTER TABLE Silhouette ADD CONSTRAINT FK_SilCtrID_Ref FOREIGN KEY (SilCtrID) REFERENCES RefValues (RefID);
ALTER TABLE Silhouette ADD CONSTRAINT FK_SilCreID_Act FOREIGN KEY (SilCreID) REFERENCES Actor (ActID);
ALTER TABLE Silhouette ADD CONSTRAINT FK_SilModID_Act FOREIGN KEY (SilModID) REFERENCES Actor (ActID);

ALTER TABLE SilhouetteTranslator ADD CONSTRAINT FK_StrSilFldID_Fld FOREIGN KEY (StrSilFldID) REFERENCES Field (FldID);
ALTER TABLE SilhouetteTranslator ADD CONSTRAINT FK_StrPerFldID_Fld FOREIGN KEY (StrPerFldID) REFERENCES Field (FldID);
ALTER TABLE SilhouetteTranslator ADD CONSTRAINT FK_StrEntFldID_Fld FOREIGN KEY (StrEntFldID) REFERENCES Field (FldID);
ALTER TABLE SilhouetteTranslator ADD CONSTRAINT FK_StrJouFldID_Fld FOREIGN KEY (StrJouFldID) REFERENCES Field (FldID);
ALTER TABLE SilhouetteTranslator ADD CONSTRAINT FK_StrSupFldID_Fld FOREIGN KEY (StrSupFldID) REFERENCES Field (FldID);
ALTER TABLE SilhouetteTranslator ADD CONSTRAINT FK_StrCreID_Act FOREIGN KEY (StrCreID) REFERENCES Actor (ActID);
ALTER TABLE SilhouetteTranslator ADD CONSTRAINT FK_StrModID_Act FOREIGN KEY (StrModID) REFERENCES Actor (ActID);

ALTER TABLE WebOperation ADD CONSTRAINT FK_WopCreID_Act FOREIGN KEY (WopCreID) REFERENCES Actor (ActID);
ALTER TABLE WebOperation ADD CONSTRAINT FK_WopModID_Act FOREIGN KEY (WopModID) REFERENCES Actor (ActID);

ALTER TABLE Alarm ADD CONSTRAINT FK_AlmActID_Act FOREIGN KEY (AlmActID) REFERENCES Actor (ActID);
ALTER TABLE Alarm ADD CONSTRAINT FK_AlmIntID_Int FOREIGN KEY (AlmIntID) REFERENCES Interaction (IntID) ON DELETE CASCADE;
ALTER TABLE Alarm ADD CONSTRAINT FK_AlmOppID_Opp FOREIGN KEY (AlmOppID) REFERENCES Opportunity (OppID) ON DELETE CASCADE;
ALTER TABLE Alarm ADD CONSTRAINT FK_AlmCreID_Act FOREIGN KEY (AlmCreID) REFERENCES Actor (ActID);
ALTER TABLE Alarm ADD CONSTRAINT FK_AlmModID_Act FOREIGN KEY (AlmModID) REFERENCES Actor (ActID);

ALTER TABLE Correspondent ADD CONSTRAINT FK_CorEntID_Ent FOREIGN KEY (CorEntID) REFERENCES Enterprise (EntID) ON DELETE CASCADE;
ALTER TABLE Correspondent ADD CONSTRAINT FK_CorPerID_Per FOREIGN KEY (CorPerID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE Correspondent ADD CONSTRAINT FK_CorSupID_Sup FOREIGN KEY (CorSupID) REFERENCES Support (SupID) ON DELETE CASCADE;
ALTER TABLE Correspondent ADD CONSTRAINT FK_CorJouID_Jou FOREIGN KEY (CorJouID) REFERENCES Journalist (JouID) ON DELETE CASCADE;
ALTER TABLE Correspondent ADD CONSTRAINT FK_CorCreID_Act FOREIGN KEY (CorCreID) REFERENCES Actor (ActID);
ALTER TABLE Correspondent ADD CONSTRAINT FK_CorModID_Act FOREIGN KEY (CorModID) REFERENCES Actor (ActID);

ALTER TABLE Enterprise ADD CONSTRAINT FK_EntCtrID_Ref FOREIGN KEY (EntCtrID) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntPosID_Ref FOREIGN KEY (EntPosID) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntActID_Act FOREIGN KEY (EntActID) REFERENCES Actor (ActID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntOriID_Ref FOREIGN KEY (EntOriID) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntAtvID_Ref FOREIGN KEY (EntAtvID) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntTyeID_Ref FOREIGN KEY (EntTyeID) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntRecID_Ref FOREIGN KEY (EntRecID) REFERENCES RefValues (RefID);
ALTER TABLE MvaEntEveID ADD CONSTRAINT FK_MC_EntEveID_Ent FOREIGN KEY (MvaColID) REFERENCES Enterprise (EntID) ON DELETE CASCADE;
ALTER TABLE MvaEntEveID ADD CONSTRAINT FK_MT_EntEveID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaEntCusID ADD CONSTRAINT FK_MC_EntCusID_Ent FOREIGN KEY (MvaColID) REFERENCES Enterprise (EntID) ON DELETE CASCADE;
ALTER TABLE MvaEntCusID ADD CONSTRAINT FK_MT_EntCusID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntTzoID_Ref FOREIGN KEY (EntTzoID) REFERENCES RefValues (RefID);
ALTER TABLE MvaEntAttID ADD CONSTRAINT FK_MC_EntAttID_Ent FOREIGN KEY (MvaColID) REFERENCES Enterprise (EntID) ON DELETE CASCADE;
ALTER TABLE MvaEntAttFileName ADD CONSTRAINT FK_MC_EntAttFileName_Ent FOREIGN KEY (MvaColID) REFERENCES Enterprise (EntID) ON DELETE CASCADE;
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntPrcID_Prc FOREIGN KEY (EntPrcID) REFERENCES Pricing (PrcID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntAddressStatus_Ref FOREIGN KEY (EntAddressStatus) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntParentID_Ent FOREIGN KEY (EntParentID) REFERENCES Enterprise (EntID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntScMktPress_Ref FOREIGN KEY (EntScMktPress) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntScoringInvest_Ref FOREIGN KEY (EntScoringInvest) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntGeoCodeStatusID_Ref FOREIGN KEY (EntGeoCodeStatusID) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntOrgType_Ref FOREIGN KEY (EntOrgType) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntAddressType_Ref FOREIGN KEY (EntAddressType) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntSiteType_Ref FOREIGN KEY (EntSiteType) REFERENCES RefValues (RefID);
ALTER TABLE MvaEntPartitionID ADD CONSTRAINT FK_MC_EntPartitionID_Ent FOREIGN KEY (MvaColID) REFERENCES Enterprise (EntID) ON DELETE CASCADE;
ALTER TABLE MvaEntPartitionID ADD CONSTRAINT FK_MT_EntPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntStatus_Ref FOREIGN KEY (EntStatus) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntSolv_Ref FOREIGN KEY (EntSolv) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntMobileCreationStateID7 FOREIGN KEY (EntMobileCreationStateID) REFERENCES RefValues (RefID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntCreID_Act FOREIGN KEY (EntCreID) REFERENCES Actor (ActID);
ALTER TABLE Enterprise ADD CONSTRAINT FK_EntModID_Act FOREIGN KEY (EntModID) REFERENCES Actor (ActID);

ALTER TABLE Expense ADD CONSTRAINT FK_ExpExfID_Exf FOREIGN KEY (ExpExfID) REFERENCES ExpenseFile (ExfID) ON DELETE CASCADE;
ALTER TABLE Expense ADD CONSTRAINT FK_ExpExtID_Ref FOREIGN KEY (ExpExtID) REFERENCES RefValues (RefID);
ALTER TABLE Expense ADD CONSTRAINT FK_ExpCurID_Ref FOREIGN KEY (ExpCurID) REFERENCES RefValues (RefID);
ALTER TABLE Expense ADD CONSTRAINT FK_ExpPayID_Ref FOREIGN KEY (ExpPayID) REFERENCES RefValues (RefID);
ALTER TABLE Expense ADD CONSTRAINT FK_ExpChaID_Ref FOREIGN KEY (ExpChaID) REFERENCES RefValues (RefID);
ALTER TABLE MvaExpActID ADD CONSTRAINT FK_MC_ExpActID_Exp FOREIGN KEY (MvaColID) REFERENCES Expense (ExpID) ON DELETE CASCADE;
ALTER TABLE MvaExpActID ADD CONSTRAINT FK_MT_ExpActID_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE Expense ADD CONSTRAINT FK_ExpCreID_Act FOREIGN KEY (ExpCreID) REFERENCES Actor (ActID);
ALTER TABLE Expense ADD CONSTRAINT FK_ExpModID_Act FOREIGN KEY (ExpModID) REFERENCES Actor (ActID);

ALTER TABLE ExpenseFile ADD CONSTRAINT FK_ExfActID_Act FOREIGN KEY (ExfActID) REFERENCES Actor (ActID);
ALTER TABLE ExpenseFile ADD CONSTRAINT FK_ExfEfsID_Ref FOREIGN KEY (ExfEfsID) REFERENCES RefValues (RefID);
ALTER TABLE ExpenseFile ADD CONSTRAINT FK_ExfCreID_Act FOREIGN KEY (ExfCreID) REFERENCES Actor (ActID);
ALTER TABLE ExpenseFile ADD CONSTRAINT FK_ExfModID_Act FOREIGN KEY (ExfModID) REFERENCES Actor (ActID);

ALTER TABLE ExpenseKM ADD CONSTRAINT FK_ExkExfID_Exf FOREIGN KEY (ExkExfID) REFERENCES ExpenseFile (ExfID) ON DELETE CASCADE;
ALTER TABLE ExpenseKM ADD CONSTRAINT FK_ExkCreID_Act FOREIGN KEY (ExkCreID) REFERENCES Actor (ActID);
ALTER TABLE ExpenseKM ADD CONSTRAINT FK_ExkModID_Act FOREIGN KEY (ExkModID) REFERENCES Actor (ActID);

ALTER TABLE ExternalLink ADD CONSTRAINT FK_EliEntID_Ent FOREIGN KEY (EliEntID) REFERENCES Enterprise (EntID);
ALTER TABLE ExternalLink ADD CONSTRAINT FK_EliPerID_Per FOREIGN KEY (EliPerID) REFERENCES Person (PerID);
ALTER TABLE ExternalLink ADD CONSTRAINT FK_EliMotRec_Ref FOREIGN KEY (EliMotRec) REFERENCES RefValues (RefID);
ALTER TABLE ExternalLink ADD CONSTRAINT FK_EliCreID_Act FOREIGN KEY (EliCreID) REFERENCES Actor (ActID);
ALTER TABLE ExternalLink ADD CONSTRAINT FK_EliModID_Act FOREIGN KEY (EliModID) REFERENCES Actor (ActID);

ALTER TABLE MvaIntActID ADD CONSTRAINT FK_MC_IntActID_Int FOREIGN KEY (MvaColID) REFERENCES Interaction (IntID) ON DELETE CASCADE;
ALTER TABLE MvaIntActID ADD CONSTRAINT FK_MT_IntActID_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntOppID_Opp FOREIGN KEY (IntOppID) REFERENCES Opportunity (OppID) ON DELETE SET NULL;
ALTER TABLE MvaIntCorID ADD CONSTRAINT FK_MC_IntCorID_Int FOREIGN KEY (MvaColID) REFERENCES Interaction (IntID) ON DELETE CASCADE;
ALTER TABLE MvaIntCorID ADD CONSTRAINT FK_MT_IntCorID_Cor FOREIGN KEY (MvaText) REFERENCES Correspondent (CorID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntStiID_Ref FOREIGN KEY (IntStiID) REFERENCES RefValues (RefID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntMedID_Ref FOREIGN KEY (IntMedID) REFERENCES RefValues (RefID);
ALTER TABLE MvaIntParentOwners ADD CONSTRAINT FK_MC_IntParentOwners_Int FOREIGN KEY (MvaColID) REFERENCES Interaction (IntID) ON DELETE CASCADE;
ALTER TABLE MvaIntParentOwners ADD CONSTRAINT FK_MT_IntParentOwners_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE MvaIntAttID ADD CONSTRAINT FK_MC_IntAttID_Int FOREIGN KEY (MvaColID) REFERENCES Interaction (IntID) ON DELETE CASCADE;
ALTER TABLE MvaIntAttFileName ADD CONSTRAINT FK_MC_IntAttFileName_Int FOREIGN KEY (MvaColID) REFERENCES Interaction (IntID) ON DELETE CASCADE;
ALTER TABLE Interaction ADD CONSTRAINT FK_IntMsgID_Msg FOREIGN KEY (IntMsgID) REFERENCES Messages (MsgID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntAtvID_Ref FOREIGN KEY (IntAtvID) REFERENCES RefValues (RefID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntCatID_Ref FOREIGN KEY (IntCatID) REFERENCES RefValues (RefID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntOpeID_Ref FOREIGN KEY (IntOpeID) REFERENCES RefValues (RefID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntCpgID_Cpg FOREIGN KEY (IntCpgID) REFERENCES Campaign (CpgID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntStgID_Stg FOREIGN KEY (IntStgID) REFERENCES Stage (StgID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntEmetteur_Act FOREIGN KEY (IntEmetteur) REFERENCES Actor (ActID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntSimID_Sim FOREIGN KEY (IntSimID) REFERENCES Simulation (SimID) ON DELETE SET NULL;
ALTER TABLE MvaIntRefusedActID ADD CONSTRAINT FK_MC_IntRefusedActID_Int FOREIGN KEY (MvaColID) REFERENCES Interaction (IntID) ON DELETE CASCADE;
ALTER TABLE MvaIntRefusedActID ADD CONSTRAINT FK_MT_IntRefusedActID_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE MvaIntPartitionID ADD CONSTRAINT FK_MC_IntPartitionID_Int FOREIGN KEY (MvaColID) REFERENCES Interaction (IntID) ON DELETE CASCADE;
ALTER TABLE MvaIntPartitionID ADD CONSTRAINT FK_MT_IntPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntGeoCodeStatusID_Ref FOREIGN KEY (IntGeoCodeStatusID) REFERENCES RefValues (RefID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntEveID_Evt FOREIGN KEY (IntEveID) REFERENCES Event (EvtID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntPvtID_Pvt FOREIGN KEY (IntPvtID) REFERENCES PersonEvent (PvtID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntRefMsgID_Msg FOREIGN KEY (IntRefMsgID) REFERENCES Messages (MsgID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntResult_Ref FOREIGN KEY (IntResult) REFERENCES RefValues (RefID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntDestEntID_Ent FOREIGN KEY (IntDestEntID) REFERENCES Enterprise (EntID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntDestPerID_Per FOREIGN KEY (IntDestPerID) REFERENCES Person (PerID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntProcessInstanceID_Pri FOREIGN KEY (IntProcessInstanceID) REFERENCES ProcessInstance (PriID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntParentID_Int FOREIGN KEY (IntParentID) REFERENCES Interaction (IntID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntRefDocID_Doc FOREIGN KEY (IntRefDocID) REFERENCES Document (DocID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntPtaID_Pta FOREIGN KEY (IntPtaID) REFERENCES ProcessTask (PtaID) ON DELETE SET NULL;
ALTER TABLE Interaction ADD CONSTRAINT FK_IntCreID_Act FOREIGN KEY (IntCreID) REFERENCES Actor (ActID);
ALTER TABLE Interaction ADD CONSTRAINT FK_IntModID_Act FOREIGN KEY (IntModID) REFERENCES Actor (ActID);

ALTER TABLE Link ADD CONSTRAINT FK_LinTypeA_Ref FOREIGN KEY (LinTypeA) REFERENCES RefValues (RefID);
ALTER TABLE Link ADD CONSTRAINT FK_LinTypeB_Ref FOREIGN KEY (LinTypeB) REFERENCES RefValues (RefID);
ALTER TABLE Link ADD CONSTRAINT FK_LinCreID_Act FOREIGN KEY (LinCreID) REFERENCES Actor (ActID);
ALTER TABLE Link ADD CONSTRAINT FK_LinModID_Act FOREIGN KEY (LinModID) REFERENCES Actor (ActID);

ALTER TABLE Location ADD CONSTRAINT FK_LocEntID_Ent FOREIGN KEY (LocEntID) REFERENCES Enterprise (EntID) ON DELETE CASCADE;
ALTER TABLE Location ADD CONSTRAINT FK_LocCtrID_Ref FOREIGN KEY (LocCtrID) REFERENCES RefValues (RefID);
ALTER TABLE MvaLocParentOwners ADD CONSTRAINT FK_MC_LocParentOwners_Loc FOREIGN KEY (MvaColID) REFERENCES Location (LocID) ON DELETE CASCADE;
ALTER TABLE MvaLocParentOwners ADD CONSTRAINT FK_MT_LocParentOwners_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE MvaLocAttID ADD CONSTRAINT FK_MC_LocAttID_Loc FOREIGN KEY (MvaColID) REFERENCES Location (LocID) ON DELETE CASCADE;
ALTER TABLE MvaLocAttFileName ADD CONSTRAINT FK_MC_LocAttFileName_Loc FOREIGN KEY (MvaColID) REFERENCES Location (LocID) ON DELETE CASCADE;
ALTER TABLE Location ADD CONSTRAINT FK_LocAddressType_Ref FOREIGN KEY (LocAddressType) REFERENCES RefValues (RefID);
ALTER TABLE Location ADD CONSTRAINT FK_LocSiteType_Ref FOREIGN KEY (LocSiteType) REFERENCES RefValues (RefID);
ALTER TABLE Location ADD CONSTRAINT FK_LocGeoCodeStatusID_Ref FOREIGN KEY (LocGeoCodeStatusID) REFERENCES RefValues (RefID);
ALTER TABLE Location ADD CONSTRAINT FK_LocCreID_Act FOREIGN KEY (LocCreID) REFERENCES Actor (ActID);
ALTER TABLE Location ADD CONSTRAINT FK_LocModID_Act FOREIGN KEY (LocModID) REFERENCES Actor (ActID);

ALTER TABLE Opportunity ADD CONSTRAINT FK_OppActID_Act FOREIGN KEY (OppActID) REFERENCES Actor (ActID);
ALTER TABLE Opportunity ADD CONSTRAINT FK_OppEntID_Ent FOREIGN KEY (OppEntID) REFERENCES Enterprise (EntID);
ALTER TABLE Opportunity ADD CONSTRAINT FK_OppPerID_Per FOREIGN KEY (OppPerID) REFERENCES Person (PerID);
ALTER TABLE Opportunity ADD CONSTRAINT FK_OppStoID_Ref FOREIGN KEY (OppStoID) REFERENCES RefValues (RefID);
ALTER TABLE Opportunity ADD CONSTRAINT FK_OppOpbID_Ref FOREIGN KEY (OppOpbID) REFERENCES RefValues (RefID);
ALTER TABLE MvaOppCptID ADD CONSTRAINT FK_MC_OppCptID_Opp FOREIGN KEY (MvaColID) REFERENCES Opportunity (OppID) ON DELETE CASCADE;
ALTER TABLE MvaOppCptID ADD CONSTRAINT FK_MT_OppCptID_Cpt FOREIGN KEY (MvaText) REFERENCES Competitor (CptID) ON DELETE CASCADE;
ALTER TABLE MvaOppParentOwners ADD CONSTRAINT FK_MC_OppParentOwners_Opp FOREIGN KEY (MvaColID) REFERENCES Opportunity (OppID) ON DELETE CASCADE;
ALTER TABLE MvaOppParentOwners ADD CONSTRAINT FK_MT_OppParentOwners_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE MvaOppAttID ADD CONSTRAINT FK_MC_OppAttID_Opp FOREIGN KEY (MvaColID) REFERENCES Opportunity (OppID) ON DELETE CASCADE;
ALTER TABLE MvaOppAttFileName ADD CONSTRAINT FK_MC_OppAttFileName_Opp FOREIGN KEY (MvaColID) REFERENCES Opportunity (OppID) ON DELETE CASCADE;
ALTER TABLE Opportunity ADD CONSTRAINT FK_OppStuID_Ref FOREIGN KEY (OppStuID) REFERENCES RefValues (RefID);
ALTER TABLE Opportunity ADD CONSTRAINT FK_OppBizProviderID_Ent FOREIGN KEY (OppBizProviderID) REFERENCES Enterprise (EntID);
ALTER TABLE MvaOppPartitionID ADD CONSTRAINT FK_MC_OppPartitionID_Opp FOREIGN KEY (MvaColID) REFERENCES Opportunity (OppID) ON DELETE CASCADE;
ALTER TABLE MvaOppPartitionID ADD CONSTRAINT FK_MT_OppPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Opportunity ADD CONSTRAINT FK_OppCreID_Act FOREIGN KEY (OppCreID) REFERENCES Actor (ActID);
ALTER TABLE Opportunity ADD CONSTRAINT FK_OppModID_Act FOREIGN KEY (OppModID) REFERENCES Actor (ActID);

ALTER TABLE Person ADD CONSTRAINT FK_PerCivID_Ref FOREIGN KEY (PerCivID) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerEntID_Ent FOREIGN KEY (PerEntID) REFERENCES Enterprise (EntID);
ALTER TABLE Person ADD CONSTRAINT FK_PerDepID_Ref FOREIGN KEY (PerDepID) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerFctID_Ref FOREIGN KEY (PerFctID) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerRleID_Ref FOREIGN KEY (PerRleID) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerLocID_Loc FOREIGN KEY (PerLocID) REFERENCES Location (LocID);
ALTER TABLE MvaPerLngID ADD CONSTRAINT FK_MC_PerLngID_Per FOREIGN KEY (MvaColID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE MvaPerLngID ADD CONSTRAINT FK_MT_PerLngID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerCtyID_Ref FOREIGN KEY (PerCtyID) REFERENCES RefValues (RefID);
ALTER TABLE MvaPerPevID ADD CONSTRAINT FK_MC_PerPevID_Per FOREIGN KEY (MvaColID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE MvaPerPevID ADD CONSTRAINT FK_MT_PerPevID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerImpID_Ref FOREIGN KEY (PerImpID) REFERENCES RefValues (RefID);
ALTER TABLE MvaPerNltID ADD CONSTRAINT FK_MC_PerNltID_Per FOREIGN KEY (MvaColID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE MvaPerNltID ADD CONSTRAINT FK_MT_PerNltID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaPerQueID ADD CONSTRAINT FK_MC_PerQueID_Per FOREIGN KEY (MvaColID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE MvaPerQueID ADD CONSTRAINT FK_MT_PerQueID_Que FOREIGN KEY (MvaText) REFERENCES Questions (QueID) ON DELETE CASCADE;
ALTER TABLE Person ADD CONSTRAINT FK_PerPoeID_Ref FOREIGN KEY (PerPoeID) REFERENCES RefValues (RefID);
ALTER TABLE MvaPerAttID ADD CONSTRAINT FK_MC_PerAttID_Per FOREIGN KEY (MvaColID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE MvaPerAttFileName ADD CONSTRAINT FK_MC_PerAttFileName_Per FOREIGN KEY (MvaColID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE MvaPerParentOwners ADD CONSTRAINT FK_MC_PerParentOwners_Per FOREIGN KEY (MvaColID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE MvaPerParentOwners ADD CONSTRAINT FK_MT_PerParentOwners_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE Person ADD CONSTRAINT FK_PerCounselor_Act FOREIGN KEY (PerCounselor) REFERENCES Actor (ActID);
ALTER TABLE Person ADD CONSTRAINT FK_PerCtrID_Ref FOREIGN KEY (PerCtrID) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerScoringY_Ref FOREIGN KEY (PerScoringY) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerLngPrinc_Ref FOREIGN KEY (PerLngPrinc) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerScoringX_Ref FOREIGN KEY (PerScoringX) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerTzoID_Ref FOREIGN KEY (PerTzoID) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerAddressStatus_Ref FOREIGN KEY (PerAddressStatus) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerFctTyp_Ref FOREIGN KEY (PerFctTyp) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerFctParentID_Per FOREIGN KEY (PerFctParentID) REFERENCES Person (PerID) ON DELETE SET NULL;
ALTER TABLE Person ADD CONSTRAINT FK_PerFctAddressType_Ref FOREIGN KEY (PerFctAddressType) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerFctSiteType_Ref FOREIGN KEY (PerFctSiteType) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerGeoCodeStatusID_Ref FOREIGN KEY (PerGeoCodeStatusID) REFERENCES RefValues (RefID);
ALTER TABLE MvaPerPartitionID ADD CONSTRAINT FK_MC_PerPartitionID_Per FOREIGN KEY (MvaColID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE MvaPerPartitionID ADD CONSTRAINT FK_MT_PerPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Person ADD CONSTRAINT FK_PerMobileCreationStateID8 FOREIGN KEY (PerMobileCreationStateID) REFERENCES RefValues (RefID);
ALTER TABLE Person ADD CONSTRAINT FK_PerCreID_Act FOREIGN KEY (PerCreID) REFERENCES Actor (ActID);
ALTER TABLE Person ADD CONSTRAINT FK_PerModID_Act FOREIGN KEY (PerModID) REFERENCES Actor (ActID);

ALTER TABLE PersonHistory ADD CONSTRAINT FK_PehPerID_Per FOREIGN KEY (PehPerID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE PersonHistory ADD CONSTRAINT FK_PehEntID_Ent FOREIGN KEY (PehEntID) REFERENCES Enterprise (EntID) ON DELETE CASCADE;
ALTER TABLE PersonHistory ADD CONSTRAINT FK_PehCreID_Act FOREIGN KEY (PehCreID) REFERENCES Actor (ActID);
ALTER TABLE PersonHistory ADD CONSTRAINT FK_PehModID_Act FOREIGN KEY (PehModID) REFERENCES Actor (ActID);

ALTER TABLE ProductOpportunity ADD CONSTRAINT FK_ProOppID_Opp FOREIGN KEY (ProOppID) REFERENCES Opportunity (OppID) ON DELETE CASCADE;
ALTER TABLE ProductOpportunity ADD CONSTRAINT FK_ProPrdID_Prd FOREIGN KEY (ProPrdID) REFERENCES Product (PrdID);
ALTER TABLE MvaProPartitionID ADD CONSTRAINT FK_MC_ProPartitionID_Pro FOREIGN KEY (MvaColID) REFERENCES ProductOpportunity (ProID) ON DELETE CASCADE;
ALTER TABLE MvaProPartitionID ADD CONSTRAINT FK_MT_ProPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE ProductOpportunity ADD CONSTRAINT FK_ProCreID_Act FOREIGN KEY (ProCreID) REFERENCES Actor (ActID);
ALTER TABLE ProductOpportunity ADD CONSTRAINT FK_ProModID_Act FOREIGN KEY (ProModID) REFERENCES Actor (ActID);

ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinActID_Act FOREIGN KEY (SinActID) REFERENCES Actor (ActID) ON DELETE CASCADE;
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinIntID_Int FOREIGN KEY (SinIntID) REFERENCES Interaction (IntID) ON DELETE CASCADE;
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinPopID_Pop FOREIGN KEY (SinPopID) REFERENCES Population (PopID) ON DELETE CASCADE;
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinEventID_Evt FOREIGN KEY (SinEventID) REFERENCES Event (EvtID) ON DELETE CASCADE;
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinOppID_Opp FOREIGN KEY (SinOppID) REFERENCES Opportunity (OppID) ON DELETE CASCADE;
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinPersID_Per FOREIGN KEY (SinPersID) REFERENCES Person (PerID) ON DELETE CASCADE;
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinEntID_Ent FOREIGN KEY (SinEntID) REFERENCES Enterprise (EntID) ON DELETE CASCADE;
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinJourID_Jou FOREIGN KEY (SinJourID) REFERENCES Journalist (JouID) ON DELETE CASCADE;
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinSuppID_Sup FOREIGN KEY (SinSuppID) REFERENCES Support (SupID) ON DELETE CASCADE;
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinPersEventID_Pvt FOREIGN KEY (SinPersEventID) REFERENCES PersonEvent (PvtID) ON DELETE SET NULL;
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinCreID_Act FOREIGN KEY (SinCreID) REFERENCES Actor (ActID);
ALTER TABLE SalesInvest ADD CONSTRAINT FK_SinModID_Act FOREIGN KEY (SinModID) REFERENCES Actor (ActID);

ALTER TABLE Simulation ADD CONSTRAINT FK_SimCreator_Act FOREIGN KEY (SimCreator) REFERENCES Actor (ActID);
ALTER TABLE Simulation ADD CONSTRAINT FK_SimPopulation_Pop FOREIGN KEY (SimPopulation) REFERENCES Population (PopID);
ALTER TABLE Simulation ADD CONSTRAINT FK_SimIntAtvID_Ref FOREIGN KEY (SimIntAtvID) REFERENCES RefValues (RefID);
ALTER TABLE Simulation ADD CONSTRAINT FK_SimIntStiID_Ref FOREIGN KEY (SimIntStiID) REFERENCES RefValues (RefID);
ALTER TABLE Simulation ADD CONSTRAINT FK_SimIntCpgID_Cpg FOREIGN KEY (SimIntCpgID) REFERENCES Campaign (CpgID);
ALTER TABLE Simulation ADD CONSTRAINT FK_SimIntStgID_Stg FOREIGN KEY (SimIntStgID) REFERENCES Stage (StgID);
ALTER TABLE MvaSimActors ADD CONSTRAINT FK_MC_SimActors_Sim FOREIGN KEY (MvaColID) REFERENCES Simulation (SimID) ON DELETE CASCADE;
ALTER TABLE MvaSimActors ADD CONSTRAINT FK_MT_SimActors_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE MvaSimRoles ADD CONSTRAINT FK_MC_SimRoles_Sim FOREIGN KEY (MvaColID) REFERENCES Simulation (SimID) ON DELETE CASCADE;
ALTER TABLE MvaSimRoles ADD CONSTRAINT FK_MT_SimRoles_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE Simulation ADD CONSTRAINT FK_SimPredefined_Ref FOREIGN KEY (SimPredefined) REFERENCES RefValues (RefID);
ALTER TABLE Simulation ADD CONSTRAINT FK_SimCreID_Act FOREIGN KEY (SimCreID) REFERENCES Actor (ActID);
ALTER TABLE Simulation ADD CONSTRAINT FK_SimModID_Act FOREIGN KEY (SimModID) REFERENCES Actor (ActID);

ALTER TABLE CusSatisfaction ADD CONSTRAINT FK_CsaPerID_Per FOREIGN KEY (CsaPerID) REFERENCES Person (PerID);
ALTER TABLE CusSatisfaction ADD CONSTRAINT FK_CsaEntID_Ent FOREIGN KEY (CsaEntID) REFERENCES Enterprise (EntID) ON DELETE SET NULL;
ALTER TABLE CusSatisfaction ADD CONSTRAINT FK_CsaSolID_Sol FOREIGN KEY (CsaSolID) REFERENCES Solicitation (SolID) ON DELETE SET NULL;
ALTER TABLE CusSatisfaction ADD CONSTRAINT FK_CsaQuestion_Ref FOREIGN KEY (CsaQuestion) REFERENCES RefValues (RefID);
ALTER TABLE CusSatisfaction ADD CONSTRAINT FK_CsaCreID_Act FOREIGN KEY (CsaCreID) REFERENCES Actor (ActID);
ALTER TABLE CusSatisfaction ADD CONSTRAINT FK_CsaModID_Act FOREIGN KEY (CsaModID) REFERENCES Actor (ActID);

ALTER TABLE SAction ADD CONSTRAINT FK_SacSolID_Sol FOREIGN KEY (SacSolID) REFERENCES Solicitation (SolID) ON DELETE CASCADE;
ALTER TABLE MvaSacActID ADD CONSTRAINT FK_MC_SacActID_Sac FOREIGN KEY (MvaColID) REFERENCES SAction (SacID) ON DELETE CASCADE;
ALTER TABLE MvaSacActID ADD CONSTRAINT FK_MT_SacActID_Act FOREIGN KEY (MvaText) REFERENCES Actor (ActID);
ALTER TABLE SAction ADD CONSTRAINT FK_SacTypID_Ref FOREIGN KEY (SacTypID) REFERENCES RefValues (RefID);
ALTER TABLE SAction ADD CONSTRAINT FK_SacAdvID_Ref FOREIGN KEY (SacAdvID) REFERENCES RefValues (RefID);
ALTER TABLE SAction ADD CONSTRAINT FK_SacPerID_Per FOREIGN KEY (SacPerID) REFERENCES Person (PerID);
ALTER TABLE MvaSacAttID ADD CONSTRAINT FK_MC_SacAttID_Sac FOREIGN KEY (MvaColID) REFERENCES SAction (SacID) ON DELETE CASCADE;
ALTER TABLE SAction ADD CONSTRAINT FK_SacCreID_Act FOREIGN KEY (SacCreID) REFERENCES Actor (ActID);
ALTER TABLE SAction ADD CONSTRAINT FK_SacModID_Act FOREIGN KEY (SacModID) REFERENCES Actor (ActID);

ALTER TABLE Solicitation ADD CONSTRAINT FK_SolCatID_Ref FOREIGN KEY (SolCatID) REFERENCES RefValues (RefID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolSubCatID_Ref FOREIGN KEY (SolSubCatID) REFERENCES RefValues (RefID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolPerID_Per FOREIGN KEY (SolPerID) REFERENCES Person (PerID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolSilID_Sil FOREIGN KEY (SolSilID) REFERENCES Silhouette (SilID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolActID_Act FOREIGN KEY (SolActID) REFERENCES Actor (ActID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolPtyID_Ref FOREIGN KEY (SolPtyID) REFERENCES RefValues (RefID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolClsID_Act FOREIGN KEY (SolClsID) REFERENCES Actor (ActID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolStsID_Ref FOREIGN KEY (SolStsID) REFERENCES RefValues (RefID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolNtfID_Ref FOREIGN KEY (SolNtfID) REFERENCES RefValues (RefID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolChnID_Ref FOREIGN KEY (SolChnID) REFERENCES RefValues (RefID);
ALTER TABLE MvaSolDomID ADD CONSTRAINT FK_MC_SolDomID_Sol FOREIGN KEY (MvaColID) REFERENCES Solicitation (SolID) ON DELETE CASCADE;
ALTER TABLE MvaSolDomID ADD CONSTRAINT FK_MT_SolDomID_Ref FOREIGN KEY (MvaText) REFERENCES RefValues (RefID);
ALTER TABLE MvaSolAttID ADD CONSTRAINT FK_MC_SolAttID_Sol FOREIGN KEY (MvaColID) REFERENCES Solicitation (SolID) ON DELETE CASCADE;
ALTER TABLE MvaSolAttFileName ADD CONSTRAINT FK_MC_SolAttFileName_Sol FOREIGN KEY (MvaColID) REFERENCES Solicitation (SolID) ON DELETE CASCADE;
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolFstActID_Act FOREIGN KEY (SolFstActID) REFERENCES Actor (ActID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolMsgID_Msg FOREIGN KEY (SolMsgID) REFERENCES Messages (MsgID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolSlaID_Sla FOREIGN KEY (SolSlaID) REFERENCES SLA (SlaID) ON DELETE SET NULL;
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolSllID_Sll FOREIGN KEY (SolSllID) REFERENCES SLAAlarm (SllID) ON DELETE SET NULL;
ALTER TABLE MvaSolPartitionID ADD CONSTRAINT FK_MC_SolPartitionID_Sol FOREIGN KEY (MvaColID) REFERENCES Solicitation (SolID) ON DELETE CASCADE;
ALTER TABLE MvaSolPartitionID ADD CONSTRAINT FK_MT_SolPartitionID_Prt FOREIGN KEY (MvaText) REFERENCES Partition (PrtID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolEntID_Ent FOREIGN KEY (SolEntID) REFERENCES Enterprise (EntID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolCustomer_Ent FOREIGN KEY (SolCustomer) REFERENCES Enterprise (EntID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolResolutionType_Ref FOREIGN KEY (SolResolutionType) REFERENCES RefValues (RefID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolLastQuestion_Sac FOREIGN KEY (SolLastQuestion) REFERENCES SAction (SacID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolCreID_Act FOREIGN KEY (SolCreID) REFERENCES Actor (ActID);
ALTER TABLE Solicitation ADD CONSTRAINT FK_SolModID_Act FOREIGN KEY (SolModID) REFERENCES Actor (ActID);

ALTER TABLE WallPost ADD CONSTRAINT FK_WptActID_Act FOREIGN KEY (WptActID) REFERENCES Actor (ActID);
ALTER TABLE WallPost ADD CONSTRAINT FK_WptCreID_Act FOREIGN KEY (WptCreID) REFERENCES Actor (ActID);
ALTER TABLE WallPost ADD CONSTRAINT FK_WptModID_Act FOREIGN KEY (WptModID) REFERENCES Actor (ActID);

ALTER TABLE WallPostObject ADD CONSTRAINT FK_WpoPostID_Wpt FOREIGN KEY (WpoPostID) REFERENCES WallPost (WptID) ON DELETE CASCADE;
ALTER TABLE WallPostObject ADD CONSTRAINT FK_WpoCreID_Act FOREIGN KEY (WpoCreID) REFERENCES Actor (ActID);
ALTER TABLE WallPostObject ADD CONSTRAINT FK_WpoModID_Act FOREIGN KEY (WpoModID) REFERENCES Actor (ActID);

ALTER TABLE WallTarget ADD CONSTRAINT FK_WtaActID_Act FOREIGN KEY (WtaActID) REFERENCES Actor (ActID);
ALTER TABLE WallTarget ADD CONSTRAINT FK_WtaCreID_Act FOREIGN KEY (WtaCreID) REFERENCES Actor (ActID);
ALTER TABLE WallTarget ADD CONSTRAINT FK_WtaModID_Act FOREIGN KEY (WtaModID) REFERENCES Actor (ActID);