CREATE TABLE ec_subsubcategory_product_map ( product_id integer NOT NULL, subsubcategory_id integer NOT NULL, publisher_favorite_p bool, last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, PRIMARY KEY (product_id,subsubcategory_id), CONSTRAINT ec_subsubcategory_product__pkey REFERENCES users (), CONSTRAINT ec_subsubcategory_product_map_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_subsubcategory_product_map_product_id_fkey REFERENCES users (), CONSTRAINT ec_subsubcategory_product_map_subsubcategory_id_fkey REFERENCES users (), CONSTRAINT ec_subsubcategory_product_map_subsubcategory_id_fkey REFERENCES ec_products (), CONSTRAINT ec_subsubcategory_product_map_product_id_fkey REFERENCES ec_products (), CONSTRAINT ec_subsubcategory_product_map_last_modifying_user_fkey REFERENCES ec_products (), CONSTRAINT ec_subsubcategory_product__pkey REFERENCES ec_products (), CONSTRAINT ec_subsubcategory_product_map_subsubcategory_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_subsubcategory_product__pkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_subsubcategory_product_map_last_modifying_user_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_subsubcategory_product_map_product_id_fkey REFERENCES ec_subsubcategories () ); CREATE INDEX ec_subsubcat_prod_map_idx ON ec_subsubcategory_product_map (subsubcategory_id); CREATE INDEX ec_subsubcat_prod_map_idx2 ON ec_subsubcategory_product_map (publisher_favorite_p); CREATE TRIGGER ec_subsubcat_prod_map_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_subsubcat_prod_map_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342279 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342280 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342284 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342285 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342289 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342290 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: ec_subsubcategory_product_map
Begin main content
