CREATE TABLE ec_sale_prices ( sale_price_id integer PRIMARY KEY NOT NULL, product_id integer NOT NULL, sale_price numeric(65535, 65531), sale_begins timestamptz NOT NULL, sale_ends timestamptz NOT NULL, sale_name varchar(30), offer_code varchar(20), last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, CONSTRAINT ec_sale_prices_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_sale_prices_pkey REFERENCES users (), CONSTRAINT ec_sale_prices_product_id_fkey REFERENCES users (), CONSTRAINT ec_sale_prices_product_id_fkey REFERENCES ec_products (), CONSTRAINT ec_sale_prices_last_modifying_user_fkey REFERENCES ec_products (), CONSTRAINT ec_sale_prices_pkey REFERENCES ec_products () ); CREATE INDEX ec_sale_prices_by_product_idx ON ec_sale_prices (product_id); CREATE TRIGGER ec_sale_prices_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_sale_prices_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342189 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342190 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342194 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342195 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
