# Veeqo schema ERD

Table and field reference for the Fivetran Veeqo connector.

## Table & Field Reference

### supplier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| deleted_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| accounting_contact_email | Unknown |  |
| accounting_contact_name | Unknown |  |
| accounting_phone_number | Unknown |  |
| active_purchase_order_count | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| bank_account_number | Unknown |  |
| bank_name | Unknown |  |
| bank_sort_code | Unknown |  |
| city | Unknown |  |
| completed_purchase_order_count | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| credit_limit | Unknown |  |
| currency_code | Unknown |  |
| deleted_at | Unknown |  |
| name | Unknown |  |
| post_code | Unknown |  |
| purchase_order_template | Unknown |  |
| region | Unknown |  |
| reminder_email_template | Unknown |  |
| sales_contact_email | Unknown |  |
| sales_contact_name | Unknown |  |
| sales_phone_number | Unknown |  |
| updated_at | Unknown |  |

### sellable_stock_entry

| Column | Type | Keys |
| --- | --- | --- |
| updated_at | Unknown | PK |
| product_id | Unknown | PK, FK |
| sellable_id | Unknown | PK, FK |
| warehouse_id | Unknown | PK, FK |
| allocated_stock_level | Unknown |  |
| available_stock_level | Unknown |  |
| incoming_stock_level | Unknown |  |
| infinite | Unknown |  |
| location | Unknown |  |
| physical_stock_level | Unknown |  |
| sellable_on_hand_value | Unknown |  |
| stock_running_low | Unknown |  |
| transit_incoming_stock_level | Unknown |  |
| transit_outgoing_stock_level | Unknown |  |

### sellable_active_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| sellable_id | Unknown | PK, FK |
| name | Unknown |  |
| short_name | Unknown |  |
| type_code | Unknown |  |

### channel_sellable

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sellable_id | Unknown | PK |
| product_id | Unknown | PK, FK |
| channel_id | Unknown | FK |
| channel_product_id | Unknown | FK |
| channel_product_remote_title | Unknown |  |
| channel_product_status | Unknown |  |
| currency_code | Unknown |  |
| image_url | Unknown |  |
| remote_gram | Unknown |  |
| remote_margin | Unknown |  |
| remote_price | Unknown |  |
| remote_profit | Unknown |  |
| remote_sku | Unknown |  |
| remote_title | Unknown |  |
| url | Unknown |  |

### sellable

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| allocated_stock_level_at_all_warehouse | Unknown |  |
| cost_price | Unknown |  |
| created_at | Unknown |  |
| customs_description | Unknown |  |
| deleted_at | Unknown |  |
| estimated_delivery | Unknown |  |
| full_title | Unknown |  |
| image_url | Unknown |  |
| inventory_allocated_stock_level_at_all_warehouses | Unknown |  |
| inventory_available_stock_level_at_all_warehouses | Unknown |  |
| inventory_incoming_stock_level_at_all_warehouses | Unknown |  |
| inventory_infinite | Unknown |  |
| inventory_physical_stock_level_at_all_warehouses | Unknown |  |
| inventory_transit_incoming_stock_level_at_all_warehouses | Unknown |  |
| inventory_transit_outgoing_stock_level_at_all_warehouses | Unknown |  |
| main_thumbnail_url | Unknown |  |
| margin | Unknown |  |
| measurement_depth | Unknown |  |
| measurement_dimensions_unit | Unknown |  |
| measurement_height | Unknown |  |
| measurement_id | Unknown |  |
| measurement_width | Unknown |  |
| min_reorder_level | Unknown |  |
| on_hand_value | Unknown |  |
| origin_country | Unknown |  |
| price | Unknown |  |
| product_title | Unknown |  |
| profit | Unknown |  |
| quantity_to_reorder | Unknown |  |
| requires_review | Unknown |  |
| sellable_title | Unknown |  |
| sku_code | Unknown |  |
| stock_level_at_all_warehouses | Unknown |  |
| tax_rate | Unknown |  |
| title | Unknown |  |
| total_quantity_sold | Unknown |  |
| type | Unknown |  |
| upc_code | Unknown |  |
| updated_at | Unknown |  |
| variant_property_specific | Json |  |
| weight | Unknown |  |
| weight_gram | Unknown |  |
| weight_unit | Unknown |  |

### channel_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| channel_id | Unknown | FK |
| channel_short_name | Unknown |  |
| channel_type_code | Unknown |  |
| inactive_after | Unknown |  |
| remote_description | Unknown |  |
| remote_id | Unknown |  |
| remote_title | Unknown |  |
| status | Unknown |  |

### products_active_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| name | Unknown |  |
| short_name | Unknown |  |
| type_code | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| deleted_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| brand_display_position | Unknown |  |
| brand_id | Unknown |  |
| brand_name | Unknown |  |
| brand_products_count | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| estimated_delivery | Unknown |  |
| hs_tariff_number | Unknown |  |
| image | Unknown |  |
| inventory_infinite | Unknown |  |
| main_image_binary_data | Unknown |  |
| main_image_content_type | Unknown |  |
| main_image_created_at | Unknown |  |
| main_image_created_by_id | Unknown |  |
| main_image_deleted_at | Unknown |  |
| main_image_deleted_by_id | Unknown |  |
| main_image_display_position | Unknown |  |
| main_image_id | Unknown |  |
| main_image_picture_content_type | Unknown |  |
| main_image_picture_file_name | Unknown |  |
| main_image_picture_file_size | Unknown |  |
| main_image_picture_order | Unknown |  |
| main_image_picture_updated_at | Unknown |  |
| main_image_src | Unknown |  |
| main_image_updated_at | Unknown |  |
| main_image_updated_by_id | Unknown |  |
| notes | Unknown |  |
| on_hand_value | Unknown |  |
| origin_country | Unknown |  |
| product_tax_rate_id | Unknown |  |
| requires_review | Unknown |  |
| tags | Json |  |
| tax_rate | Unknown |  |
| thumbnail_url | Unknown |  |
| title | Unknown |  |
| total_allocated_stock_level | Unknown |  |
| total_available_stock_level | Unknown |  |
| total_quantity_sold | Unknown |  |
| total_stock_level | Unknown |  |
| updated_at | Unknown |  |
| web_meta_description | Unknown |  |
| web_meta_keywords | Unknown |  |
| web_meta_title | Unknown |  |
| web_page_title | Unknown |  |
| web_page_url | Unknown |  |
| weight | Unknown |  |

### orders_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| orders_id | Unknown | PK, FK |
| colour | Unknown |  |
| name | Unknown |  |

### orders_employee_note

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Unknown | PK |
| id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| created_at | Unknown |  |
| text | Unknown |  |

### orders_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| orders_id | Unknown | PK, FK |
| sellable_id | Unknown | FK |
| additional_option | Unknown |  |
| created_at | Unknown |  |
| picked_quantity | Unknown |  |
| price_per_unit | Unknown |  |
| quantity | Unknown |  |
| remote_id | Unknown |  |
| tax_rate | Unknown |  |
| taxless_discount_per_unit | Unknown |  |
| updated_at | Unknown |  |

### sellable_variant_option_specific

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allocation_id | Unknown | PK, FK |
| allocation_line_item_id | Unknown | PK, FK |
| orders_id | Unknown | PK, FK |
| product_property_id | Unknown |  |
| product_property_name | Unknown |  |
| product_specific_id | Unknown |  |
| value | Unknown |  |

### sellable_variant_property_specific

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allocation_id | Unknown | PK, FK |
| allocation_line_item_id | Unknown | PK, FK |
| orders_id | Unknown | PK, FK |
| product_property_id | Unknown |  |
| product_property_name | Unknown |  |
| product_specific_id | Unknown |  |
| value | Unknown |  |

### allocation_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allocation_id | Unknown | PK, FK |
| orders_id | Unknown | PK, FK |
| sellable_id | Unknown | FK |
| created_at | Unknown |  |
| picked_quantity | Unknown |  |
| quantity | Unknown |  |
| updated_at | Unknown |  |

### allocation_carrier_service_enhancement_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| allocation_id | Unknown | PK, FK |
| orders_id | Unknown | PK, FK |
| carrier_service_enhancement_code | Unknown |  |

### allocation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| warehouse_id | Unknown | FK |
| allocated_by_id | Unknown |  |
| created_at | Unknown |  |
| dispatch_date | Unknown |  |
| due_date | Unknown |  |
| matched_parcel_properties_criteria | Unknown |  |
| packed_completely | Unknown |  |
| preferred_shipment_option | Unknown |  |
| recommended_shipping_options_applied_service_rule_id | Unknown |  |
| recommended_shipping_options_applied_service_rule_name | Unknown |  |
| recommended_shipping_options_carrier_id | Unknown |  |
| recommended_shipping_options_created_at | Unknown |  |
| recommended_shipping_options_id | Unknown |  |
| recommended_shipping_options_params_additional_option | Unknown |  |
| recommended_shipping_options_params_service_id | Unknown |  |
| recommended_shipping_options_params_service_options_signature_required | Unknown |  |
| recommended_shipping_options_updated_at | Unknown |  |
| shipment | Unknown |  |
| total_weight | Unknown |  |
| updated_at | Unknown |  |
| weight_unit | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| channel_id | Unknown | FK |
| created_by_id | Unknown | FK |
| delivery_method_id | Unknown | FK |
| payment_created_by_id | Unknown | FK |
| additional_order_level_taxless_discount | Unknown |  |
| additional_order_level_taxless_discount_percentage | Unknown |  |
| adjustment_amount | Unknown |  |
| allocated_completely | Unknown |  |
| billing_address_id | Unknown |  |
| business_customer_billing_address_id | Unknown |  |
| business_customer_shipping_address_id | Unknown |  |
| buyer_user_id | Unknown |  |
| can_be_shipped | Unknown |  |
| can_pay_by_card | Unknown |  |
| cancel_reason | Unknown |  |
| cancelled_at | Unknown |  |
| cancelled_by | Unknown |  |
| contact_id | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| customer_id | Unknown |  |
| customer_note_id | Unknown |  |
| customer_note_text | Unknown |  |
| customer_viewable_note | Unknown |  |
| deliver_to_id | Unknown |  |
| delivery_cost | Unknown |  |
| delivery_method_cost | Unknown |  |
| delivery_method_name | Unknown |  |
| dispatch_date | Unknown |  |
| due_date | Unknown |  |
| fulfilled_by_amazon | Unknown |  |
| fulfillment_channel_order | Unknown |  |
| international | Unknown |  |
| invoice_date | Unknown |  |
| invoice_file_url | Unknown |  |
| invoice_sent_ago | Unknown |  |
| invoice_viewed_at | Unknown |  |
| is_amazon_premium_order | Unknown |  |
| is_amazon_prime | Unknown |  |
| mergable_checksum | Unknown |  |
| mergeable_id | Unknown |  |
| merged_order | Unknown |  |
| merged_to_id | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| payment_card_number | Unknown |  |
| payment_created_at | Unknown |  |
| payment_due_date | Unknown |  |
| payment_id | Unknown |  |
| payment_reference_number | Unknown |  |
| payment_term | Unknown |  |
| payment_type | Unknown |  |
| payment_updated_at | Unknown |  |
| picked_completely | Unknown |  |
| picked_status | Unknown |  |
| price_list_id | Unknown |  |
| receipt_printed | Unknown |  |
| refund_amount | Unknown |  |
| restock_shipped_item | Unknown |  |
| return | Json |  |
| send_notification_email | Unknown |  |
| send_refund_email | Unknown |  |
| shipped_at | Unknown |  |
| shipping_discount | Unknown |  |
| status | Unknown |  |
| subtotal_price | Unknown |  |
| till_id | Unknown |  |
| total_discount | Unknown |  |
| total_fee | Unknown |  |
| total_price | Unknown |  |
| total_tax | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |
| with_duty | Unknown |  |

### warehouse

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| deleted_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| city | Unknown |  |
| click_and_collect_day | Unknown |  |
| click_and_collect_enabled | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| default_min_reorder | Unknown |  |
| deleted_at | Unknown |  |
| display_position | Unknown |  |
| eori_id | Unknown |  |
| inventory_type_code | Unknown |  |
| ioss_id | Unknown |  |
| letterbox_address_status | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| post_code | Unknown |  |
| region | Unknown |  |
| requested_carrier_account | Unknown |  |
| tax_id | Unknown |  |
| trading_name | Unknown |  |
| updated_at | Unknown |  |

### company_active_feature

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| active_feature | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| default_channel_id | Unknown | FK |
| deleted_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| account_owner_user_id | Unknown |  |
| activated_at | Unknown |  |
| activation_code | Unknown |  |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| default_order_view_id | Unknown |  |
| default_till_id | Unknown |  |
| default_warehouse_id | Unknown |  |
| deleted_at | Unknown |  |
| email | Unknown |  |
| failed_login_attempt | Unknown |  |
| guide_completed_message_viewed | Unknown |  |
| guide_progress | Unknown |  |
| location | Unknown |  |
| login | Unknown |  |
| new_orders_opted_in | Unknown |  |
| new_products_opted_in | Unknown |  |
| orders_walkthrough_viewed | Unknown |  |
| role_id | Unknown |  |
| timezone | Unknown |  |
| two_factor_authentication_enabled | Unknown |  |
| updated_at | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| billing_period_started | Unknown |  |
| chargify_current_plan | Unknown |  |
| chargify_product_handle | Unknown |  |
| company_address_address_line_1 | Unknown |  |
| company_address_address_line_2 | Unknown |  |
| company_address_address_line_3 | Unknown |  |
| company_address_city | Unknown |  |
| company_address_country | Unknown |  |
| company_address_phone | Unknown |  |
| company_address_post_code | Unknown |  |
| company_address_region | Unknown |  |
| created_at | Unknown |  |
| has_ever_created_remote_channel | Unknown |  |
| has_right_to_use_veeqo | Unknown |  |
| name | Unknown |  |
| paying | Unknown |  |
| plan_features_accounting_quickbook | Unknown |  |
| plan_features_accounting_setting | Unknown |  |
| plan_features_accounting_xero | Unknown |  |
| plan_features_api_any_action | Unknown |  |
| plan_features_billing_legacy_billing | Unknown |  |
| plan_features_channels_amazon_fba | Unknown |  |
| plan_features_channels_change_routing_order_type | Unknown |  |
| plan_features_channels_legacy_channels_connection | Unknown |  |
| plan_features_channels_magento | Unknown |  |
| plan_features_channels_manage_stock_level | Unknown |  |
| plan_features_channels_noth | Unknown |  |
| plan_features_channels_opencart | Unknown |  |
| plan_features_channels_prestashop | Unknown |  |
| plan_features_channels_price_minister | Unknown |  |
| plan_features_channels_shopify_multi_location | Unknown |  |
| plan_features_channels_vend | Unknown |  |
| plan_features_dashboard_any_action | Unknown |  |
| plan_features_fulfilment_allocate_action | Unknown |  |
| plan_features_fulfilment_digital_picking_in_onboarding | Unknown |  |
| plan_features_inventory_change_stock_reason | Unknown |  |
| plan_features_inventory_merge_review | Unknown |  |
| plan_features_inventory_show_stock_level | Unknown |  |
| plan_features_inventory_use_custom_view | Unknown |  |
| plan_features_inventory_use_kit | Unknown |  |
| plan_features_listings_any_action | Unknown |  |
| plan_features_onboarding_coaching | Unknown |  |
| plan_features_onboarding_inventory_feature | Unknown |  |
| plan_features_onboarding_setup_step | Unknown |  |
| plan_features_onboarding_signup_redirects_to_channels_wizard | Unknown |  |
| plan_features_onboarding_switch_legacy_to_power_plan_modal | Unknown |  |
| plan_features_orders_auto_allocation | Unknown |  |
| plan_features_orders_nav_sub_item | Unknown |  |
| plan_features_orders_packing | Unknown |  |
| plan_features_orders_wfs_default_view | Unknown |  |
| plan_features_picking_any_action | Unknown |  |
| plan_features_price_lists_any_action | Unknown |  |
| plan_features_printing_customizable_template | Unknown |  |
| plan_features_printing_direct_print | Unknown |  |
| plan_features_purchase_orders_any_action | Unknown |  |
| plan_features_reorders_any_action | Unknown |  |
| plan_features_reports_daily_digest_email | Unknown |  |
| plan_features_reports_forecast | Unknown |  |
| plan_features_reports_inventory_history | Unknown |  |
| plan_features_reports_return | Unknown |  |
| plan_features_reports_shipping_metric | Unknown |  |
| plan_features_reports_stock | Unknown |  |
| plan_features_reports_team_metric | Unknown |  |
| plan_features_returns_any_action | Unknown |  |
| plan_features_roles_any_action | Unknown |  |
| plan_features_settings_page_appstore | Unknown |  |
| plan_features_settings_page_customer | Unknown |  |
| plan_features_settings_page_customer_orders_action | Unknown |  |
| plan_features_settings_page_listings_linking | Unknown |  |
| plan_features_settings_page_payment_gateway | Unknown |  |
| plan_features_settings_page_sps_scan_form | Unknown |  |
| plan_features_shipping_all_carrier | Unknown |  |
| plan_features_shipping_carriers_amazon_logistic | Unknown |  |
| plan_features_shipping_carriers_apc | Unknown |  |
| plan_features_shipping_carriers_asendia | Unknown |  |
| plan_features_shipping_carriers_australia_post | Unknown |  |
| plan_features_shipping_carriers_canada_post | Unknown |  |
| plan_features_shipping_carriers_dhl_de | Unknown |  |
| plan_features_shipping_carriers_dx | Unknown |  |
| plan_features_shipping_carriers_endicia | Unknown |  |
| plan_features_shipping_carriers_hermes_world | Unknown |  |
| plan_features_shipping_carriers_israel_post | Unknown |  |
| plan_features_shipping_carriers_parcelforce | Unknown |  |
| plan_features_shipping_carriers_tnt | Unknown |  |
| plan_features_shipping_carriers_ups_reseller | Unknown |  |
| plan_features_shipping_carriers_usps | Unknown |  |
| plan_features_shipping_carriers_yodel | Unknown |  |
| plan_features_shipping_incoterm | Unknown |  |
| plan_features_shipping_pack_and_ship | Unknown |  |
| plan_features_stock_take_any_action | Unknown |  |
| plan_features_stock_transfers_any_action | Unknown |  |
| plan_features_suppliers_any_action | Unknown |  |
| plan_features_user_roles_accountant | Unknown |  |
| plan_features_user_roles_admin | Unknown |  |
| plan_features_user_roles_customer_service_agent | Unknown |  |
| plan_features_user_roles_customer_service_manager | Unknown |  |
| plan_features_user_roles_picker_packer | Unknown |  |
| plan_features_user_roles_purchaser | Unknown |  |
| plan_features_user_roles_warehouse_manager | Unknown |  |
| plan_features_warehouses_multi_bin | Unknown |  |
| plan_features_wholesale_any_action | Unknown |  |
| printnode_api_key | Unknown |  |
| referring_website | Unknown |  |
| settings_charge_taxes_on_shipping_rate | Unknown |  |
| settings_currency_code | Unknown |  |
| settings_date_format | Unknown |  |
| settings_dimensions_unit | Unknown |  |
| settings_id | Unknown |  |
| settings_phone_number | Unknown |  |
| settings_phone_payment | Unknown |  |
| settings_point_of_sale_enabled | Unknown |  |
| settings_pull_fba_inbound_stock | Unknown |  |
| settings_require_complete_packing | Unknown |  |
| settings_stock_change_reason_required | Unknown |  |
| settings_timezone | Unknown |  |
| settings_weight_unit | Unknown |  |
| shopify_app_store_referral | Unknown |  |
| trial_end_date | Unknown |  |
| trialing | Unknown |  |
| updated_at | Unknown |  |
| veeqo_product_name | Unknown |  |

### purchase_order_line_item_stock_entry

| Column | Type | Keys |
| --- | --- | --- |
| sellable_id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| purchase_order_line_item_id | Unknown | PK, FK |
| warehouse_id | Unknown | PK, FK |
| allocated_stock_level | Unknown |  |
| available_stock_level | Unknown |  |
| incoming_stock_level | Unknown |  |
| infinite | Unknown |  |
| location | Unknown |  |
| physical_stock_level | Unknown |  |
| sellable_on_hand_value | Unknown |  |
| stock_running_low | Unknown |  |
| updated_at | Unknown |  |

### purchase_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| allocated_stock_level_at_all_warehouse | Unknown |  |
| available_stock_level_at_all_warehouse | Unknown |  |
| cost | Unknown |  |
| cost_price | Unknown |  |
| created_at | Unknown |  |
| full_title | Unknown |  |
| inventory_allocated_stock_level_at_all_warehouse | Unknown |  |
| inventory_available_stock_level_at_all_warehouse | Unknown |  |
| inventory_incoming_stock_level_at_all_warehouse | Unknown |  |
| inventory_infinite | Unknown |  |
| inventory_physical_stock_level_at_all_warehouse | Unknown |  |
| margin | Unknown |  |
| measurement_depth | Unknown |  |
| measurement_dimensions_unit | Unknown |  |
| measurement_height | Unknown |  |
| measurement_id | Unknown |  |
| measurement_width | Unknown |  |
| min_reorder_level | Unknown |  |
| model_number | Unknown |  |
| on_hand_value | Unknown |  |
| price | Unknown |  |
| product_description | Unknown |  |
| product_estimated_delivery | Unknown |  |
| product_hs_tariff_number | Unknown |  |
| product_id | Unknown |  |
| product_title | Unknown |  |
| product_variant_id | Unknown |  |
| profit | Unknown |  |
| quantity | Unknown |  |
| quantity_to_reorder | Unknown |  |
| received | Unknown |  |
| received_at | Unknown |  |
| sellable_title | Unknown |  |
| sku_code | Unknown |  |
| stock_level_at_all_warehouse | Unknown |  |
| tax_rate | Unknown |  |
| title | Unknown |  |
| total_quantity_sold | Unknown |  |
| type | Unknown |  |
| upc_code | Unknown |  |
| updated_at | Unknown |  |
| weight | Unknown |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| supplier_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| actual_delivery_day | Unknown |  |
| actual_return_day | Unknown |  |
| arrival_at_calc | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| destination_warehouse_id | Unknown |  |
| estimated_delivery_day | Unknown |  |
| estimated_return_day | Unknown |  |
| number | Unknown |  |
| received_at | Unknown |  |
| returned_at | Unknown |  |
| send_to_supplier | Unknown |  |
| started_at | Unknown |  |
| started_or_returned_at_calc | Unknown |  |
| state | Unknown |  |
| total_calc | Unknown |  |
| updated_at | Unknown |  |
| user_id | Unknown |  |

