# Akeneo schema ERD

Table and field reference for the Fivetran Akeneo connector.

## 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| attribute_table_configuration_index | Unknown | PK, FK |
| code | Unknown |  |
| labels | Json |  |

### attribute_table_configuration

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| attribute_code | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| labels | Json |  |
| variant_attribute_sets | Json |  |

### product_quality_score

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_uuid | Unknown | PK, FK |
| data | Unknown |  |
| locale | Unknown |  |
| scope | Unknown |  |

### product_completeness

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_uuid | Unknown | PK, FK |
| 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 | PK, FK |
| reference_entity_attribute_reference_entity | Unknown | PK, FK |
| labels | Json |  |

### attribute_option

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| attribute_code | Unknown | PK, FK |
| attribute | Unknown |  |
| labels | Json |  |
| sort_order | Unknown |  |

### attribute_group_attribute_code

| Column | Type | Keys |
| --- | --- | --- |
| attribute_group_code | Unknown | PK, FK |
| code | Unknown | PK, FK |

### 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 | PK, FK |
| created | Unknown |  |
| updated | Unknown |  |
| values | Json |  |

### family_attribute_code

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK, FK |
| family_code | Unknown | PK, FK |

### 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 | PK, FK |
| created | Unknown |  |
| updated | Unknown |  |
| values | Json |  |

## Relationships

- asset_family_transformation(asset_family_code) → asset_family(code)
- asset_family_product_link_rule(asset_family_code) → asset_family(code)
- reference_entity_attribute(reference_entity) → reference_entity(code)
- attribute_table_configuration_option(attribute_table_configuration_code) → attribute_table_configuration(attribute_code)
- attribute_table_configuration_option(attribute_table_configuration_index) → attribute_table_configuration(index)
- attribute_table_configuration(attribute_code) → attribute(code)
- product_model_quality_score(product_model_code) → product_model(code)
- product_model(family_code) → family(code)
- product_model(parent_code) → product_model(code)
- family_variant(family_code) → family(code)
- product_quality_score(product_uuid) → product(uuid)
- product_completeness(product_uuid) → product(uuid)
- product(parent_code) → product_model(code)
- reference_entity_attribute_option(reference_entity_attribute_code) → reference_entity_attribute(code)
- reference_entity_attribute_option(reference_entity_attribute_reference_entity) → reference_entity_attribute(reference_entity)
- attribute_option(attribute_code) → attribute(code)
- attribute_group_attribute_code(code) → attribute(code)
- attribute_group_attribute_code(attribute_group_code) → attribute_group(code)
- asset(asset_family_code) → asset_family(code)
- family_attribute_code(code) → attribute(code)
- family_attribute_code(family_code) → family(code)
- category(parent_code) → category(code)
- reference_entity_record(reference_entity_code) → reference_entity(code)