CREATE TABLE ec_product_recommendations ( recommendation_id integer PRIMARY KEY NOT NULL, product_id integer NOT NULL, user_class_id integer, recommendation_text varchar(4000), active_p bool DEFAULT true, category_id integer, subcategory_id integer, subsubcategory_id integer, last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, CONSTRAINT ec_product_recommendations_last_modifying_user_fkey REFERENCES ec_categories (), CONSTRAINT ec_product_recommendations_category_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_product_recommendations_pkey REFERENCES ec_categories (), CONSTRAINT ec_product_recommendations_product_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_product_recommendations_subcategory_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_product_recommendations_subsubcategory_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_product_recommendations_user_class_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_product_recommendations_category_id_fkey REFERENCES users (), CONSTRAINT ec_product_recommendations_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_product_recommendations_pkey REFERENCES users (), CONSTRAINT ec_product_recommendations_product_id_fkey REFERENCES users (), CONSTRAINT ec_product_recommendations_subcategory_id_fkey REFERENCES users (), CONSTRAINT ec_product_recommendations_subsubcategory_id_fkey REFERENCES users (), CONSTRAINT ec_product_recommendations_user_class_id_fkey REFERENCES users (), CONSTRAINT ec_product_recommendations_last_modifying_user_fkey REFERENCES ec_products (), CONSTRAINT ec_product_recommendations_category_id_fkey REFERENCES ec_products (), CONSTRAINT ec_product_recommendations_pkey REFERENCES ec_products (), CONSTRAINT ec_product_recommendations_product_id_fkey REFERENCES ec_products (), CONSTRAINT ec_product_recommendations_subcategory_id_fkey REFERENCES ec_products (), CONSTRAINT ec_product_recommendations_subsubcategory_id_fkey REFERENCES ec_products (), CONSTRAINT ec_product_recommendations_user_class_id_fkey REFERENCES ec_products (), CONSTRAINT ec_product_recommendations_product_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_product_recommendations_user_class_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_product_recommendations_subsubcategory_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_product_recommendations_subcategory_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_product_recommendations_pkey REFERENCES ec_subcategories (), CONSTRAINT ec_product_recommendations_last_modifying_user_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_product_recommendations_category_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_product_recommendations_user_class_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_product_recommendations_subsubcategory_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_product_recommendations_subcategory_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_product_recommendations_product_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_product_recommendations_pkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_product_recommendations_last_modifying_user_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_product_recommendations_category_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_product_recommendations_user_class_id_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_product_recommendations_subsubcategory_id_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_product_recommendations_subcategory_id_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_product_recommendations_product_id_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_product_recommendations_pkey REFERENCES ec_user_classes (), CONSTRAINT ec_product_recommendations_last_modifying_user_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_product_recommendations_category_id_fkey REFERENCES ec_user_classes () ); CREATE INDEX ec_product_recommendation_idx ON ec_product_recommendations (category_id); CREATE INDEX ec_product_recommendation_idx2 ON ec_product_recommendations (subcategory_id); CREATE INDEX ec_product_recommendation_idx3 ON ec_product_recommendations (subsubcategory_id); CREATE INDEX ec_product_recommendation_idx4 ON ec_product_recommendations (user_class_id); CREATE INDEX ec_product_recommendation_idx5 ON ec_product_recommendations (active_p); CREATE TRIGGER ec_product_recommend_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_product_recommend_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342059 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342060 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342064 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342065 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342069 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342070 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342074 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342075 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342079 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342080 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342084 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342085 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