### delivery_method

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deleted_by_id | Unknown | FK |
| cost | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |
| user_id | Unknown |  |

### store

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| default_warehouse_id | Unknown | FK |
| deleted_by_id | Unknown | FK |
| warehouse_id | Unknown | FK |
| additional_api_2_cart_site | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| adjust_orders_tax_rate | Unknown |  |
| always_set_qty | Unknown |  |
| amazon_channel_specific | Unknown |  |
| amazon_fulfillment_enabled | Unknown |  |
| amazon_fulfillment_setting | Unknown |  |
| api_2_cart_channel_specific | Unknown |  |
| api_2_cart_store_key | Unknown |  |
| authorized_at_remote_store | Unknown |  |
| automatic_product_linking_disabled | Unknown |  |
| bridge_url | Unknown |  |
| bridge_verified | Unknown |  |
| channel_oauth_refresh_token_expires_at | Unknown |  |
| channel_setup_id | Unknown |  |
| channel_warehouse | Json |  |
| city | Unknown |  |
| country | Unknown |  |
| create_product_if_unmatched | Unknown |  |
| create_product_on_ended_listing | Unknown |  |
| currency_code | Unknown |  |
| default_send_shipment_email | Unknown |  |
| default_warehouse | Unknown |  |
| default_warehouse_company_id | Unknown |  |
| default_warehouse_lat | Unknown |  |
| default_warehouse_letterbox_address_id | Unknown |  |
| default_warehouse_lng | Unknown |  |
| default_warehouse_user_id | Unknown |  |
| deleted_at | Unknown |  |
| disabled_push_of_stock_level | Unknown |  |
| ebay_site_code_id | Unknown |  |
| ebay_url | Unknown |  |
| email | Unknown |  |
| end_ebay_listing_on_out_of_stock | Unknown |  |
| first_sync_finish_notice_marked_as_read | Unknown |  |
| import_additional_payment_detail | Unknown |  |
| import_cost_price | Unknown |  |
| import_order_tag | Unknown |  |
| import_product_brand | Unknown |  |
| import_product_tag | Unknown |  |
| is_master | Unknown |  |
| keep_inventory_tracking_value | Unknown |  |
| link_to_products_linked_to_current_channel | Unknown |  |
| link_with_similar_listings_by_sku | Unknown |  |
| marketplace_country | Unknown |  |
| marketplace_id | Unknown |  |
| max_qty_to_advert | Unknown |  |
| min_threshold_qty | Unknown |  |
| mws_auth_token | Unknown |  |
| name | Unknown |  |
| pending_setup | Unknown |  |
| percent_of_qty | Unknown |  |
| post_code | Unknown |  |
| pull_historical_order | Unknown |  |
| pull_pending_order | Unknown |  |
| pull_product_image | Unknown |  |
| pull_product_property | Unknown |  |
| pull_stock_level_required | Unknown |  |
| pull_unpaid_shopify_order | Unknown |  |
| pulled_orders_at | Unknown |  |
| pulled_products_at | Unknown |  |
| pulled_stock_level_at | Unknown |  |
| region | Unknown |  |
| remote | Unknown |  |
| remote_warehouses_exist | Unknown |  |
| routing_order_type | Unknown |  |
| seller_id | Unknown |  |
| send_notification_emails_to_customer | Unknown |  |
| shopify_import_hs_code_and_country_of_origin | Unknown |  |
| shopify_multi_location | Unknown |  |
| shopify_pull_order_edit | Unknown |  |
| shopify_pull_orders_fraud_info | Unknown |  |
| shopify_url | Unknown |  |
| short_name | Unknown |  |
| skip_fba_orders_and_product | Unknown |  |
| skip_title_matching | Unknown |  |
| state | Unknown |  |
| stock_level_update_request | Json |  |
| successfully_fetched_stock_levels_at | Unknown |  |
| time_since_order_sync | Unknown |  |
| time_since_product_sync | Unknown |  |
| time_since_successfully_fetch_stock_level | Unknown |  |
| time_since_tried_fetch_stock_level | Unknown |  |
| time_zone | Unknown |  |
| time_zone_offset | Unknown |  |
| token | Unknown |  |
| type_code | Unknown |  |
| update_product_attribute | Unknown |  |
| update_remote_order | Unknown |  |
| url | Unknown |  |
| veeqo_dictates_price | Unknown |  |
| veeqo_dictates_stock_level | Unknown |  |
| warehouse | Json |  |
| weight_unit | Unknown |  |
| with_fba | Unknown |  |

