-- -- The circles of the petri net. These hold the tokens representing the overall -- state of the workflow. -- CREATE TABLE wf_places ( place_key varchar(100) NOT NULL, workflow_key varchar(100) NOT NULL, place_name varchar(100) NOT NULL, sort_order integer, PRIMARY KEY (place_key,workflow_key), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_place_order_ck REFERENCES wf_workflows (), CONSTRAINT wf_place_workflow_fk REFERENCES wf_workflows (), CONSTRAINT wf_place_pk REFERENCES wf_workflows () ); CREATE UNIQUE INDEX wf_places_wf_key_place_name_un ON wf_places (workflow_key, place_name); CREATE TRIGGER RI_ConstraintTrigger_a_343167 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343168 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343449 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343450 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343547 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343548 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to wf_places: --wf_arcs(wf_place_order_ck) --wf_arcs(wf_place_pk) --wf_arcs(wf_place_workflow_fk) --wf_tokens(wf_place_order_ck) --wf_tokens(wf_place_pk) --wf_tokens(wf_place_workflow_fk) -- Table size: 8,192 bytes -- Table rows: 5
Begin main content
