CREATE TABLE cr_item_keyword_map ( item_id integer NOT NULL, keyword_id integer NOT NULL, PRIMARY KEY (item_id,keyword_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_item_keyword_map_item_id_fk REFERENCES cr_items (), CONSTRAINT cr_item_keyword_map_kw_fk REFERENCES cr_items (), CONSTRAINT cr_item_keyword_map_pk REFERENCES cr_items (), CONSTRAINT cr_item_keyword_map_pk REFERENCES cr_keywords (), CONSTRAINT cr_item_keyword_map_item_id_fk REFERENCES cr_keywords (), CONSTRAINT cr_item_keyword_map_kw_fk REFERENCES cr_keywords () ); CREATE INDEX cr_item_keyword_map_kw_id_idx ON cr_item_keyword_map (keyword_id); CREATE TRIGGER RI_ConstraintTrigger_c_341294 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341295 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341299 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341300 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 409,600 bytes -- Table rows: 11,240
Begin main content
