CREATE TABLE bt_projects ( project_id integer PRIMARY KEY NOT NULL, description text(-5), email_subject_name text(-5), maintainer integer, folder_id integer, root_keyword_id integer, component_keyword_id integer, workflow_id integer, CONSTRAINT bt_projects_apm_packages_fk REFERENCES cr_keywords (), CONSTRAINT bt_component_keyword_fk REFERENCES cr_keywords (), CONSTRAINT bt_projects_folder_fk REFERENCES cr_keywords (), CONSTRAINT bt_projects_keyword_fk REFERENCES cr_keywords (), CONSTRAINT bt_projects_maintainer_fk REFERENCES cr_keywords (), CONSTRAINT bt_projects_pk REFERENCES cr_keywords (), CONSTRAINT bt_projects_workflow_id_fk REFERENCES cr_keywords () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT bt_component_keyword_fk REFERENCES apm_packages (), CONSTRAINT bt_projects_apm_packages_fk REFERENCES apm_packages (), CONSTRAINT bt_projects_folder_fk REFERENCES apm_packages (), CONSTRAINT bt_projects_keyword_fk REFERENCES apm_packages (), CONSTRAINT bt_projects_maintainer_fk REFERENCES apm_packages (), CONSTRAINT bt_projects_pk REFERENCES apm_packages (), CONSTRAINT bt_projects_workflow_id_fk REFERENCES apm_packages (), CONSTRAINT bt_projects_apm_packages_fk REFERENCES cr_folders (), CONSTRAINT bt_component_keyword_fk REFERENCES cr_folders (), CONSTRAINT bt_projects_folder_fk REFERENCES cr_folders (), CONSTRAINT bt_projects_keyword_fk REFERENCES cr_folders (), CONSTRAINT bt_projects_maintainer_fk REFERENCES cr_folders (), CONSTRAINT bt_projects_pk REFERENCES cr_folders (), CONSTRAINT bt_projects_workflow_id_fk REFERENCES cr_folders (), CONSTRAINT bt_projects_keyword_fk REFERENCES cr_keywords (), CONSTRAINT bt_projects_workflow_id_fk REFERENCES cr_keywords (), CONSTRAINT bt_projects_pk REFERENCES cr_keywords (), CONSTRAINT bt_projects_maintainer_fk REFERENCES cr_keywords (), CONSTRAINT bt_projects_folder_fk REFERENCES cr_keywords (), CONSTRAINT bt_projects_apm_packages_fk REFERENCES cr_keywords (), CONSTRAINT bt_component_keyword_fk REFERENCES cr_keywords (), CONSTRAINT bt_projects_workflow_id_fk REFERENCES users (), CONSTRAINT bt_projects_pk REFERENCES users (), CONSTRAINT bt_projects_maintainer_fk REFERENCES users (), CONSTRAINT bt_projects_keyword_fk REFERENCES users (), CONSTRAINT bt_projects_folder_fk REFERENCES users (), CONSTRAINT bt_projects_apm_packages_fk REFERENCES users (), CONSTRAINT bt_component_keyword_fk REFERENCES users () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT bt_projects_workflow_id_fk REFERENCES workflows (), CONSTRAINT bt_projects_pk REFERENCES workflows (), CONSTRAINT bt_projects_maintainer_fk REFERENCES workflows (), CONSTRAINT bt_projects_keyword_fk REFERENCES workflows (), CONSTRAINT bt_projects_folder_fk REFERENCES workflows (), CONSTRAINT bt_projects_apm_packages_fk REFERENCES workflows (), CONSTRAINT bt_component_keyword_fk REFERENCES workflows () ); CREATE TRIGGER RI_ConstraintTrigger_c_340899 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340900 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340922 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340923 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340974 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340975 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340979 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340980 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340984 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340985 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340989 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340990 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340994 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340995 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to bt_projects: --bt_default_keywords(bt_component_keyword_fk) --bt_default_keywords(bt_projects_apm_packages_fk) --bt_default_keywords(bt_projects_folder_fk) --bt_default_keywords(bt_projects_keyword_fk) --bt_default_keywords(bt_projects_maintainer_fk) --bt_default_keywords(bt_projects_pk) --bt_default_keywords(bt_projects_workflow_id_fk) -- Table size: 8,192 bytes -- Table rows: 3
Begin main content
