Packiyo
Explore the interactive ERD
Table & Field Reference
location_product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
location_id | Unknown | PKFK |
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 | PKFK |
tote_id | Unknown | PKFK |
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 | PKFK |
product_id | Unknown | PKFK |
type | Unknown | FK |
product_image
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
product_id | Unknown | PKFK |
type | Unknown | FK |
products_location_product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
product_id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
type | Unknown | FK |
customer_children
| Column | Type | Keys |
|---|---|---|
customer_id | Unknown | PKFK |
id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
purchase_order_id | Unknown | PKFK |
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 | PKFK |
order_id | Unknown | PKFK |
type | Unknown | FK |
order_shipment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
order_id | Unknown | PKFK |
type | Unknown | FK |
order_return
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
order_id | Unknown | PKFK |
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 |