-- -- Stores directed graph of linked categories. If category A -- and category B are linked, then any categorization on A -- will result in an additional categorization in B. -- CREATE TABLE category_links ( -- -- Primary key. -- link_id integer PRIMARY KEY NOT NULL, -- -- Category the link is coming from. Any categorization in this -- category will trigger a categorization in the other category. -- from_category_id integer NOT NULL, -- -- Category the link is coming to. Any categorization in the other -- category will trigger a categorization in this category. -- to_category_id integer NOT NULL, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT category_links_from_fk REFERENCES categories (), CONSTRAINT category_links_pk REFERENCES categories (), CONSTRAINT category_links_to_fk REFERENCES categories (), CONSTRAINT category_links_un REFERENCES categories () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT category_links_un REFERENCES categories (), CONSTRAINT category_links_from_fk REFERENCES categories (), CONSTRAINT category_links_pk REFERENCES categories (), CONSTRAINT category_links_to_fk REFERENCES categories () ); CREATE UNIQUE INDEX category_links_rev_ix ON category_links (to_category_id, from_category_id); CREATE UNIQUE INDEX category_links_un ON category_links (from_category_id, to_category_id); CREATE TRIGGER RI_ConstraintTrigger_c_341134 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341135 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341139 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341140 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
