1 Project Onxshop 1.7 @ DbSchema.com Layout public Column comments as mouse-over tooltips. Fk common_configuration_node_id_fkey common_configuration ref common_node ( node_id -> id ) node_id Fk common_node_taxonomy_node_id_fkey common_node_taxonomy ref common_node ( node_id -> id ) node_id Fk common_node_taxonomy_taxonomy_tree_id_fkey common_node_taxonomy ref common_taxonomy_tree ( taxonomy_tree_id -> id ) taxonomy_tree_id Fk common_uri_mapping_node_id_fkey common_uri_mapping ref common_node ( node_id -> id ) node_id Fk common_comment_customer_id_fkey common_comment ref client_customer ( customer_id -> id ) customer_id Fk common_comment_parent_fkey common_comment ref common_comment ( parent -> id ) parent Fk common_comment_node_id_fkey common_comment ref common_node ( node_id -> id ) node_id Fk ecommerce_product_variety_product_id_fkey ecommerce_product_variety ref ecommerce_product ( product_id -> id ) product_id Fk ecommerce_product_variety_product_type_id_fkey ecommerce_product_variety ref ecommerce_product_type ( product_type_id -> id ) product_type_id Fk ecommerce_product_variety_taxonomy_taxonomy_tree_id_fkey ecommerce_product_variety_taxonomy ref common_taxonomy_tree ( taxonomy_tree_id -> id ) taxonomy_tree_id Fk ecommerce_product_variety_taxonomy_node_id_fkey ecommerce_product_variety_taxonomy ref ecommerce_product_variety ( node_id -> id ) node_id Fk common_session_archive_customer_id_fkey common_session_archive ref client_customer ( customer_id -> id ) customer_id Fk common_watchdog_customer_id_fkey common_watchdog ref client_customer ( customer_id -> id ) customer_id Fk client_address_customer_id_fkey client_address ref client_customer ( customer_id -> id ) customer_id Fk client_address_country_id_fkey client_address ref international_country ( country_id -> id ) country_id Fk ecommerce_product_image_customer_id_fkey ecommerce_product_image ref client_customer ( customer_id -> id ) customer_id Fk ecommerce_product_image_node_id_fkey ecommerce_product_image ref ecommerce_product ( node_id -> id ) node_id Fk ecommerce_basket_content_basket_id_fkey ecommerce_basket_content ref ecommerce_basket ( basket_id -> id ) basket_id Fk ecommerce_basket_content_price_id_fkey ecommerce_basket_content ref ecommerce_price ( price_id -> id ) price_id Fk ecommerce_basket_content_product_type_id_fkey ecommerce_basket_content ref ecommerce_product_type ( product_type_id -> id ) product_type_id Fk ecommerce_basket_content_product_variety_id_fkey ecommerce_basket_content ref ecommerce_product_variety ( product_variety_id -> id ) product_variety_id Fk ecommerce_offer_campaign_category_id_fkey ecommerce_offer ref common_taxonomy_tree ( campaign_category_id -> id ) campaign_category_id Fk ecommerce_offer_roundel_category_id_fkey ecommerce_offer ref common_taxonomy_tree ( roundel_category_id -> id ) roundel_category_id Fk ecommerce_offer_offer_group_id_fkey ecommerce_offer ref ecommerce_offer_group ( offer_group_id -> id ) offer_group_id Fk ecommerce_offer_price_id_fkey ecommerce_offer ref ecommerce_price ( price_id -> id ) price_id Fk ecommerce_offer_product_variety_id_fkey ecommerce_offer ref ecommerce_product_variety ( product_variety_id -> id ) product_variety_id Fk ecommerce_product_variety_image_customer_id_fkey ecommerce_product_variety_image ref client_customer ( customer_id -> id ) customer_id Fk ecommerce_product_variety_image_node_id_fkey ecommerce_product_variety_image ref ecommerce_product_variety ( node_id -> id ) node_id Fk ecommerce_product_review_customer_id_fkey ecommerce_product_review ref client_customer ( customer_id -> id ) customer_id Fk ecommerce_product_review_node_id_fkey ecommerce_product_review ref ecommerce_product ( node_id -> id ) node_id Fk ecommerce_product_review_parent_fkey ecommerce_product_review ref ecommerce_product_review ( parent -> id ) parent Fk ecommerce_product_to_product_product_id_fkey ecommerce_product_to_product ref ecommerce_product ( product_id -> id ) product_id Fk ecommerce_product_to_product_related_product_id_fkey ecommerce_product_to_product ref ecommerce_product ( related_product_id -> id ) related_product_id Fk ecommerce_promotion_generated_by_customer_id_fkey ecommerce_promotion ref client_customer ( generated_by_customer_id -> id ) generated_by_customer_id Fk ecommerce_promotion_limit_by_customer_id_fkey ecommerce_promotion ref client_customer ( limit_by_customer_id -> id ) limit_by_customer_id Fk ecommerce_promotion_generated_by_order_id_fkey ecommerce_promotion ref ecommerce_order ( generated_by_order_id -> id ) generated_by_order_id Fk ecommerce_promotion_type_fkey ecommerce_promotion ref ecommerce_promotion_type ( type -> id ) type Fk ecommerce_order_delivery_address_id_fkey ecommerce_order ref client_address ( delivery_address_id -> id ) delivery_address_id Fk ecommerce_order_invoices_address_id_fkey ecommerce_order ref client_address ( invoices_address_id -> id ) invoices_address_id Fk ecommerce_order_basket_id_fkey ecommerce_order ref ecommerce_basket ( basket_id -> id ) basket_id Fk ecommerce_promotion_code_order_id_fkey ecommerce_promotion_code ref ecommerce_order ( order_id -> id ) order_id Fk ecommerce_promotion_code_promotion_id_fkey ecommerce_promotion_code ref ecommerce_promotion ( promotion_id -> id ) promotion_id Fk ecommerce_transaction_order_id_fkey ecommerce_transaction ref ecommerce_order ( order_id -> id ) order_id Fk ecommerce_order_log_order_id_fkey ecommerce_order_log ref ecommerce_order ( order_id -> id ) order_id Fk ecommerce_invoice_order_id_fkey ecommerce_invoice ref ecommerce_order ( order_id -> id ) order_id Fk client_customer_store_id_fkey client_customer ref ecommerce_store ( store_id -> id ) store_id Fk client_customer_token_customer_id_fkey client_customer_token ref client_customer ( customer_id -> id ) customer_id Fk common_session_customer_id_fkey common_session ref client_customer ( customer_id -> id ) customer_id Fk client_customer_group_customer_id_fkey client_customer_group ref client_customer ( customer_id -> id ) customer_id Fk client_customer_group_group_id_fkey client_customer_group ref client_group ( group_id -> id ) group_id Fk client_customer_role_customer_id_fkey client_customer_role ref client_customer ( customer_id -> id ) customer_id Fk client_customer_role_role_id_fkey client_customer_role ref client_role ( role_id -> id ) role_id Fk client_role_permission_role_id_fkey client_role_permission ref client_role ( role_id -> id ) role_id Fk client_action_customer_id_fkey client_action ref client_customer ( customer_id -> id ) customer_id Fk client_action_node_id_fkey client_action ref common_node ( node_id -> id ) node_id Fk client_company_customer_id_fkey client_company ref client_customer ( customer_id -> id ) customer_id Fk client_customer_taxonomy_customer_fkey client_customer_taxonomy ref client_customer ( node_id -> id ) node_id Fk client_customer_taxonomy_taxonomy_fkey client_customer_taxonomy ref common_taxonomy_tree ( taxonomy_tree_id -> id ) taxonomy_tree_id Fk ecommerce_product_taxonomy_taxonomy_tree_id_fkey ecommerce_product_taxonomy ref common_taxonomy_tree ( taxonomy_tree_id -> id ) taxonomy_tree_id Fk ecommerce_product_taxonomy_node_id_fkey ecommerce_product_taxonomy ref ecommerce_product ( node_id -> id ) node_id Fk common_taxonomy_label_image_customer_id_fkey common_taxonomy_label_image ref client_customer ( customer_id -> id ) customer_id Fk common_taxonomy_label_image_node_id_fkey common_taxonomy_label_image ref common_taxonomy_label ( node_id -> id ) node_id Fk common_image_customer_id_fkey common_image ref client_customer ( customer_id -> id ) customer_id Fk common_image_node_id_fkey common_image ref common_node ( node_id -> id ) node_id Fk common_print_article_node_id_fkey common_print_article ref common_node ( node_id -> id ) node_id Fk common_file_customer_id_fkey common_file ref client_customer ( customer_id -> id ) customer_id Fk common_file_node_id_fkey common_file ref common_node ( node_id -> id ) node_id Fk common_node_customer_id_fkey common_node ref client_customer ( customer_id -> id ) customer_id Fk common_node_link_to_node_id_fkey common_node ref common_node ( link_to_node_id -> id ) link_to_node_id Fk common_node_parent_fkey common_node ref common_node ( parent -> id ) parent Fk ecommerce_price_product_variety_id_fkey ecommerce_price ref ecommerce_product_variety ( product_variety_id -> id ) product_variety_id Fk ecommerce_basket_customer_id_fkey ecommerce_basket ref client_customer ( customer_id -> id ) customer_id Fk education_survey_image_customer_id_fkey education_survey_image ref client_customer ( customer_id -> id ) customer_id Fk education_survey_image_node_id_fkey education_survey_image ref education_survey ( node_id -> id ) node_id Fk education_survey_entry_customer_id_fkey education_survey_entry ref client_customer ( customer_id -> id ) customer_id Fk education_survey_entry_survey_id_fkey education_survey_entry ref education_survey ( survey_id -> id ) survey_id Fk education_survey_entry_answer_survey_entry_id_fkey education_survey_entry_answer ref education_survey_entry ( survey_entry_id -> id ) survey_entry_id Fk education_survey_entry_answer_question_id_fkey education_survey_entry_answer ref education_survey_question ( question_id -> id ) question_id Fk education_survey_entry_answer_question_answer_id_fkey education_survey_entry_answer ref education_survey_question_answer ( question_answer_id -> id ) question_answer_id Fk education_survey_question_answer_question_id_fkey education_survey_question_answer ref education_survey_question ( question_id -> id ) question_id Fk education_survey_question_survey_id_fkey education_survey_question ref education_survey ( survey_id -> id ) survey_id Fk education_survey_question_parent_fkey education_survey_question ref education_survey_question ( parent -> id ) parent Fk ecommerce_store_image_customer_id_fkey ecommerce_store_image ref client_customer ( customer_id -> id ) customer_id Fk ecommerce_store_image_store_fkey ecommerce_store_image ref ecommerce_store ( node_id -> id ) node_id Fk ecommerce_store_type_id_fkey ecommerce_store ref ecommerce_store_type ( type_id -> id ) type_id Fk ecommerce_store_country_id_fkey ecommerce_store ref international_country ( country_id -> id ) country_id Fk ecommerce_store_taxonomy_taxonomy_fkey ecommerce_store_taxonomy ref common_taxonomy_tree ( taxonomy_tree_id -> id ) taxonomy_tree_id Fk ecommerce_store_taxonomy_store_fkey ecommerce_store_taxonomy ref ecommerce_store ( node_id -> id ) node_id Fk ecommerce_recipe_taxonomy_taxonmy_fkey ecommerce_recipe_taxonomy ref common_taxonomy_tree ( taxonomy_tree_id -> id ) taxonomy_tree_id Fk ecommerce_recipe_taxonomy_recipe_fkey ecommerce_recipe_taxonomy ref ecommerce_recipe ( node_id -> id ) node_id Fk ecommerce_recipe_ingredients_units_fkey ecommerce_recipe_ingredients ref common_taxonomy_tree ( units -> id ) units Fk ecommerce_recipe_ingredients_product_variety_id_fkey ecommerce_recipe_ingredients ref ecommerce_product_variety ( product_variety_id -> id ) product_variety_id Fk ecommerce_recipe_ingredients_recipe_fkey ecommerce_recipe_ingredients ref ecommerce_recipe ( recipe_id -> id ) recipe_id Fk ecommerce_recipe_review_customer_id_fkey ecommerce_recipe_review ref client_customer ( customer_id -> id ) customer_id Fk ecommerce_recipe_review_node_id_fkey ecommerce_recipe_review ref ecommerce_recipe ( node_id -> id ) node_id Fk ecommerce_recipe_review_parent_fkey ecommerce_recipe_review ref ecommerce_recipe_review ( parent -> id ) parent Fk ecommerce_recipe_image_customer_id_fkey ecommerce_recipe_image ref client_customer ( customer_id -> id ) customer_id Fk ecommerce_recipe_node_id_fkey ecommerce_recipe_image ref ecommerce_recipe ( node_id -> id ) node_id Fk common_taxonomy_tree_label_id_fkey common_taxonomy_tree ref common_taxonomy_label ( label_id -> id ) label_id Fk common_taxonomy_tree_parent_fkey common_taxonomy_tree ref common_taxonomy_tree ( parent -> id ) parent Fk ecommerce_delivery_carrier_country_to_zone_zone_id_fkey ecommerce_delivery_carrier_zone_to_country ref ecommerce_delivery_carrier_zone ( zone_id -> id ) zone_id Fk ecommerce_delivery_carrier_country_to_zone_country_id_fkey ecommerce_delivery_carrier_zone_to_country ref international_country ( country_id -> id ) country_id Fk ecommerce_delivery_carrier_zone_carrier_id_fkey ecommerce_delivery_carrier_zone ref ecommerce_delivery_carrier ( carrier_id -> id ) carrier_id Fk ecommerce_delivery_carrier_zone_price_zone_id_fkey ecommerce_delivery_carrier_zone_price ref ecommerce_delivery_carrier_zone ( zone_id -> id ) zone_id Fk ecommerce_delivery_carrier_id_fkey ecommerce_delivery ref ecommerce_delivery_carrier ( carrier_id -> id ) carrier_id Fk ecommerce_delivery_order_id_fkey ecommerce_delivery ref ecommerce_order ( order_id -> id ) order_id Fk international_translation_node_id_fkey international_translation ref common_node ( node_id -> id ) node_id Fk ecommerce_delivery_carrier_rate_carrier_id_fkey ecommerce_delivery_carrier_rate ref ecommerce_delivery_carrier ( carrier_id -> id ) carrier_id Fk client_customer_image_customer_fkey client_customer_image ref client_customer ( node_id -> id ) node_id Fk client_customer_image_customer_id_fkey client_customer_image ref client_customer ( customer_id -> id ) customer_id Fk common_revision_customer_id_fkey common_revision ref client_customer ( customer_id -> id ) customer_id common_configurationTable public.common_configuration Pk common_configuration_pkey ( id ) idid * serial node_idnode_id * integer default 0 References common_node ( node_id -> id ) objectobject varchar(255) propertyproperty varchar(255) valuevalue text descriptiondescription text apply_to_childrenapply_to_children smallint default 0::smallint common_node_taxonomyTable public.common_node_taxonomy Pk common_node_taxonomy_pkey ( id ) idid * serial Unq node_node_id_taxonomy_tree_id_key ( node_id, taxonomy_tree_id ) common_node_taxonomy_node_id_idx ( node_id ) node_idnode_id * integer References common_node ( node_id -> id ) Unq node_node_id_taxonomy_tree_id_key ( node_id, taxonomy_tree_id ) common_node_taxonomy_taxonomy_tree_id_idx ( taxonomy_tree_id ) taxonomy_tree_idtaxonomy_tree_id * integer References common_taxonomy_tree ( taxonomy_tree_id -> id ) common_uri_mappingTable public.common_uri_mapping Pk common_uri_mapping_pkey ( id ) idid * serial common_uri_mapping_node_id_idx ( node_id ) node_idnode_id integer References common_node ( node_id -> id ) Unq common_uri_mapping_public_uri_key ( public_uri ) public_uripublic_uri text common_uri_mapping_type_idx ( type ) typetype varchar(255) common_commentTable public.common_comment Pk common_comment_pkey ( id ) idid * serial Referred by common_comment ( parent -> id ) common_comment_parent_idx ( parent ) parentparent integer References common_comment ( parent -> id ) node_idnode_id integer References common_node ( node_id -> id ) titletitle varchar(255) contentcontent text author_nameauthor_name varchar(255) author_emailauthor_email varchar(255) author_websiteauthor_website varchar(255) author_ip_addressauthor_ip_address varchar(255) common_comment_costomer_id_id_idx ( customer_id ) customer_idcustomer_id * integer References client_customer ( customer_id -> id ) createdcreated timestamp default now() publishpublish smallint ratingrating smallint default 0 relation_subjectrelation_subject text ecommerce_product_varietyTable public.ecommerce_product_variety Pk ecommerce_product_variety_pkey ( id ) idid * serial Referred by ecommerce_basket_content ( product_variety_id -> id ) Referred by ecommerce_offer ( product_variety_id -> id ) Referred by ecommerce_price ( product_variety_id -> id ) Referred by ecommerce_product_variety_image ( node_id -> id ) Referred by ecommerce_product_variety_taxonomy ( node_id -> id ) Referred by ecommerce_recipe_ingredients ( product_variety_id -> id ) namename varchar(255) ecommerce_product_variety_product_id_idx ( product_id ) product_idproduct_id integer References ecommerce_product ( product_id -> id ) Unq ecommerce_product_variety_code_key ( sku ) skusku varchar(255) weightweight integer weight_grossweight_gross integer stockstock integer prioritypriority * integer default 0 descriptiondescription text other_dataother_data text widthwidth * integer default 0 heightheight * integer default 0 depthdepth * integer default 0 diameterdiameter * integer default 0 modifiedmodified * timestamp default now() publishpublish * smallint default 0 display_permissiondisplay_permission * integer default 0 ean13ean13 varchar(255) upcupc varchar(255) conditioncondition * smallint default 0 wholesalewholesale smallint reward_pointsreward_points integer subtitlesubtitle varchar(255) product_type_idproduct_type_id integer References ecommerce_product_type ( product_type_id -> id ) limit_to_delivery_zoneslimit_to_delivery_zones varchar(512) ecommerce_productTable public.ecommerce_product Pk ecommerce_product_pkey ( id ) idid * serial Referred by ecommerce_product_image ( node_id -> id ) Referred by ecommerce_product_review ( node_id -> id ) Referred by ecommerce_product_taxonomy ( node_id -> id ) Referred by ecommerce_product_to_product ( product_id -> id ) Referred by ecommerce_product_to_product ( related_product_id -> id ) Referred by ecommerce_product_variety ( product_id -> id ) namename varchar(255) teaserteaser text descriptiondescription text urlurl text prioritypriority * integer default 0 ecommerce_product_publish_idx ( publish ) publishpublish * integer default 0 other_dataother_data text modifiedmodified * timestamp default now() availabilityavailability * smallint default 0 name_akaname_aka varchar(255) ecommerce_product_variety_taxonomyTable public.ecommerce_product_variety_taxonomy Pk ecommerce_product_variety_taxonomy_pkey ( id ) idid * serial Unq product_variety_node_id_taxonomy_tree_id_key ( node_id, taxonomy_tree_id ) ecommerce_product_variety_taxonomy_node_id_idx ( node_id ) node_idnode_id * integer References ecommerce_product_variety ( node_id -> id ) Unq product_variety_node_id_taxonomy_tree_id_key ( node_id, taxonomy_tree_id ) ecommerce_product_variety_taxonomy_taxonomy_tree_id_idx ( taxonomy_tree_id ) taxonomy_tree_idtaxonomy_tree_id * integer References common_taxonomy_tree ( taxonomy_tree_id -> id ) common_session_archiveTable public.common_session_archive Pk common_session_archive_pkey ( id ) idid * serial session_idsession_id varchar(32) session_datasession_data text customer_idcustomer_id integer References client_customer ( customer_id -> id ) createdcreated timestamp modifiedmodified timestamp ip_addressip_address varchar(255) php_auth_userphp_auth_user varchar(255) http_refererhttp_referer text http_user_agenthttp_user_agent varchar(255) common_watchdogTable public.common_watchdog Pk common_watchdog_pkey ( id ) idid * serial common_watchdog_combined_idx ( name, watched_item_id, publish ) namename varchar(255) common_watchdog_combined_idx ( name, watched_item_id, publish ) watched_item_idwatched_item_id integer customer_idcustomer_id integer References client_customer ( customer_id -> id ) createdcreated timestamp modifiedmodified timestamp default now() common_watchdog_combined_idx ( name, watched_item_id, publish ) publishpublish smallint other_dataother_data text client_addressTable public.client_address Pk client_address_pkey ( id ) idid * serial Referred by ecommerce_order ( delivery_address_id -> id ) Referred by ecommerce_order ( invoices_address_id -> id ) client_address_customer_id_idx ( customer_id ) customer_idcustomer_id integer References client_customer ( customer_id -> id ) client_address_country_id_idx ( country_id ) country_idcountry_id integer References international_country ( country_id -> id ) namename varchar(255) line_1line_1 varchar(255) line_2line_2 varchar(255) line_3line_3 varchar(255) post_codepost_code varchar(255) citycity varchar(255) countycounty varchar(255) telephonetelephone varchar(255) commentcomment varchar(255) is_deletedis_deleted bool default false ecommerce_product_imageTable public.ecommerce_product_image Pk ecommerce_product_image_pkey ( id ) idid * serial srcsrc varchar(255) rolerole varchar(255) ecommerce_product_image_node_id_idx ( node_id ) node_idnode_id * integer References ecommerce_product ( node_id -> id ) titletitle varchar(255) descriptiondescription text prioritypriority * integer default 0 modifiedmodified timestamp authorauthor integer contentcontent text other_dataother_data text link_to_node_idlink_to_node_id integer customer_idcustomer_id integer References client_customer ( customer_id -> id ) ecommerce_product_typeTable public.ecommerce_product_type Pk ecommerce_product_type_pkey ( id ) idid * serial Referred by ecommerce_basket_content ( product_type_id -> id ) Referred by ecommerce_product_variety ( product_type_id -> id ) namename varchar(255) vatvat * numeric(-9999999,0) default 0 publishpublish * integer default 1 ecommerce_basket_contentTable public.ecommerce_basket_content Pk ecommerce_basket_content_pkey ( id ) idid * serial ecommerce_basket_content_basket_id_idx ( basket_id ) basket_idbasket_id integer References ecommerce_basket ( basket_id -> id ) ecommerce_basket_content_product_variety_id_idx ( product_variety_id ) product_variety_idproduct_variety_id integer References ecommerce_product_variety ( product_variety_id -> id ) quantityquantity integer ecommerce_basket_content_price_id_idx ( price_id ) price_idprice_id integer References ecommerce_price ( price_id -> id ) other_dataother_data text product_type_idproduct_type_id smallint References ecommerce_product_type ( product_type_id -> id ) discountdiscount * numeric(12,5) default 0 ecommerce_offerTable public.ecommerce_offer Pk ecommerce_offer_pkey ( id ) idid * serial descriptiondescription text product_variety_idproduct_variety_id integer References ecommerce_product_variety ( product_variety_id -> id ) schedule_startschedule_start timestamp schedule_endschedule_end timestamp campaign_category_idcampaign_category_id integer References common_taxonomy_tree ( campaign_category_id -> id ) roundel_category_idroundel_category_id integer References common_taxonomy_tree ( roundel_category_id -> id ) price_idprice_id integer References ecommerce_price ( price_id -> id ) quantityquantity integer savingsaving integer createdcreated timestamp modifiedmodified timestamp other_dataother_data text offer_group_idoffer_group_id integer References ecommerce_offer_group ( offer_group_id -> id ) prioritypriority * integer default 0 ecommerce_offer_groupTable public.ecommerce_offer_group Pk ecommerce_offer_group_pkey ( id ) idid * serial Referred by ecommerce_offer ( offer_group_id -> id ) titletitle varchar(255) descriptiondescription text schedule_startschedule_start timestamp schedule_endschedule_end timestamp publishpublish * integer default 0 createdcreated timestamp modifiedmodified timestamp other_dataother_data text ecommerce_product_variety_imageTable public.ecommerce_product_variety_image Pk ecommerce_product_variety_image_pkey ( id ) idid * serial srcsrc varchar(255) rolerole varchar(255) ecommerce_product_variety_image_node_id_idx ( node_id ) node_idnode_id * integer References ecommerce_product_variety ( node_id -> id ) titletitle varchar(255) descriptiondescription text prioritypriority * integer default 0 modifiedmodified timestamp authorauthor integer contentcontent text other_dataother_data text link_to_node_idlink_to_node_id integer customer_idcustomer_id integer References client_customer ( customer_id -> id ) ecommerce_product_reviewTable public.ecommerce_product_review Pk ecommerce_product_review_pkey ( id ) idid * serial Referred by ecommerce_product_review ( parent -> id ) parentparent integer References ecommerce_product_review ( parent -> id ) ecommerce_product_review_node_id_key1 ( node_id ) node_idnode_id integer References ecommerce_product ( node_id -> id ) titletitle varchar(255) contentcontent text author_nameauthor_name varchar(255) author_emailauthor_email varchar(255) author_websiteauthor_website varchar(255) author_ip_addressauthor_ip_address varchar(255) customer_idcustomer_id * integer References client_customer ( customer_id -> id ) createdcreated timestamp default now() publishpublish smallint ratingrating smallint default 0 relation_subjectrelation_subject text ecommerce_product_to_productTable public.ecommerce_product_to_product Pk ecommerce_product_to_product_pkey ( id ) idid * serial Unq product_id_related_product_id_key ( product_id, related_product_id ) ecommerce_product_to_product_product_id_idx ( product_id ) product_idproduct_id integer References ecommerce_product ( product_id -> id ) Unq product_id_related_product_id_key ( product_id, related_product_id ) ecommerce_product_to_product_related_product_id_idx ( related_product_id ) related_product_idrelated_product_id integer References ecommerce_product ( related_product_id -> id ) ecommerce_promotionTable public.ecommerce_promotion Pk ecommerce_promotion_pkey ( id ) idid * serial Referred by ecommerce_promotion_code ( promotion_id -> id ) titletitle varchar(255) descriptiondescription text publishpublish * smallint default 1 createdcreated * timestamp default now() modifiedmodified * timestamp default now() customer_account_typecustomer_account_type * smallint default 0 code_patterncode_pattern * varchar(255) discount_fixed_valuediscount_fixed_value * numeric(12,5) default 0 discount_percentage_valuediscount_percentage_value * numeric(5,2) default 0 discount_free_deliverydiscount_free_delivery * smallint default 0 uses_per_couponuses_per_coupon * integer default 0 uses_per_customeruses_per_customer * smallint default 0 limit_list_productslimit_list_products text other_dataother_data text limit_delivery_country_idlimit_delivery_country_id * smallint default 0 limit_delivery_carrier_idlimit_delivery_carrier_id * smallint default 0 generated_by_order_idgenerated_by_order_id integer References ecommerce_order ( generated_by_order_id -> id ) generated_by_customer_idgenerated_by_customer_id integer References client_customer ( generated_by_customer_id -> id ) limit_by_customer_idlimit_by_customer_id integer default 0 References client_customer ( limit_by_customer_id -> id ) limit_to_first_orderlimit_to_first_order * smallint default 0 limit_to_order_amountlimit_to_order_amount numeric(12,5) default 0 typetype integer References ecommerce_promotion_type ( type -> id ) free_promo_productsfree_promo_products text limit_cumulative_discountlimit_cumulative_discount numeric(12,5) default 0 ecommerce_orderTable public.ecommerce_order Pk ecommerce_order_pkey ( id ) idid * serial Referred by ecommerce_delivery ( order_id -> id ) Referred by ecommerce_invoice ( order_id -> id ) Referred by ecommerce_order_log ( order_id -> id ) Referred by ecommerce_promotion ( generated_by_order_id -> id ) Referred by ecommerce_promotion_code ( order_id -> id ) Referred by ecommerce_transaction ( order_id -> id ) ecommerce_order_basket_id_idx ( basket_id ) basket_idbasket_id integer References ecommerce_basket ( basket_id -> id ) ecommerce_order_invoices_address_id_idx ( invoices_address_id ) invoices_address_idinvoices_address_id integer References client_address ( invoices_address_id -> id ) ecommerce_order_delivery_address_id_idx ( delivery_address_id ) delivery_address_iddelivery_address_id integer References client_address ( delivery_address_id -> id ) other_dataother_data text statusstatus integer note_customernote_customer text note_backofficenote_backoffice text php_session_idphp_session_id varchar(32) referrerreferrer varchar(255) payment_typepayment_type varchar(255) createdcreated timestamp default now() modifiedmodified timestamp default now() ecommerce_order_review_email_sent_idx ( review_email_sent ) review_email_sentreview_email_sent integer ecommerce_promotion_codeTable public.ecommerce_promotion_code Pk ecommerce_promotion_code_pkey ( id ) idid * serial promotion_idpromotion_id * integer References ecommerce_promotion ( promotion_id -> id ) codecode varchar(255) order_idorder_id * integer References ecommerce_order ( order_id -> id ) ecommerce_transactionTable public.ecommerce_transaction Pk ecommerce_transaction_pkey ( id ) idid * serial ecommerce_transaction_order_id_idx ( order_id ) order_idorder_id integer References ecommerce_order ( order_id -> id ) pg_datapg_data text currency_codecurrency_code char(3) amountamount numeric(12,5) createdcreated timestamp typetype varchar(255) statusstatus smallint ecommerce_order_logTable public.ecommerce_order_log Pk ecommerce_order_log_pkey ( id ) idid * serial ecommerce_order_log_order_id_idx ( order_id ) order_idorder_id integer References ecommerce_order ( order_id -> id ) ecommerce_order_log_status_idx ( status ) statusstatus integer datetimedatetime timestamp descriptiondescription text other_dataother_data text ecommerce_invoiceTable public.ecommerce_invoice Pk ecommerce_invoice_pkey ( id ) idid * serial order_idorder_id integer References ecommerce_order ( order_id -> id ) goods_netgoods_net numeric(12,5) goods_vatgoods_vat numeric(12,5) delivery_netdelivery_net numeric(12,5) delivery_vatdelivery_vat numeric(12,5) payment_amountpayment_amount numeric(12,5) payment_typepayment_type varchar(255) createdcreated * timestamp default now() modifiedmodified * timestamp default now() statusstatus smallint other_dataother_data text basket_detailbasket_detail text customer_namecustomer_name varchar(255) customer_emailcustomer_email varchar(255) address_invoiceaddress_invoice text address_deliveryaddress_delivery text face_value_voucherface_value_voucher numeric(12,5) basket_detail_enhancedbasket_detail_enhanced text ecommerce_promotion_typeTable public.ecommerce_promotion_type Pk ecommerce_promotion_type_pkey ( id ) idid * serial Referred by ecommerce_promotion ( type -> id ) titletitle varchar(255) descriptiondescription text taxabletaxable * smallint default 0 publishpublish * smallint default 1 createdcreated * timestamp default now() modifiedmodified * timestamp default now() other_dataother_data text client_customerTable public.client_customer Pk client_customer_pkey ( id ) idid * serial Referred by client_action ( customer_id -> id ) Referred by client_address ( customer_id -> id ) Referred by client_company ( customer_id -> id ) Referred by client_customer_group ( customer_id -> id ) Referred by client_customer_image ( node_id -> id ) Referred by client_customer_image ( customer_id -> id ) Referred by client_customer_role ( customer_id -> id ) Referred by client_customer_taxonomy ( node_id -> id ) Referred by client_customer_token ( customer_id -> id ) Referred by common_comment ( customer_id -> id ) Referred by common_file ( customer_id -> id ) Referred by common_image ( customer_id -> id ) Referred by common_node ( customer_id -> id ) Referred by common_session ( customer_id -> id ) Referred by common_session_archive ( customer_id -> id ) Referred by common_taxonomy_label_image ( customer_id -> id ) Referred by common_watchdog ( customer_id -> id ) Referred by ecommerce_basket ( customer_id -> id ) Referred by ecommerce_product_image ( customer_id -> id ) Referred by ecommerce_product_review ( customer_id -> id ) Referred by ecommerce_product_variety_image ( customer_id -> id ) Referred by ecommerce_promotion ( generated_by_customer_id -> id ) Referred by ecommerce_promotion ( limit_by_customer_id -> id ) Referred by ecommerce_recipe_image ( customer_id -> id ) Referred by ecommerce_recipe_review ( customer_id -> id ) Referred by ecommerce_store_image ( customer_id -> id ) Referred by education_survey_entry ( customer_id -> id ) Referred by education_survey_image ( customer_id -> id ) Referred by common_revision ( customer_id -> id ) title_beforetitle_before varchar(255) first_namefirst_name varchar(255) last_namelast_name varchar(255) title_aftertitle_after varchar(255) Unq client_customer_email_key ( email, deleted_date ) emailemail varchar(255) usernameusername varchar(255) telephonetelephone varchar(255) mobilephonemobilephone varchar(255) nicknamenickname varchar(255) passwordpassword varchar(255) company_idcompany_id integer invoices_address_idinvoices_address_id integer delivery_address_iddelivery_address_id integer gendergender char(1) createdcreated timestamp currency_codecurrency_code char(3) statusstatus smallint newsletternewsletter smallint birthdaybirthday date other_dataother_data text modifiedmodified timestamp account_typeaccount_type * smallint default 0 agreed_with_latest_t_and_cagreed_with_latest_t_and_c * smallint default 0 verified_email_addressverified_email_address * smallint default 0 oauthoauth text Unq client_customer_email_key ( email, deleted_date ) deleted_datedeleted_date timestamp facebook_idfacebook_id bigint twitter_idtwitter_id bigint google_idgoogle_id bigint profile_image_urlprofile_image_url text store_idstore_id integer References ecommerce_store ( store_id -> id ) janrain_idjanrain_id varchar(255) client_customer_tokenTable public.client_customer_token Pk client_customer_token_pkey ( id ) idid * serial customer_idcustomer_id * integer References client_customer ( customer_id -> id ) client_customer_token_publish_key ( publish ) publishpublish * smallint default 0 client_customer_token_key ( token ) tokentoken char(32) oauth_dataoauth_data text other_dataother_data text ttlttl integer ip_addressip_address varchar(255) http_user_agenthttp_user_agent varchar(255) createdcreated * timestamp modifiedmodified * timestamp common_sessionTable public.common_session Pk common_session_pkey ( id ) idid * serial common_session_session_id_idx ( session_id ) session_idsession_id varchar(32) session_datasession_data text customer_idcustomer_id integer References client_customer ( customer_id -> id ) createdcreated timestamp common_session_modified_idx ( modified ) modifiedmodified timestamp ip_addressip_address varchar(255) php_auth_userphp_auth_user varchar(255) http_refererhttp_referer text http_user_agenthttp_user_agent varchar(255) client_customer_groupTable public.client_customer_group Pk client_customer_group_pkey ( id ) idid * serial client_customer_group_group_id_key ( group_id ) group_idgroup_id * integer References client_group ( group_id -> id ) client_customer_group_customer_id_key ( customer_id ) customer_idcustomer_id * integer References client_customer ( customer_id -> id ) createdcreated * timestamp default now() modifiedmodified * timestamp default now() client_groupTable public.client_group Pk client_group_pkey ( id ) idid * serial Referred by client_customer_group ( group_id -> id ) namename varchar(255) descriptiondescription text search_filtersearch_filter text other_dataother_data text client_customer_roleTable public.client_customer_role Pk client_customer_role_pkey ( id ) idid * serial client_customer_role_role_id_key ( role_id ) role_idrole_id * integer References client_role ( role_id -> id ) client_customer_role_customer_id_key ( customer_id ) customer_idcustomer_id * integer References client_customer ( customer_id -> id ) createdcreated * timestamp default now() modifiedmodified * timestamp default now() client_roleTable public.client_role Pk client_role_pkey ( id ) idid * serial Referred by client_customer_role ( role_id -> id ) Referred by client_role_permission ( role_id -> id ) namename varchar(255) descriptiondescription text other_dataother_data text client_role_permissionTable public.client_role_permission Pk client_role_permission_pkey ( id ) idid * serial client_role_role_id_key ( role_id ) role_idrole_id * integer References client_role ( role_id -> id ) scopescope text createdcreated * timestamp default now() modifiedmodified * timestamp default now() other_dataother_data text resourceresource acl_resource operationoperation acl_operation client_actionTable public.client_action Pk client_action_pkey ( id ) idid * serial client_action_customer_id_key ( customer_id ) customer_idcustomer_id * integer References client_customer ( customer_id -> id ) node_idnode_id * integer References common_node ( node_id -> id ) action_idaction_id varchar(255) client_action_network_key ( network ) networknetwork varchar(255) action_nameaction_name varchar(255) object_nameobject_name varchar(255) createdcreated * timestamp modifiedmodified * timestamp other_dataother_data text client_companyTable public.client_company Pk client_company_pkey ( id ) idid * serial namename varchar(255) wwwwww varchar(255) telephonetelephone varchar(255) faxfax varchar(255) client_company_customer_id_idx ( customer_id ) customer_idcustomer_id integer References client_customer ( customer_id -> id ) registration_noregistration_no varchar(255) vat_novat_no varchar(255) other_dataother_data text client_customer_taxonomyTable public.client_customer_taxonomy Pk client_customer_taxonomy_pkey ( id ) idid * serial Unq client_customer_taxonomy_node_id_key ( node_id, taxonomy_tree_id ) client_customer_taxonomy_node_id_key1 ( node_id ) node_idnode_id * integer References client_customer ( node_id -> id ) Unq client_customer_taxonomy_node_id_key ( node_id, taxonomy_tree_id ) client_customer_taxonomy_taxonomy_tree_id_key ( taxonomy_tree_id ) taxonomy_tree_idtaxonomy_tree_id * integer References common_taxonomy_tree ( taxonomy_tree_id -> id ) ecommerce_product_taxonomyTable public.ecommerce_product_taxonomy Pk ecommerce_product_taxonomy_pkey ( id ) idid * serial Unq product_node_id_taxonomy_tree_id_key ( node_id, taxonomy_tree_id ) ecommerce_product_taxonomy_node_id_idx ( node_id ) node_idnode_id * integer References ecommerce_product ( node_id -> id ) Unq product_node_id_taxonomy_tree_id_key ( node_id, taxonomy_tree_id ) ecommerce_product_taxonomy_taxonomy_tree_id_idx ( taxonomy_tree_id ) taxonomy_tree_idtaxonomy_tree_id * integer References common_taxonomy_tree ( taxonomy_tree_id -> id ) common_taxonomy_labelTable public.common_taxonomy_label Pk common_taxonomy_label_pkey ( id ) idid * serial Referred by common_taxonomy_label_image ( node_id -> id ) Referred by common_taxonomy_tree ( label_id -> id ) titletitle * varchar(255) descriptiondescription text prioritypriority * integer default 0 publishpublish * integer default 1 common_taxonomy_label_imageTable public.common_taxonomy_label_image Pk common_taxonomy_label_image_pkey ( id ) idid * serial srcsrc varchar(255) rolerole varchar(255) node_idnode_id * integer References common_taxonomy_label ( node_id -> id ) titletitle varchar(255) descriptiondescription text prioritypriority * integer default 0 modifiedmodified timestamp authorauthor integer contentcontent text other_dataother_data text link_to_node_idlink_to_node_id integer customer_idcustomer_id integer References client_customer ( customer_id -> id ) common_imageTable public.common_image Pk common_image_pkey ( id ) idid * serial srcsrc varchar(255) rolerole varchar(255) common_image_node_id_idx ( node_id ) node_idnode_id * integer References common_node ( node_id -> id ) titletitle varchar(255) descriptiondescription text prioritypriority * integer default 0 modifiedmodified timestamp authorauthor integer contentcontent text other_dataother_data text link_to_node_idlink_to_node_id integer customer_idcustomer_id integer References client_customer ( customer_id -> id ) common_print_articleTable public.common_print_article Pk common_print_article_pkey ( id ) idid * serial srcsrc varchar(255) rolerole varchar(255) common_print_article_node_id_idx ( node_id ) node_idnode_id * integer References common_node ( node_id -> id ) titletitle * varchar(255) descriptiondescription text prioritypriority * integer default 0 modifiedmodified timestamp authorauthor integer typetype varchar(255) authorsauthors text issue_numberissue_number integer page_frompage_from integer datedate date otherother text common_fileTable public.common_file Pk common_file_pkey ( id ) idid * serial srcsrc varchar(255) rolerole varchar(255) common_file_node_id_idx ( node_id ) node_idnode_id * integer References common_node ( node_id -> id ) titletitle varchar(255) descriptiondescription text prioritypriority * integer default 0 modifiedmodified timestamp authorauthor integer contentcontent text other_dataother_data text link_to_node_idlink_to_node_id integer customer_idcustomer_id integer References client_customer ( customer_id -> id ) common_nodeTable public.common_node Pk common_node_pkey ( id ) idid * serial Referred by client_action ( node_id -> id ) Referred by common_comment ( node_id -> id ) Referred by common_configuration ( node_id -> id ) Referred by common_file ( node_id -> id ) Referred by common_image ( node_id -> id ) Referred by common_node ( link_to_node_id -> id ) Referred by common_node ( parent -> id ) Referred by common_node_taxonomy ( node_id -> id ) Referred by common_print_article ( node_id -> id ) Referred by common_uri_mapping ( node_id -> id ) Referred by international_translation ( node_id -> id ) titletitle * varchar(255) common_node_node_type_idx ( node_group ) node_groupnode_group * varchar(255) common_node_node_controller_idx ( node_controller ) node_controllernode_controller varchar(255) common_node_parent_idx ( parent ) parentparent integer References common_node ( parent -> id ) parent_containerparent_container * smallint default 0 prioritypriority * integer default 0 teaserteaser text contentcontent text descriptiondescription text keywordskeywords text page_titlepage_title varchar(255) headhead text createdcreated * timestamp default now() modifiedmodified * timestamp default now() common_node_publish_idx ( publish ) publishpublish * integer default 0 common_node_display_in_idx ( display_in_menu ) display_in_menudisplay_in_menu * smallint default 1 authorauthor * integer uri_titleuri_title varchar(255) display_permissiondisplay_permission * smallint default 0 other_dataother_data text css_classcss_class * varchar(255) default ''::character varying layout_stylelayout_style * varchar(255) default ''::character varying componentcomponent text relationsrelations text display_titledisplay_title smallint display_secondary_navigationdisplay_secondary_navigation smallint require_loginrequire_login smallint display_breadcrumbdisplay_breadcrumb * smallint default 0 browser_titlebrowser_title * varchar(255) default ''::character varying link_to_node_idlink_to_node_id * integer default 0 References common_node ( link_to_node_id -> id ) require_sslrequire_ssl * smallint default 0 display_permission_group_acldisplay_permission_group_acl text share_countershare_counter * integer default 0 customer_idcustomer_id integer References client_customer ( customer_id -> id ) ecommerce_priceTable public.ecommerce_price Pk ecommerce_price_pkey ( id ) idid * serial Referred by ecommerce_basket_content ( price_id -> id ) Referred by ecommerce_offer ( price_id -> id ) ecommerce_price_product_variety_id_idx ( product_variety_id ) product_variety_idproduct_variety_id integer References ecommerce_product_variety ( product_variety_id -> id ) ecommerce_price_currency_code_idx ( currency_code ) currency_codecurrency_code char(3) valuevalue numeric(12,5) ecommerce_price_type_idx ( type ) typetype varchar(255) datedate timestamp ecommerce_basketTable public.ecommerce_basket Pk ecommerce_basket_pkey ( id ) idid * serial Referred by ecommerce_basket_content ( basket_id -> id ) Referred by ecommerce_order ( basket_id -> id ) ecommerce_basket_customer_id_idx ( customer_id ) customer_idcustomer_id integer References client_customer ( customer_id -> id ) createdcreated timestamp notenote text ip_addressip_address varchar(255) face_value_voucherface_value_voucher * numeric(12,5) default 0 titletitle varchar(255) other_dataother_data text education_surveyTable public.education_survey Pk education_survey_pkey ( id ) idid * serial Referred by education_survey_entry ( survey_id -> id ) Referred by education_survey_image ( node_id -> id ) Referred by education_survey_question ( survey_id -> id ) titletitle * varchar(255) descriptiondescription text createdcreated * timestamp default now() modifiedmodified timestamp default now() prioritypriority smallint default 0 publishpublish smallint default 0 other_dataother_data text education_survey_imageTable public.education_survey_image Pk education_survey_image_pkey ( id ) idid * serial srcsrc varchar(255) rolerole varchar(255) education_survey_image_node_id_key ( node_id ) node_idnode_id * integer References education_survey ( node_id -> id ) titletitle varchar(255) descriptiondescription text prioritypriority * integer default 0 modifiedmodified timestamp authorauthor integer contentcontent text other_dataother_data text link_to_node_idlink_to_node_id integer customer_idcustomer_id integer References client_customer ( customer_id -> id ) education_survey_entryTable public.education_survey_entry Pk education_survey_entry_pkey ( id ) idid * serial Referred by education_survey_entry_answer ( survey_entry_id -> id ) Unq education_survey_entry_survey_id_key ( survey_id, customer_id, relation_subject ) survey_idsurvey_id * integer References education_survey ( survey_id -> id ) Unq education_survey_entry_survey_id_key ( survey_id, customer_id, relation_subject ) customer_idcustomer_id * integer References client_customer ( customer_id -> id ) Unq education_survey_entry_survey_id_key ( survey_id, customer_id, relation_subject ) relation_subjectrelation_subject text createdcreated * timestamp default now() modifiedmodified timestamp default now() publishpublish smallint default 0 ip_addressip_address varchar(255) session_idsession_id varchar(32) other_dataother_data text education_survey_entry_answerTable public.education_survey_entry_answer Pk education_survey_entry_answer_pkey ( id ) idid * serial survey_entry_idsurvey_entry_id * integer References education_survey_entry ( survey_entry_id -> id ) question_idquestion_id * integer References education_survey_question ( question_id -> id ) question_answer_idquestion_answer_id integer References education_survey_question_answer ( question_answer_id -> id ) valuevalue text createdcreated * timestamp default now() modifiedmodified timestamp default now() publishpublish smallint default 0 education_survey_question_answerTable public.education_survey_question_answer Pk education_survey_question_answer_pkey ( id ) idid * serial Referred by education_survey_entry_answer ( question_answer_id -> id ) question_idquestion_id * integer References education_survey_question ( question_id -> id ) titletitle * text descriptiondescription text is_correctis_correct smallint pointspoints smallint prioritypriority smallint default 0 publishpublish smallint default 1 contentcontent text other_dataother_data text education_survey_questionTable public.education_survey_question Pk education_survey_question_pkey ( id ) idid * serial Referred by education_survey_entry_answer ( question_id -> id ) Referred by education_survey_question ( parent -> id ) Referred by education_survey_question_answer ( question_id -> id ) survey_idsurvey_id * integer References education_survey ( survey_id -> id ) parentparent integer References education_survey_question ( parent -> id ) stepstep smallint default 1 titletitle * varchar(255) descriptiondescription text mandatorymandatory smallint default 1 typetype * varchar(255) prioritypriority smallint default 0 publishpublish smallint default 1 weightweight * real default 1 contentcontent text other_dataother_data text ecommerce_store_imageTable public.ecommerce_store_image Pk ecommerce_store_image_pkey ( id ) idid * serial srcsrc varchar(255) rolerole varchar(255) ecommerce_store_image_node_id_key ( node_id ) node_idnode_id * integer References ecommerce_store ( node_id -> id ) titletitle varchar(255) descriptiondescription text prioritypriority * integer default 0 modifiedmodified timestamp authorauthor integer contentcontent text other_dataother_data text link_to_node_idlink_to_node_id integer customer_idcustomer_id integer References client_customer ( customer_id -> id ) ecommerce_storeTable public.ecommerce_store Pk ecommerce_store_pkey ( id ) idid * serial Referred by client_customer ( store_id -> id ) Referred by ecommerce_store_image ( node_id -> id ) Referred by ecommerce_store_taxonomy ( node_id -> id ) titletitle varchar(255) descriptiondescription text addressaddress text opening_hoursopening_hours text telephonetelephone varchar(255) manager_namemanager_name varchar(255) emailemail varchar(255) type_idtype_id integer References ecommerce_store_type ( type_id -> id ) coordinates_xcoordinates_x integer coordinates_ycoordinates_y integer latitudelatitude float8 longitudelongitude float8 createdcreated * timestamp modifiedmodified * timestamp publishpublish * smallint default 0 other_dataother_data text street_view_optionsstreet_view_options text codecode varchar(255) country_idcountry_id integer References international_country ( country_id -> id ) address_nameaddress_name varchar(255) address_line_1address_line_1 varchar(255) address_line_2address_line_2 varchar(255) address_line_3address_line_3 varchar(255) address_cityaddress_city varchar(255) address_countyaddress_county varchar(255) address_post_codeaddress_post_code varchar(255) urlurl varchar(512) ecommerce_store_typeTable public.ecommerce_store_type Pk ecommerce_store_type_pkey ( id ) idid * serial Referred by ecommerce_store ( type_id -> id ) titletitle varchar(255) descriptiondescription text publishpublish * smallint default 1 createdcreated * timestamp default now() modifiedmodified * timestamp default now() other_dataother_data text ecommerce_store_taxonomyTable public.ecommerce_store_taxonomy Pk ecommerce_store_taxonomy_pkey ( id ) idid * serial Unq ecommerce_store_taxonomy_node_id_key ( node_id, taxonomy_tree_id ) ecommerce_store_taxonomy_node_id_key1 ( node_id ) node_idnode_id * integer References ecommerce_store ( node_id -> id ) Unq ecommerce_store_taxonomy_node_id_key ( node_id, taxonomy_tree_id ) ecommerce_store_taxonomy_taxonomy_tree_id_key ( taxonomy_tree_id ) taxonomy_tree_idtaxonomy_tree_id * integer References common_taxonomy_tree ( taxonomy_tree_id -> id ) ecommerce_recipe_taxonomyTable public.ecommerce_recipe_taxonomy Pk ecommerce_recipe_taxonomy_pkey ( id ) idid * serial Unq ecommerce_recipe_taxonomy_node_id_key ( node_id, taxonomy_tree_id ) ecommerce_recipe_taxonomy_node_id_key1 ( node_id ) node_idnode_id * integer References ecommerce_recipe ( node_id -> id ) Unq ecommerce_recipe_taxonomy_node_id_key ( node_id, taxonomy_tree_id ) ecommerce_recipe_taxonomy_taxonomy_tree_id_key ( taxonomy_tree_id ) taxonomy_tree_idtaxonomy_tree_id * integer References common_taxonomy_tree ( taxonomy_tree_id -> id ) ecommerce_recipe_ingredientsTable public.ecommerce_recipe_ingredients Pk ecommerce_recipe_ingredients_pkey ( id ) idid * serial recipe_idrecipe_id integer References ecommerce_recipe ( recipe_id -> id ) product_variety_idproduct_variety_id * integer References ecommerce_product_variety ( product_variety_id -> id ) quantityquantity real unitsunits integer References common_taxonomy_tree ( units -> id ) notesnotes text group_titlegroup_title varchar(255) ecommerce_recipeTable public.ecommerce_recipe Pk ecommerce_recipe_pkey ( id ) idid * serial Referred by ecommerce_recipe_image ( node_id -> id ) Referred by ecommerce_recipe_ingredients ( recipe_id -> id ) Referred by ecommerce_recipe_review ( node_id -> id ) Referred by ecommerce_recipe_taxonomy ( node_id -> id ) titletitle varchar(255) descriptiondescription text instructionsinstructions text video_urlvideo_url text serving_peopleserving_people integer preparation_timepreparation_time integer cooking_timecooking_time integer prioritypriority integer createdcreated timestamp modifiedmodified timestamp default now() publishpublish smallint other_dataother_data text ecommerce_recipe_reviewTable public.ecommerce_recipe_review Pk ecommerce_recipe_review_pkey ( id ) idid * serial Referred by ecommerce_recipe_review ( parent -> id ) parentparent integer References ecommerce_recipe_review ( parent -> id ) ecommerce_recipe_review_node_id_key1 ( node_id ) node_idnode_id integer References ecommerce_recipe ( node_id -> id ) titletitle varchar(255) contentcontent text author_nameauthor_name varchar(255) author_emailauthor_email varchar(255) author_websiteauthor_website varchar(255) author_ip_addressauthor_ip_address varchar(255) customer_idcustomer_id * integer References client_customer ( customer_id -> id ) createdcreated timestamp default now() publishpublish smallint ratingrating smallint default 0 relation_subjectrelation_subject text ecommerce_recipe_imageTable public.ecommerce_recipe_image Pk ecommerce_recipe_image_pkey ( id ) idid * serial srcsrc varchar(255) rolerole varchar(255) ecommerce_recipe_image_node_id_key ( node_id ) node_idnode_id * integer References ecommerce_recipe ( node_id -> id ) titletitle varchar(255) descriptiondescription text prioritypriority * integer default 0 modifiedmodified timestamp default now() authorauthor integer contentcontent text other_dataother_data text link_to_node_idlink_to_node_id integer customer_idcustomer_id integer References client_customer ( customer_id -> id ) common_taxonomy_treeTable public.common_taxonomy_tree Pk common_taxonomy_tree_pkey ( id ) idid * serial Referred by client_customer_taxonomy ( taxonomy_tree_id -> id ) Referred by common_node_taxonomy ( taxonomy_tree_id -> id ) Referred by common_taxonomy_tree ( parent -> id ) Referred by ecommerce_offer ( campaign_category_id -> id ) Referred by ecommerce_offer ( roundel_category_id -> id ) Referred by ecommerce_product_taxonomy ( taxonomy_tree_id -> id ) Referred by ecommerce_product_variety_taxonomy ( taxonomy_tree_id -> id ) Referred by ecommerce_recipe_ingredients ( units -> id ) Referred by ecommerce_recipe_taxonomy ( taxonomy_tree_id -> id ) Referred by ecommerce_store_taxonomy ( taxonomy_tree_id -> id ) common_taxonomy_tree_label_id_idx ( label_id ) label_idlabel_id * integer References common_taxonomy_label ( label_id -> id ) common_taxonomy_tree_parent_idx ( parent ) parentparent integer References common_taxonomy_tree ( parent -> id ) prioritypriority * smallint default 0 publishpublish * smallint default 1 ecommerce_delivery_carrier_zone_to_countryTable public.ecommerce_delivery_carrier_zone_to_country Pk ecommerce_delivery_carrier_zone_to_country_pkey ( id ) idid * serial Unq country_id_zone_id_key ( country_id, zone_id ) country_idcountry_id * integer References international_country ( country_id -> id ) Unq country_id_zone_id_key ( country_id, zone_id ) zone_idzone_id * integer References ecommerce_delivery_carrier_zone ( zone_id -> id ) ecommerce_delivery_carrier_zoneTable public.ecommerce_delivery_carrier_zone Pk ecommerce_delivery_carrier_zone_pkey ( id ) idid * serial Referred by ecommerce_delivery_carrier_zone_price ( zone_id -> id ) Referred by ecommerce_delivery_carrier_zone_to_country ( zone_id -> id ) namename varchar(255) carrier_idcarrier_id * integer default 1 References ecommerce_delivery_carrier ( carrier_id -> id ) ecommerce_delivery_carrier_zone_priceTable public.ecommerce_delivery_carrier_zone_price Pk ecommerce_delivery_carrier_zone_price_pkey ( id ) idid * serial zone_idzone_id * integer References ecommerce_delivery_carrier_zone ( zone_id -> id ) weightweight integer priceprice numeric(9,2) currency_codecurrency_code char(3) international_currencyTable public.international_currency Pk international_currency_pkey ( id ) idid * serial codecode char(3) namename * varchar(255) default ''::character varying symbol_leftsymbol_left varchar(255) symbol_rightsymbol_right varchar(255) international_currency_rateTable public.international_currency_rate Pk international_currency_rate_pkey ( id ) idid * serial currency_codecurrency_code char(3) currency_code_fromcurrency_code_from char(3) sourcesource varchar(255) datedate timestamp amountamount numeric(12,8) common_emailTable public.common_email Pk common_email_pkey ( id ) idid * serial email_fromemail_from varchar(255) name_fromname_from varchar(255) subjectsubject varchar(255) contentcontent text templatetemplate varchar(255) email_recipientemail_recipient varchar(255) name_recipientname_recipient varchar(255) createdcreated timestamp ipip varchar(255) common_schedulerTable public.common_scheduler Pk common_scheduler_pkey ( id ) idid * serial common_scheduler_node_id_key ( node_id ) node_idnode_id integer node_typenode_type varchar(255) controllercontroller varchar(255) parametersparameters text common_scheduler_scheduled_time_key ( scheduled_time ) scheduled_timescheduled_time timestamp common_scheduler_status_key ( status ) statusstatus smallint common_scheduler_lock_token_key ( lock_token ) lock_tokenlock_token integer resultresult text start_timestart_time timestamp completed_timecompleted_time timestamp createdcreated timestamp modifiedmodified timestamp default now() ecommerce_deliveryTable public.ecommerce_delivery Pk ecommerce_delivery_pkey ( id ) idid * serial order_idorder_id integer References ecommerce_order ( order_id -> id ) carrier_idcarrier_id integer References ecommerce_delivery_carrier ( carrier_id -> id ) value_netvalue_net numeric(12,5) vatvat numeric(12,5) vat_ratevat_rate numeric(12,5) required_datetimerequired_datetime timestamp note_customernote_customer text note_backofficenote_backoffice text other_dataother_data text weightweight * integer default 0 international_countryTable public.international_country Pk international_country_pkey ( id ) idid * serial Referred by client_address ( country_id -> id ) Referred by ecommerce_delivery_carrier_zone_to_country ( country_id -> id ) Referred by ecommerce_store ( country_id -> id ) namename varchar(255) iso_code2iso_code2 char(2) iso_code3iso_code3 char(3) eu_statuseu_status bool currency_codecurrency_code char(3) publishpublish smallint international_translationTable public.international_translation Pk international_translation_pkey ( id ) idid * serial international_translation_locale_idx ( locale ) localelocale * varchar(20) original_stringoriginal_string * text translated_stringtranslated_string * text contextcontext varchar(63) international_translation_node_id_idx ( node_id ) node_idnode_id integer References common_node ( node_id -> id ) ecommerce_delivery_carrierTable public.ecommerce_delivery_carrier Pk ecommerce_delivery_carrier_pkey ( id ) idid * serial Referred by ecommerce_delivery ( carrier_id -> id ) Referred by ecommerce_delivery_carrier_zone ( carrier_id -> id ) Referred by ecommerce_delivery_carrier_rate ( carrier_id -> id ) titletitle varchar(255) descriptiondescription text limit_list_countrieslimit_list_countries text limit_list_productslimit_list_products text limit_list_product_typeslimit_list_product_types text limit_order_valuelimit_order_value * numeric(12,5) default 0 fixed_valuefixed_value * numeric(12,5) default 0 fixed_percentagefixed_percentage * numeric(5,2) default 0 prioritypriority * smallint default 0 publishpublish * smallint default 1 free_delivery_mapfree_delivery_map text ecommerce_delivery_carrier_rateTable public.ecommerce_delivery_carrier_rate Pk ecommerce_delivery_carrier_rate_pkey ( id ) idid * serial ecommerce_delivery_carrier_rate_carrier_id_idx ( carrier_id ) carrier_idcarrier_id integer References ecommerce_delivery_carrier ( carrier_id -> id ) ecommerce_delivery_carrier_rate_weight_idx ( weight_from, weight_to ) weight_fromweight_from numeric(12,5) default 0 ecommerce_delivery_carrier_rate_weight_idx ( weight_from, weight_to ) weight_toweight_to numeric(12,5) default 0 priceprice numeric(12,5) client_customer_imageTable public.client_customer_image Pk client_customer_image_pkey ( id ) idid * serial srcsrc varchar(255) rolerole varchar(255) client_customer_image_node_id_key ( node_id ) node_idnode_id * integer References client_customer ( node_id -> id ) titletitle varchar(255) descriptiondescription text prioritypriority * integer default 0 modifiedmodified timestamp authorauthor integer contentcontent text other_dataother_data text link_to_node_idlink_to_node_id integer customer_idcustomer_id integer References client_customer ( customer_id -> id ) common_revisionTable public.common_revision Pk common_revision_pkey ( id ) idid * serial common_revision_combined_idx ( object, node_id ) objectobject * varchar(255) common_revision_combined_idx ( object, node_id ) node_idnode_id * integer contentcontent text statusstatus smallint customer_idcustomer_id integer References client_customer ( customer_id -> id ) createdcreated * timestamp default now() modifiedmodified * timestamp default now() other_dataother_data text

Table common_configuration
* id serial
* node_id integer DEFO 0
  object varchar( 255 )
  property varchar( 255 )
  value text
  description text
  apply_to_children smallint DEFO 0::smallint
Indexes
Pkcommon_configuration_pkey ON id
Foreign Keys
 common_configuration_node_id_fkey ( node_id ) ref common_node (id)


Table common_node_taxonomy
* id serial
* node_id integer
* taxonomy_tree_id integer
Indexes
Pkcommon_node_taxonomy_pkey ON id
Unode_node_id_taxonomy_tree_id_key ON node_id, taxonomy_tree_id
 common_node_taxonomy_node_id_idx ON node_id
 common_node_taxonomy_taxonomy_tree_id_idx ON taxonomy_tree_id
Foreign Keys
 common_node_taxonomy_node_id_fkey ( node_id ) ref common_node (id)
 common_node_taxonomy_taxonomy_tree_id_fkey ( taxonomy_tree_id ) ref common_taxonomy_tree (id)


Table common_uri_mapping
* id serial
  node_id integer
  public_uri text
  type varchar( 255 )
Indexes
Pkcommon_uri_mapping_pkey ON id
Ucommon_uri_mapping_public_uri_key ON public_uri
 common_uri_mapping_node_id_idx ON node_id
 common_uri_mapping_type_idx ON type
