CREATE TABLE ec_offers ( offer_id integer PRIMARY KEY NOT NULL, product_id integer NOT NULL, retailer_location_id integer NOT NULL, store_sku integer, retailer_premiums varchar(500), price numeric(65535, 65531) NOT NULL, shipping numeric(65535, 65531), shipping_unavailable_p bool, stock_status char(1), special_offer_p bool, special_offer_html varchar(500), offer_begins timestamptz NOT NULL, offer_ends timestamptz NOT NULL, deleted_p bool DEFAULT false, last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, CONSTRAINT ec_offers_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_offers_pkey REFERENCES users (), CONSTRAINT ec_offers_product_id_fkey REFERENCES users (), CONSTRAINT ec_offers_retailer_location_id_fkey REFERENCES users (), CONSTRAINT ec_offers_stock_status REFERENCES users (), CONSTRAINT ec_offers_last_modifying_user_fkey REFERENCES ec_products (), CONSTRAINT ec_offers_pkey REFERENCES ec_products (), CONSTRAINT ec_offers_product_id_fkey REFERENCES ec_products (), CONSTRAINT ec_offers_retailer_location_id_fkey REFERENCES ec_products (), CONSTRAINT ec_offers_stock_status REFERENCES ec_products (), CONSTRAINT ec_offers_stock_status REFERENCES ec_retailer_locations (), CONSTRAINT ec_offers_last_modifying_user_fkey REFERENCES ec_retailer_locations (), CONSTRAINT ec_offers_pkey REFERENCES ec_retailer_locations (), CONSTRAINT ec_offers_product_id_fkey REFERENCES ec_retailer_locations (), CONSTRAINT ec_offers_retailer_location_id_fkey REFERENCES ec_retailer_locations () ); CREATE TRIGGER ec_offers_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_offers_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341939 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341940 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341944 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341945 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341949 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341950 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
