CREATE TABLE ec_subcategories ( subcategory_id integer PRIMARY KEY NOT NULL, category_id integer NOT NULL, subcategory_name varchar(100), sort_key numeric(65535, 65531), last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, CONSTRAINT ec_subcategories_category_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_subcategories_last_modifying_user_fkey REFERENCES ec_categories (), CONSTRAINT ec_subcategories_pkey REFERENCES ec_categories (), CONSTRAINT ec_subcategories_pkey REFERENCES users (), CONSTRAINT ec_subcategories_category_id_fkey REFERENCES users (), CONSTRAINT ec_subcategories_last_modifying_user_fkey REFERENCES users () ); CREATE INDEX ec_subcategories_idx ON ec_subcategories (category_id); CREATE INDEX ec_subcategories_idx2 ON ec_subcategories (sort_key); CREATE TRIGGER ec_subcategories_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_subcategories_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341722 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341723 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342072 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342073 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342222 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342223 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342244 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342245 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342249 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342250 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342262 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342263 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342272 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342273 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to ec_subcategories: --ec_cat_mailing_lists(ec_subcategories_category_id_fkey) --ec_cat_mailing_lists(ec_subcategories_last_modifying_user_fkey) --ec_cat_mailing_lists(ec_subcategories_pkey) --ec_product_recommendations(ec_subcategories_category_id_fkey) --ec_product_recommendations(ec_subcategories_last_modifying_user_fkey) --ec_product_recommendations(ec_subcategories_pkey) --ec_spam_log(ec_subcategories_category_id_fkey) --ec_spam_log(ec_subcategories_last_modifying_user_fkey) --ec_spam_log(ec_subcategories_pkey) --ec_subcategory_product_map(ec_subcategories_category_id_fkey) --ec_subcategory_product_map(ec_subcategories_last_modifying_user_fkey) --ec_subcategory_product_map(ec_subcategories_pkey) --ec_subsubcategories(ec_subcategories_category_id_fkey) --ec_subsubcategories(ec_subcategories_last_modifying_user_fkey) --ec_subsubcategories(ec_subcategories_pkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
