CREATE TABLE ec_products (
product_id integer PRIMARY KEY NOT NULL,
sku varchar(100),
product_name varchar(200),
creation_date timestamptz DEFAULT now() NOT NULL,
one_line_description varchar(400),
detailed_description varchar(4000),
search_keywords varchar(4000),
price numeric(65535, 65531),
no_shipping_avail_p bool DEFAULT false,
shipping numeric(65535, 65531),
shipping_additional numeric(65535, 65531),
weight numeric(65535, 65531),
dirname varchar(200),
present_p bool DEFAULT true,
active_p bool DEFAULT true,
available_date timestamptz DEFAULT now() NOT NULL,
announcements varchar(4000),
announcements_expire timestamptz,
url varchar(300),
template_id integer,
stock_status char(1),
color_list varchar(4000),
size_list varchar(4000),
style_list varchar(4000),
email_on_purchase_list varchar(4000),
last_modified timestamptz NOT NULL,
last_modifying_user integer NOT NULL,
modified_ip_address varchar(20) NOT NULL,
CONSTRAINT ec_products_last_modifying_user_fkey REFERENCES users (),
CONSTRAINT ec_products_product_id_fk REFERENCES users (),
CONSTRAINT ec_products_product_id_pk REFERENCES users (),
CONSTRAINT ec_products_stock_status REFERENCES users (),
CONSTRAINT ec_products_template_id_fkey REFERENCES users () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT ec_products_last_modifying_user_fkey REFERENCES acs_objects (),
CONSTRAINT ec_products_product_id_fk REFERENCES acs_objects (),
CONSTRAINT ec_products_product_id_pk REFERENCES acs_objects (),
CONSTRAINT ec_products_stock_status REFERENCES acs_objects (),
CONSTRAINT ec_products_template_id_fkey REFERENCES acs_objects (),
CONSTRAINT ec_products_template_id_fkey REFERENCES ec_templates (),
CONSTRAINT ec_products_last_modifying_user_fkey REFERENCES ec_templates (),
CONSTRAINT ec_products_product_id_fk REFERENCES ec_templates (),
CONSTRAINT ec_products_product_id_pk REFERENCES ec_templates (),
CONSTRAINT ec_products_stock_status REFERENCES ec_templates ()
);
CREATE TRIGGER ec_products__dtrg AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE ec_products__dtrg (disabled)
CREATE TRIGGER ec_products__itrg AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE ec_products__itrg (disabled)
CREATE TRIGGER ec_products__utrg AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_products__utrg (disabled)
CREATE TRIGGER ec_products_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_products_audit_tr (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341752 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341753 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341792 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341793 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341917 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341918 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341942 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341943 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342002 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342003 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342017 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342018 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342022 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342023 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342027 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342028 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342032 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342033 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342037 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342038 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342042 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342043 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342047 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342048 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342052 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342053 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342067 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342068 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342092 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342093 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342097 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342098 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342107 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342108 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342117 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342118 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342129 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342130 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342134 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342135 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342139 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342140 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342192 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342193 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342232 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342233 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342257 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342258 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342282 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342283 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342327 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342328 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342337 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342338 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
-- Tables with foreign keys that refer to ec_products:
--ec_category_product_map(ec_products_last_modifying_user_fkey)
--ec_category_product_map(ec_products_product_id_fk)
--ec_category_product_map(ec_products_product_id_pk)
--ec_category_product_map(ec_products_stock_status)
--ec_category_product_map(ec_products_template_id_fkey)
--ec_custom_product_field_values(ec_products_last_modifying_user_fkey)
--ec_custom_product_field_values(ec_products_product_id_fk)
--ec_custom_product_field_values(ec_products_product_id_pk)
--ec_custom_product_field_values(ec_products_stock_status)
--ec_custom_product_field_values(ec_products_template_id_fkey)
--ec_items(ec_products_last_modifying_user_fkey)
--ec_items(ec_products_product_id_fk)
--ec_items(ec_products_product_id_pk)
--ec_items(ec_products_stock_status)
--ec_items(ec_products_template_id_fkey)
--ec_offers(ec_products_last_modifying_user_fkey)
--ec_offers(ec_products_product_id_fk)
--ec_offers(ec_products_product_id_pk)
--ec_offers(ec_products_stock_status)
--ec_offers(ec_products_template_id_fkey)
--ec_product_comments(ec_products_last_modifying_user_fkey)
--ec_product_comments(ec_products_product_id_fk)
--ec_product_comments(ec_products_product_id_pk)
--ec_product_comments(ec_products_stock_status)
--ec_product_comments(ec_products_template_id_fkey)
--ec_product_links(ec_products_last_modifying_user_fkey)
--ec_product_links(ec_products_product_id_fk)
--ec_product_links(ec_products_product_id_pk)
--ec_product_links(ec_products_stock_status)
--ec_product_links(ec_products_template_id_fkey)
--ec_product_purchase_comb(ec_products_last_modifying_user_fkey)
--ec_product_purchase_comb(ec_products_product_id_fk)
--ec_product_purchase_comb(ec_products_product_id_pk)
--ec_product_purchase_comb(ec_products_stock_status)
--ec_product_purchase_comb(ec_products_template_id_fkey)
--ec_product_recommendations(ec_products_last_modifying_user_fkey)
--ec_product_recommendations(ec_products_product_id_fk)
--ec_product_recommendations(ec_products_product_id_pk)
--ec_product_recommendations(ec_products_stock_status)
--ec_product_recommendations(ec_products_template_id_fkey)
--ec_product_reviews(ec_products_last_modifying_user_fkey)
--ec_product_reviews(ec_products_product_id_fk)
--ec_product_reviews(ec_products_product_id_pk)
--ec_product_reviews(ec_products_stock_status)
--ec_product_reviews(ec_products_template_id_fkey)
--ec_product_series_map(ec_products_last_modifying_user_fkey)
--ec_product_series_map(ec_products_product_id_fk)
--ec_product_series_map(ec_products_product_id_pk)
--ec_product_series_map(ec_products_stock_status)
--ec_product_series_map(ec_products_template_id_fkey)
--ec_product_user_class_prices(ec_products_last_modifying_user_fkey)
--ec_product_user_class_prices(ec_products_product_id_fk)
--ec_product_user_class_prices(ec_products_product_id_pk)
--ec_product_user_class_prices(ec_products_stock_status)
--ec_product_user_class_prices(ec_products_template_id_fkey)
--ec_sale_prices(ec_products_last_modifying_user_fkey)
--ec_sale_prices(ec_products_product_id_fk)
--ec_sale_prices(ec_products_product_id_pk)
--ec_sale_prices(ec_products_stock_status)
--ec_sale_prices(ec_products_template_id_fkey)
--ec_spam_log(ec_products_last_modifying_user_fkey)
--ec_spam_log(ec_products_product_id_fk)
--ec_spam_log(ec_products_product_id_pk)
--ec_spam_log(ec_products_stock_status)
--ec_spam_log(ec_products_template_id_fkey)
--ec_subcategory_product_map(ec_products_last_modifying_user_fkey)
--ec_subcategory_product_map(ec_products_product_id_fk)
--ec_subcategory_product_map(ec_products_product_id_pk)
--ec_subcategory_product_map(ec_products_stock_status)
--ec_subcategory_product_map(ec_products_template_id_fkey)
--ec_subsubcategory_product_map(ec_products_last_modifying_user_fkey)
--ec_subsubcategory_product_map(ec_products_product_id_fk)
--ec_subsubcategory_product_map(ec_products_product_id_pk)
--ec_subsubcategory_product_map(ec_products_stock_status)
--ec_subsubcategory_product_map(ec_products_template_id_fkey)
--ec_user_session_info(ec_products_last_modifying_user_fkey)
--ec_user_session_info(ec_products_product_id_fk)
--ec_user_session_info(ec_products_product_id_pk)
--ec_user_session_info(ec_products_stock_status)
--ec_user_session_info(ec_products_template_id_fkey)
--ec_user_session_offer_codes(ec_products_last_modifying_user_fkey)
--ec_user_session_offer_codes(ec_products_product_id_fk)
--ec_user_session_offer_codes(ec_products_product_id_pk)
--ec_user_session_offer_codes(ec_products_stock_status)
--ec_user_session_offer_codes(ec_products_template_id_fkey)
-- Table size: 0 bytes
-- Table rows: 0
Tables: