--
-- Stores the relationship types available for use by each group. Only
-- relationship types in this table are offered for adding
-- relations. Note that there is no restriction that says groups can
-- only have relationship types specified for their group type. The
-- group_type_rels table just stores defaults for groups
-- of a new type.
--
CREATE TABLE group_rels (
group_rel_id integer PRIMARY KEY NOT NULL,
rel_type varchar(1000) NOT NULL,
group_id integer NOT NULL,
ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT group_rels_group_id_fk REFERENCES groups (),
CONSTRAINT group_rels_group_rel_id_pk REFERENCES groups (),
CONSTRAINT group_rels_rel_type_fk REFERENCES groups () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT group_rels_rel_type_fk REFERENCES acs_rel_types (),
CONSTRAINT group_rels_group_id_fk REFERENCES acs_rel_types (),
CONSTRAINT group_rels_group_rel_id_pk REFERENCES acs_rel_types ()
);
CREATE UNIQUE INDEX group_rels_group_rel_type_un ON group_rels (group_id, rel_type);
CREATE INDEX group_rels_rel_type_idx ON group_rels (rel_type);
CREATE TRIGGER RI_ConstraintTrigger_c_342499 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342500 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342504 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342505 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 8,192 bytes
-- Table rows: 33
Begin main content