## Relationships

- supplier(updated_by_id) → employee(id)
- supplier(created_by_id) → employee(id)
- supplier(deleted_by_id) → employee(id)
- sellable_stock_entry(warehouse_id) → warehouse(id)
- sellable_stock_entry(sellable_id) → sellable(id)
- sellable_stock_entry(product_id) → product(id)
- sellable_active_channel(product_id) → product(id)
- sellable_active_channel(sellable_id) → sellable(id)
- channel_sellable(channel_product_id) → channel_product(id)
- channel_sellable(channel_id) → store(id)
- channel_sellable(product_id) → product(id)
- sellable(product_id) → product(id)
- sellable(created_by_id) → employee(id)
- channel_product(channel_id) → store(id)
- channel_product(product_id) → product(id)
- products_active_channel(id) → store(id)
- products_active_channel(product_id) → product(id)
- product(updated_by_id) → employee(id)
- product(created_by_id) → employee(id)
- product(deleted_by_id) → employee(id)
- orders_tag(orders_id) → orders(id)
- orders_employee_note(id) → orders(id)
- orders_employee_note(created_by_id) → employee(id)
- orders_line_item(sellable_id) → sellable(id)
- orders_line_item(orders_id) → orders(id)
- sellable_variant_option_specific(allocation_line_item_id) → allocation_line_item(id)
- sellable_variant_option_specific(orders_id) → orders(id)
- sellable_variant_option_specific(allocation_id) → allocation(id)
- sellable_variant_property_specific(allocation_line_item_id) → allocation_line_item(id)
- sellable_variant_property_specific(orders_id) → orders(id)
- sellable_variant_property_specific(allocation_id) → allocation(id)
- allocation_line_item(sellable_id) → sellable(id)
- allocation_line_item(orders_id) → orders(id)
- allocation_line_item(allocation_id) → allocation(id)
- allocation_carrier_service_enhancement_code(allocation_id) → allocation(id)
- allocation_carrier_service_enhancement_code(orders_id) → orders(id)
- allocation(warehouse_id) → warehouse(id)
- allocation(order_id) → orders(id)
- orders(payment_created_by_id) → company(id)
- orders(created_by_id) → employee(id)
- orders(delivery_method_id) → delivery_method(id)
- orders(channel_id) → store(id)
- warehouse(updated_by_id) → employee(id)
- warehouse(created_by_id) → employee(id)
- warehouse(deleted_by_id) → employee(id)
- company_active_feature(company_id) → company(id)
- employee(updated_by_id) → employee(id)
- employee(company_id) → company(id)
- employee(default_channel_id) → store(id)
- employee(deleted_by_id) → employee(id)
- company(owner_id) → employee(id)
- purchase_order_line_item_stock_entry(warehouse_id) → warehouse(id)
- purchase_order_line_item_stock_entry(purchase_order_line_item_id) → purchase_order_line_item(id)
- purchase_order_line_item_stock_entry(purchase_order_id) → purchase_order(id)
- purchase_order_line_item(created_by_id) → employee(id)
- purchase_order_line_item(purchase_order_id) → purchase_order(id)
- purchase_order(updated_by_id) → employee(id)
- purchase_order(created_by_id) → employee(id)
- purchase_order(supplier_id) → supplier(id)
- delivery_method(deleted_by_id) → employee(id)
- store(warehouse_id) → warehouse(id)
- store(created_by_id) → employee(id)
- store(deleted_by_id) → employee(id)
- store(default_warehouse_id) → warehouse(id)