# ShipHero schema ERD

Table and field reference for the Fivetran ShipHero connector.

## Table & Field Reference

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| account_number | Unknown |  |
| address_address_1 | Unknown |  |
| address_address_2 | Unknown |  |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_name | Unknown |  |
| address_phone | Unknown |  |
| address_state | Unknown |  |
| address_zip | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| default_po_note | Unknown |  |
| email | Unknown |  |
| internal_note | Unknown |  |
| legacy_id | Unknown |  |
| logo | Unknown |  |
| name | Unknown |  |
| partner_vendor_id | Unknown |  |

### browse_order_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| account_id | Unknown |  |
| information | Unknown |  |
| order_email | Unknown |  |
| order_fulfillment_status | Unknown |  |
| order_number | Unknown |  |
| order_order_date | Unknown |  |
| order_packing_note | Unknown |  |
| order_profile | Unknown |  |
| order_required_ship_date | Unknown |  |
| order_shipping_address_address_1 | Unknown |  |
| order_shipping_address_address_2 | Unknown |  |
| order_shipping_address_city | Unknown |  |
| order_shipping_address_company | Unknown |  |
| order_shipping_address_country | Unknown |  |
| order_shipping_address_country_code | Unknown |  |
| order_shipping_address_email | Unknown |  |
| order_shipping_address_first_name | Unknown |  |
| order_shipping_address_last_name | Unknown |  |
| order_shipping_address_phone | Unknown |  |
| order_shipping_address_state | Unknown |  |
| order_shipping_address_state_code | Unknown |  |
| order_shipping_address_zip | Unknown |  |
| order_shop_name | Unknown |  |

### warehouse_product_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| warehouse_id | Unknown | FK |
| account_id | Unknown |  |
| custom | Unknown |  |
| inventory_bin | Unknown |  |
| on_hand | Unknown |  |
| product_name | Unknown |  |
| product_sku | Unknown |  |
| reorder_amount | Unknown |  |
| reorder_level | Unknown |  |
| reserve_inventory | Unknown |  |
| warehouse_dynamic_slotting | Unknown |  |
| warehouse_profile | Unknown |  |

### warehouse_product_inventory_metric

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| warehouse_id | Unknown | PK, FK |
| warehouse_product_product_id | Unknown | FK |
| account_id | Unknown |  |
| active | Unknown |  |
| allocated | Unknown |  |
| available | Unknown |  |
| backorder | Unknown |  |
| created_at | Instant |  |
| custom | Unknown |  |
| customs_value | Unknown |  |
| in_tote | Unknown |  |
| inventory_bin | Unknown |  |
| inventory_overstock_bin | Unknown |  |
| legacy_id | Unknown |  |
| non_sellable_quantity | Unknown |  |
| on_hand | Unknown |  |
| price | Unknown |  |
| reorder_amount | Unknown |  |
| reorder_level | Unknown |  |
| replenishment_level | Unknown |  |
| reserve_inventory | Unknown |  |
| sell_ahead | Unknown |  |
| sku | Unknown |  |
| updated_at | Instant |  |
| value | Unknown |  |
| value_currency | Unknown |  |
| warehouse_identifier | Unknown |  |

### warehouse_product

| Column | Type | Keys |
| --- | --- | --- |
| warehouse_id | Unknown | PK |
| product_id | Unknown | PK, FK |
| on_hand | Unknown |  |

### product_image

| Column | Type | Keys |
| --- | --- | --- |
| src | Unknown | PK |
| product_id | Unknown | PK, FK |

### product_kit_component

| Column | Type | Keys |
| --- | --- | --- |
| sku | Unknown | PK |
| product_id | Unknown | PK, FK |
| quantity | Unknown |  |

### product_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| tags | Unknown |  |

### product_vendor

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| vendor_id | Unknown | PK, FK |
| price | Unknown |  |
| vendor_sku | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| active | Unknown |  |
| barcode | Unknown |  |
| country_of_manufacture | Unknown |  |
| created_at | Unknown |  |
| customs_description | Unknown |  |
| customs_value | Unknown |  |
| dimensions_height | Unknown |  |
| dimensions_length | Unknown |  |
| dimensions_weight | Unknown |  |
| dimensions_width | Unknown |  |
| dropship | Unknown |  |
| final_sale | Unknown |  |
| ignore_on_customs | Unknown |  |
| ignore_on_invoice | Unknown |  |
| kit | Unknown |  |
| kit_build | Unknown |  |
| large_thumbnail | Unknown |  |
| legacy_id | Unknown |  |
| name | Unknown |  |
| needs_serial_number | Unknown |  |
| no_air | Unknown |  |
| not_owned | Unknown |  |
| product_note | Unknown |  |
| sku | Unknown |  |
| tariff_code | Unknown |  |
| thumbnail | Unknown |  |
| updated_at | Unknown |  |
| virtual | Unknown |  |

