# ShipStation schema ERD

Table and field reference for the Fivetran ShipStation connector.

## Table & Field Reference

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_intl_package_code | Unknown | FK |
| default_intl_service_code | Unknown | FK |
| default_package_code | Unknown | FK |
| default_service_code | Unknown | FK |
| sku | Unknown | FK |
| active | Unknown |  |
| aliases | Unknown |  |
| create_date | LocalDateTime |  |
| customs_country_code | Unknown |  |
| customs_description | Unknown |  |
| customs_tariff_number | Unknown |  |
| customs_value | Unknown |  |
| default_confirmation | Unknown |  |
| default_cost | Unknown |  |
| default_intl_confirmation | Unknown |  |
| fulfillment_sku | Unknown |  |
| height | Unknown |  |
| internal_note | Unknown |  |
| length | Unknown |  |
| modify_date | LocalDateTime |  |
| name | Unknown |  |
| no_customs | Unknown |  |
| price | Unknown |  |
| product_category_category_id | Unknown |  |
| product_category_name | Unknown |  |
| product_type | Unknown |  |
| warehouse_location | Unknown |  |
| weight_oz | Unknown |  |
| width | Unknown |  |

### package

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| shipping_provider_id | Unknown | FK |
| carrier_code | Unknown |  |
| domestic | Unknown |  |
| international | Unknown |  |
| name | Unknown |  |

### shipping_provider

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_number | Unknown |  |
| balance | Unknown |  |
| code | Unknown |  |
| is_primary | Unknown |  |
| name | Unknown |  |
| nickname | Unknown |  |
| requires_funded_account | Unknown |  |

### shipment_item

| Column | Type | Keys |
| --- | --- | --- |
| order_item_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| shipment_id | Unknown | FK |
| sku | Unknown | FK |
| fulfillment_sku | Unknown |  |
| image_url | Unknown |  |
| line_item_key | Unknown |  |
| name | Unknown |  |
| options | Unknown |  |
| quantity | Unknown |  |
| unit_price | Unknown |  |
| warehouse_location | Unknown |  |
| weight | Unknown |  |

### shipment_merged

| Column | Type | Keys |
| --- | --- | --- |
| merged_order_id | Unknown | PK, FK |
| shipment_id | Unknown | PK, FK |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| package_code | Unknown | FK |
| service_code | Unknown | FK |
| user_id | Unknown | FK |
| warehouse_id | Unknown | FK |
| advanced_options_bill_to_account | Unknown |  |
| advanced_options_bill_to_country_code | Unknown |  |
| advanced_options_bill_to_my_other_account | Unknown |  |
| advanced_options_bill_to_party | Unknown |  |
| advanced_options_bill_to_postal_code | Unknown |  |
| advanced_options_contains_alcohol | Unknown |  |
| advanced_options_custom_field_1 | Unknown |  |
| advanced_options_custom_field_2 | Unknown |  |
| advanced_options_custom_field_3 | Unknown |  |
| advanced_options_merged_or_split | Unknown |  |
| advanced_options_non_machinable | Unknown |  |
| advanced_options_parent_id | Unknown |  |
| advanced_options_saturday_delivery | Unknown |  |
| advanced_options_source | Unknown |  |
| advanced_options_store_id | Unknown |  |
| advanced_options_warehouse_id | Unknown |  |
| batch_number | Unknown |  |
| confirmation | Unknown |  |
| create_date | LocalDateTime |  |
| dimensions_height | Unknown |  |
| dimensions_length | Unknown |  |
| dimensions_units | Unknown |  |
| dimensions_width | Unknown |  |
| form_data | Unknown |  |
| insurance_cost | Unknown |  |
| insurance_options_insure_shipment | Unknown |  |
| insurance_options_insured_value | Unknown |  |
| insurance_options_provider | Unknown |  |
| is_return_label | Unknown |  |
| label_data | Unknown |  |
| marketplace_notified | Unknown |  |
| notify_error_message | Unknown |  |
| order_key | Unknown |  |
| order_number | Unknown |  |
| ship_date | LocalDate |  |
| ship_to_city | Unknown |  |
| ship_to_company | Unknown |  |
| ship_to_country | Unknown |  |
| ship_to_name | Unknown |  |
| ship_to_phone | Unknown |  |
| ship_to_postal_code | Unknown |  |
| ship_to_residential | Unknown |  |
| ship_to_state | Unknown |  |
| ship_to_street_1 | Unknown |  |
| ship_to_street_2 | Unknown |  |
| ship_to_street_3 | Unknown |  |
| shipment_cost | Unknown |  |
| shipping_provider_code | Unknown |  |
| tracking_number | Unknown |  |
| void_date | Unknown |  |
| voided | Unknown |  |
| weight_units | Unknown |  |
| weight_value | Unknown |  |

