4 Data model

Table: acl_classes

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
class_type	VARCHAR(200)	Not null, Unique

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_69DD750638A36066	class_type	UNIQUE

Table: acl_entries

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
class_id	INT	Not null, Unique		foreign key to column id on table acl_classes.
object_identity_id	INT	Unique	NULL	foreign key to column id on table acl_object_identities.
security_identity_id	INT	Not null		foreign key to column id on table acl_security_identities.
field_name	VARCHAR(50)	Unique	NULL
ace_order	SMALLINT	Not null, Unique
mask	INT	Not null
granting	TINYINT	Not null
granting_strategy	VARCHAR(30)	Not null
audit_success	TINYINT	Not null
audit_failure	TINYINT	Not null

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_46C8B806EA000B103D9AB4A64DEF17BCE4289BF4	class_id, object_identity_id, field_name, ace_order	UNIQUE
IDX_46C8B806EA000B103D9AB4A6DF9183C9	class_id, object_identity_id, security_identity_id	INDEX
IDX_46C8B806EA000B10	class_id	INDEX
IDX_46C8B8063D9AB4A6	object_identity_id	INDEX
IDX_46C8B806DF9183C9	security_identity_id	INDEX

Table: acl_object_identities

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
parent_object_identity_id	INT		NULL	foreign key to column id on table acl_object_identities.
class_id	INT	Not null, Unique
object_identifier	VARCHAR(100)	Not null, Unique
entries_inheriting	TINYINT	Not null

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_9407E5494B12AD6EA000B10	object_identifier, class_id	UNIQUE
IDX_9407E54977FA751A	parent_object_identity_id	INDEX

Table: acl_object_identity_ancestors

Description:

Columns:

Column	Data type	Attributes	Default	Description
object_identity_id	INT	PRIMARY, Not null		foreign key to column id on table acl_object_identities.
ancestor_id	INT	PRIMARY, Not null		foreign key to column id on table acl_object_identities.

Indices:

Name	Columns	Type	Description
PRIMARY	object_identity_id, ancestor_id	PRIMARY
IDX_825DE2993D9AB4A6	object_identity_id	INDEX
IDX_825DE299C671CEA1	ancestor_id	INDEX

Table: acl_security_identities

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
identifier	VARCHAR(200)	Not null, Unique
username	TINYINT	Not null, Unique

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_8835EE78772E836AF85E0677	identifier, username	UNIQUE

Table: al_action

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
promotion_id	INT		NULL	foreign key to column id on table al_promotion.
action_type	VARCHAR(255)		NULL	Action type
configuration	LONGTEXT		NULL	Configuration of the action(DC2Type:array)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_9C680D2139DF194	promotion_id	INDEX

Table: al_address

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT		NULL	foreign key to column id on table al_user.
active	TINYINT		1
first_name	VARCHAR(255)		NULL	First name of address owner
last_name	VARCHAR(255)		NULL	Last name of address owner
phone_number	LONGTEXT		NULL	Phone number of address owner(DC2Type:json_array)
company	VARCHAR(255)		NULL	Name of company of address owner
country	VARCHAR(255)		NULL	Address country
street	VARCHAR(255)		NULL	Address street
street_number	VARCHAR(255)		NULL	Address street number
apartment_number	VARCHAR(255)		NULL
floor_number	VARCHAR(255)		NULL
city	VARCHAR(255)		NULL
postcode	VARCHAR(255)		NULL
email	VARCHAR(255)		NULL
created_at	DATETIME		NULL	Date when address was created
updatedAt	DATETIME		NULL	Date when address was last updated
erp_code	VARCHAR(255)	Unique	NULL	Unique identifier for address. Used for storing address's erp code
ship_to_other_address	TINYINT		0	Indicates if shipping address is different then billing address
township	VARCHAR(255)		NULL	Address township

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_7BDC241D61EE0AEB	erp_code	UNIQUE
IDX_7BDC241DA76ED395	user_id	INDEX

Table: al_adjustment

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
order_id	INT		NULL	foreign key to column id on table al_order.
order_item_id	INT		NULL	foreign key to column id on table al_order_item.
label	VARCHAR(255)		NULL
description	VARCHAR(255)		NULL
amount	DOUBLE		NULL
neutral	TINYINT		NULL
locked	TINYINT		NULL
is_fixed_value	TINYINT		NULL
created_at	DATETIME		NULL
updatedAt	DATETIME		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_707C5D528D9F6D38	order_id	INDEX
IDX_707C5D52E415FB15	order_item_id	INDEX

Table: al_album

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
title	VARCHAR(128)	Not null, Unique		Album title
description	LONGTEXT	Not null		Album description
slug	VARCHAR(128)	Unique	NULL	Album slug
createdAt	DATETIME		NULL	Album created at
updatedAt	DATETIME		NULL	Album updated at
visible	TINYINT		NULL	Defines if album is visible or not
images_urls	LONGTEXT		NULL	Album image urls(DC2Type:simple_array)
featured_image_url	LONGTEXT		NULL	Album featured image url
left_image_url	LONGTEXT		NULL	Album left image url
right_image_url	LONGTEXT		NULL	Album right image url
priority	INT	Not null		Album priority

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_37177AA12B36786B	title	UNIQUE
UNIQ_37177AA1989D9B62	slug	UNIQUE

Table: al_analytics_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
order_chart	TINYINT		NULL	Display order chart or not
financial_chart	TINYINT		NULL	Display financial chart or not
visits_chart	TINYINT		NULL	Display visits chart or not

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_answers_choices_join_table

Description:

Columns:

Column	Data type	Attributes	Default	Description
answer_id	INT	PRIMARY, Not null		foreign key to column id on table al_survey_answer.
choice_id	INT	PRIMARY, Not null		foreign key to column id on table al_survey_choice.

Indices:

Name	Columns	Type	Description
PRIMARY	answer_id, choice_id	PRIMARY
IDX_7FC3263AAA334807	answer_id	INDEX
IDX_7FC3263A998666D1	choice_id	INDEX

Table: al_attr_set_attr

Description:

Columns:

Column	Data type	Attributes	Default	Description
attribute_id	INT	PRIMARY, Not null		foreign key to column id on table al_attribute.
attribute_set_id	INT	PRIMARY, Not null		foreign key to column id on table al_attribute_set.

Indices:

Name	Columns	Type	Description
PRIMARY	attribute_id, attribute_set_id	PRIMARY
IDX_1CD899F8B6E62EFA	attribute_id	INDEX
IDX_1CD899F8321A2342	attribute_set_id	INDEX

Table: al_attribute

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
code	INT	Unique	NULL	Unique identifier for attribute
erp_code	VARCHAR(255)	Unique	NULL	Unique identifier for attribute
display_to_user	TINYINT	Not null		Should display on frontend
name_dependency	TINYINT	Not null	0
priority	INT		NULL	Position of attribute in attribute set
name	VARCHAR(255)	Not null
type	VARCHAR(255)		NULL	Attribute type(CHECK, RADIO, SELECT)(DC2Type:attribute_type_type)
attribute_type	VARCHAR(255)	Not null		Attribute type(information type, price type)
type_of_values	VARCHAR(255)		NULL	Value type(number)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_C680C46777153098	code	UNIQUE
UNIQ_C680C46761EE0AEB	erp_code	UNIQUE

Table: al_attribute_set

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
attribute_order	LONGTEXT		NULL	Order for attributes in attribute set
code	INT	Unique	NULL	Unique identifier for attribute set
name	VARCHAR(255)	Not null

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_D2AC32CE77153098	code	UNIQUE

Table: al_attribute_set_product

Description:

Columns:

Column	Data type	Attributes	Default	Description
simple_product_id	INT	PRIMARY, Not null		foreign key to column id on table al_simple_product.
attribute_set_id	INT	PRIMARY, Not null		foreign key to column id on table al_attribute_set.

Indices:

Name	Columns	Type	Description
PRIMARY	simple_product_id, attribute_set_id	PRIMARY
IDX_6A39F90227543CCA	simple_product_id	INDEX
IDX_6A39F902321A2342	attribute_set_id	INDEX

Table: al_attribute_value

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
attribute_id	INT		NULL	foreign key to column id on table al_attribute.
code	INT	Unique	NULL	Unique identifier for attribute
erp_code	VARCHAR(255)	Unique	NULL	Unique identifier for attribute
priority	INT		NULL	Position in attribute
value	VARCHAR(255)	Not null		Value name
color	VARCHAR(255)		'1'
display_text	TINYINT	Not null		Should display value name

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_E650999877153098	code	UNIQUE
UNIQ_E650999861EE0AEB	erp_code	UNIQUE
IDX_E6509998B6E62EFA	attribute_id	INDEX

Table: al_attribute_value_product_attr_value

Description:

Columns:

Column	Data type	Attributes	Default	Description
product_attribute_values_id	INT	PRIMARY, Not null		foreign key to column id on table al_product_attribute_values.
attribute_value_id	INT	PRIMARY, Not null		foreign key to column id on table al_attribute_value.

Indices:

Name	Columns	Type	Description
PRIMARY	product_attribute_values_id, attribute_value_id	PRIMARY
IDX_B2226FD23B30C44E	product_attribute_values_id	INDEX
IDX_B2226FD265A22152	attribute_value_id	INDEX

Table: al_availability_notification

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT		NULL	foreign key to column id on table al_user.
product_id	INT		NULL	foreign key to column id on table al_product.
product_attr_values_id	INT		NULL	foreign key to column id on table al_product_attribute_values.
order_id	INT		NULL	foreign key to column id on table al_order.
quantity	DOUBLE		NULL
should_inform_user	TINYINT		0
unique_identifier	VARCHAR(255)	Not null, Unique

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_73C8DB766BD2BEA0	unique_identifier	UNIQUE
IDX_73C8DB76A76ED395	user_id	INDEX
IDX_73C8DB764584665A	product_id	INDEX
IDX_73C8DB761909B82E	product_attr_values_id	INDEX
IDX_73C8DB768D9F6D38	order_id	INDEX

Table: al_block_elements

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
theme_id	INT		NULL	foreign key to column id on table al_theme.
block_template_id	INT		NULL	foreign key to column id on table al_block_template.
entity	VARCHAR(255)	Not null		String title of entity used in block
layout_title	VARCHAR(255)	Not null, Unique		Title of block
algorithm	VARCHAR(255)		NULL	Algorithm used to fetch data
location	VARCHAR(255)		NULL	Layout of block location
template_name	VARCHAR(255)	Not null		Name of template to use
locale	VARCHAR(255)		NULL	Defines locale of block, if block depends on language used
algorithm_params	LONGTEXT		NULL	Array of parameters used in algorithm to fetch data(DC2Type:json_array)
linked_entity	VARCHAR(255)		NULL	Title of related entity
linked_entity_id	VARCHAR(255)		NULL	Id of related entity
entity_relationship_name	VARCHAR(255)		NULL	Name of entity relationship tu include in data
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
base_image_url	LONGTEXT		NULL	Url of preview image
cachable	TINYINT		NULL	Defines if block can be cached

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_B6509665A20A10A1	layout_title	UNIQUE
UNIQ_B65096653DA5256D	image_id	UNIQUE
IDX_B650966559027487	theme_id	INDEX
IDX_B6509665DFD75A63	block_template_id	INDEX

Table: al_block_page

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
pageName	VARCHAR(255)	Not null, Unique		Name of page
slug	VARCHAR(255)	Unique	NULL
htmlForEdit	LONGTEXT	Not null		Html content for edit
html	LONGTEXT	Not null		Html page
css_code	LONGTEXT	Not null		Custom css code for page
js_code	LONGTEXT	Not null		Custom js for page
visible	TINYINT	Not null		Is page visible
permalink	VARCHAR(255)	Not null, Unique		Permalink of page
extends_master	TINYINT	Not null		Does page extend theme master of is it fully custom page

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_2BE1C11F7FC5C053	pageName	UNIQUE
UNIQ_2BE1C11FF286BC32	permalink	UNIQUE
UNIQ_2BE1C11F989D9B62	slug	UNIQUE

Table: al_block_page_route_config

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
route_id	INT		NULL	foreign key to column id on table al_block_page_routes.
type	INT	Not null		0=defaults,1=req,2=options
name	VARCHAR(255)	Not null		Name of route
value	VARCHAR(255)	Not null		Route value

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_B652DFD834ECB4E6	route_id	INDEX

Table: al_block_page_routes

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
page_id	INT	Unique	NULL	foreign key to column id on table al_block_page.
name	VARCHAR(255)	Not null		Name of page
title	VARCHAR(100)	Not null		Title of route
path	VARCHAR(255)	Not null		Sting path
replacement_path	LONGTEXT		NULL	Route alias
host	VARCHAR(255)		NULL	Host for route
controller	VARCHAR(255)	Not null		Route controller
role	VARCHAR(100)	Not null		Role limit
is_active	TINYINT	Not null		Is route active

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_E243C256C4663E4	page_id	UNIQUE

Table: al_block_template

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
theme_id	INT	Unique	NULL	foreign key to column id on table al_theme.
entity	VARCHAR(255)	Not null		Defines main entity in template
template_title	VARCHAR(255)	Not null, Unique		Title of template
css_content	LONGTEXT		NULL	Custom CSS
html_content	LONGTEXT		NULL	HTML content
js_content	LONGTEXT		NULL	Custom template JS
scss_content	LONGTEXT		NULL	Custom SCSS

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_block_template_unique	template_title, theme_id	UNIQUE
IDX_657A8EBB59027487	theme_id	INDEX

Table: al_block_template_relationship

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
block_template_id	INT		NULL	foreign key to column id on table al_block_template.
block_template_attachment_id	INT		NULL	foreign key to column id on table al_block_template.
related_entity	VARCHAR(255)	Not null, Unique

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_9830282FA2E43CCE	related_entity	UNIQUE
IDX_9830282FDFD75A63	block_template_id	INDEX
IDX_9830282FAFE38DC	block_template_attachment_id	INDEX

Table: al_blog_category

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
root_id	INT		NULL	foreign key to column id on table al_blog_category.
parent_id	INT		NULL	foreign key to column id on table al_blog_category.
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
name	VARCHAR(64)		NULL	Name of blog category
description	LONGTEXT		NULL	Description of blog category
createdAt	DATETIME		NULL	Date when blog category created
updatedAt	DATETIME		NULL	Date when blog category last updated
lft	INT	Not null		Left value for representation of nested node
lvl	INT	Not null		Level of node in hierarchy
rgt	INT	Not null		Right value for representation of nested node
number_of_posts	INT		NULL	Number of blog post in blog category
meta_keywords	LONGTEXT		NULL	SEO meta keywords for blog category(DC2Type:simple_array)
meta_title	LONGTEXT		NULL	SEO meta title for blog category
meta_description	LONGTEXT		NULL	SEO meta description for blog category
slug	VARCHAR(255)	Unique	NULL	Slug for blog category
locale	VARCHAR(255)	Not null	'en'
permalink	VARCHAR(255)		NULL	Permalink for blog category, needs to be unique on database level

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_70A3BF4B989D9B62	slug	UNIQUE
UNIQ_70A3BF4B3DA5256D	image_id	UNIQUE
IDX_70A3BF4B79066886	root_id	INDEX
IDX_70A3BF4B727ACA70	parent_id	INDEX