Foreign Keys
 common_uri_mapping_node_id_fkey ( node_id ) ref common_node (id)


Table common_comment
* id serial
  parent integer
  node_id integer
  title varchar( 255 )
  content text
  author_name varchar( 255 )
  author_email varchar( 255 )
  author_website varchar( 255 )
  author_ip_address varchar( 255 )
* customer_id integer
  created timestamp DEFO now()
  publish smallint
  rating smallint DEFO 0
  relation_subject text
Indexes
Pkcommon_comment_pkey ON id
 common_comment_costomer_id_id_idx ON customer_id
 common_comment_parent_idx ON parent
Foreign Keys
 common_comment_customer_id_fkey ( customer_id ) ref client_customer (id)
 common_comment_parent_fkey ( parent ) ref common_comment (id)
 common_comment_node_id_fkey ( node_id ) ref common_node (id)


Table ecommerce_product_variety
* id serial
  name varchar( 255 )
  product_id integer
  sku varchar( 255 )
  weight integer
  weight_gross integer
  stock integer
* priority integer DEFO 0
  description text
  other_data text
* width integer DEFO 0
* height integer DEFO 0
* depth integer DEFO 0
* diameter integer DEFO 0
* modified timestamp DEFO now()
* publish smallint DEFO 0
* display_permission integer DEFO 0
  ean13 varchar( 255 )
  upc varchar( 255 )