### marketplace

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| can_confirm_shipments | Unknown |  |
| can_refresh | Unknown |  |
| name | Unknown |  |
| supports_custom_mappings | Unknown |  |
| supports_custom_statuses | Unknown |  |

### inventory_warehouse

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| name | Unknown |  |
| updated_at | Instant |  |

### store

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| marketplace_id | Unknown | FK |
| account_name | Unknown |  |
| active | Unknown |  |
| auto_refresh | Unknown |  |
| company_name | Unknown |  |
| create_date | LocalDateTime |  |
| email | Unknown |  |
| integration_url | Unknown |  |
| last_refresh_attempt | LocalDateTime |  |
| marketplace_name | Unknown |  |
| modify_date | LocalDateTime |  |
| phone | Unknown |  |
| public_email | Unknown |  |
| refresh_date | LocalDateTime |  |
| store_name | Unknown |  |
| website | Unknown |  |

### warehouse

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| create_date | LocalDateTime |  |
| ext_inventory_identity | Unknown |  |
| is_default | Unknown |  |
| origin_address_address_verified | Unknown |  |
| origin_address_city | Unknown |  |
| origin_address_company | Unknown |  |
| origin_address_country | Unknown |  |
| origin_address_name | Unknown |  |
| origin_address_phone | Unknown |  |
| origin_address_postal_code | Unknown |  |
| origin_address_residential | Unknown |  |
| origin_address_state | Unknown |  |
| origin_address_street_1 | Unknown |  |
| origin_address_street_2 | Unknown |  |
| origin_address_street_3 | Unknown |  |
| register_fedex_meter | Unknown |  |
| return_address_address_verified | Unknown |  |
| return_address_city | Unknown |  |
| return_address_company | Unknown |  |
| return_address_country | Unknown |  |
| return_address_name | Unknown |  |
| return_address_phone | Unknown |  |
| return_address_postal_code | Unknown |  |
| return_address_residential | Unknown |  |
| return_address_state | Unknown |  |
| return_address_street_1 | Unknown |  |
| return_address_street_2 | Unknown |  |
| return_address_street_3 | Unknown |  |
| seller_integration_id | Unknown |  |
| warehouse_name | Unknown |  |

### inventory

| Column | Type | Keys |
| --- | --- | --- |
| sku | Unknown | PK |
| inventory_location_id | Unknown | PK, FK |
| inventory_warehouse_id | Unknown | FK |
| allocated | Unknown |  |
| available | Unknown |  |
| average_cost_amount | Unknown |  |
| average_cost_currency | Unknown |  |
| on_hand | Unknown |  |

### inventory_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| inventory_warehouse_id | Unknown | FK |
| barcode | Unknown |  |
| created_at | Instant |  |
| name | Unknown |  |
| updated_at | Instant |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| user_name | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| name | Unknown |  |

### service

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| shipping_provider_id | Unknown | FK |
| carrier_code | Unknown |  |
| domestic | Unknown |  |
| international | Unknown |  |
| name | Unknown |  |