Table: al_blog_comment

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
blog_post_id	INT		NULL	foreign key to column id on table al_blog_post.
user_id	INT		NULL	foreign key to column id on table al_user.
comment_content	LONGTEXT	Not null		Blog comment content
created_at	DATETIME		NULL	Date when blog comment created
approved_at	DATETIME		NULL	Date when blog comment last updated
status	TINYINT		NULL	Status of blog comment, approved or not
user_name	LONGTEXT	Not null		Name of user who created blog comment
mail	LONGTEXT	Not null		Mail of user who created blog comment
user_image	LONGTEXT		NULL	Base image url of user who created blog comment

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_A793482CA77FBEAF	blog_post_id	INDEX
IDX_A793482CA76ED395	user_id	INDEX

Table: al_blog_post

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
user_id	INT		NULL	foreign key to column id on table al_user.
post_title	LONGTEXT	Not null		Title of blog post
post_content	LONGTEXT	Not null		Content of blog post
description	LONGTEXT		NULL	Description of blog post
createdAt	DATETIME		NULL	Date when blog post created
updatedAt	DATETIME		NULL	Date when blog post last updated
featured_video	VARCHAR(128)		NULL	Link to featured video
visible	TINYINT		NULL	Visibility of blog post
meta_keywords	LONGTEXT		NULL	SEO meta keywords for blog post(DC2Type:simple_array)
meta_title	LONGTEXT		NULL	SEO meta title for blog post
meta_description	LONGTEXT		NULL	SEO meta description for blog post
slug	VARCHAR(252)	Unique	NULL	Slug for blog post
image_path	LONGTEXT		NULL	Base image URL of blog post image
locale	VARCHAR(255)	Not null	'en'
blogCategory_id	INT		NULL	foreign key to column id on table al_blog_category.
permalink	VARCHAR(255)		NULL	Permalink for blog post, needs to be unique on database level

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_86A0CB81989D9B62	slug	UNIQUE
UNIQ_86A0CB813DA5256D	image_id	UNIQUE
IDX_86A0CB811157C0A4	blogCategory_id	INDEX
IDX_86A0CB81A76ED395	user_id	INDEX

Table: al_brand

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
brand_name	VARCHAR(255)	Unique	NULL	Brand name
type	VARCHAR(255)	Not null	'REGULAR'	Brand type(DC2Type:brand_type_type)
base_image_url	LONGTEXT		NULL	Brand base image web path
deleted_at	DATETIME		NULL	Brand deleted at field
slug	VARCHAR(255)	Unique	NULL	Brand slug
code	VARCHAR(255)		NULL	Brand code
isVisible	TINYINT		NULL	Brand visibility property
position	INT		NULL	Brand position
parent_brand_name	VARCHAR(255)		NULL	Alternative brand name
seo_title	VARCHAR(255)		NULL	Brand seo title
seo_description	LONGTEXT		NULL	Brand seo description
seo_keywords	LONGTEXT		NULL	Brand seo keyword
permalink	VARCHAR(255)		NULL	Brand permalink

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_12DDEDBA794474B9	brand_name	UNIQUE
UNIQ_12DDEDBA989D9B62	slug	UNIQUE

Table: al_brand_translation

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
brand_id	INT	Unique	NULL	foreign key to column id on table al_brand.
locale	VARCHAR(8)	Not null, Unique		Brand translation locale
name_translation	VARCHAR(255)		NULL	Brand translation name
permalink_translation	VARCHAR(255)		NULL	Permalink translation
seo_title_translation	VARCHAR(255)		NULL	Seo title translation
seo_description_translation	LONGTEXT		NULL	Seo description translation
seo_keywords_translation	LONGTEXT		NULL	Seo keywords translation

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_brand_translation_locale_constraint	brand_id, locale	UNIQUE
IDX_B075C6BA44F5D008	brand_id	INDEX

Table: al_buy_x

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT	Unique	NULL	foreign key to column id on table al_product.
product_attr_value_id	INT		NULL	foreign key to column id on table al_product_attribute_values.
name	LONGTEXT	Not null		Name of buy x promotion

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_4F637C364584665A	product_id	UNIQUE
IDX_4F637C36AC1E7D98	product_attr_value_id	INDEX

Table: al_buy_x_quantity

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
buy_x_id	INT		NULL	foreign key to column id on table al_buy_x.
amount	INT	Not null		Minimal amount of added products to be valid buy x offer

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_53B78010E8591761	buy_x_id	INDEX

Table: al_category

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
root_id	INT		NULL	foreign key to column id on table al_category.
parent_id	INT	Unique	NULL	foreign key to column id on table al_category.
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
code	INT		NULL	Category code
lft	INT	Not null		Category left property for tree structure
lvl	INT	Not null		Category level property for tree structure
rgt	INT	Not null		Category right property for tree structure
deleted_at	DATETIME		NULL	Category deleted at date
is_root_category	TINYINT	Not null		Defines if category is root
products_order	LONGTEXT		NULL	Defines products order inside category
slug	VARCHAR(254)	Unique	NULL	Category slug
breadcrumb	LONGTEXT		NULL	Category breadcrumb(DC2Type:json_array)
meta_keywords	LONGTEXT		NULL	Category metakeywords(DC2Type:simple_array)
meta_title	LONGTEXT		NULL	Category meta title
meta_description	LONGTEXT		NULL	Category meta description
number_of_items	INT		NULL	Category number of children items
image_path	LONGTEXT		NULL	Category image web path
image_id_string	VARCHAR(255)		NULL	Category image id
has_active_categories	TINYINT	Not null		Defines if category has active categories
permissions	LONGTEXT		NULL	Array of category permissions(DC2Type:simple_array)
brand_position	LONGTEXT		NULL	Brand position(DC2Type:json_array)
disabled_attributes	LONGTEXT		NULL	Category disabled attributes array(DC2Type:simple_array)
attributes_sort	LONGTEXT		NULL	Attributes sort array(DC2Type:simple_array)
price_range_position	LONGTEXT		NULL	Category price range position(DC2Type:json_array)
subcategories_position	LONGTEXT		NULL	Subcategories position inside parent category(DC2Type:json_array)
regex	LONGTEXT		NULL	Category regex(DC2Type:json_array)
name	VARCHAR(255)	Not null, Unique		Category name
description	LONGTEXT		NULL	Category description
icon	LONGTEXT		NULL	Category icon
createdAt	DATETIME		NULL	Category created at
updatedAt	DATETIME		NULL	Category updated at
display	TINYINT	Not null		Enable disable category visibility
hide_from_menu	TINYINT	Not null	0	Show/hide category from menu
updated_by	VARCHAR(255)	Not null
hash	VARCHAR(255)		NULL
permalink	VARCHAR(255)		NULL	Category permalink

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_FF8354E5989D9B62	slug	UNIQUE
UNIQ_FF8354E53DA5256D	image_id	UNIQUE
al_category_primary	name, parent_id	UNIQUE
IDX_FF8354E579066886	root_id	INDEX
IDX_FF8354E5727ACA70	parent_id	INDEX

Table: al_category_external_link

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
category_id	INT	Unique	NULL	foreign key to column id on table al_category.
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
title	VARCHAR(255)	Not null, Unique		External link title
link	VARCHAR(255)		NULL	External link
base_image_url	VARCHAR(255)		NULL	External link image web path

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_43BFC4083DA5256D	image_id	UNIQUE
al_category_external_links_unique	category_id, title	UNIQUE
IDX_43BFC40812469DE2	category_id	INDEX

Table: al_category_filter

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
category_id	INT	Unique	NULL	foreign key to column id on table al_category.
name	VARCHAR(255)	Not null
minPrice	DOUBLE	Not null
maxPrice	DOUBLE	Not null
autoPrice	TINYINT	Not null
display_price_range	TINYINT	Not null
ajaxFilters	TINYINT	Not null
filterExclusion	TINYINT	Not null
additional_filters	LONGTEXT		NULL	(DC2Type:simple_array)
brand_position	INT		NULL
disabled_attributes	LONGTEXT		NULL	(DC2Type:simple_array)
attributes_sort	LONGTEXT		NULL	(DC2Type:simple_array)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_6833B77C12469DE2	category_id	UNIQUE

Table: al_category_filter_attribute_set

Description:

Columns:

Column	Data type	Attributes	Default	Description
category_filter_id	INT	PRIMARY, Not null		foreign key to column id on table al_category_filter.
attribute_set_id	INT	PRIMARY, Not null		foreign key to column id on table al_attribute_set.

Indices:

Name	Columns	Type	Description
PRIMARY	category_filter_id, attribute_set_id	PRIMARY
IDX_EC148FCC14F5606E	category_filter_id	INDEX
IDX_EC148FCC321A2342	attribute_set_id	INDEX

Table: al_category_filter_brand

Description:

Columns:

Column	Data type	Attributes	Default	Description
category_filter_id	INT	PRIMARY, Not null		foreign key to column id on table al_category_filter.
brand_id	INT	PRIMARY, Not null		foreign key to column id on table al_brand.

Indices:

Name	Columns	Type	Description
PRIMARY	category_filter_id, brand_id	PRIMARY
IDX_EC37C1AD14F5606E	category_filter_id	INDEX
IDX_EC37C1AD44F5D008	brand_id	INDEX

Table: al_category_logs

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
entity_id	INT		NULL
username	VARCHAR(255)		NULL
action_type	VARCHAR(255)		NULL
created_at	DATETIME		NULL
entity	VARCHAR(255)		NULL
object_changes	LONGTEXT		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_category_translation

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
category_id	INT	Unique	NULL	foreign key to column id on table al_category.
locale	VARCHAR(8)	Not null, Unique
name_translation	VARCHAR(255)		NULL	External link name translation
description_translation	LONGTEXT		NULL	External link description translation
permalink_translation	VARCHAR(255)		NULL	Permalink translation
seo_title_translation	VARCHAR(255)		NULL	Seto title translation
seo_description_translation	LONGTEXT		NULL	Seo description translation
seo_keywords_translation	LONGTEXT		NULL	Seo keywords translation

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_category_translation_locale_constraint	category_id, locale	UNIQUE
IDX_B6F8938612469DE2	category_id	INDEX

Table: al_changed_price

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT	Unique	NULL	foreign key to column id on table al_user.
product_id	INT	Unique	NULL	foreign key to column id on table al_product.
product_attr_values_id	INT	Unique	NULL	foreign key to column id on table al_product_attribute_values.
old_price	DOUBLE	Not null		The last price that the product had before the change. 0 if value has not changed since user added product

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_watchlist_primary	user_id, product_id, product_attr_values_id	UNIQUE
IDX_E01750D0A76ED395	user_id	INDEX
IDX_E01750D04584665A	product_id	INDEX
IDX_E01750D01909B82E	product_attr_values_id	INDEX

Table: al_checkout_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
pick_up_in_the_store_default_shipping_provider_id	INT		NULL	foreign key to column id on table al_shipping.
name	LONGTEXT	Not null		Checkout settings name
number_of_steps	INT	Not null		Number of checkout steps
internet_discount	DOUBLE		0	Discount for all orders
steps	LONGTEXT		NULL	Array of checkout steps(DC2Type:simple_array)
current	TINYINT		NULL	Is active checkout settings, only one can be active
pick_up_in_the_store	TINYINT		NULL	Pick up in the store option active
find_my_location	TINYINT		NULL	Find my location option active
one_step_checkout	TINYINT		NULL	Is one step checkout process
created_at	DATETIME		NULL	Date when checkout settings created
updated_at	DATETIME		NULL	Date when checkout settings last updated
ship_to_other_address	TINYINT		NULL	Ship to other address option active
free_delivery_amount	DOUBLE		0	Minimal amount for free delivery

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_A92DA199630A7665	pick_up_in_the_store_default_shipping_provider_id	INDEX

Table: al_checkout_step_payment_types

Description:

Columns:

Column	Data type	Attributes	Default	Description
checkout_step_id	INT	PRIMARY, Not null		foreign key to column id on table al_checkout_settings.
payment_type_id	INT	PRIMARY, Not null		foreign key to column id on table al_payment_type.

Indices:

Name	Columns	Type	Description
PRIMARY	checkout_step_id, payment_type_id	PRIMARY
IDX_5269B50B8FD9FAE5	checkout_step_id	INDEX
IDX_5269B50BDC058279	payment_type_id	INDEX

Table: al_comment

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT		NULL	foreign key to column id on table al_user.
ticket_id	INT		NULL	foreign key to column id on table al_ticket.
order_id	INT		NULL	foreign key to column id on table al_order.
file_id	INT	Unique	NULL	foreign key to column id on table al_file.
comment_content	LONGTEXT	Not null		Comment content
comment_status	VARCHAR(50)	Not null		Comment status. Can be new or seen
createdAt	DATETIME		NULL	Date when comment was created
updatedAt	DATETIME		NULL	Date when comment was last updated
base_file_url	LONGTEXT		NULL	File url

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_E2E619F093CB796C	file_id	UNIQUE
IDX_E2E619F0A76ED395	user_id	INDEX
IDX_E2E619F0700047D2	ticket_id	INDEX
IDX_E2E619F08D9F6D38	order_id	INDEX

Table: al_company

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)	Not null
pib	VARCHAR(255)	Not null

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_compare

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT	Unique	NULL	foreign key to column id on table al_user.
name	VARCHAR(255)	Not null, Unique		Compare list name

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_compare_primary	name, user_id	UNIQUE
IDX_CB5B43C1A76ED395	user_id	INDEX

Table: al_compare_product

Description:

Columns:

Column	Data type	Attributes	Default	Description
compare_id	INT	PRIMARY, Not null		foreign key to column id on table al_compare.
product_id	INT	PRIMARY, Not null		foreign key to column id on table al_product.

Indices:

Name	Columns	Type	Description
PRIMARY	compare_id, product_id	PRIMARY
IDX_9C61EC6328448872	compare_id	INDEX
IDX_9C61EC634584665A	product_id	INDEX

Table: al_configurable_product

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
base_product_id	INT	Unique	NULL	foreign key to column id on table al_product.
base_price	DECIMAL		0

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_15774C80D63EB556	base_product_id	UNIQUE

Table: al_configurable_simple_product

Description:

Columns:

Column	Data type	Attributes	Default	Description
simple_product_id	INT	PRIMARY, Not null		foreign key to column id on table al_simple_product.
configurable_product_id	INT	PRIMARY, Not null		foreign key to column id on table al_configurable_product.

Indices:

Name	Columns	Type	Description
PRIMARY	simple_product_id, configurable_product_id	PRIMARY
IDX_DEF507E627543CCA	simple_product_id	INDEX
IDX_DEF507E62905368	configurable_product_id	INDEX

Table: al_contact_us

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
file_id	INT	Unique	NULL	foreign key to column id on table al_file.
name	VARCHAR(255)	Not null		Contact question name
email	VARCHAR(255)	Not null		Contact question email
title	VARCHAR(255)		NULL	Contact question title
message	LONGTEXT	Not null		Contact question message
phone_number	VARCHAR(255)		NULL	Contact question phone number
created_at	DATETIME		NULL	Contact question created at

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_7B80D89493CB796C	file_id	UNIQUE

Table: al_coupon

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
promotion_id	INT		NULL	foreign key to column id on table al_promotion.
user_id	INT	Unique	NULL	foreign key to column id on table al_user.
code	VARCHAR(255)	Unique	NULL	Coupon code, passed from promotion
usage_limit	INT		NULL	Maximum number of time coupon can be used, passed from promotion
number_of_uses	INT	Not null		Number of times coupon has been used
used	INT		NULL	Coupon has been fully used

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
coupon_unique	code, user_id	UNIQUE
IDX_2AB53342139DF194	promotion_id	INDEX
IDX_2AB53342A76ED395	user_id	INDEX

Table: al_currency_ratio

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
currency_name	VARCHAR(255)	Not null, Unique		Name of currency
iso_number	VARCHAR(255)	Not null, Unique		ISO number of currency
is_default	TINYINT		1	Defines if currency is default for shop
is_auto_calculated	TINYINT		0	Should this currency be autoc alculated or is its ratio set manually
conversion_provider	VARCHAR(255)	Not null		Defines a service to use when converting
currency_code	VARCHAR(255)	Not null, Unique		Code of currency
ratio	DOUBLE	Not null		Ratio compared to default currency
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
base_image_url	VARCHAR(255)		NULL	Path to currency image

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_3E7D7CED4943D72	currency_name	UNIQUE
UNIQ_3E7D7CEFC522D62	iso_number	UNIQUE
UNIQ_3E7D7CEFDA273EC	currency_code	UNIQUE
UNIQ_3E7D7CE3DA5256D	image_id	UNIQUE

Table: al_db_session

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	VARCHAR(255)	PRIMARY, Not null
value	LONGTEXT	Not null
time	INT	Not null
lifetime	INT	Not null

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_declaration

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
declaration_category_id	INT		NULL	foreign key to column id on table al_declaration_category.
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
title	LONGTEXT	Not null		Declaration title
path	LONGTEXT		NULL	Image web path
description	LONGTEXT		NULL	Declaration description
createdAt	DATETIME		NULL	Date when comment was created
locale	VARCHAR(255)	Not null	'en'
visible	TINYINT		NULL	Should declaration be visible
name	VARCHAR(255)		NULL	File name
file_size	VARCHAR(255)		NULL	File size

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_BEBDA6E3DA5256D	image_id	UNIQUE
IDX_BEBDA6E3A762135	declaration_category_id	INDEX

Table: al_declaration_category

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
root_id	INT		NULL	foreign key to column id on table al_declaration_category.
parent_id	INT		NULL	foreign key to column id on table al_declaration_category.
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
name	VARCHAR(255)	Not null		Declaration category name
display_title	TINYINT		NULL	Should display category title
lft	INT	Not null
lvl	INT	Not null
rgt	INT	Not null
slug	VARCHAR(254)	Unique	NULL
meta_keywords	LONGTEXT		NULL	(DC2Type:simple_array)
meta_title	LONGTEXT		NULL	SEO title
meta_description	LONGTEXT		NULL	SEO description
number_of_items	INT		NULL	Number of visible declaration that belongs to this category
number_of_kids	INT		NULL	Number of child nodes
image_path	LONGTEXT		NULL
image_id_string	VARCHAR(255)		NULL
description	VARCHAR(255)		NULL	Category description
icon	VARCHAR(255)		NULL	Category icon
locale	VARCHAR(255)	Not null	'en'

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_40906E6D989D9B62	slug	UNIQUE
UNIQ_40906E6D3DA5256D	image_id	UNIQUE
IDX_40906E6D79066886	root_id	INDEX
IDX_40906E6D727ACA70	parent_id	INDEX

Table: al_digital_catalogue

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
first_page_id	INT	Unique	NULL	foreign key to column id on table al_image.
last_page_id	INT	Unique	NULL	foreign key to column id on table al_image.
name	VARCHAR(255)	Not null		Catalogue name
first_page_base_image_url	LONGTEXT		NULL	First page image url
last_page_base_image_url	LONGTEXT		NULL	Last page image url
number_of_products	INT		NULL	Number of products
all_category_products_selected	TINYINT		0	Checks if all products are selected
catalogue_url	LONGTEXT		NULL	Catalogue web path
priority	INT	Not null		Catalogue priority in list of catalogues

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_D705F9811FCA0F18	first_page_id	UNIQUE
UNIQ_D705F9816ACA5FAC	last_page_id	UNIQUE

Table: al_digital_catalogue_categories

Description:

Columns:

Column	Data type	Attributes	Default	Description
catalogue_id	INT	PRIMARY, Not null		foreign key to column id on table al_digital_catalogue.
category_id	INT	PRIMARY, Not null		foreign key to column id on table al_category.

Indices:

Name	Columns	Type	Description
PRIMARY	catalogue_id, category_id	PRIMARY
IDX_45C1C1564A7843DC	catalogue_id	INDEX
IDX_45C1C15612469DE2	category_id	INDEX

Table: al_email_friend

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT		NULL	foreign key to column id on table al_product.
fromMail	VARCHAR(255)	Not null		Senders email
toMail	VARCHAR(255)	Not null		Recipients email
subject	VARCHAR(255)	Not null		Title of email
content	VARCHAR(255)	Not null		Content of email

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_F765D8524584665A	product_id	INDEX

Table: al_entity_relationship

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)	Not null		Name of relationship. Multiple relationships can have same name
main_entity_type	VARCHAR(255)	Not null		String namespace of main entity
main_entity_search_by	VARCHAR(255)	Not null		Field of main entity to do search by
main_entity_search_view	VARCHAR(255)	Not null		Field of main entity to display as result of search
main_entity_ids	LONGTEXT	Not null		Array of main entity element ids(DC2Type:simple_array)
sub_entity_type	VARCHAR(255)	Not null		String namespace of sub entity
sub_entity_search_by	VARCHAR(255)	Not null		Field of sub entity to do search by
sub_entity_search_view	VARCHAR(255)	Not null		Field of sub entity to display as result of search
sub_entity_ids	LONGTEXT	Not null		Array of sub entity element ids(DC2Type:simple_array)
children_relationships	LONGTEXT		NULL	Defines if some other relationships should be included with this one(DC2Type:simple_array)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_facebook_pixel_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
pixel_id	VARCHAR(255)	Not null		ID of pixel
currency	VARCHAR(255)	Not null		Currency of values
view_content_value	INT	Not null	0	Value for content view
search_value	INT	Not null	0	Value for search
add_to_cart_value	INT	Not null	0	Value for add to cart
add_to_wishlist_value	INT	Not null	0	Value for add to wishlist
initiate_checkout_value	INT	Not null	0	Value for checkout initialization
add_payment_info_value	INT	Not null	0	Value for add payment
complete_registration_value	INT	Not null	0	Value for completed registration
lead_value	INT	Not null	0	Value for lead

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_faq

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT		NULL	foreign key to column id on table al_user.
faq_category_id	INT		NULL	foreign key to column id on table al_faq_category.
title	VARCHAR(255)		NULL	Question title
isVisible	TINYINT		NULL	Should question be shown on frontend
answer	LONGTEXT		NULL	Question answer
locale	VARCHAR(255)	Not null	'en'

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_AA78543AA76ED395	user_id	INDEX
IDX_AA78543AF689B0DB	faq_category_id	INDEX

Table: al_faq_category

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
parent_id	INT	Unique	NULL	foreign key to column id on table al_faq_category.
root_id	INT		NULL	foreign key to column id on table al_faq_category.
name	VARCHAR(255)	Unique	NULL	Category name
description	LONGTEXT		NULL	Category description
icon	VARCHAR(255)		NULL	Category icon(fa-icon)
lft	INT	Not null
lvl	INT	Not null
rgt	INT	Not null
is_root_category	TINYINT		NULL	Indicates whether this node is root or not
created_at	DATETIME		NULL	Date when category was created
updated_at	DATETIME		NULL	Date when category was last updated
number_of_items	INT		NULL
slug	VARCHAR(255)	Unique	NULL
locale	VARCHAR(255)	Not null, Unique	'en'

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_25FF4715989D9B62	slug	UNIQUE
al_faq_category_primary	name, parent_id, locale	UNIQUE
IDX_25FF4715727ACA70	parent_id	INDEX
IDX_25FF471579066886	root_id	INDEX

Table: al_feature

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT		NULL	foreign key to column id on table al_product.
feature_name	VARCHAR(255)	Not null		Product feature name
feature_value	VARCHAR(255)	Not null		Product feature value

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_69453EFA4584665A	product_id	INDEX

Table: al_featured_categories

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
category_id	INT	Unique	NULL	foreign key to column id on table al_category.

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_3E4B0B9012469DE2	category_id	UNIQUE

Table: al_file

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT		NULL	foreign key to column id on table al_product.
priority	INT		NULL	File priority
name	VARCHAR(255)		NULL	File name
file_size	VARCHAR(255)		NULL	File size

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_D803E6184584665A	product_id	INDEX

Table: al_form

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
template_id	INT		NULL	foreign key to column id on table al_block_template.
form_title	VARCHAR(128)	Not null, Unique		Form title
form_content	LONGTEXT	Not null		Form content
emails	LONGTEXT	Not null		Emails for form submit
slug	VARCHAR(128)	Unique	NULL
locale	VARCHAR(255)	Not null	'en'

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_6142D47A871DCA8	form_title	UNIQUE
UNIQ_6142D47989D9B62	slug	UNIQUE
IDX_6142D475DA0FB8	template_id	INDEX

Table: al_get_y

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT		NULL	foreign key to column id on table al_product.
product_attr_value_id	INT		NULL	foreign key to column id on table al_product_attribute_values.
buy_x_quantity_id	INT		NULL	foreign key to column id on table al_buy_x_quantity.
discount	INT	Not null		Percentage discount for offer
max_quantity	INT	Not null		Max quantity of products on offer per cart

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_A845071C4584665A	product_id	INDEX
IDX_A845071CAC1E7D98	product_attr_value_id	INDEX
IDX_A845071C71AC7B57	buy_x_quantity_id	INDEX

Table: al_gift_card

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
created_by_id	INT		NULL	foreign key to column id on table al_user.
created_at	DATETIME	Not null		When was gift car purchased
code	VARCHAR(255)	Not null, Unique		Code of gift card
used	TINYINT	Not null		Is gift card used
amount	DOUBLE	Not null		Amount of gift card
currency	VARCHAR(255)	Not null		Currency of gift card

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_D893411277153098	code	UNIQUE
IDX_D8934112B03A8386	created_by_id	INDEX

Table: al_gift_card_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
purchasable_from	DATETIME		NULL	Date from which gift cards can be purchased
purchasable_to	DATETIME		NULL	Date to which gift cards can be purchased
min_amount	DOUBLE		NULL	Minimal amount of gift card
max_amount	DOUBLE		NULL	Maximal amount of gift card
default_currency_code	VARCHAR(255)		NULL	Default currency

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_google_analytics_id

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
view_id	VARCHAR(255)	Not null		Google analytics view id
tracking_id	VARCHAR(255)	Not null		Google analytics tracking id

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_group

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)	Not null, Unique

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_634F50275E237E06	name	UNIQUE

Table: al_group_product

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
base_product_id	INT	Unique	NULL	foreign key to column id on table al_product.
discount	DECIMAL		0	Discount
generate_price	TINYINT	Not null	0

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_57F8D20CD63EB556	base_product_id	UNIQUE

Table: al_group_role

Description:

Columns:

Column	Data type	Attributes	Default	Description
group_id	INT	PRIMARY, Not null		foreign key to column id on table al_group.
rol_id	INT	PRIMARY, Not null		foreign key to column id on table al_role.

Indices:

Name	Columns	Type	Description
PRIMARY	group_id, rol_id	PRIMARY
IDX_87B6F45EFE54D947	group_id	INDEX
IDX_87B6F45E4BAB96C	rol_id	INDEX

Table: al_group_simple_product

Description:

Columns:

Column	Data type	Attributes	Default	Description
group_product_id	INT	PRIMARY, Not null		foreign key to column id on table al_group_product.
simple_product_id	INT	PRIMARY, Not null		foreign key to column id on table al_simple_product.
product_attr_values_id	INT		NULL	foreign key to column id on table al_product_attribute_values.
quantity	INT	Not null	1	Number of products in group product

Indices:

Name	Columns	Type	Description
PRIMARY	group_product_id, simple_product_id	PRIMARY
IDX_B48447A6924907E8	group_product_id	INDEX
IDX_B48447A627543CCA	simple_product_id	INDEX
IDX_B48447A61909B82E	product_attr_values_id	INDEX

Table: al_group_user

Description:

Columns:

Column	Data type	Attributes	Default	Description
user_id	INT	PRIMARY, Not null		foreign key to column id on table al_user.
group_id	INT	PRIMARY, Not null		foreign key to column id on table al_group.

Indices:

Name	Columns	Type	Description
PRIMARY	user_id, group_id	PRIMARY
IDX_5D4CA87DA76ED395	user_id	INDEX
IDX_5D4CA87DFE54D947	group_id	INDEX

Table: al_image

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT		NULL	foreign key to column id on table al_product.
category_id	INT	Unique	NULL	foreign key to column id on table al_category.
category_gallery_id	INT		NULL	foreign key to column id on table al_category.
brand_id	INT		NULL	foreign key to column id on table al_brand.
product_attribute_value_id	INT		NULL	foreign key to column id on table al_product_attribute_values.
position	VARCHAR(255)		NULL	Image position
not_resizable	TINYINT		NULL	Property that enables or disables image resizing on save
watermark_image	TINYINT		NULL	Use watermark over image or not
priority	INT		NULL	Position of image. Used for sort images in products
code	VARCHAR(255)	Unique	NULL	Unique identifier for image
name	VARCHAR(255)		NULL	File name
file_size	VARCHAR(255)		NULL	File size

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_CBB210BD77153098	code	UNIQUE
UNIQ_CBB210BD12469DE2	category_id	UNIQUE
IDX_CBB210BD4584665A	product_id	INDEX
IDX_CBB210BD22F9FFF1	category_gallery_id	INDEX
IDX_CBB210BD44F5D008	brand_id	INDEX
IDX_CBB210BD9774A42E	product_attribute_value_id	INDEX

