CREATE TABLE ec_product_user_class_prices ( product_id integer NOT NULL, user_class_id integer NOT NULL, price numeric(65535, 65531), last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, PRIMARY KEY (product_id,user_class_id), CONSTRAINT ec_product_user_class_pric_pkey REFERENCES users (), CONSTRAINT ec_product_user_class_prices_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_product_user_class_prices_product_id_fkey REFERENCES users (), CONSTRAINT ec_product_user_class_prices_user_class_id_fkey REFERENCES users (), CONSTRAINT ec_product_user_class_prices_user_class_id_fkey REFERENCES ec_products (), CONSTRAINT ec_product_user_class_prices_product_id_fkey REFERENCES ec_products (), CONSTRAINT ec_product_user_class_prices_last_modifying_user_fkey REFERENCES ec_products (), CONSTRAINT ec_product_user_class_pric_pkey REFERENCES ec_products (), CONSTRAINT ec_product_user_class_prices_user_class_id_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_product_user_class_pric_pkey REFERENCES ec_user_classes (), CONSTRAINT ec_product_user_class_prices_last_modifying_user_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_product_user_class_prices_product_id_fkey REFERENCES ec_user_classes () ); CREATE INDEX ec_product_user_class_idx ON ec_product_user_class_prices (user_class_id); CREATE TRIGGER ec_product_u_c_prices_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_product_u_c_prices_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342114 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342115 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342119 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342120 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342124 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342125 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
