# Packiyo schema ERD

Table and field reference for the Fivetran Packiyo connector.

## Table & Field Reference

### location_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| location_id | Unknown | PK, FK |
| type | Unknown | FK |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_type | Unknown | FK |
| location_type_id | Unknown | FK |
| warehouse_id | Unknown | FK |
| warehouse_type | Unknown | FK |
| barcode | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### location_included

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type | Unknown | PK |
| product_id | Unknown | FK |
| address | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| customer_contact_information_id | Unknown |  |
| customer_contact_information_type | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| product_type | Unknown |  |
| quantity_on_hand | Unknown |  |
| quantity_reserved_for_picking | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |
| zip | Unknown |  |

### tote_order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| tote_id | Unknown | PK, FK |
| type | Unknown | FK |

### tote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| warehouse_id | Unknown | FK |
| warehouse_type | Unknown | FK |
| barcode | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### product_included

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type | Unknown | PK |
| location_product_location_id | Unknown | FK |
| address | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| customer_contact_information_id | Unknown |  |
| customer_contact_information_type | Unknown |  |
| email | Unknown |  |
| file_name | Unknown |  |
| location_product_location_type | Unknown |  |
| name | Unknown |  |
| object_type | Unknown |  |
| phone | Unknown |  |
| source | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |
| zip | Unknown |  |

### product_barcode

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| type | Unknown | FK |

### product_image

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| type | Unknown | FK |

### products_location_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| type | Unknown | FK |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| customer_type | Unknown | FK |
| attribute_type | Unknown |  |
| barcode | Unknown |  |
| country_of_origin | Unknown |  |
| created_at | Unknown |  |
| customs_description | Unknown |  |
| customs_price | Unknown |  |
| height | Unknown |  |
| hs_code | Unknown |  |
| inventory_sync | Unknown |  |
| length | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| price | Unknown |  |
| quantity_allocated | Unknown |  |
| quantity_available | Unknown |  |
| quantity_backordered | Unknown |  |
| quantity_on_hand | Unknown |  |
| sku | Unknown |  |
| tags | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |
| weight | Unknown |  |
| width | Unknown |  |

### customer_setting

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| type | Unknown | FK |

### customer_children

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| type | Unknown | FK |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_information_id | Unknown | FK |
| contact_information_type | Unknown | FK |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### purchase_order_included

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| id | Unknown | PK, FK |
| product_id | Unknown | FK |
| address | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| contact_information_id | Unknown |  |
| contact_information_type | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| quantity | Unknown |  |
| quantity_pending | Unknown |  |
| quantity_received | Unknown |  |
| quantity_rejected | Unknown |  |
| quantity_returned | Unknown |  |
| quantity_sell_ahead | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |
| zip | Unknown |  |

### purchase_order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| purchase_order_id | Unknown | PK, FK |
| type | Unknown | FK |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| customer_type | Unknown | FK |
| warehouse_id | Unknown | FK |
| warehouse_type | Unknown | FK |
| closed_at | Unknown |  |
| created_at | Instant |  |
| delivered_at | Unknown |  |
| expected_at | Unknown |  |
| external_id | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| ordered_at | Unknown |  |
| priority | Unknown |  |
| received_at | Unknown |  |
| tags | Unknown |  |
| tracking_number | Unknown |  |
| tracking_url | Unknown |  |
| updated_at | Unknown |  |

### order_included

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type | Unknown | PK |
| order_item_product_id | Unknown | FK |
| address | Unknown |  |
| address_2 | Unknown |  |
| approved | Unknown |  |
| attribute_type | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| contact_information_id | Unknown |  |
| contact_information_type | Unknown |  |
| cost | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| document_type | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| height | Unknown |  |
| length | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| package_order_item | Unknown |  |
| phone | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| quantity_allocated | Unknown |  |
| quantity_allocated_pickable | Unknown |  |
| quantity_backordered | Unknown |  |
| quantity_pending | Unknown |  |
| quantity_reshipped | Unknown |  |
| quantity_returned | Unknown |  |
| quantity_shipped | Unknown |  |
| reason | Unknown |  |
| return_order_item_id | Unknown |  |
| serial_number | Unknown |  |
| shipment_shipping_method_id | Unknown |  |
| shipment_shipping_method_type | Unknown |  |
| shipping_carrier_id | Unknown |  |
| shipping_carrier_type | Unknown |  |
| size | Unknown |  |
| sku | Unknown |  |
| state | Unknown |  |
| status_text | Unknown |  |
| tracking_number | Unknown |  |
| tracking_url | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| weight | Unknown |  |
| width | Unknown |  |
| zip | Unknown |  |

### tote_included

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type | Unknown | PK |
| order_id | Unknown | FK |
| order_item_id | Unknown | FK |
| product_id | Unknown | FK |
| address | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| contact_information_id | Unknown |  |
| contact_information_type | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| order_item_type | Unknown |  |
| order_type | Unknown |  |
| phone | Unknown |  |
| picked_at | Unknown |  |
| price | Unknown |  |
| product_type | Unknown |  |
| quantity | Unknown |  |
| quantity_allocated | Unknown |  |
| quantity_allocated_pickable | Unknown |  |
| quantity_backordered | Unknown |  |
| quantity_pending | Unknown |  |
| quantity_reshipped | Unknown |  |
| quantity_returned | Unknown |  |
| quantity_shipped | Unknown |  |
| removed_at | Unknown |  |
| sku | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |
| zip | Unknown |  |

### customer_included

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type | Unknown | PK |
| address | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| customer_children_contact_information_id | Unknown |  |
| customer_children_contact_information_type | Unknown |  |
| email | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |
| zip | Unknown |  |

### order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| order_id | Unknown | PK, FK |
| type | Unknown | FK |

### order_shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| order_id | Unknown | PK, FK |
| type | Unknown | FK |

### order_return

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| order_id | Unknown | PK, FK |
| type | Unknown | FK |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_contact_information_id | Unknown | FK |
| billing_contact_information_type | Unknown | FK |
| customer_id | Unknown | FK |
| customer_type | Unknown | FK |
| order_channel_id | Unknown | FK |
| order_channel_type | Unknown | FK |
| shipping_contact_information_id | Unknown | FK |
| shipping_contact_information_type | Unknown | FK |
| shipping_method_id | Unknown | FK |
| shipping_method_type | Unknown | FK |
| address_hold | Unknown |  |
| allow_partial | Unknown |  |
| archived_at | Unknown |  |
| cancelled_at | Unknown |  |
| created_at | Unknown |  |
| discount | Unknown |  |
| external_id | Unknown |  |
| fraud_hold | Unknown |  |
| fulfilled_at | Unknown |  |
| hold_until | Unknown |  |
| is_wholesale | Unknown |  |
| number | Unknown |  |
| operator_hold | Unknown |  |
| ordered_at | Unknown |  |
| packing_note | Unknown |  |
| payment_hold | Unknown |  |
| ready_to_pick | Unknown |  |
| ready_to_ship | Unknown |  |
| scheduled_delivery | Unknown |  |
| ship_before | Unknown |  |
| shipping | Unknown |  |
| shipping_method_code | Unknown |  |
| shipping_method_name | Unknown |  |
| status_text | Unknown |  |
| tags | Unknown |  |
| tax | Unknown |  |
| total | Unknown |  |
| tote | Unknown |  |
| updated_at | Instant |  |

## Relationships

- location_product(id) → location_included(id)
- location_product(type) → location_included(type)
- location_product(location_id) → location(id)
- location(location_type_id) → location_included(id)
- location(location_type) → location_included(type)
- location(warehouse_id) → location_included(id)
- location(warehouse_type) → location_included(type)
- location_included(product_id) → product(id)
- tote_order_item(id) → tote_included(id)
- tote_order_item(type) → tote_included(type)
- tote_order_item(tote_id) → tote(id)
- tote(warehouse_id) → tote_included(id)
- tote(warehouse_type) → tote_included(type)
- product_included(location_product_location_id) → location(id)
- product_barcode(id) → product_included(id)
- product_barcode(type) → product_included(type)
- product_barcode(product_id) → product(id)
- product_image(id) → product_included(id)
- product_image(type) → product_included(type)
- product_image(product_id) → product(id)
- products_location_product(id) → product_included(id)
- products_location_product(type) → product_included(type)
- products_location_product(product_id) → product(id)
- product(customer_id) → product_included(id)
- product(customer_type) → product_included(type)
- customer_setting(id) → customer_included(id)
- customer_setting(type) → customer_included(type)
- customer_setting(customer_id) → customer(id)
- customer_children(id) → customer_included(id)
- customer_children(type) → customer_included(type)
- customer_children(customer_id) → customer(id)
- customer(contact_information_id) → customer_included(id)
- customer(contact_information_type) → customer_included(type)
- purchase_order_included(id) → purchase_order_item(id)
- purchase_order_included(product_id) → product(id)
- purchase_order_item(id) → purchase_order_included(id)
- purchase_order_item(type) → purchase_order_included(type)
- purchase_order_item(purchase_order_id) → purchase_order(id)
- purchase_order(customer_id) → purchase_order_included(id)
- purchase_order(customer_type) → purchase_order_included(type)
- purchase_order(warehouse_id) → purchase_order_included(id)
- purchase_order(warehouse_type) → purchase_order_included(type)
- order_included(order_item_product_id) → product(id)
- tote_included(product_id) → product(id)
- tote_included(order_id) → orders(id)
- tote_included(order_item_id) → tote_order_item(id)
- order_item(id) → order_included(id)
- order_item(type) → order_included(type)
- order_item(order_id) → orders(id)
- order_shipment(id) → order_included(id)
- order_shipment(type) → order_included(type)
- order_shipment(order_id) → orders(id)
- order_return(id) → order_included(id)
- order_return(type) → order_included(type)
- order_return(order_id) → orders(id)
- orders(customer_type) → order_included(type)
- orders(billing_contact_information_type) → order_included(type)
- orders(order_channel_id) → order_included(id)
- orders(shipping_method_type) → order_included(type)
- orders(billing_contact_information_id) → order_included(id)
- orders(shipping_contact_information_type) → order_included(type)
- orders(shipping_contact_information_id) → order_included(id)
- orders(customer_id) → order_included(id)
- orders(shipping_method_id) → order_included(id)
- orders(order_channel_type) → order_included(type)