Table: al_image_album_aggregation

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
album_id	INT		NULL	foreign key to column id on table al_album.
featured	TINYINT		NULL	Album Image aggregation featured property
lft	TINYINT		NULL	Album Image aggregation left property
rgt	TINYINT		NULL	Album Image aggregation right property
priority	INT	Not null		Album Image aggregation priority

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_5298F5543DA5256D	image_id	UNIQUE
IDX_5298F5541137ABCF	album_id	INDEX

Table: al_import_export_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
import_settings	LONGTEXT		NULL	Import settings array(DC2Type:simple_array)
export_settings	LONGTEXT		NULL	Export settings array(DC2Type:simple_array)
custom_import_settings	LONGTEXT		NULL	Custom import settings array(DC2Type:simple_array)
parent_categories_type	TINYINT		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_language

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
file_id	INT	Unique	NULL	foreign key to column id on table al_file.
language_name	VARCHAR(255)	Unique	NULL	Name of the language
language_locale	VARCHAR(255)	Not null	'en'
language_iso_code	VARCHAR(255)		NULL	Language iso code
available	TINYINT		0	Indicates if language should be used on frontend
countries	LONGTEXT		NULL	Collection of countries associated with language(DC2Type:simple_array)
is_default	TINYINT	Not null	0	Language used for new users/sessions

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_2D143C916C2A944A	language_name	UNIQUE
UNIQ_2D143C9193CB796C	file_id	UNIQUE

Table: al_layout

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
theme_id	INT	Unique	NULL	foreign key to column id on table al_theme.
name	VARCHAR(255)	Not null, Unique		Layout name

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_layout_theme_primary	name, theme_id	UNIQUE
IDX_743067A259027487	theme_id	INDEX

Table: al_mail_list

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)	Not null		Mail list name
mails	LONGTEXT		NULL	Mail list mails
all_users_selected	INT		NULL	All users selected

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_mail_list_users

Description:

Columns:

Column	Data type	Attributes	Default	Description
mail_list_id	INT	PRIMARY, Not null		foreign key to column id on table al_mail_list.
user_id	INT	PRIMARY, Not null		foreign key to column id on table al_user.

Indices:

Name	Columns	Type	Description
PRIMARY	mail_list_id, user_id	PRIMARY
IDX_1CCF90CE71397E4	mail_list_id	INDEX
IDX_1CCF90CA76ED395	user_id	INDEX

Table: al_mail_templates_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
order_success_template_id	INT		NULL	foreign key to column id on table al_block_template.
newsletter_template_id	INT		NULL	foreign key to column id on table al_block_template.

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_A4E354C913891047	order_success_template_id	INDEX
IDX_A4E354C933345077	newsletter_template_id	INDEX

Table: al_mass_mail

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT		NULL	foreign key to column id on table al_user.
sent_from_user_id	INT		NULL	foreign key to column id on table al_user.
file_id	INT	Unique	NULL	foreign key to column id on table al_file.
mail_list_id	INT		NULL	foreign key to column id on table al_mail_list.
subject	VARCHAR(255)		NULL	Mass mail subject
description	LONGTEXT		NULL	Mass mail description
additional_mails	LONGTEXT		NULL	Additional mails
send_to_subscribers	TINYINT		0	Send mail to subscribers
product_group_id	INT		NULL	foreign key to column id on table al_product_group.

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_F189677393CB796C	file_id	UNIQUE
IDX_F1896773A76ED395	user_id	INDEX
IDX_F189677395484102	sent_from_user_id	INDEX
IDX_F1896773E71397E4	mail_list_id	INDEX
IDX_F189677335E4B3D0	product_group_id	INDEX

Table: al_media

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
name	VARCHAR(255)	Not null

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_64A3B5EE3DA5256D	image_id	UNIQUE

Table: al_menu_item

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
root_id	INT		NULL	foreign key to column id on table al_menu_item.
parent_id	INT		NULL	foreign key to column id on table al_menu_item.
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
name	VARCHAR(255)	Not null		Menu item name
icon	VARCHAR(255)		NULL	Menu item icon
link	VARCHAR(255)	Not null		Menu item link
replacement_link	LONGTEXT		NULL	Link to be shown in url. If missing real link is shown
entity	VARCHAR(255)		NULL	The name of the class for which the link is generated
entity_id	VARCHAR(255)		NULL	The id of the entity for which the link is generated
entity_name	VARCHAR(255)		NULL	The name of the entity for which the link is generated
route	VARCHAR(255)		NULL	Route name
locale	VARCHAR(255)		NULL	Language locale
lft	INT	Not null
lvl	INT	Not null
rgt	INT	Not null

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_EBAEFECC3DA5256D	image_id	UNIQUE
IDX_EBAEFECC79066886	root_id	INDEX
IDX_EBAEFECC727ACA70	parent_id	INDEX

Table: al_meta_data

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_count	INT	Not null
locale	VARCHAR(255)	Not null	'en'
username	VARCHAR(255)		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_my_team

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)	Not null, Unique		Team name
slug	VARCHAR(255)	Unique	NULL	Unique identifier for team. Automatically generated based on name
all_users_selected	INT		NULL	Indicate if all users are selected for team

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_7255C4D75E237E06	name	UNIQUE
UNIQ_7255C4D7989D9B62	slug	UNIQUE

Table: al_my_team_user_aggregation

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT		NULL	foreign key to column id on table al_user.
my_team_id	INT		NULL	foreign key to column id on table al_my_team.
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
priority	INT	Not null		User position in team

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_5CF6EE403DA5256D	image_id	UNIQUE
IDX_5CF6EE40A76ED395	user_id	INDEX
IDX_5CF6EE40A3957482	my_team_id	INDEX

Table: al_order

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
shipping_id	INT		NULL	foreign key to column id on table al_shipping.
user_id	INT		NULL	foreign key to column id on table al_user.
current_pricelist_id	INT		NULL	foreign key to column id on table al_pricelist.
address_id	INT		NULL	foreign key to column id on table al_address.
shipping_address_id	INT		NULL	foreign key to column id on table al_address.
tax_id	INT		NULL	foreign key to column id on table al_tax.
completedAt	DATETIME		NULL	Completion date
payment_type	VARCHAR(255)		NULL	Name of payment type(in english language)
payment_additional_info	LONGTEXT		NULL	Data send from bank after payment(DC2Type:json)
payment_transaction_id	VARCHAR(255)		NULL	Transaction id received from bank after payment
payment_merchant_transaction_id	VARCHAR(255)		NULL	Unique id for order(for bank payment)
card_payment_state	VARCHAR(255)		NULL
items_total	DOUBLE		NULL	Total cost of all items in order, represented in default currency
base_items_total	DOUBLE		NULL	Total cost of all items in order without adjustments, represented in default currency
delivery_service_price	DECIMAL		NULL	Cost of delivery service, represented in default currency
delivery_service_code	VARCHAR(255)		NULL	Code of delivery service
adjustments_total	DECIMAL		NULL	Sum of all adjustments, represented in percentage
code	VARCHAR(255)		NULL	Unique value for order used in synchronization with erp
locale	VARCHAR(255)		NULL	Language locale when order was created
currency	VARCHAR(255)		NULL	Currency name for which order was created
currency_ratio	DOUBLE		1	Ratio for currency relative to default currency
tax_value	DOUBLE		NULL	Tax value, represented in percentage
vat_value	DOUBLE		NULL	Tax value, already calculated in price
total_with_tax	DOUBLE		NULL	Total cost of all items in order including tax, represented in default currency
total_with_delivery_service	DOUBLE		NULL	Total cost of all items in order including tax and delivery service cost, represented in default currency
total	DOUBLE		NULL	Total cost of all items in order including adjustments, represented in default currency
confirmed	TINYINT		NULL	Indicates if order has been confirmed by mail.
confirmation_token	VARCHAR(255)	Unique	NULL	Random string used to confirm order
created_at	DATETIME		NULL	Datetime when order was created
updatedAt	DATETIME		NULL	Datetime when order was last updated
state	VARCHAR(255)		NULL	State of order
discount	DOUBLE		NULL	Order discount, represented in default currency
previous_states	LONGTEXT		NULL	Collection of all previous states(DC2Type:simple_array)
checkout_comment	LONGTEXT		NULL	Order comment
anonymous	VARCHAR(255)		NULL	Name of user that created order(if user is not logged in)
session_id	VARCHAR(255)		NULL
anonymous_mail	VARCHAR(255)		NULL	Email of user that created order(if user is not logged in)
coupon_code	VARCHAR(255)		NULL
has_address	TINYINT	Not null		Indicates if user has entered/selected address
synchronized_with_erp	TINYINT		NULL	Indicates if order is synchronized with erp
erp_synchronization_comment	LONGTEXT		NULL
number	VARCHAR(255)		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_FBA6877AC05FB297	confirmation_token	UNIQUE
IDX_FBA6877A4887F3F8	shipping_id	INDEX
IDX_FBA6877AA76ED395	user_id	INDEX
IDX_FBA6877A76B5E783	current_pricelist_id	INDEX
IDX_FBA6877AF5B7AF75	address_id	INDEX
IDX_FBA6877A4D4CFF2B	shipping_address_id	INDEX
IDX_FBA6877AB2A824D8	tax_id	INDEX

Table: al_order_item

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
order_id	INT		NULL	foreign key to column id on table al_order.
product_id	INT		NULL	foreign key to column id on table al_product.
state	VARCHAR(255)		NULL	State of order item. One of the predefined.
quantity	INT		NULL	Number of products
quantity_obtained	INT		NULL	Number of products obtained
unit_price	DOUBLE		NULL	Price of single product
adjustments_total	DOUBLE		NULL	Total adjustment, represented in percentage
fixed_adjustments_total	DOUBLE		NULL	Fixed total adjustment, represented in default currency
tax_value	DOUBLE		NULL	Tax value, represented in percentage
vat_value	DOUBLE		NULL	Tax value, already calculated in price
total	DOUBLE		NULL	Total cost of all products in order item including adjustments, represented in default currency
product_sku	VARCHAR(255)	Not null		Sku of product
product_name	VARCHAR(255)	Not null		Name of product

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_AB6F3A4D8D9F6D38	order_id	INDEX
IDX_AB6F3A4D4584665A	product_id	INDEX

Table: al_order_promotions

Description:

Columns:

Column	Data type	Attributes	Default	Description
promotion_id	INT	PRIMARY, Not null		foreign key to column id on table al_promotion.
order_id	INT	PRIMARY, Not null		foreign key to column id on table al_order.

Indices:

Name	Columns	Type	Description
PRIMARY	promotion_id, order_id	PRIMARY
IDX_A4BB2B39139DF194	promotion_id	INDEX
IDX_A4BB2B398D9F6D38	order_id	INDEX

Table: al_package

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
title	VARCHAR(255)	Not null, Unique		Package title

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_A8FA2C092B36786B	title	UNIQUE

Table: al_pay_pal_payment_details

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
details	LONGTEXT	Not null		(DC2Type:json_array)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_payment_account

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
business_account	VARCHAR(255)		NULL	Business account information
api_username	VARCHAR(255)		NULL	API username
APIPassword	VARCHAR(255)		NULL	Api password
APISignature	VARCHAR(255)		NULL	Api signature

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_payment_account_stripe

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
strip_public	VARCHAR(255)		NULL	Stripe public
strip_private	VARCHAR(255)		NULL	Stripe private

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_payment_security_token

Description:

Columns:

Column	Data type	Attributes	Default	Description
hash	VARCHAR(255)	PRIMARY, Not null
details	LONGTEXT		NULL	(DC2Type:object)
after_url	LONGTEXT		NULL
target_url	LONGTEXT	Not null
gateway_name	VARCHAR(255)	Not null

Indices:

Name	Columns	Type	Description
PRIMARY	hash	PRIMARY

Table: al_payment_terms

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
content	LONGTEXT	Not null		Payment terms content

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_payment_type

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
card_payment	TINYINT	Not null		Card payment
card_payment_data	LONGTEXT		NULL	Card payment type(DC2Type:array)
description	LONGTEXT		NULL	Payment description
icon	LONGTEXT		NULL	Payment icon
payment_name	VARCHAR(255)	Unique	NULL	Payment type name
payment_value	VARCHAR(255)		NULL	Payment type value

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_724C679E7FA0E972	payment_name	UNIQUE

Table: al_payment_type_guest_role_disable

Description:

Columns:

Column	Data type	Attributes	Default	Description
payment_type_id	INT	PRIMARY, Not null		foreign key to column id on table al_payment_type.
role_id	INT	PRIMARY, Not null		foreign key to column id on table al_role.

Indices:

Name	Columns	Type	Description
PRIMARY	payment_type_id, role_id	PRIMARY
IDX_DB2CD4F4DC058279	payment_type_id	INDEX
IDX_DB2CD4F4D60322AC	role_id	INDEX

Table: al_payment_type_pricelist

Description:

Columns:

Column	Data type	Attributes	Default	Description
payment_type_id	INT	PRIMARY, Not null		foreign key to column id on table al_payment_type.
pricelist_id	INT	PRIMARY, Not null		foreign key to column id on table al_pricelist.

Indices:

Name	Columns	Type	Description
PRIMARY	payment_type_id, pricelist_id	PRIMARY
IDX_F3F609E7DC058279	payment_type_id	INDEX
IDX_F3F609E789045958	pricelist_id	INDEX

Table: al_payment_type_role_disable

Description:

Columns:

Column	Data type	Attributes	Default	Description
payment_type_id	INT	PRIMARY, Not null		foreign key to column id on table al_payment_type.
role_id	INT	PRIMARY, Not null		foreign key to column id on table al_role.

Indices:

Name	Columns	Type	Description
PRIMARY	payment_type_id, role_id	PRIMARY
IDX_357C5E74DC058279	payment_type_id	INDEX
IDX_357C5E74D60322AC	role_id	INDEX

Table: al_pdf_document

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
file_id	INT	Unique	NULL	foreign key to column id on table al_pdf_file.
title	VARCHAR(255)		NULL
base_image_url	LONGTEXT		NULL
base_pdf_url	LONGTEXT		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_ACDAAA6D3DA5256D	image_id	UNIQUE
UNIQ_ACDAAA6D93CB796C	file_id	UNIQUE

Table: al_pdf_file

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)		NULL	File name
file_size	VARCHAR(255)		NULL	File size

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_plugin_config

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
theme_name	VARCHAR(255)	Not null		Theme name
plugin_name	VARCHAR(255)	Not null		Plugin name
active	TINYINT	Not null		State of plugin
core	TINYINT	Not null	0	Plugin is core, always active
dependency	LONGTEXT		NULL	List of plugins on which this plugin depends(DC2Type:simple_array)
priority	INT	Not null		Plugin priority
views_name	VARCHAR(255)	Not null		Plugin views name

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_plugin_config_template

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
plugin_id	INT		NULL	foreign key to column id on table al_plugin_config.
layout	VARCHAR(255)		NULL	Layout name in which template will be loaded
twig	VARCHAR(255)	Not null		Twig template name
page	VARCHAR(255)	Not null		Page on which template will be loaded
name	VARCHAR(255)		NULL	Template name
image	VARCHAR(255)		NULL	Template image
active	TINYINT	Not null		Is template active
priority	INT	Not null		Template priority inside specific plugin

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_BAC18F4EEC942BCF	plugin_id	INDEX

Table: al_pools

Description:

Prepared instances (pool)

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)	Not null		Name of prepared instance
theme	VARCHAR(255)	Not null		Theme name of prepared instance

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_price

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT		NULL	foreign key to column id on table al_product.
value	DOUBLE	Not null		Product price
date_from	DATETIME		NULL	Product price valid from
date_to	DATETIME		NULL	Product price valid to

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_C447363B4584665A	product_id	INDEX

Table: al_pricelist

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)		NULL	Name of pricelist
currency	VARCHAR(255)		NULL	Currency string of pricelist
is_default	TINYINT	Not null	0	Is pricelist default
erp_code	VARCHAR(255)		NULL	Erp code of pricelist
discount	DOUBLE		NULL	Base discount
discounts	LONGTEXT		NULL	Array of quantity dependent discounts(DC2Type:json)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_pricelist_item

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
pricelist_id	INT	Unique	NULL	foreign key to column id on table al_pricelist.
product_id	INT	Unique	NULL	foreign key to column id on table al_product.
price	DOUBLE	Not null		Price for item
action_price	DOUBLE		NULL	Price for action

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_pricelist_item_pricelist_product_unique	pricelist_id, product_id	UNIQUE
IDX_BEC6E95789045958	pricelist_id	INDEX
IDX_BEC6E9574584665A	product_id	INDEX

Table: al_privacy_policy

Description:

Privacy policy

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
language_id	INT	Not null, Unique		foreign key to column id on table al_language.
content	LONGTEXT		NULL	Privacy policy for shop
cookies_text	LONGTEXT		NULL	Text to display about cookies information

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_9683C5CC82F1BAF4	language_id	UNIQUE

Table: al_product

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
brand_id	INT		NULL	foreign key to column id on table al_brand.
unit_of_measure_id	INT		NULL	foreign key to column id on table al_unit_of_measure.
package_id	INT		NULL	foreign key to column id on table al_package.
unit_of_measure_weight_id	INT		NULL	foreign key to column id on table al_unit_of_measure.
unit_of_measure_qty_per_package_id	INT		NULL	foreign key to column id on table al_unit_of_measure.
used_as_pav_product	TINYINT		0	Product used as product attribute values
pricelist_items_array	LONGTEXT		NULL	List of associated price list items represented in one field for easier manipulation(DC2Type:json)
default_pricelist_discount	INT		NULL	Default percentage price list discount
view_count	INT	Not null	0	Number of times the product is viewed
sales	INT	Not null	0	Number of times the product is sold
company_name	VARCHAR(255)		NULL
base_image_url	LONGTEXT		NULL	Path to product base image
deleted_at	DATETIME		NULL	Date when product set to UNAVAILABLE
has_null_category	TINYINT	Not null		Product assigned to any category
erp_code	VARCHAR(255)	Unique	NULL
tax_value	DOUBLE		NULL	Tax value for product
vat_value	DOUBLE		NULL	Vat value for product
is_new	TINYINT	Not null	1	Product is new
on_sale	TINYINT	Not null	0	Product is on sale
on_total_sale	TINYINT	Not null	0	Product is on total sale
damaged_good	TINYINT	Not null	0	Product is damaged
permissions	LONGTEXT		NULL	Product permissions(DC2Type:simple_array)
keywords	LONGTEXT		NULL	Product keywords(DC2Type:simple_array)
additional_keywords	LONGTEXT		NULL	Product additional keywords for search(DC2Type:simple_array)
product_search_options	LONGTEXT		NULL	Contains all product specific search terms(DC2Type:json_array)
price_from	DOUBLE		NULL	If product contains product attribute values, represents minimal price
price_to	DOUBLE		NULL	If product contains product attribute values, represents maximal price
review_rating	DOUBLE		NULL	Product rating
admin_review	TINYINT		0	Fixed rating set by admin
product_search_string	LONGTEXT		NULL	Contains product specific search terms
outlet	TINYINT	Not null	0	Product is on outlet
quantity_rebate	LONGTEXT		NULL	Product quantity rebate(DC2Type:json_array)
quantity_step	INT		1	Product quantity to add to cart
width	DOUBLE		0	Product width
height	DOUBLE		0	Product height
depth	DOUBLE		0	Product depth
weight	DOUBLE		0	Product weight with weight of its packaging
net_weight	DOUBLE		0	Product weight without weight of its packaging
qty_per_package	DOUBLE		1	Number of products per package
seo_title	VARCHAR(255)		NULL	SEO title for product
seo_description	LONGTEXT		NULL	SEO description for product
seo_keywords	LONGTEXT		NULL	SEO keywords for product
custom_labels	LONGTEXT		NULL	Array of labels for product(DC2Type:json)
custom_product_links	LONGTEXT		NULL	Array of associated links(DC2Type:json)
product_name	VARCHAR(255)	Not null		Name of product
created_at	DATETIME		NULL	Date when product created
updated_at	DATETIME		NULL	Date when product last updated
arrival_date	DATETIME		NULL	Date when product will be available
description	LONGTEXT		NULL	Description of product
on_action	TINYINT		NULL	Product is on action
price_on_action	DOUBLE		NULL	Product action price
sku	VARCHAR(255)		NULL	Sku of product
youtube_url	VARCHAR(255)		''	Link to youtube video
vimeo_url	VARCHAR(255)		''
status	VARCHAR(255)		'UNAVAILABLE'	Product availability (AVAILABLE, UNAVAILABLE)(DC2Type:product_status_type)
tags	LONGTEXT		NULL	Product tags, specific keywords(DC2Type:simple_array)
description_html	LONGTEXT	Not null		Description of product as HTML
product_type	VARCHAR(255)	Not null	'SIMPLE'	Type of product(DC2Type:product_type_type)
current_price	DOUBLE		NULL	Product price
slug	VARCHAR(255)	Unique	NULL	Product slug
updated_by	VARCHAR(255)	Not null
hash	VARCHAR(255)		NULL
permalink	VARCHAR(255)		NULL	Product permalink, needs to be unique on database level
prevent_direct_add_to_cart	TINYINT		0	Can you add product to cart directly from product component. If product has multiple product attribute values you can't add it from component

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_A5D84F3161EE0AEB	erp_code	UNIQUE
UNIQ_A5D84F31989D9B62	slug	UNIQUE
IDX_A5D84F3144F5D008	brand_id	INDEX
IDX_A5D84F31DA4E2C90	unit_of_measure_id	INDEX
IDX_A5D84F31F44CABFF	package_id	INDEX
IDX_A5D84F31DB886B16	unit_of_measure_weight_id	INDEX
IDX_A5D84F31B921077D	unit_of_measure_qty_per_package_id	INDEX
sales_idx	sales	INDEX

Table: al_product_att_value_order_item

Description:

Columns:

Column	Data type	Attributes	Default	Description
order_item_id	INT	PRIMARY, Not null		foreign key to column id on table al_order_item.
product_attribute_values_id	INT	PRIMARY, Not null		foreign key to column id on table al_product_attribute_values.

Indices:

Name	Columns	Type	Description
PRIMARY	order_item_id, product_attribute_values_id	PRIMARY
IDX_6B2E67F9E415FB15	order_item_id	INDEX
IDX_6B2E67F93B30C44E	product_attribute_values_id	INDEX

Table: al_product_attribute_value_feature

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_attribute_value_id	INT		NULL	foreign key to column id on table al_product_attribute_values.
feature_name	VARCHAR(255)	Not null		Product attribute value feature name
feature_value	VARCHAR(255)	Not null		Product attribute value feature value

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_F4272C899774A42E	product_attribute_value_id	INDEX

Table: al_product_attribute_values

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
file_id	INT	Unique	NULL	foreign key to column id on table al_file.
product_id	INT		NULL	foreign key to column id on table al_product.
pav_product_id	INT	Unique	NULL	foreign key to column id on table al_product.
code	INT	Unique	NULL	Code to connect product attribute values with ERP representation of entity
cost	DOUBLE		0	Price of product attribute values
sku	VARCHAR(255)		NULL	Sku of product attribute values
erp_code	VARCHAR(255)		NULL	Code to connect product attribute values with ERP representation of entity
quantity	INT	Not null	0	Available quantity, total quantity decreased by reserved quantity
total_quantity	INT	Not null	0	Total quantity in stock, including reserved quantity
reserved_quantity	INT	Not null	0	Reserved quantity
min_quantity	INT		NULL	Minimal quantity that can be added to cart
tax_value	INT		NULL	Tax value for product attribute values
quantity_step	INT		NULL	Product attribute values quantity to add to cart
default_pav	TINYINT		NULL	Default product attribute value
display_to_user	TINYINT	Not null	1	Show product attribute values fo user
base_image_url	VARCHAR(255)		NULL	Path to default image
price_on_action	DOUBLE		NULL	Product attribute values action price
keywords	LONGTEXT		NULL	Product attribute values keywords(DC2Type:simple_array)
additional_keywords	LONGTEXT		NULL	Product attribute values additional keywords(DC2Type:simple_array)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_6A64C75577153098	code	UNIQUE
UNIQ_6A64C75593CB796C	file_id	UNIQUE
UNIQ_6A64C7556E8ECA83	pav_product_id	UNIQUE
IDX_6A64C7554584665A	product_id	INDEX

Table: al_product_category

Description:

Columns:

Column	Data type	Attributes	Default	Description
product_id	INT	PRIMARY, Not null		foreign key to column id on table al_product.
category_id	INT	PRIMARY, Not null		foreign key to column id on table al_category.

Indices:

Name	Columns	Type	Description
PRIMARY	product_id, category_id	PRIMARY
IDX_3086950E4584665A	product_id	INDEX
IDX_3086950E12469DE2	category_id	INDEX

Table: al_product_entity_relationship

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
main_product_id	INT	Unique	NULL	foreign key to column id on table al_product.
title	VARCHAR(255)		NULL	Name of simple relationship

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_product_entity_relationship_unique	main_product_id	UNIQUE

Table: al_product_group

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)		'0'	Name of group
is_active	TINYINT		0	Is group active
date_from	DATETIME		NULL	Date from which the group is available
date_to	DATETIME		NULL	Date to which the group is available
keywords	VARCHAR(255)		NULL	Products can be filtered by keywords
products	LONGTEXT		NULL	Final array of all ids of products in group(DC2Type:array)
custom_products	LONGTEXT		NULL	(DC2Type:array)
serialized_search_wrapper	LONGTEXT		NULL
base_discount	INT		NULL
discounts	LONGTEXT		NULL	(DC2Type:array)
priority	INT	Not null
base_fixed_discount	INT		NULL
fixed_discounts_array	LONGTEXT		NULL	(DC2Type:json)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_product_group_attribute

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_group_id	INT		NULL	foreign key to column id on table al_product_group.
attribute_id	INT		NULL	foreign key to column id on table al_attribute.

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_1F0BDFDC35E4B3D0	product_group_id	INDEX
IDX_1F0BDFDCB6E62EFA	attribute_id	INDEX

Table: al_product_group_attribute_attribute_value

Description:

Columns:

Column	Data type	Attributes	Default	Description
product_group_attribute_id	INT	PRIMARY, Not null		foreign key to column id on table al_product_group_attribute.
attribute_value_id	INT	PRIMARY, Not null		foreign key to column id on table al_attribute_value.

Indices:

Name	Columns	Type	Description
PRIMARY	product_group_attribute_id, attribute_value_id	PRIMARY
IDX_F8CB3520A876E1BF	product_group_attribute_id	INDEX
IDX_F8CB352065A22152	attribute_value_id	INDEX

Table: al_product_group_brand

Description:

Columns:

Column	Data type	Attributes	Default	Description
product_group_id	INT	PRIMARY, Not null		foreign key to column id on table al_product_group.
brand_id	INT	PRIMARY, Not null		foreign key to column id on table al_brand.

Indices:

Name	Columns	Type	Description
PRIMARY	product_group_id, brand_id	PRIMARY
IDX_3A0AFF9D35E4B3D0	product_group_id	INDEX
IDX_3A0AFF9D44F5D008	brand_id	INDEX

Table: al_product_group_category

Description:

Columns:

Column	Data type	Attributes	Default	Description
product_group_id	INT	PRIMARY, Not null		foreign key to column id on table al_product_group.
category_id	INT	PRIMARY, Not null		foreign key to column id on table al_category.

Indices:

Name	Columns	Type	Description
PRIMARY	product_group_id, category_id	PRIMARY
IDX_A2C2330C35E4B3D0	product_group_id	INDEX
IDX_A2C2330C12469DE2	category_id	INDEX

Table: al_product_group_discount_user

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_group_id	INT		NULL	foreign key to column id on table al_product_group.
limit_to_price_list_id	INT		NULL	foreign key to column id on table al_pricelist.
base_discount	INT		NULL
discounts	LONGTEXT		NULL	(DC2Type:json)
base_fixed_discount	INT		NULL
fixed_discounts_array	LONGTEXT		NULL	(DC2Type:json)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_ECDBFFA435E4B3D0	product_group_id	INDEX
IDX_ECDBFFA48156B4B8	limit_to_price_list_id	INDEX

Table: al_product_group_discount_user_users

Description:

Columns:

Column	Data type	Attributes	Default	Description
product_group_discount_id	INT	PRIMARY, Not null		foreign key to column id on table al_product_group_discount_user.
user_id	INT	PRIMARY, Not null		foreign key to column id on table al_user.

Indices:

Name	Columns	Type	Description
PRIMARY	product_group_discount_id, user_id	PRIMARY
IDX_87FFCA5DDD414C8D	product_group_discount_id	INDEX
IDX_87FFCA5DA76ED395	user_id	INDEX

Table: al_product_logs

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
entity_id	INT		NULL
username	VARCHAR(255)		NULL
action_type	VARCHAR(255)		NULL
created_at	DATETIME		NULL
entity	VARCHAR(255)		NULL
object_changes	LONGTEXT		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_product_on_model

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
name	VARCHAR(255)	Not null		Product on model name
description	LONGTEXT	Not null		Product on model description
base_image_url	LONGTEXT		NULL	Base image url for main product on model image

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_6DC5E9EF3DA5256D	image_id	UNIQUE

Table: al_product_rating

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT	Unique	NULL	foreign key to column id on table al_product.
user_id	INT	Unique	NULL	foreign key to column id on table al_user.
rating	DOUBLE	Not null		Number of starts for rated product. Can be any number between 1 and 5

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_product_rating_unique	user_id, product_id	UNIQUE
IDX_12900A514584665A	product_id	INDEX
IDX_12900A51A76ED395	user_id	INDEX

