CREATE TABLE wf_task_assignments (
task_id integer NOT NULL,
party_id integer NOT NULL,
PRIMARY KEY (task_id,party_id),
ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT wf_task_assign_task_fk REFERENCES wf_tasks (),
CONSTRAINT wf_task_assignments_pk REFERENCES wf_tasks (),
CONSTRAINT wf_task_party_fk REFERENCES wf_tasks () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT wf_task_party_fk REFERENCES parties (),
CONSTRAINT wf_task_assign_task_fk REFERENCES parties (),
CONSTRAINT wf_task_assignments_pk REFERENCES parties ()
);
CREATE INDEX wf_task_asgn_party_id_idx ON wf_task_assignments (party_id);
CREATE TRIGGER RI_ConstraintTrigger_c_343504 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343505 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343519 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343520 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 0 bytes
-- Table rows: 0
Tables: