# Backbone PLM schema ERD

Table and field reference for the Fivetran Backbone PLM connector.

## Table & Field Reference

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| canceled | Unknown |  |
| code | Unknown |  |
| created_at | Unknown |  |
| created_by_first_name | Unknown |  |
| created_by_id | Unknown |  |
| created_by_last_name | Unknown |  |
| default_image_caption | Unknown |  |
| default_image_front_page | Unknown |  |
| default_image_id | Unknown |  |
| default_image_is_archived | Unknown |  |
| default_image_name | Unknown |  |
| default_image_url | Unknown |  |
| default_image_url_hi | Unknown |  |
| default_image_url_lo | Unknown |  |
| default_image_url_med | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| season_id | Unknown |  |
| season_name | Unknown |  |
| updated_at | Unknown |  |
| year_id | Unknown |  |
| year_name | Unknown |  |

### product_variant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| color_code | Unknown |  |
| color_company | Unknown |  |
| color_created_at | Unknown |  |
| color_created_by_hidden_pom_fields | Json |  |
| color_created_by_hidden_sample_fields | Json |  |
| color_external_code | Unknown |  |
| color_id | Unknown |  |
| color_image_comment_markers | Json |  |
| color_image_component_markers | Json |  |
| color_image_construction_detail_markers | Json |  |
| color_image_point_of_measure_markers | Json |  |
| color_image_sections | Json |  |
| color_internal_code | Unknown |  |
| color_name | Unknown |  |
| color_palettes | Json |  |
| color_updated_at | Unknown |  |
| color_updated_by_hidden_pom_fields | Json |  |
| color_updated_by_hidden_sample_fields | Json |  |
| color_v | Unknown |  |
| created_at | Unknown |  |
| created_bom_template_sort_pref | Unknown |  |
| created_by | Unknown |  |
| created_color_book_library_sort_pref | Unknown |  |
| created_company | Unknown |  |
| created_component_master_sort_pref | Unknown |  |
| created_components_sort_pref | Unknown |  |
| created_created_at | Unknown |  |
| created_created_by | Unknown |  |
| created_details_sort_pref | Unknown |  |
| created_email | Unknown |  |
| created_feature_tutorials | Json |  |
| created_file_sort_pref | Unknown |  |
| created_first_name | Unknown |  |
| created_homepage | Unknown |  |
| created_id | Unknown |  |
| created_item_master_sort_pref | Unknown |  |
| created_last_active | Unknown |  |
| created_last_name | Unknown |  |
| created_locale | Unknown |  |
| created_objects_sort_pref | Unknown |  |
| created_palette_library_sort_pref | Unknown |  |
| created_phone_verified | Unknown |  |
| created_pom_sort_pref | Unknown |  |
| created_preset_sort_pref | Unknown |  |
| created_role | Unknown |  |
| created_size_spec_uom_pref | Unknown |  |
| created_size_spec_view | Unknown |  |
| created_status | Unknown |  |
| created_title | Unknown |  |
| created_updated_at | Unknown |  |
| created_utilization_report_library_sort_pref | Unknown |  |
| created_v | Unknown |  |
| image_caption | Unknown |  |
| image_company | Unknown |  |
| image_created_at | Unknown |  |
| image_front_page | Unknown |  |
| image_id | Unknown |  |
| image_is_archived | Unknown |  |
| image_position | Unknown |  |
| image_sort | Unknown |  |
| image_thumbnailing_failed | Unknown |  |
| image_updated_at | Unknown |  |
| image_url | Unknown |  |
| image_url_hi | Unknown |  |
| image_url_lo | Unknown |  |
| image_url_med | Unknown |  |
| image_v | Unknown |  |
| images | Json |  |
| updated_at | Unknown |  |
| updated_bom_template_sort_pref | Unknown |  |
| updated_by | Unknown |  |
| updated_color_book_library_sort_pref | Unknown |  |
| updated_company | Unknown |  |
| updated_component_master_sort_pref | Unknown |  |
| updated_components_sort_pref | Unknown |  |
| updated_created_at | Unknown |  |
| updated_created_by | Unknown |  |
| updated_details_sort_pref | Unknown |  |
| updated_email | Unknown |  |
| updated_feature_tutorials | Json |  |
| updated_file_sort_pref | Unknown |  |
| updated_first_name | Unknown |  |
| updated_homepage | Unknown |  |
| updated_id | Unknown |  |
| updated_item_master_sort_pref | Unknown |  |
| updated_last_active | Unknown |  |
| updated_last_name | Unknown |  |
| updated_locale | Unknown |  |
| updated_objects_sort_pref | Unknown |  |
| updated_palette_library_sort_pref | Unknown |  |
| updated_phone_verified | Unknown |  |
| updated_pom_sort_pref | Unknown |  |
| updated_preset_sort_pref | Unknown |  |
| updated_role | Unknown |  |
| updated_size_spec_uom_pref | Unknown |  |
| updated_size_spec_view | Unknown |  |
| updated_status | Unknown |  |
| updated_title | Unknown |  |
| updated_updated_at | Unknown |  |
| updated_utilization_report_library_sort_pref | Unknown |  |
| updated_v | Unknown |  |
| view_preference_bill_of_materials | Unknown |  |
| view_preference_blocks | Unknown |  |
| view_preference_components | Unknown |  |
| view_preference_point_of_measure | Unknown |  |
| view_preference_products | Unknown |  |
| custom_** |  |  |

