--
-- The workflow attributes that should be set when
-- the given transition is fired.
--
CREATE TABLE wf_transition_attribute_map (
workflow_key varchar(100) NOT NULL,
transition_key varchar(100) NOT NULL,
sort_order integer NOT NULL,
attribute_id integer NOT NULL,
PRIMARY KEY (workflow_key,transition_key,attribute_id),
CONSTRAINT wf_trans_attr_map_attribute_fk REFERENCES acs_attributes (),
CONSTRAINT wf_trans_attr_map_pk REFERENCES acs_attributes (),
CONSTRAINT wf_trans_attr_map_trans_fk REFERENCES acs_attributes (),
CONSTRAINT wf_trans_attr_map_workflow_fk REFERENCES acs_attributes () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT wf_trans_attr_map_workflow_fk REFERENCES wf_transitions (),
CONSTRAINT wf_trans_attr_map_trans_fk REFERENCES wf_transitions (),
CONSTRAINT wf_trans_attr_map_pk REFERENCES wf_transitions (),
CONSTRAINT wf_trans_attr_map_attribute_fk REFERENCES wf_transitions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT wf_trans_attr_map_workflow_fk REFERENCES wf_workflows (),
CONSTRAINT wf_trans_attr_map_attribute_fk REFERENCES wf_workflows (),
CONSTRAINT wf_trans_attr_map_pk REFERENCES wf_workflows (),
CONSTRAINT wf_trans_attr_map_trans_fk REFERENCES wf_workflows ()
);
CREATE TRIGGER RI_ConstraintTrigger_c_343579 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343580 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343584 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343585 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343589 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343590 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 8,192 bytes
-- Table rows: 1
Tables: