CREATE TABLE ec_subsubcategories ( subsubcategory_id integer PRIMARY KEY NOT NULL, subcategory_id integer NOT NULL, subsubcategory_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_subsubcategories_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_subsubcategories_pkey REFERENCES users (), CONSTRAINT ec_subsubcategories_subcategory_id_fkey REFERENCES users (), CONSTRAINT ec_subsubcategories_subcategory_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_subsubcategories_last_modifying_user_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_subsubcategories_pkey REFERENCES ec_subcategories () ); CREATE INDEX ec_subsubcategories_idx ON ec_subsubcategories (subcategory_id); CREATE INDEX ec_subsubcategories_idx2 ON ec_subsubcategories (sort_key); CREATE TRIGGER ec_subsubcategories_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_subsubcategories_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341727 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341728 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342077 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342078 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342227 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342228 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342269 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342270 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342274 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342275 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342287 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342288 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to ec_subsubcategories: --ec_cat_mailing_lists(ec_subsubcategories_last_modifying_user_fkey) --ec_cat_mailing_lists(ec_subsubcategories_pkey) --ec_cat_mailing_lists(ec_subsubcategories_subcategory_id_fkey) --ec_product_recommendations(ec_subsubcategories_last_modifying_user_fkey) --ec_product_recommendations(ec_subsubcategories_pkey) --ec_product_recommendations(ec_subsubcategories_subcategory_id_fkey) --ec_spam_log(ec_subsubcategories_last_modifying_user_fkey) --ec_spam_log(ec_subsubcategories_pkey) --ec_spam_log(ec_subsubcategories_subcategory_id_fkey) --ec_subsubcategory_product_map(ec_subsubcategories_last_modifying_user_fkey) --ec_subsubcategory_product_map(ec_subsubcategories_pkey) --ec_subsubcategory_product_map(ec_subsubcategories_subcategory_id_fkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
