# Picqer schema ERD

Table and field reference for the Fivetran Picqer connector.

## 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 | PK, FK |
| 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 | PK, FK |
| picklist_product_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| image_url | Unknown |  |

### product_stock

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| warehouse_id | Unknown | PK, FK |
| freestock | Unknown |  |
| reserved | Unknown |  |
| reserved_allocations | Unknown |  |
| reserved_back_order | Unknown |  |
| reserved_picklist | Unknown |  |
| stock | Unknown |  |

### product_field

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

### product_price_list

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

### product_tag

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

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| order_id | Unknown | PK, FK |

### order_price_list

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

### order_warehouse

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

### order_tag

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

### 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 | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |

### customer_tag

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

### 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 |  |

## Relationships

- shipping_provider_profile(shipping_provider_id) → shipping_provider(id)
- picklist_location(location_id) → location(id)
- picklist_location(picklist_product_id) → picklist_product(id)
- picklist_location(picklist_id) → picklist_product(picklist_id)
- picklist_product(product_id) → picklist_product(id)
- picklist_product(order_product_id) → order_product(order_product_id)
- picklist_product(picklist_id) → picklist(id)
- picklist(template_id) → template(id)
- picklist(return_id) → return(id)
- picklist(warehouse_id) → warehouse(id)
- picklist(order_id) → orders(id)
- picklist(customer_id) → customer(id)
- picklist(reference) → orders(reference)
- picklist(closed_by_user_id) → users(id)
- picklist(shipping_provider_profile_id) → shipping_provider_profile(id)
- picklist(assigned_to_user_id) → users(id)
- supplier(template_id) → template(id)
- product_image(product_id) → product(id)
- product_stock(warehouse_id) → warehouse(id)
- product_stock(product_id) → product(id)
- product_field(id) → product_field_detailed(id)
- product_field(product_id) → product(id)
- product_price_list(id) → price_list(id)
- product_price_list(product_id) → product(id)
- product_tag(tag_id) → tags(id)
- product_tag(product_id) → product(id)
- product(vat_group_id) → vat_group(id)
- product(supplier_id) → supplier(id)
- picking_container(picklist_id) → picklist(id)
- user_right(user_id) → users(id)
- backorder(product_id) → product(id)
- backorder(return_id) → return(id)
- backorder(warehouse_id) → warehouse(id)
- backorder(order_id) → orders(id)
- backorder(customer_id) → customer(id)
- backorder(part_of_backorder_id) → backorder(id)
- purchase_order_product(product_id) → product(id)
- purchase_order_product(purchase_order_id) → purchase_order(id)
- purchase_order(template_id) → template(id)
- purchase_order(completed_user_id) → users(id)
- purchase_order(warehouse_id) → warehouse(id)
- purchase_order(supplier_id) → supplier(id)
- purchase_order(created_user_id) → users(id)
- purchase_order(purchased_user_id) → users(id)
- location(warehouse_id) → warehouse(id)
- location(parent_location_id) → location(id)
- comment_mention(user_id) → users(id)
- comment_mention(comment_id) → comment(id)
- comment(product_id) → product(id)
- comment(user_id) → users(id)
- comment(return_id) → return(id)
- comment(picklist_id) → picklist(id)
- comment(order_id) → orders(id)
- comment(supplier_id) → supplier(id)
- comment(customer_id) → customer(id)
- comment(purchaseorder_id) → purchase_order(id)
- order_product(product_id) → product(id)
- order_product(part_of_order_product_id) → order_product(order_product_id)
- order_product(order_id) → orders(id)
- order_field(id) → order_field_detailed(id)
- order_field(order_id) → orders(id)
- order_price_list(pricelist_id) → price_list(id)
- order_price_list(order_id) → orders(id)
- order_warehouse(warehouse_id) → warehouse(id)
- order_warehouse(order_id) → orders(id)
- order_tag(tag_id) → tags(id)
- order_tag(order_id) → orders(id)
- orders(template_id) → template(id)
- orders(customer_id) → customer(id)
- orders(shipping_provider_profile_id) → shipping_provider_profile(id)
- return(template_id) → template(id)
- return(order_id) → orders(id)
- return(customer_id) → customer(id)
- stock_history(product_id) → product(id)
- stock_history(user_id) → users(id)
- stock_history(warehouse_id) → warehouse(id)
- stock_history(location_id) → location(id)
- customer_address(customer_id) → customer(id)
- customer_field(id) → customer_field_detailed(id)
- customer_field(customer_id) → customer(id)
- customer_tag(tag_id) → tags(id)
- customer_tag(customer_id) → customer(id)
- customer(template_id) → template(id)