Table: al_product_relationship

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null, Unique
main_product_id	INT	Unique	NULL	foreign key to column id on table al_product.
relationship_name_id	INT	Not null		foreign key to column id on table al_product_relationship_name.
erp_code	VARCHAR(255)		NULL	Unique code of relationship

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_category_primary	id, main_product_id	UNIQUE
IDX_18AAF2497D7C1239	main_product_id	INDEX
IDX_18AAF2494506A65F	relationship_name_id	INDEX

Table: al_product_relationship_categories

Description:

Columns:

Column	Data type	Attributes	Default	Description
product_relationship_id	INT	PRIMARY, Not null		foreign key to column id on table al_product_relationship.
category_id	INT	PRIMARY, Not null		foreign key to column id on table al_category.

Indices:

Name	Columns	Type	Description
PRIMARY	product_relationship_id, category_id	PRIMARY
IDX_3ED0EF321ECAD3F5	product_relationship_id	INDEX
IDX_3ED0EF3212469DE2	category_id	INDEX

Table: al_product_relationship_name

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)	Not null, Unique		Title of relationship
priority	INT	Not null		Priority of relationship name
position	VARCHAR(64)	Not null		Position of list
offset	INT	Not null		Number of products per page
type	VARCHAR(64)	Not null		Type of list
main_product_settings_override	TINYINT		NULL	Does this relationship name override general settings

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_2C7EAAE65E237E06	name	UNIQUE

Table: al_product_relationship_product

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null, Unique
main_product_id	INT	Unique	NULL	foreign key to column id on table al_product.
product_relationship_id	INT		NULL	foreign key to column id on table al_product_relationship.
priority	INT	Not null		Priority of product in specific list

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_product_relationship_primary	id, main_product_id	UNIQUE
IDX_8A26F92D7D7C1239	main_product_id	INDEX
IDX_8A26F92D1ECAD3F5	product_relationship_id	INDEX

Table: al_product_relationship_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
allow_without_main_product	TINYINT	Not null	0	Defines if relationships are allowed without main product

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_product_search_log

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT		NULL	foreign key to column id on table al_user.
search_param	VARCHAR(255)	Not null		Searched param for product
has_results	TINYINT	Not null	0	Search had results
created_at	DATETIME		NULL	Date when searched happend

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_E3E82E3AA76ED395	user_id	INDEX

Table: al_product_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
number_of_days_for_new_product	INT	Not null	0	Number of days product is considered new
require_same_product_add_to_cart_confirm	TINYINT	Not null	0	Confirm when adding the same product to cart
calculate_multiple_group_discounts	VARCHAR(255)	Not null		Calculate discount between multiple groups
calculate_pricelist_group_discounts	VARCHAR(255)	Not null		Calculate discount between groups and pricelist

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_product_single_entity_relationship

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_entity_relationship_id	INT		NULL	foreign key to column id on table al_product_entity_relationship.
name	VARCHAR(255)	Not null		Name of simple relationship
content	LONGTEXT	Not null		Content of simple relationship
priority	INT	Not null		Priority of relationship

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_55650F4B1D5260EA	product_entity_relationship_id	INDEX

Table: al_product_tag

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_on_model_id	INT		NULL	foreign key to column id on table al_product_on_model.
product_id	INT		NULL	foreign key to column id on table al_product.
height	INT	Not null		Product tag height dimension
width	INT	Not null		Product tag width dimension
coordinate_top	INT	Not null		Product tag top left coordinate
coordinate_left	INT	Not null		Product tag top left coordinate

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_92EEE3307A169FE7	product_on_model_id	INDEX
IDX_92EEE3304584665A	product_id	INDEX

Table: al_product_translation

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT	Unique	NULL	foreign key to column id on table al_product.
locale	VARCHAR(8)	Not null, Unique		Product translation locale
name_translation	VARCHAR(255)		NULL	Product name translation
short_description_translation	LONGTEXT		NULL	Product short description translation
description_translation	LONGTEXT		NULL	Product description translation
seo_title_translation	VARCHAR(255)		NULL	Product SEO title translation
seo_description_translation	LONGTEXT		NULL	Product SEO description translation
seo_keywords_translation	LONGTEXT		NULL	Product SEO keywords translation
permalink_translation	VARCHAR(255)		NULL	Product permalink translation

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_product_translation_locale_constraint	product_id, locale	UNIQUE
IDX_C21D68CD4584665A	product_id	INDEX

Table: al_promo_products_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
number_most_viewed	INT	Not null
text_most_viewed	VARCHAR(255)	Not null
number_best_sellers	INT	Not null
text_best_sellers	VARCHAR(255)	Not null
number_top_rated	INT	Not null
text_top_rated	VARCHAR(255)	Not null
number_newest	INT	Not null
text_newest	VARCHAR(255)	Not null

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_promotion

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)		NULL
description	VARCHAR(255)		NULL	Promotion description
priority	INT		NULL	When exclusive, promotion with top priority will be applied
exclusive	TINYINT		NULL	Cannot be applied together with other promotions
type	VARCHAR(255)	Not null		Promotion type
code	VARCHAR(255)		NULL	Promotion code
usage_limit	INT		NULL	Maximum number of time promotion can be used
used	TINYINT		NULL	Number of times promotion has been used
starts_at	DATETIME		NULL	Date from which prmotion is valid
ends_at	DATETIME		NULL	Date until which promotion is valid
coupon_based	TINYINT		NULL	Whether this promotion is triggered by a coupon
send_by_mail	TINYINT		NULL	Notify users about promotion
updatedAt	DATETIME		NULL	Date when promotion last updated
created_at	DATETIME		NULL	Date when promotion created
all_users_selected	INT		NULL	Promotion valid for all users

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_question_survey_aggregation

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
question_id	INT		NULL	foreign key to column id on table al_survey_question.
survey_id	INT		NULL	foreign key to column id on table al_survey_survey.
position	INT		NULL	Question survey aggregation position
required	TINYINT		NULL	Question survey aggregation is required

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_E6F1D8CF1E27F6BF	question_id	INDEX
IDX_E6F1D8CFB3FE509D	survey_id	INDEX

Table: al_reclamation

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT		NULL	foreign key to column id on table al_user.
created_at	DATETIME		NULL	Date when reclamation created
updated_at	DATETIME		NULL	Date when reclamation last updated
status	VARCHAR(255)	Not null	'pending'	Reclamation status

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_BF2864A8A76ED395	user_id	INDEX

Table: al_reclamation_item

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
reclamation_id	INT		NULL	foreign key to column id on table al_reclamation.
order_item_id	INT		NULL	foreign key to column id on table al_order_item.
reclamation_problem_id	INT		NULL	foreign key to column id on table al_reclamation_problem.
number_of_pieces	INT	Not null		Number of products for reclamation
additional_info	VARCHAR(255)		NULL	Additional reclamation item description
invoice_number	VARCHAR(255)		NULL	Order identification

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_E32E44292D6BA2D9	reclamation_id	INDEX
IDX_E32E4429E415FB15	order_item_id	INDEX
IDX_E32E4429980D1ED7	reclamation_problem_id	INDEX

Table: al_reclamation_problem

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
title	VARCHAR(255)	Not null, Unique		Reclamation problem title
priority	INT	Not null		Reclamation problem priority

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_DC96A1E42B36786B	title	UNIQUE

Table: al_review

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT		NULL	foreign key to column id on table al_product.
user_id	INT		NULL	foreign key to column id on table al_user.
approved	TINYINT	Not null		Indicate if review should be shown on frontend
review_title	VARCHAR(255)	Not null		Review title
review_content	LONGTEXT	Not null		Review content
review_rating	DOUBLE		NULL	Number of starts for reviewed product
created_at	DATETIME		NULL	Date when review was posted

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_37498D864584665A	product_id	INDEX
IDX_37498D86A76ED395	user_id	INDEX

Table: al_role

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
parent_id	INT		NULL	foreign key to column id on table al_role.
name	VARCHAR(30)	Not null
role	VARCHAR(50)	Not null, Unique
lft	INT	Not null
lvl	INT	Not null
rgt	INT	Not null
root	INT		NULL
allowed_routes	LONGTEXT		NULL	Collection of allowed routes(DC2Type:simple_array)
regex_allowed_routes	LONGTEXT		NULL	Regex for allowed routes(DC2Type:simple_array)
backend_route	VARCHAR(255)		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_3F55A6257698A6A	role	UNIQUE
IDX_3F55A62727ACA70	parent_id	INDEX

Table: al_role_permissions

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
role_id	INT	Unique	NULL	foreign key to column id on table al_role.
role_permissions	LONGTEXT		NULL	(DC2Type:simple_array)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_E2C072BED60322AC	role_id	UNIQUE

Table: al_route_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
route_name	VARCHAR(255)		NULL	Route name
route_value	VARCHAR(255)		NULL	Route value
route_parent	VARCHAR(255)		NULL	Route parent
locale	VARCHAR(255)	Not null	'en'

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_rule

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
promotion_id	INT		NULL	foreign key to column id on table al_promotion.
rule_type	VARCHAR(255)		NULL	Rule type
configuration	LONGTEXT		NULL	Configuration of the rule(DC2Type:array)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_12447CC4139DF194	promotion_id	INDEX

Table: al_sas

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
sas_image_id	INT	Unique	NULL	foreign key to column id on table al_sas_image.
first_name	VARCHAR(255)	Not null		First name of user who requested new sas instance
last_name	VARCHAR(255)	Not null		Last name of user who requested new sas instance
email	VARCHAR(255)	Not null		Email of user who requested new sas instance
company	VARCHAR(255)	Not null, Unique		Company name of user who requested new sas instance
domain	VARCHAR(255)	Not null, Unique		Domain generated from company and sas domain
phone_number	VARCHAR(255)	Not null		Phone number of user who requested new sas instance
street_name	VARCHAR(255)	Not null		Street name of user who requested new sas instance
street_number	VARCHAR(255)	Not null		Street number of user who requested new sas instance
city	VARCHAR(255)	Not null		City of user who requested new sas instance
country	VARCHAR(255)	Not null		Country of user who requested new sas instance
sas_token	VARCHAR(255)	Not null, Unique		Token used for identifying specific sas instace
active	TINYINT	Not null	0	Is sas instance activated
theme	VARCHAR(255)	Not null		Theme for sas instance

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_5E9B548D4FBF094F	company	UNIQUE
UNIQ_5E9B548DA7A91E0B	domain	UNIQUE
UNIQ_5E9B548D8A2B6D29	sas_token	UNIQUE
UNIQ_5E9B548D514996AB	sas_image_id	UNIQUE

Table: al_sas_domain

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Not null
domain	VARCHAR(255)	Not null		Sas domain
conf_dir	VARCHAR(255)	Not null		Path to base configuration

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_sas_image

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)		NULL	File name
file_size	VARCHAR(255)		NULL	File size

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_search_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
ajax_filters	TINYINT	Not null		Ajax triggering for the filters
ajax_search	TINYINT	Not null		Enable ajax searching in menu search box
filter_exclusion	TINYINT	Not null		Exclude filters on search
sync_category_page	TINYINT	Not null		Include category selectbox in menu search
infinite_scroll	TINYINT	Not null		Use infinite scroll for pagination on product listing pages
show_subcat_products	TINYINT	Not null		Show subcategory products
filter_labels	TINYINT	Not null		Show filter labels
show_price_range	TINYINT	Not null		Show price range
include_filter_values	TINYINT	Not null		Include filter values
all_search_params_in_one_field	TINYINT	Not null		All search params in one or multiple fields
show_subcategories	TINYINT	Not null		Show subcategories
show_search_field	TINYINT	Not null		Show search field
brands_first_on_search_page	TINYINT	Not null		Brands first on search page

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_section

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
title	VARCHAR(255)	Not null		Section title
description	LONGTEXT	Not null		Section description
locale	VARCHAR(255)	Not null	'en'	Section locale
base_image_url	LONGTEXT		NULL	Path to section image

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_5BE131733DA5256D	image_id	UNIQUE

Table: al_section_item

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
section_id	INT		NULL	foreign key to column id on table al_section.
text	VARCHAR(255)	Not null		Section item text
icon	VARCHAR(255)	Not null		Section item icon
priority	INT	Not null		Section item priority
value	LONGTEXT	Not null		Section item value

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_45B46ED6D823E37A	section_id	INDEX

Table: al_seo_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null		Seo settings entity
seo_title	VARCHAR(300)		NULL	Seo title
seo_keywords	VARCHAR(200)		NULL	Seo keywords
seo_description	VARCHAR(200)		NULL	Seo description

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_settings_translations

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
locale	VARCHAR(8)	Not null
object_class	VARCHAR(255)	Not null
field	VARCHAR(32)	Not null
foreign_key	VARCHAR(64)	Not null
content	LONGTEXT		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
article_translation_idx	locale, object_class, field, foreign_key	INDEX

Table: al_shipping

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
price	DOUBLE	Not null		Shipping price
description	LONGTEXT		NULL	Shipping description
name	VARCHAR(255)	Not null, Unique		Shipping provider name
type	VARCHAR(255)	Not null		Shipping provider type
code	VARCHAR(255)	Unique	NULL	Shipping provider code

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_D4D35A005E237E06	name	UNIQUE
UNIQ_D4D35A0077153098	code	UNIQUE
UNIQ_D4D35A003DA5256D	image_id	UNIQUE

Table: al_simple_product

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
base_product_id	INT	Unique	NULL	foreign key to column id on table al_product.
numberInStock	INT	Not null	0	Available quantity, total quantity decreased by researved quantity
min_quantity	INT	Not null	1	Minimal quantity that can be added to cart
total_quantity	INT	Not null	0	Total quantity in stock, including reserved quantity
reserved_quantity	INT	Not null	0	Reserved quantity
min_quantity_light_value	INT	Not null	0	Minimal quantity light value
max_quantity_light_value	INT	Not null	0	Maximal quantity light value

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_31667781D63EB556	base_product_id	UNIQUE

Table: al_slide

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
logo_image_id	INT	Unique	NULL	foreign key to column id on table al_image.
baseImageUrl	VARCHAR(255)		NULL	Slide base image url
logoImageUrl	VARCHAR(255)		NULL	Logo image url
slide_name	VARCHAR(255)	Not null		Slide name
slide_html	LONGTEXT	Not null		Slide name
text_position	VARCHAR(255)	Not null		Slide text position
text_color	VARCHAR(255)	Not null		Slide text color
logo_position	VARCHAR(255)	Not null		Slide logo position
createdAt	DATETIME		NULL	Slide created at
updatedAt	DATETIME		NULL	Slide updated at
sort_order	INT		0	Slider order priority
slide_link	VARCHAR(505)	Not null		Slide link
link_button	TINYINT	Not null		Slide link button
locale	VARCHAR(255)	Not null	'en'

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_7C60FA803DA5256D	image_id	UNIQUE
UNIQ_7C60FA806D947EBB	logo_image_id	UNIQUE