### component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| name | Unknown |  |
| price_number_decimal | Unknown |  |
| updated_at | Unknown |  |

### bom_divider

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| description | Unknown |  |
| id | Unknown |  |
| identifier | Unknown |  |
| position | Unknown |  |

### bom_item_techpack_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| image | Unknown |  |
| sections | Json |  |

### bom_item_component_variant

| Column | Type | Keys |
| --- | --- | --- |
| bom_item_index | Unknown | PK, FK |
| id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| component_custom_color | Unknown |  |
| data_code | Unknown |  |
| data_field | Json |  |
| data_image | Json |  |
| inherit_component_price | Unknown |  |
| price_numberdecimal | Unknown |  |

### bom_item_colorway

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bom_item_index | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| custom_color | Unknown |  |

### bom_item_component_techpack_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bom_item_index | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| image | Unknown |  |
| sections | Json |  |

### bom_item_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| component_id | Unknown | FK |
| component_canceled | Unknown |  |
| component_company | Unknown |  |
| component_created_at | Unknown |  |
| component_created_by | Unknown |  |
| component_type | Unknown |  |
| component_v | Unknown |  |
| component_variant_types | Json |  |
| created_at | Unknown |  |
| hidden | Unknown |  |
| id | Unknown |  |
| is_factory | Unknown |  |
| note | Unknown |  |
| placement | Unknown |  |
| price_numberdecimal | Unknown |  |
| quantity | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### bom_item_description

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| brand | Unknown |  |
| canceled | Unknown |  |
| category | Unknown |  |
| code | Unknown |  |
| company | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| description | Unknown |  |
| division | Unknown |  |
| files | Json |  |
| hide_bom_component_variant_1 | Unknown |  |
| hide_bom_component_variant_2 | Unknown |  |
| hide_bom_note | Unknown |  |
| hide_bom_placement | Unknown |  |
| hide_bom_pricing | Unknown |  |
| hide_bom_quantity | Unknown |  |
| name | Unknown |  |
| ordered_bom_item | Json |  |
| price | Unknown |  |
| price_unit | Unknown |  |
| sample_data | Json |  |
| sampling | Unknown |  |
| season | Unknown |  |
| size_spec | Unknown |  |
| updated_at | Unknown |  |
| year | Unknown |  |
| custom_** |  |  |

## Relationships

- product_variant(product_id) → product(id)
- bom_divider(product_id) → bom_item_description(product_id)
- bom_item_techpack_image(product_id) → bom_item_description(product_id)
- bom_item_component_variant(id) → product_variant(id)
- bom_item_component_variant(product_id) → bom_item_detail(product_id)
- bom_item_component_variant(bom_item_index) → bom_item_detail(index)
- bom_item_colorway(product_id) → bom_item_detail(product_id)
- bom_item_colorway(bom_item_index) → bom_item_detail(index)
- bom_item_component_techpack_image(product_id) → bom_item_detail(product_id)
- bom_item_component_techpack_image(bom_item_index) → bom_item_detail(index)
- bom_item_detail(component_id) → component(id)
- bom_item_detail(product_id) → product(id)
- bom_item_description(product_id) → product(id)