### shipment_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| shipping_label_id | Unknown | FK |
| line_item_id | Unknown |  |
| partner_line_item_id | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |

### shipment_shipping_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| account_id | Unknown |  |
| alternate_tracking_id | Unknown |  |
| box_code | Unknown |  |
| box_id | Unknown |  |
| box_name | Unknown |  |
| carrier | Unknown |  |
| carrier_account_id | Unknown |  |
| cost | Unknown |  |
| created_date | Unknown |  |
| dimensions_height | Unknown |  |
| dimensions_length | Unknown |  |
| dimensions_weight | Unknown |  |
| dimensions_width | Unknown |  |
| image_location | Unknown |  |
| insurance_amount | Unknown |  |
| legacy_id | Unknown |  |
| packing_slip | Unknown |  |
| paper_pdf_location | Unknown |  |
| pdf_location | Unknown |  |
| profile | Unknown |  |
| shipping_method | Unknown |  |
| shipping_name | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| thermal_pdf_location | Unknown |  |
| tracking_number | Unknown |  |
| tracking_url | Unknown |  |
| warehouse | Unknown |  |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| warehouse_id | Unknown | FK |
| address_address_1 | Unknown |  |
| address_address_2 | Unknown |  |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_name | Unknown |  |
| address_phone | Unknown |  |
| address_state | Unknown |  |
| address_zip | Unknown |  |
| created_date | Unknown |  |
| dropshipment | Unknown |  |
| legacy_id | Unknown |  |
| pending_shipment_id | Unknown |  |
| shipped_off_shiphero | Unknown |  |
| user_id | Unknown |  |

### order_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_id | Unknown | FK |
| created_at | Unknown |  |
| information | Unknown |  |
| user_id | Unknown |  |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | Unknown | PK |
| order_id | Unknown | PK, FK |
| backorder_quantity | Unknown |  |
| price | Unknown |  |
| promotion_discount | Unknown |  |
| quantity | Unknown |  |
| quantity_allocated | Unknown |  |
| quantity_pending_fulfillment | Unknown |  |
| sku | Unknown |  |

### orders_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_name | Unknown | PK |
| order_id | Unknown | PK, FK |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| adult_signature_required | Unknown |  |
| alcohol | Unknown |  |
| allocation_priority | Unknown |  |
| allow_partial | Unknown |  |
| allow_split | Unknown |  |
| auto_print_return_label | Unknown |  |
| currency | Unknown |  |
| custom_invoice_url | Unknown |  |
| email | Unknown |  |
| expected_weight_in_oz | Unknown |  |
| flagged | Unknown |  |
| fulfillment_status | Unknown |  |
| gift_invoice | Unknown |  |
| has_dry_ice | Unknown |  |
| ignore_address_validation_errors | Unknown |  |
| insurance | Unknown |  |
| insurance_amount | Unknown |  |
| legacy_id | Unknown |  |
| order_date | Unknown |  |
| order_number | Unknown |  |
| packing_note | Unknown |  |
| partner_order_id | Unknown |  |
| priority_flag | Unknown |  |
| profile | Unknown |  |
| require_signature | Unknown |  |
| required_ship_date | Unknown |  |
| saturday_delivery | Unknown |  |
| shipping_line_carrier | Unknown |  |
| shipping_line_method | Unknown |  |
| shipping_line_price | Unknown |  |
| shipping_line_title | Unknown |  |
| shop_name | Unknown |  |
| source | Unknown |  |
| subtotal | Unknown |  |
| third_party_shipper_account_number | Unknown |  |
| third_party_shipper_country | Unknown |  |
| third_party_shipper_zip | Unknown |  |
| total_discounts | Unknown |  |
| total_price | Unknown |  |
| total_tax | Unknown |  |