Table: al_slide_translations

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
locale	VARCHAR(8)	Not null
object_class	VARCHAR(255)	Not null
field	VARCHAR(32)	Not null
foreign_key	VARCHAR(64)	Not null
content	LONGTEXT		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
article_translation_idx	locale, object_class, field, foreign_key	INDEX

Table: al_slidersettings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
settings_name	VARCHAR(255)		NULL	Slider settings name
navigation	TINYINT		NULL	Slider navigation option
pagination	TINYINT		NULL	Slider pagination option
slide_speed	INT		NULL	Slider speed option
pagination_speed	INT		NULL	Slider pagination speed
mouse_drag	TINYINT		NULL	Slider mouse drag option
auto_play	INT		NULL	Slider autoplay option
stop_on_hover	TINYINT		NULL	Slider stop on hover option
transition_style	VARCHAR(255)		NULL	Slider transition style option
full_width	TINYINT		0	Slider full width option

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_social_network

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
sn_facebook	VARCHAR(300)		NULL	Social network facebook
sn_twitter	VARCHAR(300)		NULL	Social network twitter
sn_instagram	VARCHAR(300)		NULL	Social network instagram
sn_youtube	VARCHAR(300)		NULL	Social network youtube
sn_gplus	VARCHAR(300)		NULL	Social network google plus

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_special_offer

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product	INT		NULL	foreign key to column id on table al_product.
product_attr_value_id	INT		NULL	foreign key to column id on table al_product_attribute_values.
name	VARCHAR(255)	Not null
description	VARCHAR(255)	Not null
allUsersSelected	TINYINT	Not null
startDate	DATETIME		NULL
endDate	DATETIME		NULL
type_of_discount	VARCHAR(255)		NULL
discount	INT		NULL
percentage	DOUBLE		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_875AABD2D34A04AD	product	INDEX
IDX_875AABD2AC1E7D98	product_attr_value_id	INDEX

Table: al_special_offer_users

Description:

Columns:

Column	Data type	Attributes	Default	Description
special_offer_id	INT	PRIMARY, Not null		foreign key to column id on table al_special_offer.
user_id	INT	PRIMARY, Not null		foreign key to column id on table al_user.

Indices:

Name	Columns	Type	Description
PRIMARY	special_offer_id, user_id	PRIMARY
IDX_8670B815D37B1F79	special_offer_id	INDEX
IDX_8670B815A76ED395	user_id	INDEX

Table: al_static_page

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
user_id	INT		NULL	foreign key to column id on table al_user.
post_title	VARCHAR(128)	Not null, Unique		Title of Static Page
post_content	LONGTEXT	Not null		Content of Static Page
description	LONGTEXT		NULL	Short description of Static Page
createdAt	DATETIME		NULL	Date when Static Page was created
updatedAt	DATETIME		NULL	Date when Static Page was last updated at
visible	TINYINT		NULL	Defines if Static Page is visible
meta_keywords	LONGTEXT		NULL	Array of meta keywords(DC2Type:simple_array)
meta_title	LONGTEXT		NULL	Meta title of Static Page
meta_description	LONGTEXT		NULL	Meta description of Static Page
slug	VARCHAR(128)	Unique	NULL	Slug for Static Page
image_path	LONGTEXT		NULL	Url of main image
locale	VARCHAR(255)	Not null	'en'
blogCategory_id	INT		NULL	foreign key to column id on table al_static_pages_category.
permalink	VARCHAR(255)		NULL	Permalink for Static Page

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_FEECEF39BC2DF484	post_title	UNIQUE
UNIQ_FEECEF39989D9B62	slug	UNIQUE
UNIQ_FEECEF393DA5256D	image_id	UNIQUE
IDX_FEECEF391157C0A4	blogCategory_id	INDEX
IDX_FEECEF39A76ED395	user_id	INDEX

Table: al_static_page_comment

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
blog_post_id	INT		NULL	foreign key to column id on table al_static_page.
user_id	INT		NULL	foreign key to column id on table al_user.
comment_content	LONGTEXT	Not null		Content of comment
created_at	DATETIME		NULL	Date when comment was created
approved_at	DATETIME		NULL	Date when comment was approved for display
status	TINYINT		NULL	Defines status of comment
user_name	LONGTEXT	Not null		Username of user who wrote the comment
mail	LONGTEXT	Not null		Mail of user who wrote the comment

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_19D4187CA77FBEAF	blog_post_id	INDEX
IDX_19D4187CA76ED395	user_id	INDEX

Table: al_static_pages_category

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
root_id	INT		NULL	foreign key to column id on table al_static_pages_category.
parent_id	INT		NULL	foreign key to column id on table al_static_pages_category.
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
name	VARCHAR(64)	Unique	NULL	StaticPageCategory name
description	LONGTEXT		NULL	StaticPageCategory description
createdAt	DATETIME		NULL	Date when StaticPageCategory was created
updatedAt	DATETIME		NULL	Date when StaticPageCategory was last updated
lft	INT	Not null
lvl	INT	Not null
rgt	INT	Not null
number_of_posts	INT		NULL	Number of posts in category
meta_keywords	LONGTEXT		NULL	Array of meta keywords(DC2Type:simple_array)
meta_title	LONGTEXT		NULL	Meta title of StaticPageCategory
meta_description	LONGTEXT		NULL	Meta description of StaticPageCategory
only_for_logged_users	TINYINT	Not null	0	Defines if category should be displayed only to logged users
slug	VARCHAR(255)	Unique	NULL
icon	LONGTEXT		NULL	Icon of StaticPageCategory
locale	VARCHAR(255)	Not null	'en'
permalink	VARCHAR(255)		NULL	Permalink for StaticPageCategory

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_A12688805E237E06	name	UNIQUE
UNIQ_A1268880989D9B62	slug	UNIQUE
UNIQ_A12688803DA5256D	image_id	UNIQUE
IDX_A126888079066886	root_id	INDEX
IDX_A1268880727ACA70	parent_id	INDEX

Table: al_statistics

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_id	INT		NULL	foreign key to column id on table al_product.
user_id	INT		NULL	foreign key to column id on table al_user.
order_id	INT		NULL	foreign key to column id on table al_order.
session_id	VARCHAR(255)		NULL	User session identifier
date_created	DATETIME	Not null		Date when statistics data created
platform	VARCHAR(255)		NULL	Platform from which client visited shop
name	VARCHAR(255)		NULL	Visited route name
url	LONGTEXT		NULL	Visited URL
browser	VARCHAR(255)		NULL	Browser from which client visited shop
type	VARCHAR(255)		NULL	Device type from which client visited shop
order_created_at	DATETIME		NULL	Date when order created
order_finished_at	DATETIME		NULL	Date when order finished
type_of_action	VARCHAR(255)		NULL	Type of cart action (add, increased, decreased, removed)
product_qty	DOUBLE		NULL	Handled product quantity
product_attribute_values_id	INT		NULL	foreign key to column id on table al_product_attribute_values.

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_1B56AE664584665A	product_id	INDEX
IDX_1B56AE66A76ED395	user_id	INDEX
IDX_1B56AE668D9F6D38	order_id	INDEX
IDX_1B56AE663B30C44E	product_attribute_values_id	INDEX

Table: al_store

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
address	INT	Unique	NULL	foreign key to column id on table al_address.
marker_id	INT	Unique	NULL	foreign key to column id on table al_image.
store_img_id	INT	Unique	NULL	foreign key to column id on table al_image.
name	VARCHAR(255)	Not null		Name of store
business_hours	VARCHAR(255)		NULL	Opened hours
different_store_hours	TINYINT		NULL	Does store have different store hours
short_description	VARCHAR(255)		NULL	Description text
latitude	VARCHAR(255)	Not null		Latitude of store
longitude	VARCHAR(255)	Not null		Longitude of store
base_marker_url	LONGTEXT		NULL	Url of marker image
base_store_image_url	LONGTEXT		NULL	Url of store image

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_F1D84C95D4E6F81	address	UNIQUE
UNIQ_F1D84C95474460EB	marker_id	UNIQUE
UNIQ_F1D84C95A47D09C3	store_img_id	UNIQUE

Table: al_store_hours

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
store_id	INT		NULL	foreign key to column id on table al_store.
day	VARCHAR(255)		NULL
hour_from	VARCHAR(255)		NULL
hour_to	VARCHAR(255)		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_876CEB38B092A811	store_id	INDEX

Table: al_store_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
logo_id	INT	Unique	NULL	foreign key to column id on table al_image.
login_image_id	INT	Unique	NULL	foreign key to column id on table al_image.
header_image_id	INT	Unique	NULL	foreign key to column id on table al_image.
store_title	VARCHAR(655)		''	Store title
store_slogan	LONGTEXT		NULL	Store slogan
store_address	VARCHAR(655)		''	Store address
store_phone	VARCHAR(100)		''	Store phone number
store_email	VARCHAR(120)		''	Store email
login_modal	TINYINT		0	Login using modal option
base_logo_url	LONGTEXT		NULL	Base path to store image
base_login_image_url	LONGTEXT		NULL	Base path to login image
base_header_image_url	LONGTEXT		NULL	Base path to store image
number_of_categories_to_show	VARCHAR(255)		''	Number of categories to show
privacy_policy	LONGTEXT		NULL	Privacy policy for shop

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_7357B2E8F98F144A	logo_id	UNIQUE
UNIQ_7357B2E8130105F2	login_image_id	UNIQUE
UNIQ_7357B2E88C782417	header_image_id	UNIQUE

Table: al_submission

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
email	VARCHAR(255)	Not null, Unique		Email for submission
confirmed	TINYINT		NULL	Confirmed submission
createdAt	DATETIME		NULL	Created at field
updatedAt	DATETIME		NULL	Updated at field
rand_id	VARCHAR(255)		NULL	Random id field

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_22807FB7E7927C74	email	UNIQUE

Table: al_survey_answer

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
question_id	INT		NULL	foreign key to column id on table al_survey_question.
survey_id	INT		NULL	foreign key to column id on table al_survey_survey.
user_id	INT		NULL	foreign key to column id on table al_user.
createdAt	DATETIME		NULL	Survey answer created at
is_deleted_from_survey	TINYINT		NULL	Helper property if answer is deleted from survey
last_time_question_was_deleted	DATETIME		NULL	Helper property when answer is deleted from survey

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_F06100E41E27F6BF	question_id	INDEX
IDX_F06100E4B3FE509D	survey_id	INDEX
IDX_F06100E4A76ED395	user_id	INDEX

Table: al_survey_category

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
parent_id	INT		NULL	foreign key to column id on table al_survey_category.
root_id	INT		NULL	foreign key to column id on table al_survey_category.
slug	VARCHAR(255)	Unique	NULL
name	VARCHAR(255)		NULL	Survey category name
description	VARCHAR(255)		NULL	Survey description
icon	VARCHAR(255)		NULL	Survey icon
is_root_category	TINYINT		NULL	Defines if category is root category
lft	INT	Not null		Survey category left tree property
lvl	INT	Not null		Survey category level tree property
rgt	INT	Not null		Survey category right tree property
created_at	DATETIME		NULL	Survey category created at
updated_at	DATETIME		NULL	Survey category updated at
number_of_items	INT		NULL	Numeber of surveys inside category
locale	VARCHAR(255)	Not null	'en'

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_42A47DFC989D9B62	slug	UNIQUE
IDX_42A47DFC727ACA70	parent_id	INDEX
IDX_42A47DFC79066886	root_id	INDEX

Table: al_survey_choice

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
question_id	INT		NULL	foreign key to column id on table al_survey_question.
content	LONGTEXT	Not null		Choice text
priority	INT		NULL	Choice priority if question has multiple choices
is_answer_choice	TINYINT		NULL	If choice has been selected in any question
rank	INT		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_EB1710531E27F6BF	question_id	INDEX

Table: al_survey_mail

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
subject	VARCHAR(255)		NULL	Survey mail subject
description	VARCHAR(255)		NULL	Survey mail description
mails	LONGTEXT		NULL	Survey mail mails array(DC2Type:simple_array)
surveys	LONGTEXT		NULL	Survey mail collection of surveys(DC2Type:simple_array)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_survey_question

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
question_type	VARCHAR(255)		NULL	Question type(DC2Type:thumbnail_size_type)
is_answered	TINYINT		NULL	If question is answered or not
content	LONGTEXT		NULL	Question content
locale	VARCHAR(255)	Not null	'en'

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_survey_survey

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
survey_category_id	INT		NULL	foreign key to column id on table al_survey_category.
title	LONGTEXT	Not null		Survey title
description	LONGTEXT	Not null		Survey description
startDate	DATETIME		NULL	Survey start date
endDate	DATETIME		NULL	Survey end date
createdAt	DATETIME		NULL	Survey created at
status	TINYINT		NULL	Survey status active or inactive
number_of_answers	INT		NULL	Number of survey answers
featured	TINYINT		NULL	Defines if survey is featured
anonymous	TINYINT		NULL	Defines if survey can be answered anonymously
locale	VARCHAR(255)	Not null	'en'

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_87E3D13DAABE42E7	survey_category_id	INDEX

Table: al_survey_user

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user	INT	Unique	NULL	foreign key to column id on table al_user.
survey	INT	Unique	NULL	foreign key to column id on table al_survey_survey.

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_survey_user_constraint	user, survey	UNIQUE
IDX_3A32D62E8D93D649	user	INDEX
IDX_3A32D62EAD5F9BFC	survey	INDEX

Table: al_tax

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
tax_name	VARCHAR(255)	Not null		Name of tax
created_at	DATETIME		NULL	Date when tax was created
ratio	DECIMAL		NULL
locale	VARCHAR(255)	Not null	'en'

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_tax_translations

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
locale	VARCHAR(8)	Not null
object_class	VARCHAR(255)	Not null
field	VARCHAR(32)	Not null
foreign_key	VARCHAR(64)	Not null
content	LONGTEXT		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
article_translation_idx	locale, object_class, field, foreign_key	INDEX

Table: al_theme

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)	Not null, Unique		Theme name
slug	VARCHAR(128)	Unique	NULL	Theme slug
theme_image_url	VARCHAR(255)		NULL	Theme base image url

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_99FAF3EA5E237E06	name	UNIQUE
UNIQ_99FAF3EA989D9B62	slug	UNIQUE

