-- -- Stores the default relationship types available for use by groups of -- a given type. We May want to generalize this table to object_types and -- put it in the relationships sql file, though there is no need to do so -- right now. -- CREATE TABLE group_type_rels ( group_rel_type_id integer PRIMARY KEY NOT NULL, rel_type varchar(1000) NOT NULL, group_type varchar(1000) NOT NULL, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT gtr_group_rel_type_id_pk REFERENCES acs_rel_types (), CONSTRAINT gtr_group_type_fk REFERENCES acs_rel_types (), CONSTRAINT gtr_rel_type_fk REFERENCES acs_rel_types () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT gtr_rel_type_fk REFERENCES acs_object_types (), CONSTRAINT gtr_group_rel_type_id_pk REFERENCES acs_object_types (), CONSTRAINT gtr_group_type_fk REFERENCES acs_object_types () ); CREATE INDEX group_type_rels_rel_type_idx ON group_type_rels (rel_type); CREATE UNIQUE INDEX gtr_group_rel_types_un ON group_type_rels (group_type, rel_type); CREATE TRIGGER RI_ConstraintTrigger_c_342524 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342525 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610636 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610637 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 6
Begin main content
