Akeneo
Explore the interactive ERD
Table & Field Reference
reference_entity
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
image | Unknown | |
labels | Json |
channel
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
category_tree | Unknown | |
conversion_units | Json | |
currencies | Json | |
labels | Json | |
locales | Json |
asset_family_transformation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
asset_family_code | Unknown | PKFK |
filename_suffix | Unknown | |
label | Unknown | |
operations | Json | |
source | Json | |
target | Json |
asset_family_product_link_rule
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
asset_family_code | Unknown | PKFK |
assign_assets_to | Json | |
product_selections | Json |
asset_family
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
attribute_as_main_media | Unknown | |
labels | Json | |
naming_convention_abort_asset_creation_on_error | Unknown | |
naming_convention_pattern | Unknown | |
naming_convention_source | Json | |
sharing_enabled | Unknown |
association_type
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
is_quantified | Unknown | |
is_two_way | Unknown | |
labels | Json |
reference_entity_attribute
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
reference_entity | Unknown | PKFK |
allowed_extensions | Json | |
decimals_allowed | Unknown | |
is_required_for_completeness | Unknown | |
is_rich_text_editor | Unknown | |
is_textarea | Unknown | |
labels | Json | |
max_characters | Unknown | |
max_file_size | Unknown | |
max_value | Unknown | |
min_value | Unknown | |
type | Unknown | |
validation_regexp | Unknown | |
validation_rule | Unknown | |
value_per_channel | Unknown | |
value_per_locale | Unknown |
attribute_table_configuration_option
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
attribute_table_configuration_code | Unknown | PKFK |
attribute_table_configuration_index | Unknown | PKFK |
code | Unknown | |
labels | Json |
attribute_table_configuration
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
attribute_code | Unknown | PKFK |
code | Unknown | |
data_type | Unknown | |
is_required_for_completeness | Unknown | |
labels | Json | |
validations | Json |
attribute
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
allowed_extensions | Json | |
attribute_group | Unknown | |
auto_option_sorting | Unknown | |
available_locales | Json | |
date_max | Unknown | |
date_min | Unknown | |
decimals_allowed | Unknown | |
default_metric_unit | Unknown | |
default_value | Unknown | |
group_labels | Json | |
guidelines | Json | |
is_main_identifier | Unknown | |
is_read_only | Unknown | |
is_unique | Unknown | |
labels | Json | |
localizable | Unknown | |
max_characters | Unknown | |
max_file_size | Unknown | |
metric_family | Unknown | |
minimum_input_length | Unknown | |
negative_allowed | Unknown | |
number_max | Unknown | |
number_min | Unknown | |
reference_data_name | Unknown | |
remove_html_tags | Unknown | |
scopable | Unknown | |
sort_order | Unknown | |
type | Unknown | |
useable_as_grid_filter | Unknown | |
validation_regexp | Unknown | |
validation_rule | Unknown | |
wysiwyg_enabled | Unknown |
product_model_quality_score
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_model_code | Unknown | PKFK |
data | Unknown | |
locale | Unknown | |
scope | Unknown |
product_model
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
family_code | Unknown | FK |
parent_code | Unknown | FK |
associations | Json | |
categories | Json | |
created | Unknown | |
family_variant_code | Unknown | |
quantified_associations | Json | |
updated | Unknown | |
values | Json |
product_media_files
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
code | Unknown | |
extension | Unknown | |
mime_type | Unknown | |
original_filename | Unknown | |
size | Unknown |
family_variant
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
family_code | Unknown | PKFK |
labels | Json | |
variant_attribute_sets | Json |
product_quality_score
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_uuid | Unknown | PKFK |
data | Unknown | |
locale | Unknown | |
scope | Unknown |
product_completeness
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_uuid | Unknown | PKFK |
data | Unknown | |
locale | Unknown | |
scope | Unknown |
product
| Column | Type | Keys |
|---|---|---|
uuid | Unknown | PK |
parent_code | Unknown | FK |
associations | Json | |
categories | Json | |
created | Unknown | |
family_code | Unknown | |
groups | Json | |
is_enabled | Unknown | |
quantified_associations | Json | |
updated | Unknown | |
values | Json |
reference_entity_attribute_option
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
reference_entity_attribute_code | Unknown | PKFK |
reference_entity_attribute_reference_entity | Unknown | PKFK |
labels | Json |
attribute_option
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
attribute_code | Unknown | PKFK |
attribute | Unknown | |
labels | Json | |
sort_order | Unknown |
attribute_group_attribute_code
| Column | Type | Keys |
|---|---|---|
attribute_group_code | Unknown | PKFK |
code | Unknown | PKFK |
attribute_group
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
attributes | Json | |
labels | Json | |
sort_order | Unknown |
asset
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
asset_family_code | Unknown | PKFK |
created | Unknown | |
updated | Unknown | |
values | Json |
family_attribute_code
| Column | Type | Keys |
|---|---|---|
code | Unknown | PKFK |
family_code | Unknown | PKFK |
family
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
attribute_as_image | Unknown | |
attribute_as_label | Unknown | |
attribute_requirements | Json | |
labels | Json |
category
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
parent_code | Unknown | FK |
labels | Json | |
position | Unknown | |
updated | Unknown | |
values | Json |
reference_entity_record
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
reference_entity_code | Unknown | PKFK |
created | Unknown | |
updated | Unknown | |
values | Json |