CREATE TABLE membership_rels ( rel_id integer PRIMARY KEY NOT NULL, member_state varchar(20), CONSTRAINT membership_rel_mem_ck REFERENCES acs_rels (), CONSTRAINT membership_rels_member_state_ck REFERENCES acs_rels (), CONSTRAINT membership_rel_rel_id_pk REFERENCES acs_rels (), CONSTRAINT membership_rel_rel_id_fk REFERENCES acs_rels () ); CREATE INDEX membership_rels_rel_id_approved_idx ON membership_rels (rel_id); CREATE TRIGGER membership_rels_del_tr BEFORE DELETE FOR EACH ROW EXECUTE PROCEDURE membership_rels_del_tr (disabled) CREATE TRIGGER membership_rels_in_tr AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE membership_rels_in_tr (disabled) CREATE TRIGGER membership_rels_up_tr BEFORE UPDATE FOR EACH ROW EXECUTE PROCEDURE membership_rels_up_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340617 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340618 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342604 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342605 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343047 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343048 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to membership_rels: --admin_rels(membership_rel_mem_ck) --admin_rels(membership_rel_rel_id_fk) --admin_rels(membership_rel_rel_id_pk) --admin_rels(membership_rels_member_state_ck) --user_profiles(membership_rel_mem_ck) --user_profiles(membership_rel_rel_id_fk) --user_profiles(membership_rel_rel_id_pk) --user_profiles(membership_rels_member_state_ck) -- Table size: 983,040 bytes -- Table rows: 21,990
Begin main content