* condition smallint DEFO 0
  wholesale smallint
  reward_points integer
  subtitle varchar( 255 )
  product_type_id integer
  limit_to_delivery_zones varchar( 512 )
Indexes
Pkecommerce_product_variety_pkey ON id
Uecommerce_product_variety_code_key ON sku
 ecommerce_product_variety_product_id_idx ON product_id
Foreign Keys
 ecommerce_product_variety_product_id_fkey ( product_id ) ref ecommerce_product (id)
 ecommerce_product_variety_product_type_id_fkey ( product_type_id ) ref ecommerce_product_type (id)


Table ecommerce_product
* id serial
  name varchar( 255 )
  teaser text
  description text
  url text
* priority integer DEFO 0
* publish integer DEFO 0
  other_data text
* modified timestamp DEFO now()
* availability smallint DEFO 0
  name_aka varchar( 255 )
Indexes
Pkecommerce_product_pkey ON id
 ecommerce_product_publish_idx ON publish


Table ecommerce_product_variety_taxonomy
* id serial
* node_id integer
* taxonomy_tree_id integer
Indexes
Pkecommerce_product_variety_taxonomy_pkey ON id
Uproduct_variety_node_id_taxonomy_tree_id_key ON node_id, taxonomy_tree_id
 ecommerce_product_variety_taxonomy_node_id_idx ON node_id
 ecommerce_product_variety_taxonomy_taxonomy_tree_id_idx ON taxonomy_tree_id
