CREATE TABLE workflows ( workflow_id integer PRIMARY KEY NOT NULL, short_name varchar(100) NOT NULL, pretty_name varchar(200) NOT NULL, object_id integer, package_key varchar(100) NOT NULL, object_type varchar(1000) NOT NULL, description text(-5), description_mime_type varchar(200), CONSTRAINT wfs_object_id_fk REFERENCES apm_package_types (), CONSTRAINT wfs_object_type_fk REFERENCES apm_package_types (), CONSTRAINT wfs_oid_sn_un REFERENCES apm_package_types (), CONSTRAINT wfs_workflow_id_fk REFERENCES apm_package_types (), CONSTRAINT wfs_apm_package_types_fk REFERENCES apm_package_types (), CONSTRAINT wfs_pk REFERENCES apm_package_types () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wfs_oid_sn_un REFERENCES acs_objects (), CONSTRAINT wfs_apm_package_types_fk REFERENCES acs_objects (), CONSTRAINT wfs_object_id_fk REFERENCES acs_objects (), CONSTRAINT wfs_object_type_fk REFERENCES acs_objects (), CONSTRAINT wfs_pk REFERENCES acs_objects (), CONSTRAINT wfs_workflow_id_fk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wfs_workflow_id_fk REFERENCES acs_objects (), CONSTRAINT wfs_pk REFERENCES acs_objects (), CONSTRAINT wfs_oid_sn_un REFERENCES acs_objects (), CONSTRAINT wfs_object_type_fk REFERENCES acs_objects (), CONSTRAINT wfs_object_id_fk REFERENCES acs_objects (), CONSTRAINT wfs_apm_package_types_fk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wfs_workflow_id_fk REFERENCES acs_object_types (), CONSTRAINT wfs_apm_package_types_fk REFERENCES acs_object_types (), CONSTRAINT wfs_object_id_fk REFERENCES acs_object_types (), CONSTRAINT wfs_object_type_fk REFERENCES acs_object_types (), CONSTRAINT wfs_oid_sn_un REFERENCES acs_object_types (), CONSTRAINT wfs_pk REFERENCES acs_object_types () ); CREATE UNIQUE INDEX wfs_oid_sn_un ON workflows (package_key, object_id, short_name); CREATE TRIGGER RI_ConstraintTrigger_a_340992 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340993 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343162 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343163 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343322 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343323 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343332 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343333 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343442 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343443 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343497 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343498 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343614 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343615 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343619 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343620 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343629 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343630 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610651 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610652 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to workflows: --bt_projects(wfs_apm_package_types_fk) --bt_projects(wfs_object_id_fk) --bt_projects(wfs_object_type_fk) --bt_projects(wfs_oid_sn_un) --bt_projects(wfs_pk) --bt_projects(wfs_workflow_id_fk) --workflow_actions(wfs_apm_package_types_fk) --workflow_actions(wfs_object_id_fk) --workflow_actions(wfs_object_type_fk) --workflow_actions(wfs_oid_sn_un) --workflow_actions(wfs_pk) --workflow_actions(wfs_workflow_id_fk) --workflow_callbacks(wfs_apm_package_types_fk) --workflow_callbacks(wfs_object_id_fk) --workflow_callbacks(wfs_object_type_fk) --workflow_callbacks(wfs_oid_sn_un) --workflow_callbacks(wfs_pk) --workflow_callbacks(wfs_workflow_id_fk) --workflow_cases(wfs_apm_package_types_fk) --workflow_cases(wfs_object_id_fk) --workflow_cases(wfs_object_type_fk) --workflow_cases(wfs_oid_sn_un) --workflow_cases(wfs_pk) --workflow_cases(wfs_workflow_id_fk) --workflow_fsm_states(wfs_apm_package_types_fk) --workflow_fsm_states(wfs_object_id_fk) --workflow_fsm_states(wfs_object_type_fk) --workflow_fsm_states(wfs_oid_sn_un) --workflow_fsm_states(wfs_pk) --workflow_fsm_states(wfs_workflow_id_fk) --workflow_roles(wfs_apm_package_types_fk) --workflow_roles(wfs_object_id_fk) --workflow_roles(wfs_object_type_fk) --workflow_roles(wfs_oid_sn_un) --workflow_roles(wfs_pk) --workflow_roles(wfs_workflow_id_fk) -- Table size: 8,192 bytes -- Table rows: 4
Begin main content
