CREATE TABLE groups ( group_id integer PRIMARY KEY NOT NULL, group_name varchar(100) NOT NULL, join_policy varchar(30) DEFAULT 'open'::character varying NOT NULL, description varchar(4000), CONSTRAINT groups_group_id_fk REFERENCES parties (), CONSTRAINT groups_pk REFERENCES parties (), CONSTRAINT groups_join_policy_ck REFERENCES parties () ); CREATE TRIGGER RI_ConstraintTrigger_a_340732 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340733 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342477 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342478 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342487 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342488 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342497 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342498 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342514 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342515 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342867 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342868 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to groups: --application_groups(groups_group_id_fk) --application_groups(groups_join_policy_ck) --application_groups(groups_pk) --group_element_index(groups_group_id_fk) --group_element_index(groups_join_policy_ck) --group_element_index(groups_pk) --group_rels(groups_group_id_fk) --group_rels(groups_join_policy_ck) --group_rels(groups_pk) --rel_segments(groups_group_id_fk) --rel_segments(groups_join_policy_ck) --rel_segments(groups_pk) -- Table size: 8,192 bytes -- Table rows: 13
Begin main content