Foreign Keys
 ecommerce_product_variety_taxonomy_taxonomy_tree_id_fkey ( taxonomy_tree_id ) ref common_taxonomy_tree (id)
 ecommerce_product_variety_taxonomy_node_id_fkey ( node_id ) ref ecommerce_product_variety (id)


Table common_session_archive
* id serial
  session_id varchar( 32 )
  session_data text
  customer_id integer
  created timestamp
  modified timestamp
  ip_address varchar( 255 )
  php_auth_user varchar( 255 )
  http_referer text
  http_user_agent varchar( 255 )
Indexes
Pkcommon_session_archive_pkey ON id
Foreign Keys
 common_session_archive_customer_id_fkey ( customer_id ) ref client_customer (id)


Table common_watchdog
* id serial
  name varchar( 255 )
  watched_item_id integer
  customer_id integer
  created timestamp
  modified timestamp DEFO now()
  publish smallint
  other_data text
Indexes
Pkcommon_watchdog_pkey ON id
 common_watchdog_combined_idx ON name, watched_item_id, publish
Foreign Keys
 common_watchdog_customer_id_fkey ( customer_id ) ref client_customer (id)


Table client_address
* id serial
  customer_id integer
  country_id integer
  name varchar( 255 )
  line_1 varchar( 255 )
  line_2 varchar( 255 )
  line_3 varchar( 255 )
  post_code varchar( 255 )
  city varchar( 255 )
  county varchar( 255 )
  telephone varchar( 255 )
  comment varchar( 255 )
  is_deleted bool DEFO false
