Picqer
Explore the interactive ERD
Table & Field Reference
template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom_css | Unknown | |
defaults | Unknown | |
name | Unknown |
shipping_provider_profile
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
shipping_provider_id | Unknown | PKFK |
active | Unknown | |
created | Unknown | |
name | Unknown | |
standard | Unknown | |
updated | Unknown |
shipping_provider
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
created | Unknown | |
name | Unknown | |
provider | Unknown | |
updated | Unknown |
vat_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
percentage | Unknown | |
standard | Unknown |
picklist_location
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
picklist_id | Unknown | PKFK |
picklist_product_id | Unknown | PKFK |
location_id | Unknown | FK |
amount | Unknown | |
amount_picked | Unknown | |
picklist_product_location_id | Unknown |
picklist_product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
picklist_id | Unknown | PKFK |
order_product_id | Unknown | FK |
product_id | Unknown | FK |
amount | Unknown | |
amount_picked | Unknown | |
has_parts | Unknown | |
part_of_picklist_product_id | Unknown | |
price | Unknown | |
remarks | Unknown | |
return_product_replacement_id | Unknown | |
stock_location | Unknown |
picklist
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assigned_to_user_id | Unknown | FK |
closed_by_user_id | Unknown | FK |
customer_id | Unknown | FK |
order_id | Unknown | FK |
reference | Unknown | FK |
return_id | Unknown | FK |
shipping_provider_profile_id | Unknown | FK |
template_id | Unknown | FK |
warehouse_id | Unknown | FK |
closed_at | Unknown | |
created | Unknown | |
delivery_address | Unknown | |
delivery_address_2 | Unknown | |
delivery_city | Unknown | |
delivery_contact | Unknown | |
delivery_country | Unknown | |
delivery_name | Unknown | |
delivery_region | Unknown | |
delivery_zip_code | Unknown | |
email_address | Unknown | |
invoiced | Unknown | |
picklist_number | Unknown | |
preferred_delivery_date | Unknown | |
snoozed_until | Unknown | |
status | Unknown | |
telephone | Unknown | |
total_picked | Unknown | |
total_product | Unknown | |
updated | Unknown | |
urgent | Unknown |
price_list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
order_field_detailed
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
required | Unknown | |
title | Unknown | |
type | Unknown | |
values | Json | |
visible_picklist | Unknown | |
visible_portal | Unknown |
customer_field_detailed
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
required | Unknown | |
title | Unknown | |
type | Unknown | |
values | Json |
supplier
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
template_id | Unknown | FK |
active | Unknown | |
address | Unknown | |
address_2 | Unknown | |
city | Unknown | |
contact_name | Unknown | |
country | Unknown | |
email_address | Unknown | |
full_address | Unknown | |
languages | Unknown | |
name | Unknown | |
region | Unknown | |
remarks | Unknown | |
telephone | Unknown | |
zip_code | Unknown |
product_image
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_id | Unknown | PKFK |
image_url | Unknown |
product_stock
| Column | Type | Keys |
|---|---|---|
product_id | Unknown | PKFK |
warehouse_id | Unknown | PKFK |
freestock | Unknown | |
reserved | Unknown | |
reserved_allocations | Unknown | |
reserved_back_order | Unknown | |
reserved_picklist | Unknown | |
stock | Unknown |
product_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
product_id | Unknown | PKFK |
product_price_list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
product_id | Unknown | PKFK |
price | Unknown |
product_tag
| Column | Type | Keys |
|---|---|---|
product_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_id | Unknown | FK |
vat_group_id | Unknown | FK |
active | Unknown | |
analysis_abc_classification | Unknown | |
analysis_pick_amount_per_day | Unknown | |
assembled | Unknown | |
barcode | Unknown | |
code | Unknown | |
country_of_origin | Unknown | |
delivery_time | Unknown | |
description | Unknown | |
fixed_stock_price | Unknown | |
height | Unknown | |
hs_code | Unknown | |
length | Unknown | |
minimum_purchase_quantity | Unknown | |
name | Unknown | |
price | Unknown | |
product_code_supplier | Unknown | |
purchase_in_quantities_of | Unknown | |
show_on_portal | Unknown | |
type | Unknown | |
unlimited_stock | Unknown | |
weight | Unknown | |
width | Unknown |
product_field_detailed
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
required | Unknown | |
title | Unknown | |
type | Unknown | |
values | Json | |
visible_invoice | Unknown | |
visible_picklist | Unknown | |
visible_portal | Unknown | |
visible_purchase_order | Unknown | |
visible_shipping_list | Unknown |
picking_container
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
picklist_id | Unknown | FK |
created_at | Unknown | |
name | Unknown | |
updated_at | Unknown |
warehouse
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
accept_orders | Unknown | |
active | Unknown | |
counts_for_general_stock | Unknown | |
name | Unknown | |
priority | Unknown |
user_right
| Column | Type | Keys |
|---|---|---|
rights | Unknown | PK |
user_id | Unknown | PKFK |
granted | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
admin | Unknown | |
created_at | Unknown | |
email_address | Unknown | |
first_name | Unknown | |
full_name | Unknown | |
languages | Unknown | |
last_login_at | Unknown | |
last_name | Unknown | |
name | Unknown | |
packing_station_id | Unknown | |
updated_at | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
color | Unknown | |
inherit | Unknown | |
text_color | Unknown | |
title | Unknown |
backorder
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
order_id | Unknown | FK |
part_of_backorder_id | Unknown | FK |
product_id | Unknown | FK |
return_id | Unknown | FK |
warehouse_id | Unknown | FK |
amount | Unknown | |
amount_available | Unknown | |
created_at | Unknown | |
has_parts | Unknown | |
parts_per_parent | Unknown | |
priority | Unknown |
purchase_order_product
| Column | Type | Keys |
|---|---|---|
purchase_order_product_id | Unknown | PK |
purchase_order_id | Unknown | PKFK |
product_id | Unknown | FK |
amount | Unknown | |
amount_received | Unknown | |
delivery_date | Unknown | |
price | Unknown | |
product_code_supplier | Unknown |
purchase_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
completed_user_id | Unknown | FK |
created_user_id | Unknown | FK |
purchased_user_id | Unknown | FK |
supplier_id | Unknown | FK |
template_id | Unknown | FK |
warehouse_id | Unknown | FK |
completed_at | Unknown | |
created | Unknown | |
delivery_date | Unknown | |
languages | Unknown | |
purchase_order_number | Unknown | |
purchased_at | Unknown | |
remarks | Unknown | |
status | Unknown | |
supplier_name | Unknown | |
supplier_order_id | Unknown | |
updated | Unknown |
location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_location_id | Unknown | FK |
warehouse_id | Unknown | FK |
is_bulk_location | Unknown | |
is_exclusive_location | Unknown | |
location_type_color | Unknown | |
location_type_default | Unknown | |
location_type_id | Unknown | |
location_type_name | Unknown | |
name | Unknown | |
remarks | Unknown | |
type | Unknown | |
unlink_on_empty | Unknown |
comment_mention
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
comment_id | Unknown | FK |
user_id | Unknown | FK |
mentioned_type | Unknown | |
text | Unknown |
comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
order_id | Unknown | FK |
picklist_id | Unknown | FK |
product_id | Unknown | FK |
purchaseorder_id | Unknown | FK |
return_id | Unknown | FK |
supplier_id | Unknown | FK |
user_id | Unknown | FK |
author_type | Unknown | |
body | Unknown | |
created_at | Unknown | |
image_url | Unknown | |
receipt_id | Unknown | |
show_at_related | Unknown | |
source_type | Unknown | |
updated_at | Unknown |
order_product
| Column | Type | Keys |
|---|---|---|
order_product_id | Unknown | PK |
order_id | Unknown | PKFK |
part_of_order_product_id | Unknown | FK |
product_id | Unknown | FK |
amount | Unknown | |
amount_cancelled | Unknown | |
has_parts | Unknown | |
price | Unknown | |
remarks | Unknown |
order_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
order_id | Unknown | PKFK |
order_price_list
| Column | Type | Keys |
|---|---|---|
order_id | Unknown | PKFK |
pricelist_id | Unknown | PKFK |
order_warehouse
| Column | Type | Keys |
|---|---|---|
order_id | Unknown | PKFK |
warehouse_id | Unknown | PKFK |
order_tag
| Column | Type | Keys |
|---|---|---|
order_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
orders
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
shipping_provider_profile_id | Int | FK |
template_id | Unknown | FK |
auto_split | Unknown | |
calculate_vat | Unknown | |
created | Unknown | |
customer_remarks | Unknown | |
delivery_address | Unknown | |
delivery_address_2 | Unknown | |
delivery_city | Unknown | |
delivery_contact_name | Unknown | |
delivery_country | Unknown | |
delivery_name | Unknown | |
delivery_region | Unknown | |
delivery_zip_code | Unknown | |
discount | Unknown | |
email_address | Unknown | |
full_delivery_address | Unknown | |
full_invoice_address | Unknown | |
invoice_address | Unknown | |
invoice_address_2 | Unknown | |
invoice_city | Unknown | |
invoice_contact_name | Unknown | |
invoice_country | Unknown | |
invoice_name | Unknown | |
invoice_region | Unknown | |
invoice_zip_code | Unknown | |
invoiced | Unknown | |
languages | Unknown | |
order_number | Unknown | |
partial_delivery | Unknown | |
pickup_point_data | Unknown | |
preferred_delivery_date | Unknown | |
public_status_page | Unknown | |
reference | Unknown | |
status | Unknown | |
telephone | Unknown | |
updated | Unknown |
return
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
order_id | Unknown | FK |
template_id | Unknown | FK |
address | Unknown | |
address_2 | Unknown | |
city | Unknown | |
completed_at | Unknown | |
contact_name | Unknown | |
country | Unknown | |
created_at | Unknown | |
email_address | Unknown | |
full_address | Unknown | |
languages | Unknown | |
name | Unknown | |
received_at | Unknown | |
reference | Unknown | |
region | Unknown | |
return_number | Unknown | |
return_status_id | Unknown | |
telephone | Unknown | |
tracking_code | Unknown | |
updated_at | Unknown | |
zip_code | Unknown |
stock_history
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
location_id | Unknown | FK |
product_id | Unknown | FK |
user_id | Unknown | FK |
warehouse_id | Unknown | FK |
change_type | Unknown | |
changed_at | Unknown | |
new_stock | Unknown | |
old_stock | Unknown | |
reason | Unknown | |
stock_change | Unknown |
customer_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | PKFK |
address | Unknown | |
address_2 | Unknown | |
city | Unknown | |
contact_name | Unknown | |
country | Unknown | |
default_delivery | Unknown | |
default_invoice | Unknown | |
full_address | Unknown | |
name | Unknown | |
region | Unknown | |
zip_code | Unknown |
customer_field
| Column | Type | Keys |
|---|---|---|
customer_id | Unknown | PKFK |
id | Unknown | PKFK |
customer_tag
| Column | Type | Keys |
|---|---|---|
customer_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
template_id | Unknown | FK |
auto_split | Unknown | |
calculate_vat | Unknown | |
contact_name | Unknown | |
customer_number | Unknown | |
default_order_remarks | Unknown | |
discount | Unknown | |
email_address | Unknown | |
languages | Unknown | |
name | Unknown | |
partial_delivery | Unknown | |
remarks | Unknown | |
telephone | Unknown | |
vat_number | Unknown |