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
Pk	common_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
Pk	common_node_taxonomy_pkey	ON id
U	node_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
Pk	common_uri_mapping_pkey	ON id
U	common_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
Pk	common_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
Pk	ecommerce_product_variety_pkey	ON id
U	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_product_variety_taxonomy_pkey	ON id
U	product_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
Pk	common_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
Pk	common_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
Pk	client_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_product_to_product_pkey	ON id
U	product_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	client_customer_pkey	ON id
U	client_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
Pk	client_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
Pk	common_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
Pk	client_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
Pk	client_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
Pk	client_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
Pk	client_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
Pk	client_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
Pk	client_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
Pk	client_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
Pk	client_customer_taxonomy_pkey	ON id
U	client_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
Pk	ecommerce_product_taxonomy_pkey	ON id
U	product_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
Pk	common_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
Pk	common_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
Pk	common_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
Pk	common_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
Pk	common_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
Pk	common_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	education_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
Pk	education_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
Pk	education_survey_entry_pkey	ON id
U	education_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
Pk	education_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
Pk	education_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
Pk	education_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_store_type_pkey	ON id

Table ecommerce_store_taxonomy
*	id	serial
*	node_id	integer
*	taxonomy_tree_id	integer
Indexes
Pk	ecommerce_store_taxonomy_pkey	ON id
U	ecommerce_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
Pk	ecommerce_recipe_taxonomy_pkey	ON id
U	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	common_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
Pk	ecommerce_delivery_carrier_zone_to_country_pkey	ON id
U	country_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	international_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
Pk	international_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
Pk	common_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
Pk	common_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
Pk	ecommerce_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
Pk	international_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
Pk	international_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
Pk	ecommerce_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
Pk	ecommerce_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
Pk	client_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
Pk	common_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)