Indexes
Pkclient_address_pkey ON id
 client_address_country_id_idx ON country_id
 client_address_customer_id_idx ON customer_id
Foreign Keys
 client_address_customer_id_fkey ( customer_id ) ref client_customer (id)
 client_address_country_id_fkey ( country_id ) ref international_country (id)


Table ecommerce_product_image
* id serial
  src varchar( 255 )
  role varchar( 255 )
* node_id integer
  title varchar( 255 )
  description text
* priority integer DEFO 0
  modified timestamp
  author integer
  content text
  other_data text
  link_to_node_id integer
  customer_id integer
Indexes
Pkecommerce_product_image_pkey ON id
 ecommerce_product_image_node_id_idx ON node_id
Foreign Keys
 ecommerce_product_image_customer_id_fkey ( customer_id ) ref client_customer (id)
 ecommerce_product_image_node_id_fkey ( node_id ) ref ecommerce_product (id)


Table ecommerce_product_type
* id serial
  name varchar( 255 )
* vat numeric DEFO 0
* publish integer DEFO 1
Indexes
Pkecommerce_product_type_pkey ON id


Table ecommerce_basket_content
* id serial
  basket_id integer
  product_variety_id integer
  quantity integer
  price_id integer
  other_data text
  product_type_id smallint
* discount numeric( 12, 5 ) DEFO 0
Indexes
Pkecommerce_basket_content_pkey ON id
 ecommerce_basket_content_basket_id_idx ON basket_id
 ecommerce_basket_content_price_id_idx ON price_id
 ecommerce_basket_content_product_variety_id_idx ON product_variety_id
Foreign Keys
 ecommerce_basket_content_basket_id_fkey ( basket_id ) ref ecommerce_basket (id)
 ecommerce_basket_content_price_id_fkey ( price_id ) ref ecommerce_price (id)
 ecommerce_basket_content_product_type_id_fkey ( product_type_id ) ref ecommerce_product_type (id)
 ecommerce_basket_content_product_variety_id_fkey ( product_variety_id ) ref ecommerce_product_variety (id)


Table ecommerce_offer
* id serial
  description text
  product_variety_id integer
  schedule_start timestamp
  schedule_end timestamp
  campaign_category_id integer
  roundel_category_id integer
  price_id integer
  quantity integer
  saving integer
  created timestamp
  modified timestamp
  other_data text
  offer_group_id integer
* priority integer DEFO 0
Indexes
Pkecommerce_offer_pkey ON id
Foreign Keys
 ecommerce_offer_campaign_category_id_fkey ( campaign_category_id ) ref common_taxonomy_tree (id)
 ecommerce_offer_roundel_category_id_fkey ( roundel_category_id ) ref common_taxonomy_tree (id)
 ecommerce_offer_offer_group_id_fkey ( offer_group_id ) ref ecommerce_offer_group (id)
 ecommerce_offer_price_id_fkey ( price_id ) ref ecommerce_price (id)
 ecommerce_offer_product_variety_id_fkey ( product_variety_id ) ref ecommerce_product_variety (id)


Table ecommerce_offer_group
* id serial
  title varchar( 255 )
  description text
  schedule_start timestamp
  schedule_end timestamp
* publish integer DEFO 0
  created timestamp
  modified timestamp
  other_data text
Indexes
Pkecommerce_offer_group_pkey ON id


Table ecommerce_product_variety_image
* id serial
  src varchar( 255 )
  role varchar( 255 )
* node_id integer
  title varchar( 255 )
  description text
* priority integer DEFO 0
  modified timestamp
  author integer
  content text
  other_data text
  link_to_node_id integer
  customer_id integer
Indexes
Pkecommerce_product_variety_image_pkey ON id
 ecommerce_product_variety_image_node_id_idx ON node_id
Foreign Keys
 ecommerce_product_variety_image_customer_id_fkey ( customer_id ) ref client_customer (id)
 ecommerce_product_variety_image_node_id_fkey ( node_id ) ref ecommerce_product_variety (id)


Table ecommerce_product_review
* id serial
  parent integer
  node_id integer
  title varchar( 255 )
  content text
  author_name varchar( 255 )
  author_email varchar( 255 )
  author_website varchar( 255 )
  author_ip_address varchar( 255 )
* customer_id integer
  created timestamp DEFO now()
  publish smallint
  rating smallint DEFO 0
  relation_subject text
Indexes
Pkecommerce_product_review_pkey ON id
 ecommerce_product_review_node_id_key1 ON node_id
Foreign Keys
 ecommerce_product_review_customer_id_fkey ( customer_id ) ref client_customer (id)
 ecommerce_product_review_node_id_fkey ( node_id ) ref ecommerce_product (id)
 ecommerce_product_review_parent_fkey ( parent ) ref ecommerce_product_review (id)


Table ecommerce_product_to_product
* id serial
  product_id integer
  related_product_id integer
Indexes
Pkecommerce_product_to_product_pkey ON id
Uproduct_id_related_product_id_key ON product_id, related_product_id
 ecommerce_product_to_product_product_id_idx ON product_id
 ecommerce_product_to_product_related_product_id_idx ON related_product_id
Foreign Keys
 ecommerce_product_to_product_product_id_fkey ( product_id ) ref ecommerce_product (id)
 ecommerce_product_to_product_related_product_id_fkey ( related_product_id ) ref ecommerce_product (id)


Table ecommerce_promotion
* id serial
  title varchar( 255 )
  description text
* publish smallint DEFO 1
* created timestamp DEFO now()
* modified timestamp DEFO now()
* customer_account_type smallint DEFO 0
* code_pattern varchar( 255 )
* discount_fixed_value numeric( 12, 5 ) DEFO 0
* discount_percentage_value numeric( 5, 2 ) DEFO 0
* discount_free_delivery smallint DEFO 0
* uses_per_coupon integer DEFO 0
* uses_per_customer smallint DEFO 0
  limit_list_products text
  other_data text
* limit_delivery_country_id smallint DEFO 0
* limit_delivery_carrier_id smallint DEFO 0
  generated_by_order_id integer
  generated_by_customer_id integer
  limit_by_customer_id integer DEFO 0
* limit_to_first_order smallint DEFO 0
  limit_to_order_amount numeric( 12, 5 ) DEFO 0
  type integer
  free_promo_products text
  limit_cumulative_discount numeric( 12, 5 ) DEFO 0
Indexes
Pkecommerce_promotion_pkey ON id
Foreign Keys
 ecommerce_promotion_generated_by_customer_id_fkey ( generated_by_customer_id ) ref client_customer (id)
 ecommerce_promotion_limit_by_customer_id_fkey ( limit_by_customer_id ) ref client_customer (id)
 ecommerce_promotion_generated_by_order_id_fkey ( generated_by_order_id ) ref ecommerce_order (id)
 ecommerce_promotion_type_fkey ( type ) ref ecommerce_promotion_type (id)


Table ecommerce_order
* id serial
  basket_id integer
  invoices_address_id integer
  delivery_address_id integer
  other_data text
  status integer
  note_customer text
  note_backoffice text
  php_session_id varchar( 32 )
  referrer varchar( 255 )
  payment_type varchar( 255 )
  created timestamp DEFO now()
  modified timestamp DEFO now()
  review_email_sent integer
Indexes
Pkecommerce_order_pkey ON id
 ecommerce_order_basket_id_idx ON basket_id
 ecommerce_order_delivery_address_id_idx ON delivery_address_id
 ecommerce_order_invoices_address_id_idx ON invoices_address_id
 ecommerce_order_review_email_sent_idx ON review_email_sent
Foreign Keys
 ecommerce_order_delivery_address_id_fkey ( delivery_address_id ) ref client_address (id)
 ecommerce_order_invoices_address_id_fkey ( invoices_address_id ) ref client_address (id)
 ecommerce_order_basket_id_fkey ( basket_id ) ref ecommerce_basket (id)


Table ecommerce_promotion_code
* id serial
* promotion_id integer
  code varchar( 255 )
* order_id integer
Indexes
Pkecommerce_promotion_code_pkey ON id
Foreign Keys
 ecommerce_promotion_code_order_id_fkey ( order_id ) ref ecommerce_order (id)
 ecommerce_promotion_code_promotion_id_fkey ( promotion_id ) ref ecommerce_promotion (id)


Table ecommerce_transaction
* id serial
  order_id integer
  pg_data text
  currency_code char( 3 )
  amount numeric( 12, 5 )
  created timestamp
  type varchar( 255 )
  status smallint
Indexes
Pkecommerce_transaction_pkey ON id
 ecommerce_transaction_order_id_idx ON order_id
Foreign Keys
 ecommerce_transaction_order_id_fkey ( order_id ) ref ecommerce_order (id)


Table ecommerce_order_log
* id serial
  order_id integer
  status integer
  datetime timestamp
  description text
  other_data text
Indexes
Pkecommerce_order_log_pkey ON id
 ecommerce_order_log_order_id_idx ON order_id
 ecommerce_order_log_status_idx ON status
Foreign Keys
 ecommerce_order_log_order_id_fkey ( order_id ) ref ecommerce_order (id)


Table ecommerce_invoice
* id serial
  order_id integer
  goods_net numeric( 12, 5 )
  goods_vat numeric( 12, 5 )
  delivery_net numeric( 12, 5 )
  delivery_vat numeric( 12, 5 )
  payment_amount numeric( 12, 5 )
  payment_type varchar( 255 )
* created timestamp DEFO now()
* modified timestamp DEFO now()
  status smallint
  other_data text
  basket_detail text
  customer_name varchar( 255 )
  customer_email varchar( 255 )
  address_invoice text
  address_delivery text
  face_value_voucher numeric( 12, 5 )
  basket_detail_enhanced text
Indexes
Pkecommerce_invoice_pkey ON id
Foreign Keys
 ecommerce_invoice_order_id_fkey ( order_id ) ref ecommerce_order (id)


Table ecommerce_promotion_type
* id serial
  title varchar( 255 )
  description text
* taxable smallint DEFO 0
* publish smallint DEFO 1
* created timestamp DEFO now()
* modified timestamp DEFO now()
  other_data text
Indexes
Pkecommerce_promotion_type_pkey ON id