### pack_per_day

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| shipment_id | Unknown | FK |
| warehouse_id | Unknown | FK |
| barcodes_scanned | Unknown |  |
| created_at | Instant |  |
| order_number | Unknown |  |
| total_items | Unknown |  |
| unique_items | Unknown |  |
| user_first_name | Unknown |  |
| user_id | Unknown |  |
| user_last_name | Unknown |  |

### shipping_plan_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| warehouse_id | Unknown | FK |
| account_id | Unknown |  |
| barcode | Unknown |  |
| created_at | Instant |  |
| expected_weight_in_lbs | Unknown |  |
| fulfillment_status | Unknown |  |
| legacy_id | Unknown |  |
| note | Unknown |  |
| option_title | Unknown |  |
| partner_line_item_id | Unknown |  |
| price | Unknown |  |
| product_id | Unknown |  |
| product_name | Unknown |  |
| quantity | Unknown |  |
| quantity_received | Unknown |  |
| quantity_rejected | Unknown |  |
| sell_ahead | Unknown |  |
| sku | Unknown |  |
| updated_at | Instant |  |
| variant_id | Unknown |  |
| vendor_sku | Unknown |  |

### purchase_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_line_item_id | Unknown | PK, FK |
| vendor_id | Unknown | FK |
| warehouse_id | Unknown | FK |
| account_id | Unknown |  |
| barcode | Unknown |  |
| created_at | Instant |  |
| expected_weight_in_lbs | Unknown |  |
| fulfillment_status | Unknown |  |
| legacy_id | Unknown |  |
| node_id | Unknown |  |
| note | Unknown |  |
| option_title | Unknown |  |
| partner_line_item_id | Unknown |  |
| po_id | Unknown |  |
| po_number | Unknown |  |
| price | Unknown |  |
| product_id | Unknown |  |
| product_name | Unknown |  |
| quantity | Unknown |  |
| quantity_received | Unknown |  |
| quantity_rejected | Unknown |  |
| sell_ahead | Unknown |  |
| sku | Unknown |  |
| updated_at | Instant |  |
| variant_id | Unknown |  |
| vendor_sku | Unknown |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| vendor_id | Unknown | FK |
| warehouse_id | Unknown | FK |
| account_id | Unknown |  |
| created_at | Unknown |  |
| date_closed | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| fulfillment_status | Unknown |  |
| images | Unknown |  |
| legacy_id | Unknown |  |
| locked_by_user_id | Unknown |  |
| locking | Unknown |  |
| packing_note | Unknown |  |
| payment_due_by | Unknown |  |
| payment_method | Unknown |  |
| payment_note | Unknown |  |
| pdf | Unknown |  |
| po_date | Instant |  |
| po_note | Unknown |  |
| po_number | Unknown |  |
| shipping_carrier | Unknown |  |
| shipping_method | Unknown |  |
| shipping_name | Unknown |  |
| shipping_price | Unknown |  |
| subtotal | Unknown |  |
| tax | Unknown |  |
| total_price | Unknown |  |
| tracking_number | Unknown |  |

### shipping_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| warehouse_id | Unknown | FK |
| origin_of_shipment | Unknown |  |
| pdf_location | Unknown |  |
| vendor_po_number | Unknown |  |
| warehouse_note | Unknown |  |

### inventory_change

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| warehouse_id | Unknown | FK |
| account_id | Unknown |  |
| change_in_on_hand | Unknown |  |
| created_at | Instant |  |
| cycle_counted | Unknown |  |
| location_account_id | Unknown |  |
| location_created_at | Unknown |  |
| location_id | Unknown |  |
| location_is_cart | Unknown |  |
| location_last_counted | Unknown |  |
| location_legacy_id | Unknown |  |
| location_name | Unknown |  |
| location_pickable | Unknown |  |
| location_sellable | Unknown |  |
| location_temperature | Unknown |  |
| location_warehouse_id | Unknown |  |
| location_zone | Unknown |  |
| previous_on_hand | Unknown |  |
| reason | Unknown |  |
| sku | Unknown |  |
| user_id | Unknown |  |

