-- -- Holds context-dependent information about the workflow, specifically the -- principal user. -- CREATE TABLE wf_context_workflow_info ( context_key varchar(100) NOT NULL, workflow_key varchar(100) NOT NULL, principal_party integer, PRIMARY KEY (context_key,workflow_key), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_context_wf_context_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_wf_principal_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_wf_workflow_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_workflow_pk REFERENCES wf_contexts () ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL, CONSTRAINT wf_context_workflow_pk REFERENCES parties (), CONSTRAINT wf_context_wf_workflow_fk REFERENCES parties (), CONSTRAINT wf_context_wf_principal_fk REFERENCES parties (), CONSTRAINT wf_context_wf_context_fk REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_context_workflow_pk REFERENCES wf_workflows (), CONSTRAINT wf_context_wf_context_fk REFERENCES wf_workflows (), CONSTRAINT wf_context_wf_principal_fk REFERENCES wf_workflows (), CONSTRAINT wf_context_wf_workflow_fk REFERENCES wf_workflows () ); CREATE TRIGGER RI_ConstraintTrigger_c_343404 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343405 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343409 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343410 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343414 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343415 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