Table: al_theme_options

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
theme_id	INT		NULL	foreign key to column id on table al_theme.
options_name	VARCHAR(255)	Not null		Theme options name
main_color	VARCHAR(255)		NULL	Main theme color
main_color_2	VARCHAR(255)		NULL	Second theme main color
secondary_color_2	VARCHAR(255)		NULL	Theme secondary color
secondary_color	VARCHAR(255)		NULL	Theme main secondary color
body_background_color	VARCHAR(255)		NULL	Theme body background colour
topnav_color	VARCHAR(255)		NULL	Theme top nav color
topnav_text_color	VARCHAR(255)		NULL	Theme top nav text color
header_background_color	VARCHAR(255)		NULL	Theme header background color
header_text_color	VARCHAR(255)		NULL	Theme header text color
menu_text_color	VARCHAR(255)		NULL	Theme menu text color
footer_text_color	VARCHAR(255)		NULL	Theme footer text color
footer_color	VARCHAR(255)		NULL	Theme footer color
border_radius	VARCHAR(255)		NULL	Border radius
font	VARCHAR(255)		'Arial'	Theme font
is_current	TINYINT	Not null	0	Is current theme option
is_default	TINYINT	Not null	0	Is default theme option

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_8BE47D0959027487	theme_id	INDEX

Table: al_thumbnail

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT		NULL	foreign key to column id on table al_image.
display_size	VARCHAR(255)	Not null
name	VARCHAR(255)		NULL	File name
file_size	VARCHAR(255)		NULL	File size

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_FFAD0D7A3DA5256D	image_id	INDEX

Table: al_thumbnail_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Not null
general_size	TINYTEXT		NULL	(DC2Type:thumbnail_size_type)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_ticket

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
file_id	INT	Unique	NULL	File id foreign key to column id on table al_file.
product_id	INT		NULL	foreign key to column id on table al_product.
user_id	INT		NULL	foreign key to column id on table al_user.
file_path	LONGTEXT		NULL	File url
file_name	LONGTEXT		NULL	File name
ticket_name	VARCHAR(255)	Not null		Ticket name
ticket_type	VARCHAR(255)	Not null		Ticket type
ticket_content	LONGTEXT	Not null		Ticket content
ticket_status	VARCHAR(50)	Not null		Ticket status
createdAt	DATETIME		NULL	Date when ticket was created
updatedAt	DATETIME		NULL	Date when ticket was last updated

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_D9AAA1E393CB796C	file_id	UNIQUE
IDX_D9AAA1E34584665A	product_id	INDEX
IDX_D9AAA1E3A76ED395	user_id	INDEX

Table: al_translation

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
language_id	INT	Unique	NULL	foreign key to column id on table al_language.
key	VARCHAR(255)	Not null, Unique		Translation key
content	LONGTEXT	Not null		Translation content/translated key for specified locale

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_translation_domain	language_id, key	UNIQUE
IDX_C52145C382F1BAF4	language_id	INDEX

Table: al_unit_of_measure

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
title	VARCHAR(255)	Not null, Unique		Unit of measure title
short	VARCHAR(255)	Not null
type	VARCHAR(255)		NULL	Unit of measure type
is_default	TINYINT	Not null		Indicates if current unit of measure is default for selected type
ratio	DOUBLE	Not null		Ratio between default and current unit of measure

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_66C55C4E2B36786B	title	UNIQUE

Table: al_unit_of_measure_pricing_rule

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
unit_of_measure_weight_pricing_id	INT		NULL	foreign key to column id on table al_unit_of_measure_weight_pricing.
min_quantity	DOUBLE		NULL	Define min weight for which rule will be applied
max_quantity	DOUBLE		NULL	Define max weight for which rule will be applied
min_price	DOUBLE		NULL	Define min price for which rule will be applied
max_price	DOUBLE		NULL	Define max price for which rule will be applied
additional_price	DOUBLE	Not null	0	Additional price for order
code	VARCHAR(255)		NULL	Pricing rule code

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_4588BA481D121F30	unit_of_measure_weight_pricing_id	INDEX

Table: al_unit_of_measure_weight_pricing

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
unit_of_measure_id	INT		NULL	foreign key to column id on table al_unit_of_measure.

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
IDX_2B9D3227DA4E2C90	unit_of_measure_id	INDEX

Table: al_user

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
address_id	INT	Unique	NULL	foreign key to column id on table al_address.
company_id	INT	Unique	NULL	foreign key to column id on table al_company.
avatar_id	INT	Unique	NULL	foreign key to column id on table al_image.
default_shipping_provider_id	INT		NULL	foreign key to column id on table al_shipping.
username	VARCHAR(255)	Not null
username_canonical	VARCHAR(255)	Not null, Unique
email	VARCHAR(255)	Not null
email_canonical	VARCHAR(255)	Not null, Unique
enabled	TINYINT	Not null
salt	VARCHAR(255)		NULL
password	VARCHAR(255)	Not null
last_login	DATETIME		NULL
confirmation_token	VARCHAR(255)		NULL
password_requested_at	DATETIME		NULL
locked	TINYINT		NULL	Indicates if user account is locked
expired	TINYINT		NULL	Indicates if user account has expired
user_specific_product_groups	LONGTEXT		NULL	(DC2Type:json_array)
type	VARCHAR(255)		'PERSONAL'	Type of user. One of defined(PERSONAL or COMPANY)(DC2Type:user_type_type)
first_name	VARCHAR(255)		NULL	User first name
last_name	VARCHAR(255)		NULL	Last name of user
user_code	VARCHAR(255)		NULL	User erp code
user_secondary_code	VARCHAR(255)		NULL	User code
phone_numbers	LONGTEXT		NULL	(DC2Type:json_array)
facebook_id	VARCHAR(255)		NULL
facebook_access_token	VARCHAR(255)		NULL
google_id	VARCHAR(255)		NULL
google_access_token	VARCHAR(255)		NULL
twitter_id	VARCHAR(255)		NULL
twitter_access_token	VARCHAR(255)		NULL
facebook_link	VARCHAR(255)		NULL	Url of user's facebook page
twitter_link	VARCHAR(255)		NULL	User's twitter access token
gplus_link	VARCHAR(255)		NULL	Url of user's google page
base_image_url	LONGTEXT		NULL	Users' profile image url
title	VARCHAR(128)		NULL
additionalInfo	VARCHAR(128)		NULL	Additional user's information
additional_user_information	LONGTEXT		NULL
default_payment_type	VARCHAR(255)		NULL	Payment which will be preselected on checkout
account_balance	DOUBLE		NULL
account_balance_plus	DOUBLE		NULL
account_balance_minus	DOUBLE		NULL
pricelist_items_array	LONGTEXT		NULL	Array that holds information about pricelist order for user and specific pricelist discounts for user(DC2Type:json)
gdpr_confirmed	TINYINT		NULL	Indicates if user has confirmed gdpr cookies

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_D90F064192FC23A8	username_canonical	UNIQUE
UNIQ_D90F0641A0D96FBF	email_canonical	UNIQUE
UNIQ_D90F0641F5B7AF75	address_id	UNIQUE
UNIQ_D90F0641979B1AD6	company_id	UNIQUE
UNIQ_D90F064186383B10	avatar_id	UNIQUE
IDX_D90F0641934BDEAB	default_shipping_provider_id	INDEX

Table: al_user_logs

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
entity_id	INT		NULL
username	VARCHAR(255)		NULL
action_type	VARCHAR(255)		NULL
created_at	DATETIME		NULL
entity	VARCHAR(255)		NULL
object_changes	LONGTEXT		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_user_settings

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
anonymous_allowed	TINYINT		0
require_erp_code	TINYINT		0
require_mail_confirmation	TINYINT		0	Indicates if registration should be confirmed via mail
show_price_if_user_not_logged	TINYINT		0	Indicates if anonymous users can see price
allow_coupon_if_user_not_logged	TINYINT		0	Indicates if anonymous users can use coupons
show_image_on_registration	TINYINT		0	Indicates whether to show dropzone field on registration or not
is_b2b_registration	TINYINT		0	Indicates if it is b2b registration
confirm_order_by_mail	TINYINT		0	Indicates if order should be confirmed via mail before completing it
require_captcha_confirmation	TINYINT		0	Indicates if captcha should be populate on registration
captcha_site_key	VARCHAR(300)		NULL	reCAPTCHA site key
captcha_secret_key	VARCHAR(300)		NULL	reCAPTCHA secret key
user_activated_by_default	TINYINT		0	Indicates if user is activated after the registration
user_cascade_discounts	TINYINT		0	Defines the way discounts are calculated, eg. 10% and 5% can be 15% but using cascade are 14.5%
order_merge_type	VARCHAR(255)	Not null	'clear_order'	Order merge type after user login
pricelist_type	VARCHAR(255)	Not null	'shop_pricelist_key'	Indicates from where product prices will be loaded
require_default_shipping_select	TINYINT		0	Show or hide default shipping provider on registration page
require_default_payment_select	TINYINT		0	Show or hide default payment type on registration page
add_available_quantity_by_default	TINYINT		0	If quantity is not available, add available and inform user about that
thousands_separator	VARCHAR(255)	Not null	' '	Default thousands separator for showing price
decimal_separator	VARCHAR(255)	Not null	'.'	Default decimal separator for showing price
decimal_places	INT	Not null	2	Default decimal places for showing price
reservation_warranty	INT	Not null	12	Warranty for reservations, expressed in months
max_quantity_per_order_item	INT	Not null	15	Max product quantity per order in reservation
max_number_of_items_per_order	INT	Not null	15	Max number of items per order in reservation
ignore_quantity_on_add_to_cart	TINYINT		0	Allow any quantity to be added regardless of number in stock

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_user_specific_pricelist

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
pricelist_id	INT	Unique	NULL	foreign key to column id on table al_pricelist.
user_id	INT	Unique	NULL	foreign key to column id on table al_user.
priority	INT	Not null		Priority of priclist for user
discount	DOUBLE		NULL	Discount value for pricelist and user
discounts	LONGTEXT		NULL	Array of quantity dependant discounts(DC2Type:json)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_user_specific_pricelist_pricelist_user_unique	pricelist_id, user_id	UNIQUE
IDX_899E48F389045958	pricelist_id	INDEX
IDX_899E48F3A76ED395	user_id	INDEX

Table: al_video

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product_video_id	INT	Unique	NULL	foreign key to column id on table al_video_document.
product	INT		NULL	foreign key to column id on table al_product.
title	VARCHAR(255)		NULL	Title of product video
description	LONGTEXT		NULL	Description of product video
enabled	TINYINT		NULL	Video enabled
youtubeUrl	VARCHAR(255)		NULL	YouTube video URL
vimeoUrl	VARCHAR(255)		NULL	Vimeo video URL
type	VARCHAR(255)	Not null		Product video type
playlist_id	VARCHAR(255)		NULL	Product video playlist id

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_7248CECEE2716AD9	product_video_id	UNIQUE
IDX_7248CECED34A04AD	product	INDEX

Table: al_video_document

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
name	VARCHAR(255)		NULL	File name
file_size	VARCHAR(255)		NULL	File size

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY

Table: al_watermark

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
enabled	TINYINT	Not null		Defines if watermark is enabled or not
image_watermark	TINYINT	Not null		If watermark is image type
text_label	VARCHAR(128)		NULL	If watermark is text label type
angle	DOUBLE	Not null		Watermark angle in degrees
gravity	INT		NULL	Watermark gravity
base_image_url	LONGTEXT		NULL	Watermark base image url

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_D64CC5183DA5256D	image_id	UNIQUE

Table: al_widget

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT	Unique	NULL	foreign key to column id on table al_user.
widgets	LONGTEXT	Not null		Sorted array of active widgets for specific user(DC2Type:simple_array)

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_CBF31290A76ED395	user_id	UNIQUE

Table: al_wish_list

Description:

Columns:

Column	Data type	Attributes	Default	Description
user_id	INT	PRIMARY, Not null		foreign key to column id on table al_user.
product_id	INT	PRIMARY, Not null		foreign key to column id on table al_product.

Indices:

Name	Columns	Type	Description
PRIMARY	user_id, product_id	PRIMARY
IDX_677D1221A76ED395	user_id	INDEX
IDX_677D12214584665A	product_id	INDEX

Table: al_wishlist

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
user_id	INT	Unique	NULL	foreign key to column id on table al_user.
name	VARCHAR(255)	Not null, Unique

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
al_wishlist_primary	name, user_id	UNIQUE
IDX_652E6715A76ED395	user_id	INDEX

Table: al_wishlist_product

Description:

Columns:

Column	Data type	Attributes	Default	Description
wishlist_id	INT	PRIMARY, Not null		foreign key to column id on table al_wishlist.
product_id	INT	PRIMARY, Not null		foreign key to column id on table al_product.

Indices:

Name	Columns	Type	Description
PRIMARY	wishlist_id, product_id	PRIMARY
IDX_B13C348FFB8E54CD	wishlist_id	INDEX
IDX_B13C348F4584665A	product_id	INDEX

Table: all_digital_catalogue_action_products

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Not null		foreign key to column id on table al_digital_catalogue.
product_id	INT	PRIMARY, Not null		foreign key to column id on table al_product.

Indices:

Name	Columns	Type	Description
PRIMARY	id, product_id	PRIMARY
IDX_155DCD3BF396750	id	INDEX
IDX_155DCD34584665A	product_id	INDEX

Table: all_digital_catalogue_category_products

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Not null		foreign key to column id on table al_digital_catalogue.
product_id	INT	PRIMARY, Not null		foreign key to column id on table al_product.

Indices:

Name	Columns	Type	Description
PRIMARY	id, product_id	PRIMARY
IDX_89F80313BF396750	id	INDEX
IDX_89F803134584665A	product_id	INDEX

Table: all_mass_mail_products

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Not null		foreign key to column id on table al_mass_mail.
product_id	INT	PRIMARY, Not null		foreign key to column id on table al_product.

Indices:

Name	Columns	Type	Description
PRIMARY	id, product_id	PRIMARY
IDX_593F03E9BF396750	id	INDEX
IDX_593F03E94584665A	product_id	INDEX

Table: ext_translations

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
locale	VARCHAR(8)	Not null, Unique
object_class	VARCHAR(255)	Not null, Unique
field	VARCHAR(32)	Not null, Unique
foreign_key	VARCHAR(64)	Not null, Unique
content	LONGTEXT		NULL

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
lookup_unique_idx	locale, object_class, field, foreign_key	UNIQUE
translations_lookup_idx	locale, object_class, foreign_key	INDEX

Table: product_360

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
product	INT	Unique	NULL	foreign key to column id on table al_product.
autoplay	TINYINT	Not null		Product360 autoplay option
autoplay_speed	INT	Not null		Product360 autoplay speed
buttons	TINYINT	Not null		Product360 buttons option
slider	TINYINT	Not null		Product360 slider option

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_9686771DD34A04AD	product	UNIQUE

Table: product_360_image

Description:

Columns:

Column	Data type	Attributes	Default	Description
id	INT	PRIMARY, Auto increments, Not null
image_id	INT	Unique	NULL	foreign key to column id on table al_image.
product360_id	INT		NULL	foreign key to column id on table product_360.
position	INT	Not null		Product360Image position in images array

Indices:

Name	Columns	Type	Description
PRIMARY	id	PRIMARY
UNIQ_8A13E8FC3DA5256D	image_id	UNIQUE
IDX_8A13E8FC5F02EAC5	product360_id	INDEX