Table client_customer
* id serial
  title_before varchar( 255 )
  first_name varchar( 255 )
  last_name varchar( 255 )
  title_after varchar( 255 )
  email varchar( 255 )
  username varchar( 255 )
  telephone varchar( 255 )
  mobilephone varchar( 255 )
  nickname varchar( 255 )
  password varchar( 255 )
  company_id integer
  invoices_address_id integer
  delivery_address_id integer
  gender char( 1 )
  created timestamp
  currency_code char( 3 )
  status smallint
  newsletter smallint
  birthday date
  other_data text
  modified timestamp
* account_type smallint DEFO 0
* agreed_with_latest_t_and_c smallint DEFO 0
* verified_email_address smallint DEFO 0
  oauth text
  deleted_date timestamp
  facebook_id bigint
  twitter_id bigint
  google_id bigint
  profile_image_url text
  store_id integer
  janrain_id varchar( 255 )
Indexes
Pkclient_customer_pkey ON id
Uclient_customer_email_key ON email, deleted_date
Foreign Keys
 client_customer_store_id_fkey ( store_id ) ref ecommerce_store (id)


Table client_customer_token
* id serial
* customer_id integer
* publish smallint DEFO 0
  token char( 32 )
  oauth_data text
  other_data text
  ttl integer
  ip_address varchar( 255 )
  http_user_agent varchar( 255 )
* created timestamp
* modified timestamp
Indexes
Pkclient_customer_token_pkey ON id
 client_customer_token_key ON token
 client_customer_token_publish_key ON publish
Foreign Keys
 client_customer_token_customer_id_fkey ( customer_id ) ref client_customer (id)


Table common_session
* id serial
  session_id varchar( 32 )
  session_data text
  customer_id integer
  created timestamp
  modified timestamp
  ip_address varchar( 255 )
  php_auth_user varchar( 255 )
  http_referer text
  http_user_agent varchar( 255 )
Indexes
Pkcommon_session_pkey ON id
 common_session_modified_idx ON modified
 common_session_session_id_idx ON session_id
Foreign Keys
 common_session_customer_id_fkey ( customer_id ) ref client_customer (id)


Table client_customer_group
* id serial
* group_id integer
* customer_id integer
* created timestamp DEFO now()
* modified timestamp DEFO now()
Indexes
Pkclient_customer_group_pkey ON id
 client_customer_group_customer_id_key ON customer_id
 client_customer_group_group_id_key ON group_id
Foreign Keys
 client_customer_group_customer_id_fkey ( customer_id ) ref client_customer (id)
 client_customer_group_group_id_fkey ( group_id ) ref client_group (id)


Table client_group
* id serial
  name varchar( 255 )
  description text
  search_filter text
  other_data text
Indexes
Pkclient_group_pkey ON id


Table client_customer_role
* id serial
* role_id integer
* customer_id integer
* created timestamp DEFO now()
* modified timestamp DEFO now()
Indexes
Pkclient_customer_role_pkey ON id
 client_customer_role_customer_id_key ON customer_id
 client_customer_role_role_id_key ON role_id
Foreign Keys
 client_customer_role_customer_id_fkey ( customer_id ) ref client_customer (id)
 client_customer_role_role_id_fkey ( role_id ) ref client_role (id)


Table client_role
* id serial
  name varchar( 255 )
  description text
  other_data text
Indexes
Pkclient_role_pkey ON id


Table client_role_permission
* id serial
* role_id integer
  scope text
* created timestamp DEFO now()
* modified timestamp DEFO now()
  other_data text
  resource acl_resource
  operation acl_operation
Indexes
Pkclient_role_permission_pkey ON id
 client_role_role_id_key ON role_id
Foreign Keys
 client_role_permission_role_id_fkey ( role_id ) ref client_role (id)


Table client_action
* id serial
* customer_id integer
* node_id integer
  action_id varchar( 255 )
  network varchar( 255 )
  action_name varchar( 255 )
  object_name varchar( 255 )
* created timestamp
* modified timestamp
  other_data text
Indexes
Pkclient_action_pkey ON id
 client_action_customer_id_key ON customer_id
 client_action_network_key ON network
Foreign Keys
 client_action_customer_id_fkey ( customer_id ) ref client_customer (id)
 client_action_node_id_fkey ( node_id ) ref common_node (id)


Table client_company
* id serial
  name varchar( 255 )
  www varchar( 255 )
  telephone varchar( 255 )
  fax varchar( 255 )
  customer_id integer
  registration_no varchar( 255 )
  vat_no varchar( 255 )
  other_data text
Indexes
Pkclient_company_pkey ON id
 client_company_customer_id_idx ON customer_id
Foreign Keys
 client_company_customer_id_fkey ( customer_id ) ref client_customer (id)


Table client_customer_taxonomy
* id serial
* node_id integer
* taxonomy_tree_id integer
Indexes
Pkclient_customer_taxonomy_pkey ON id
Uclient_customer_taxonomy_node_id_key ON node_id, taxonomy_tree_id
 client_customer_taxonomy_node_id_key1 ON node_id
 client_customer_taxonomy_taxonomy_tree_id_key ON taxonomy_tree_id
Foreign Keys
 client_customer_taxonomy_customer_fkey ( node_id ) ref client_customer (id)
 client_customer_taxonomy_taxonomy_fkey ( taxonomy_tree_id ) ref common_taxonomy_tree (id)


Table ecommerce_product_taxonomy
* id serial
* node_id integer
* taxonomy_tree_id integer
Indexes
Pkecommerce_product_taxonomy_pkey ON id
Uproduct_node_id_taxonomy_tree_id_key ON node_id, taxonomy_tree_id
 ecommerce_product_taxonomy_node_id_idx ON node_id
 ecommerce_product_taxonomy_taxonomy_tree_id_idx ON taxonomy_tree_id
Foreign Keys
 ecommerce_product_taxonomy_taxonomy_tree_id_fkey ( taxonomy_tree_id ) ref common_taxonomy_tree (id)
 ecommerce_product_taxonomy_node_id_fkey ( node_id ) ref ecommerce_product (id)


Table common_taxonomy_label
* id serial
* title varchar( 255 )
  description text
* priority integer DEFO 0
* publish integer DEFO 1
Indexes
Pkcommon_taxonomy_label_pkey ON id


Table common_taxonomy_label_image
* id serial
  src varchar( 255 )
  role varchar( 255 )
* node_id integer
  title varchar( 255 )
  description text
* priority integer DEFO 0
  modified timestamp
  author integer
  content text
  other_data text
  link_to_node_id integer
  customer_id integer
Indexes
Pkcommon_taxonomy_label_image_pkey ON id
Foreign Keys
 common_taxonomy_label_image_customer_id_fkey ( customer_id ) ref client_customer (id)
 common_taxonomy_label_image_node_id_fkey ( node_id ) ref common_taxonomy_label (id)


Table common_image
* id serial
  src varchar( 255 )
  role varchar( 255 )
* node_id integer
  title varchar( 255 )
  description text
* priority integer DEFO 0
  modified timestamp
  author integer
  content text
  other_data text
  link_to_node_id integer
  customer_id integer
Indexes
Pkcommon_image_pkey ON id
 common_image_node_id_idx ON node_id
Foreign Keys
 common_image_customer_id_fkey ( customer_id ) ref client_customer (id)
 common_image_node_id_fkey ( node_id ) ref common_node (id)


Table common_print_article
* id serial
  src varchar( 255 )
  role varchar( 255 )
* node_id integer
* title varchar( 255 )
  description text
* priority integer DEFO 0
  modified timestamp
  author integer
  type varchar( 255 )
  authors text
  issue_number integer
  page_from integer
  date date
  other text
Indexes
Pkcommon_print_article_pkey ON id
 common_print_article_node_id_idx ON node_id
Foreign Keys
 common_print_article_node_id_fkey ( node_id ) ref common_node (id)


Table common_file
* id serial
  src varchar( 255 )
  role varchar( 255 )
* node_id integer
  title varchar( 255 )
  description text
* priority integer DEFO 0
  modified timestamp
  author integer
  content text
  other_data text
  link_to_node_id integer
  customer_id integer
Indexes
Pkcommon_file_pkey ON id
 common_file_node_id_idx ON node_id
Foreign Keys
 common_file_customer_id_fkey ( customer_id ) ref client_customer (id)
 common_file_node_id_fkey ( node_id ) ref common_node (id)


Table common_node
* id serial
* title varchar( 255 )
* node_group varchar( 255 )
  node_controller varchar( 255 )
  parent integer
* parent_container smallint DEFO 0
* priority integer DEFO 0
  teaser text
  content text
  description text
  keywords text
  page_title varchar( 255 )
  head text
* created timestamp DEFO now()
* modified timestamp DEFO now()
* publish integer DEFO 0
* display_in_menu smallint DEFO 1
* author integer
  uri_title varchar( 255 )
* display_permission smallint DEFO 0
  other_data text
* css_class varchar( 255 ) DEFO ''::character varying
* layout_style varchar( 255 ) DEFO ''::character varying
  component text
  relations text
  display_title smallint
  display_secondary_navigation smallint
  require_login smallint
* display_breadcrumb smallint DEFO 0
* browser_title varchar( 255 ) DEFO ''::character varying
* link_to_node_id integer DEFO 0
* require_ssl smallint DEFO 0
  display_permission_group_acl text
* share_counter integer DEFO 0
  customer_id integer
Indexes
Pkcommon_node_pkey ON id
 common_node_display_in_idx ON display_in_menu
 common_node_node_controller_idx ON node_controller
 common_node_node_type_idx ON node_group
 common_node_parent_idx ON parent
 common_node_publish_idx ON publish
Foreign Keys
 common_node_customer_id_fkey ( customer_id ) ref client_customer (id)
 common_node_link_to_node_id_fkey ( link_to_node_id ) ref common_node (id)
 common_node_parent_fkey ( parent ) ref common_node (id)


Table ecommerce_price
* id serial
  product_variety_id integer
  currency_code char( 3 )
  value numeric( 12, 5 )
  type varchar( 255 )
  date timestamp
Indexes
Pkecommerce_price_pkey ON id
 ecommerce_price_currency_code_idx ON currency_code
 ecommerce_price_product_variety_id_idx ON product_variety_id
 ecommerce_price_type_idx ON type
Foreign Keys
 ecommerce_price_product_variety_id_fkey ( product_variety_id ) ref ecommerce_product_variety (id)


Table ecommerce_basket
* id serial
  customer_id integer
  created timestamp
  note text
  ip_address varchar( 255 )
* face_value_voucher numeric( 12, 5 ) DEFO 0
  title varchar( 255 )
  other_data text
Indexes
Pkecommerce_basket_pkey ON id
 ecommerce_basket_customer_id_idx ON customer_id
Foreign Keys
 ecommerce_basket_customer_id_fkey ( customer_id ) ref client_customer (id)


Table education_survey
* id serial
* title varchar( 255 )
  description text
* created timestamp DEFO now()
  modified timestamp DEFO now()
  priority smallint DEFO 0
  publish smallint DEFO 0
  other_data text
Indexes
Pkeducation_survey_pkey ON id


Table education_survey_image
* id serial
  src varchar( 255 )
  role varchar( 255 )
* node_id integer
  title varchar( 255 )
  description text
* priority integer DEFO 0
  modified timestamp
  author integer
  content text
  other_data text
  link_to_node_id integer
  customer_id integer
Indexes
Pkeducation_survey_image_pkey ON id
 education_survey_image_node_id_key ON node_id
Foreign Keys
 education_survey_image_customer_id_fkey ( customer_id ) ref client_customer (id)
 education_survey_image_node_id_fkey ( node_id ) ref education_survey (id)


Table education_survey_entry
* id serial
* survey_id integer
* customer_id integer
  relation_subject text
* created timestamp DEFO now()
  modified timestamp DEFO now()
  publish smallint DEFO 0
  ip_address varchar( 255 )
  session_id varchar( 32 )
  other_data text
Indexes
Pkeducation_survey_entry_pkey ON id
Ueducation_survey_entry_survey_id_key ON survey_id, customer_id, relation_subject
Foreign Keys
 education_survey_entry_customer_id_fkey ( customer_id ) ref client_customer (id)
 education_survey_entry_survey_id_fkey ( survey_id ) ref education_survey (id)


Table education_survey_entry_answer
* id serial
* survey_entry_id integer
* question_id integer
  question_answer_id integer
  value text
* created timestamp DEFO now()
  modified timestamp DEFO now()
  publish smallint DEFO 0
Indexes
Pkeducation_survey_entry_answer_pkey ON id
Foreign Keys
 education_survey_entry_answer_survey_entry_id_fkey ( survey_entry_id ) ref education_survey_entry (id)
 education_survey_entry_answer_question_id_fkey ( question_id ) ref education_survey_question (id)
 education_survey_entry_answer_question_answer_id_fkey ( question_answer_id ) ref education_survey_question_answer (id)


Table education_survey_question_answer
* id serial
* question_id integer
* title text
  description text
  is_correct smallint
  points smallint
  priority smallint DEFO 0
  publish smallint DEFO 1
  content text
  other_data text