### return_line_item_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| return_id | Unknown | PK, FK |
| return_line_item_id | Unknown | PK, FK |
| warehouse_id | Unknown | FK |
| backorder_quantity | Unknown |  |
| barcode | Unknown |  |
| created_at | Unknown |  |
| custom_barcode | Unknown |  |
| custom_options | Unknown |  |
| customs_value | Unknown |  |
| eligible_for_return | Unknown |  |
| fulfillment_status | Unknown |  |
| legacy_id | Unknown |  |
| locked_to_warehouse_id | Unknown |  |
| option_title | Unknown |  |
| partner_line_item_id | Unknown |  |
| price | Unknown |  |
| product_name | Unknown |  |
| quantity | Unknown |  |
| quantity_allocated | Unknown |  |
| quantity_pending_fulfillment | Unknown |  |
| quantity_shipped | Unknown |  |
| sku | Unknown |  |
| subtotal | Unknown |  |
| updated_at | Unknown |  |
| warehouse | Unknown |  |

### return_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| return_id | Unknown | PK, FK |
| warehouse_id | Unknown | FK |
| account_id | Unknown |  |
| condition | Unknown |  |
| created_at | Unknown |  |
| is_component | Unknown |  |
| legacy_id | Unknown |  |
| line_item_id | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| reason | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### return

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| account_id | Unknown |  |
| cost_to_customer | Unknown |  |
| created_at | Instant |  |
| display_issue_refund | Unknown |  |
| label_cost | Unknown |  |
| label_type | Unknown |  |
| legacy_id | Unknown |  |
| partner_id | Unknown |  |
| reason | Unknown |  |
| shipping_carrier | Unknown |  |
| shipping_method | Unknown |  |
| status | Unknown |  |

### line_item_pick

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| barcode_scanned | Unknown |  |
| created_at | Instant |  |
| inventory_bin | Unknown |  |
| line_item_id | Unknown |  |
| location_id | Unknown |  |
| order_number | Unknown |  |
| pick_type | Unknown |  |
| picked_quantity | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |
| tote_id | Unknown |  |
| user_first_name | Unknown |  |
| user_id | Unknown |  |
| user_last_name | Unknown |  |

## Relationships

- browse_order_history(order_id) → orders(id)
- warehouse_product_detail(warehouse_id) → warehouse_product(warehouse_id)
- warehouse_product_detail(product_id) → product(id)
- warehouse_product_inventory_metric(warehouse_id) → warehouse_product(warehouse_id)
- warehouse_product_inventory_metric(warehouse_product_product_id) → warehouse_product(product_id)
- warehouse_product(product_id) → product(id)
- product_image(product_id) → product(id)
- product_kit_component(product_id) → product(id)
- product_tag(product_id) → product(id)
- product_vendor(vendor_id) → vendor(id)
- product_vendor(product_id) → product(id)
- shipment_line_item(shipping_label_id) → shipment_shipping_label(id)
- shipment_line_item(shipment_id) → shipment(id)
- shipment_shipping_label(shipment_id) → shipment(id)
- shipment(order_id) → orders(id)
- shipment(warehouse_id) → warehouse_product(warehouse_id)
- order_history(order_id) → orders(id)
- order_line_item(order_id) → orders(id)
- orders_tag(order_id) → orders(id)
- pack_per_day(warehouse_id) → warehouse_product(warehouse_id)
- pack_per_day(order_id) → orders(id)
- pack_per_day(shipment_id) → shipment(id)
- shipping_plan_line_item(warehouse_id) → warehouse_product(warehouse_id)
- shipping_plan_line_item(purchase_order_id) → purchase_order(id)
- purchase_order_line_item(vendor_id) → vendor(id)
- purchase_order_line_item(warehouse_id) → warehouse_product(warehouse_id)
- purchase_order_line_item(purchase_order_line_item_id) → purchase_order(id)
- purchase_order(id) → orders(id)
- purchase_order(vendor_id) → vendor(id)
- purchase_order(warehouse_id) → warehouse_product(warehouse_id)
- shipping_plan(warehouse_id) → warehouse_product(warehouse_id)
- shipping_plan(purchase_order_id) → purchase_order(id)
- inventory_change(warehouse_id) → warehouse_product(warehouse_id)
- return_line_item_detail(warehouse_id) → warehouse_product(warehouse_id)
- return_line_item_detail(return_id) → return_line_item(return_id)
- return_line_item_detail(return_line_item_id) → return_line_item(id)
- return_line_item(warehouse_id) → warehouse_product(warehouse_id)
- return_line_item(return_id) → return(id)
- return(order_id) → orders(id)
- line_item_pick(order_id) → orders(id)