### order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| product_id | Unknown | FK |
| sku | Unknown | FK |
| adjustment | Unknown |  |
| create_date | LocalDateTime |  |
| fulfillment_sku | Unknown |  |
| image_url | Unknown |  |
| line_item_key | Unknown |  |
| modify_date | LocalDateTime |  |
| name | Unknown |  |
| options | Json |  |
| quantity | Unknown |  |
| shipping_amount | Unknown |  |
| tax_amount | Unknown |  |
| unit_price | Unknown |  |
| upc | Unknown |  |
| warehouse_location | Unknown |  |

### order_tag

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

### order_merged

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

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advanced_options_store_id | Unknown | FK |
| advanced_options_warehouse_id | Unknown | FK |
| customer_id | Unknown | FK |
| package_code | Unknown | FK |
| service_code | Unknown | FK |
| user_id | Unknown | FK |
| advanced_options_bill_to_account | Unknown |  |
| advanced_options_bill_to_country_code | Unknown |  |
| advanced_options_bill_to_my_other_account | Unknown |  |
| advanced_options_bill_to_party | Unknown |  |
| advanced_options_bill_to_postal_code | Unknown |  |
| advanced_options_contains_alcohol | Unknown |  |
| advanced_options_custom_field_1 | Unknown |  |
| advanced_options_custom_field_2 | Unknown |  |
| advanced_options_custom_field_3 | Unknown |  |
| advanced_options_merged_or_split | Unknown |  |
| advanced_options_non_machinable | Unknown |  |
| advanced_options_parent_id | Unknown |  |
| advanced_options_saturday_delivery | Unknown |  |
| advanced_options_source | Unknown |  |
| amount_paid | Unknown |  |
| bill_to_address_verified | Unknown |  |
| bill_to_city | Unknown |  |
| bill_to_company | Unknown |  |
| bill_to_country | Unknown |  |
| bill_to_name | Unknown |  |
| bill_to_phone | Unknown |  |
| bill_to_postal_code | Unknown |  |
| bill_to_residential | Unknown |  |
| bill_to_state | Unknown |  |
| bill_to_street_1 | Unknown |  |
| bill_to_street_2 | Unknown |  |
| bill_to_street_3 | Unknown |  |
| confirmation | Unknown |  |
| create_date | LocalDateTime |  |
| customer_email | Unknown |  |
| customer_notes | Unknown |  |
| customer_username | Unknown |  |
| dimensions_height | Unknown |  |
| dimensions_length | Unknown |  |
| dimensions_units | Unknown |  |
| dimensions_width | Unknown |  |
| externally_fulfilled | Unknown |  |
| externally_fulfilled_by | Unknown |  |
| externally_fulfilled_by_id | Unknown |  |
| externally_fulfilled_by_name | Unknown |  |
| gift | Unknown |  |
| gift_message | Unknown |  |
| hold_until_date | Unknown |  |
| insurance_options_insure_shipment | Unknown |  |
| insurance_options_insured_value | Unknown |  |
| insurance_options_provider | Unknown |  |
| internal_notes | Unknown |  |
| international_options_contents | Unknown |  |
| international_options_customs_items | Unknown |  |
| international_options_non_delivery | Unknown |  |
| label_messages | Unknown |  |
| modify_date | LocalDateTime |  |
| order_date | LocalDateTime |  |
| order_key | Unknown |  |
| order_number | Unknown |  |
| order_status | Unknown |  |
| order_total | Unknown |  |
| payment_date | LocalDateTime |  |
| payment_method | Unknown |  |
| requested_shipping_service | Unknown |  |
| ship_by_date | LocalDateTime |  |
| ship_date | LocalDate |  |
| ship_to_address_verified | Unknown |  |
| ship_to_city | Unknown |  |
| ship_to_company | Unknown |  |
| ship_to_country | Unknown |  |
| ship_to_name | Unknown |  |
| ship_to_phone | Unknown |  |
| ship_to_postal_code | Unknown |  |
| ship_to_residential | Unknown |  |
| ship_to_state | Unknown |  |
| ship_to_street_1 | Unknown |  |
| ship_to_street_2 | Unknown |  |
| ship_to_street_3 | Unknown |  |
| shipping_amount | Unknown |  |
| shipping_provider_code | Unknown |  |
| tax_amount | Unknown |  |
| weight_units_of_measurement | Unknown |  |
| weight_value | Unknown |  |
| weight_weight_units | Unknown |  |

### fulfillment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| user_id | Unknown | FK |
| create_date | LocalDateTime |  |
| customer_email | Unknown |  |
| delivery_date | Unknown |  |
| fulfillment_fee | Unknown |  |
| fulfillment_provider_code | Unknown |  |
| fulfillment_service_code | Unknown |  |
| marketplace_notified | Unknown |  |
| notify_error_message | Unknown |  |
| order_number | Unknown |  |
| seller_fill_provider_id | Unknown |  |
| seller_fill_provider_name | Unknown |  |
| ship_date | LocalDateTime |  |
| ship_to_address_verified | Unknown |  |
| ship_to_city | Unknown |  |
| ship_to_company | Unknown |  |
| ship_to_country | Unknown |  |
| ship_to_name | Unknown |  |
| ship_to_phone | Unknown |  |
| ship_to_postal_code | Unknown |  |
| ship_to_residential | Unknown |  |
| ship_to_state | Unknown |  |
| ship_to_street_1 | Unknown |  |
| ship_to_street_2 | Unknown |  |
| ship_to_street_3 | Unknown |  |
| shipping_provider_code | Unknown |  |
| tracking_number | Unknown |  |
| void_date | Unknown |  |
| void_requested | Unknown |  |
| voided | Unknown |  |

### customer_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| customer_id | Unknown | FK |
| tag_id | Unknown | FK |
| name | Unknown |  |

### marketplace_username

| Column | Type | Keys |
| --- | --- | --- |
| customer_user_id | Unknown | PK |
| customer_id | Unknown | FK |
| marketplace_id | Unknown | FK |
| create_date | LocalDateTime |  |
| marketplace | Unknown |  |
| modify_date | LocalDateTime |  |
| username | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_verified | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| country_code | Unknown |  |
| create_date | LocalDateTime |  |
| email | Unknown |  |
| modify_date | LocalDateTime |  |
| name | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| street_1 | Unknown |  |
| street_2 | Unknown |  |

## Relationships

- product(sku) → inventory(sku)
- product(default_intl_service_code) → service(code)
- product(default_service_code) → service(code)
- product(default_package_code) → package(code)
- product(default_intl_package_code) → package(code)
- package(shipping_provider_id) → shipping_provider(id)
- shipment_item(product_id) → product(id)
- shipment_item(sku) → inventory(sku)
- shipment_item(order_item_id) → order_item(id)
- shipment_item(shipment_id) → shipment(id)
- shipment_merged(merged_order_id) → orders(id)
- shipment_merged(shipment_id) → shipment(id)
- shipment(user_id) → users(id)
- shipment(warehouse_id) → inventory_warehouse(id)
- shipment(service_code) → service(code)
- shipment(order_id) → orders(id)
- shipment(package_code) → package(code)
- store(marketplace_id) → marketplace(id)
- inventory(inventory_location_id) → inventory_location(id)
- inventory(inventory_warehouse_id) → warehouse(id)
- inventory_location(inventory_warehouse_id) → warehouse(id)
- service(shipping_provider_id) → shipping_provider(id)
- order_item(product_id) → product(id)
- order_item(sku) → inventory(sku)
- order_item(order_id) → orders(id)
- order_tag(tag_id) → tags(id)
- order_tag(order_id) → orders(id)
- order_merged(merged_order_id) → orders(id)
- order_merged(order_id) → orders(id)
- orders(user_id) → users(id)
- orders(advanced_options_warehouse_id) → inventory_warehouse(id)
- orders(service_code) → service(code)
- orders(package_code) → package(code)
- orders(customer_id) → customer(id)
- orders(advanced_options_store_id) → store(id)
- fulfillment(user_id) → users(id)
- fulfillment(order_id) → orders(id)
- customer_tag(tag_id) → tags(id)
- customer_tag(customer_id) → customer(id)
- marketplace_username(marketplace_id) → marketplace(id)
- marketplace_username(customer_id) → customer(id)