Indexes
Pkeducation_survey_question_answer_pkey ON id
Foreign Keys
 education_survey_question_answer_question_id_fkey ( question_id ) ref education_survey_question (id)


Table education_survey_question
* id serial
* survey_id integer
  parent integer
  step smallint DEFO 1
* title varchar( 255 )
  description text
  mandatory smallint DEFO 1
* type varchar( 255 )
  priority smallint DEFO 0
  publish smallint DEFO 1
* weight real DEFO 1
  content text
  other_data text
Indexes
Pkeducation_survey_question_pkey ON id
Foreign Keys
 education_survey_question_survey_id_fkey ( survey_id ) ref education_survey (id)
 education_survey_question_parent_fkey ( parent ) ref education_survey_question (id)


Table ecommerce_store_image
* id serial
  src varchar( 255 )
  role varchar( 255 )
* node_id integer
  title varchar( 255 )
  description text
* priority integer DEFO 0
  modified timestamp
  author integer
  content text
  other_data text
  link_to_node_id integer
  customer_id integer
Indexes
Pkecommerce_store_image_pkey ON id
 ecommerce_store_image_node_id_key ON node_id
Foreign Keys
 ecommerce_store_image_customer_id_fkey ( customer_id ) ref client_customer (id)
 ecommerce_store_image_store_fkey ( node_id ) ref ecommerce_store (id)


Table ecommerce_store
* id serial
  title varchar( 255 )
  description text
  address text
  opening_hours text
  telephone varchar( 255 )
  manager_name varchar( 255 )
  email varchar( 255 )
  type_id integer
  coordinates_x integer
  coordinates_y integer
  latitude float8
  longitude float8
* created timestamp
* modified timestamp
* publish smallint DEFO 0
  other_data text
  street_view_options text
  code varchar( 255 )
  country_id integer
  address_name varchar( 255 )
  address_line_1 varchar( 255 )
  address_line_2 varchar( 255 )
  address_line_3 varchar( 255 )
  address_city varchar( 255 )
  address_county varchar( 255 )
  address_post_code varchar( 255 )
  url varchar( 512 )
Indexes
Pkecommerce_store_pkey ON id
Foreign Keys
 ecommerce_store_type_id_fkey ( type_id ) ref ecommerce_store_type (id)
 ecommerce_store_country_id_fkey ( country_id ) ref international_country (id)


Table ecommerce_store_type
* id serial
  title varchar( 255 )
  description text
* publish smallint DEFO 1
* created timestamp DEFO now()
* modified timestamp DEFO now()
  other_data text
Indexes
Pkecommerce_store_type_pkey ON id


Table ecommerce_store_taxonomy
* id serial
* node_id integer
* taxonomy_tree_id integer
Indexes
Pkecommerce_store_taxonomy_pkey ON id
Uecommerce_store_taxonomy_node_id_key ON node_id, taxonomy_tree_id
 ecommerce_store_taxonomy_node_id_key1 ON node_id
 ecommerce_store_taxonomy_taxonomy_tree_id_key ON taxonomy_tree_id
Foreign Keys
 ecommerce_store_taxonomy_taxonomy_fkey ( taxonomy_tree_id ) ref common_taxonomy_tree (id)
 ecommerce_store_taxonomy_store_fkey ( node_id ) ref ecommerce_store (id)


Table ecommerce_recipe_taxonomy
* id serial
* node_id integer
* taxonomy_tree_id integer
Indexes
Pkecommerce_recipe_taxonomy_pkey ON id
Uecommerce_recipe_taxonomy_node_id_key ON node_id, taxonomy_tree_id
 ecommerce_recipe_taxonomy_node_id_key1 ON node_id
 ecommerce_recipe_taxonomy_taxonomy_tree_id_key ON taxonomy_tree_id
Foreign Keys
 ecommerce_recipe_taxonomy_taxonmy_fkey ( taxonomy_tree_id ) ref common_taxonomy_tree (id)
 ecommerce_recipe_taxonomy_recipe_fkey ( node_id ) ref ecommerce_recipe (id)


Table ecommerce_recipe_ingredients
* id serial
  recipe_id integer
* product_variety_id integer
  quantity real
  units integer
  notes text
  group_title varchar( 255 )
Indexes
Pkecommerce_recipe_ingredients_pkey ON id
Foreign Keys
 ecommerce_recipe_ingredients_units_fkey ( units ) ref common_taxonomy_tree (id)
 ecommerce_recipe_ingredients_product_variety_id_fkey ( product_variety_id ) ref ecommerce_product_variety (id)
 ecommerce_recipe_ingredients_recipe_fkey ( recipe_id ) ref ecommerce_recipe (id)


Table ecommerce_recipe
* id serial
  title varchar( 255 )
  description text
  instructions text
  video_url text
  serving_people integer
  preparation_time integer
  cooking_time integer
  priority integer
  created timestamp
  modified timestamp DEFO now()
  publish smallint
  other_data text
Indexes
Pkecommerce_recipe_pkey ON id


Table ecommerce_recipe_review
* id serial
  parent integer
  node_id integer
  title varchar( 255 )
  content text
  author_name varchar( 255 )
  author_email varchar( 255 )
  author_website varchar( 255 )
  author_ip_address varchar( 255 )
* customer_id integer
  created timestamp DEFO now()
  publish smallint
  rating smallint DEFO 0
  relation_subject text
Indexes
Pkecommerce_recipe_review_pkey ON id
 ecommerce_recipe_review_node_id_key1 ON node_id
Foreign Keys
 ecommerce_recipe_review_customer_id_fkey ( customer_id ) ref client_customer (id)
 ecommerce_recipe_review_node_id_fkey ( node_id ) ref ecommerce_recipe (id)
 ecommerce_recipe_review_parent_fkey ( parent ) ref ecommerce_recipe_review (id)


Table ecommerce_recipe_image
* id serial
  src varchar( 255 )
  role varchar( 255 )
* node_id integer
  title varchar( 255 )
  description text
* priority integer DEFO 0
  modified timestamp DEFO now()
  author integer
  content text
  other_data text
  link_to_node_id integer
  customer_id integer
Indexes
Pkecommerce_recipe_image_pkey ON id
 ecommerce_recipe_image_node_id_key ON node_id
Foreign Keys
 ecommerce_recipe_image_customer_id_fkey ( customer_id ) ref client_customer (id)
 ecommerce_recipe_node_id_fkey ( node_id ) ref ecommerce_recipe (id)


Table common_taxonomy_tree
* id serial
* label_id integer
  parent integer
* priority smallint DEFO 0
* publish smallint DEFO 1
Indexes
Pkcommon_taxonomy_tree_pkey ON id
 common_taxonomy_tree_label_id_idx ON label_id
 common_taxonomy_tree_parent_idx ON parent
Foreign Keys
 common_taxonomy_tree_label_id_fkey ( label_id ) ref common_taxonomy_label (id)
 common_taxonomy_tree_parent_fkey ( parent ) ref common_taxonomy_tree (id)


Table ecommerce_delivery_carrier_zone_to_country
* id serial
* country_id integer
* zone_id integer
Indexes
Pkecommerce_delivery_carrier_zone_to_country_pkey ON id
Ucountry_id_zone_id_key ON country_id, zone_id
Foreign Keys
 ecommerce_delivery_carrier_country_to_zone_zone_id_fkey ( zone_id ) ref ecommerce_delivery_carrier_zone (id)
 ecommerce_delivery_carrier_country_to_zone_country_id_fkey ( country_id ) ref international_country (id)


Table ecommerce_delivery_carrier_zone
* id serial
  name varchar( 255 )
* carrier_id integer DEFO 1
Indexes
Pkecommerce_delivery_carrier_zone_pkey ON id
Foreign Keys
 ecommerce_delivery_carrier_zone_carrier_id_fkey ( carrier_id ) ref ecommerce_delivery_carrier (id)


Table ecommerce_delivery_carrier_zone_price
* id serial
* zone_id integer
  weight integer
  price numeric( 9, 2 )
  currency_code char( 3 )
Indexes
Pkecommerce_delivery_carrier_zone_price_pkey ON id
Foreign Keys
 ecommerce_delivery_carrier_zone_price_zone_id_fkey ( zone_id ) ref ecommerce_delivery_carrier_zone (id)


Table international_currency
* id serial
  code char( 3 )
* name varchar( 255 ) DEFO ''::character varying
  symbol_left varchar( 255 )
  symbol_right varchar( 255 )
Indexes
Pkinternational_currency_pkey ON id


Table international_currency_rate
* id serial
  currency_code char( 3 )
  currency_code_from char( 3 )
  source varchar( 255 )
  date timestamp
  amount numeric( 12, 8 )
Indexes
Pkinternational_currency_rate_pkey ON id


Table common_email
* id serial
  email_from varchar( 255 )
  name_from varchar( 255 )
  subject varchar( 255 )
  content text
  template varchar( 255 )
  email_recipient varchar( 255 )
  name_recipient varchar( 255 )
  created timestamp
  ip varchar( 255 )
Indexes
Pkcommon_email_pkey ON id


Table common_scheduler
* id serial
  node_id integer
  node_type varchar( 255 )
  controller varchar( 255 )
  parameters text
  scheduled_time timestamp
  status smallint
  lock_token integer
  result text
  start_time timestamp
  completed_time timestamp
  created timestamp
  modified timestamp DEFO now()
Indexes
Pkcommon_scheduler_pkey ON id
 common_scheduler_lock_token_key ON lock_token
 common_scheduler_node_id_key ON node_id
 common_scheduler_scheduled_time_key ON scheduled_time
 common_scheduler_status_key ON status


Table ecommerce_delivery
* id serial
  order_id integer
  carrier_id integer
  value_net numeric( 12, 5 )
  vat numeric( 12, 5 )
  vat_rate numeric( 12, 5 )
  required_datetime timestamp
  note_customer text
  note_backoffice text
  other_data text
* weight integer DEFO 0
Indexes
Pkecommerce_delivery_pkey ON id
Foreign Keys
 ecommerce_delivery_carrier_id_fkey ( carrier_id ) ref ecommerce_delivery_carrier (id)
 ecommerce_delivery_order_id_fkey ( order_id ) ref ecommerce_order (id)


Table international_country
* id serial
  name varchar( 255 )
  iso_code2 char( 2 )
  iso_code3 char( 3 )
  eu_status bool
  currency_code char( 3 )
  publish smallint
Indexes
Pkinternational_country_pkey ON id


Table international_translation
* id serial
* locale varchar( 20 )
* original_string text
* translated_string text
  context varchar( 63 )
  node_id integer
Indexes
Pkinternational_translation_pkey ON id
 international_translation_locale_idx ON locale
 international_translation_node_id_idx ON node_id
Foreign Keys
 international_translation_node_id_fkey ( node_id ) ref common_node (id)


Table ecommerce_delivery_carrier
* id serial
  title varchar( 255 )
  description text
  limit_list_countries text
  limit_list_products text
  limit_list_product_types text
* limit_order_value numeric( 12, 5 ) DEFO 0
* fixed_value numeric( 12, 5 ) DEFO 0
* fixed_percentage numeric( 5, 2 ) DEFO 0
* priority smallint DEFO 0
* publish smallint DEFO 1
  free_delivery_map text
Indexes
Pkecommerce_delivery_carrier_pkey ON id


Table ecommerce_delivery_carrier_rate
* id serial
  carrier_id integer
  weight_from numeric( 12, 5 ) DEFO 0
  weight_to numeric( 12, 5 ) DEFO 0
  price numeric( 12, 5 )
Indexes
Pkecommerce_delivery_carrier_rate_pkey ON id
 ecommerce_delivery_carrier_rate_carrier_id_idx ON carrier_id
 ecommerce_delivery_carrier_rate_weight_idx ON weight_from, weight_to
Foreign Keys
 ecommerce_delivery_carrier_rate_carrier_id_fkey ( carrier_id ) ref ecommerce_delivery_carrier (id)


Table client_customer_image
* id serial
  src varchar( 255 )
  role varchar( 255 )
* node_id integer
  title varchar( 255 )
  description text
* priority integer DEFO 0
  modified timestamp
  author integer
  content text
  other_data text
  link_to_node_id integer
  customer_id integer
Indexes
Pkclient_customer_image_pkey ON id
 client_customer_image_node_id_key ON node_id
Foreign Keys
 client_customer_image_customer_fkey ( node_id ) ref client_customer (id)
 client_customer_image_customer_id_fkey ( customer_id ) ref client_customer (id)


Table common_revision
* id serial
* object varchar( 255 )
* node_id integer
  content text
  status smallint
  customer_id integer
* created timestamp DEFO now()
* modified timestamp DEFO now()
  other_data text
Indexes
Pkcommon_revision_pkey ON id
 common_revision_combined_idx ON object, node_id
Foreign Keys
 common_revision_customer_id_fkey ( customer_id ) ref client_customer (id)