CREATE TABLE party_approved_member_map ( party_id integer NOT NULL, member_id integer NOT NULL, originating_rel_id integer NOT NULL, PRIMARY KEY (party_id,member_id,originating_rel_id), CONSTRAINT party_approved_member_map_pk REFERENCES parties (), CONSTRAINT party_member_member_fk REFERENCES parties (), CONSTRAINT party_member_party_fk REFERENCES parties (), CONSTRAINT party_member_rel_id_fk REFERENCES parties (), CONSTRAINT party_member_rel_id_fk REFERENCES parties (), CONSTRAINT party_member_party_fk REFERENCES parties (), CONSTRAINT party_member_member_fk REFERENCES parties (), CONSTRAINT party_approved_member_map_pk REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT party_member_rel_id_fk REFERENCES acs_rels (), CONSTRAINT party_approved_member_map_pk REFERENCES acs_rels (), CONSTRAINT party_member_member_fk REFERENCES acs_rels (), CONSTRAINT party_member_party_fk REFERENCES acs_rels () ); CREATE INDEX party_member_member_idx ON party_approved_member_map (member_id); CREATE INDEX party_member_originating_idx ON party_approved_member_map (originating_rel_id); CREATE INDEX party_member_party_idx ON party_approved_member_map (party_id); CREATE TRIGGER RI_ConstraintTrigger_c_342794 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342795 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342799 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342800 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342804 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342805 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 3,579,904 bytes -- Table rows: 80,732
Begin main content
