Traede schema and ERD

32 tables

Loading diagram…

customer

invoice

order

product

production_order

production_order_delivery_note

variant

category

string

name

string

parent

string

created_at

date

updated_at

date

_weld_synced

date

customer

string

customer_number

string

name

string

currency

string

country

string

vat_number

string

ean_number

string

notes

string

customer_meta

customer_id

string

key

string

value

string

_weld_synced

date

customer_billing_email

customer_id

string

_weld_synced

date

customer_group

customer_id

string

customer_group_id

string

name

string

created_at

date

updated_at

date

_weld_synced

date

invoice

string

customer_id

string

order_id

string

invoice_number

string

order_type

string

invoice_date

string

status

string

currency

string

notes

string

total_quantity

long

price_before_discount

double

invoice_meta

invoice_id

string

key

string

value

string

invoice_updated_at

date

_weld_synced

date

invoice_line

string

invoice_id

string

product_id

string

variant_id

string

quantity

long

price_before_discount

double

discount_amount

double

discount_percentage

double

net_price

double

vat_amount

double

total_price

double

total_price_after_vat

double

created_at

date

updated_at

date

invoice_updated_at

date

_weld_synced

date

invoice_line_meta

invoice_line_id

string

key

string

value

string

invoice_updated_at

date

_weld_synced

date

order

string

customer_id

string

order_number

string

type

string

internal_status

string

cancelled

string

archived

string

status

string

currency

string

comments_internal

string

order_meta

order_id

string

key

string

value

string

order_updated_at

date

_weld_synced

date

order_line

order_id

string

variant_id

string

product_id

string

quantity

long

shipped

long

invoiced

long

price_before_discount

double

discount_amount

double

discount_percentage

double

net_price

double

vat_amount

double

order_line_meta

order_id

string

variant_id

string

key

string

value

string

order_updated_at

date

_weld_synced

date

product

string

item_number

string

name

string

description

string

subbrand_id

string

collection_id

string

height

double

height_type

string

length

double

product_variant

product_id

string

variant_id

string

product_updated_at

date

_weld_synced

date

variant_cost_price

product_id

string

variant_id

string

product_variant_cost_price_set_id

string

currency

string

cost_price

double

product_costs

string

total_cost

double

landed_cost

double

created_at

date

updated_at

date

product_updated_at

date

_weld_synced

date

product_category

product_id

string

category_id

string

product_updated_at

date

_weld_synced

date

product_meta

product_id

string

key

string

value

string

product_updated_at

date

_weld_synced

date

product_cost_price_set

product_id

string

cost_price_set_id

string

label

string

default

boolean

currency

string

created_at

date

updated_at

date

product_updated_at

date

_weld_synced

date

production_order

string

production_order_number

string

status

string

supplier_id

string

external_comments

string

internal_comments

string

expected_arrival

date

original_expected_arrival

date

expected_departure

date

production_order_meta

production_order_id

string

key

string

value

string

production_order_updated_at

date

_weld_synced

date

production_order_line

string

production_order_id

string

product_id

string

variant_id

string

batch_id

string

text

string

quantity

long

in_production

long

in_delivery

long

on_the_way

long

received

long

unit_price

double

production_order_delivery_note

string

production_order_id

string

production_order_delivery_note_number

string

status

string

supplier_id

string

notes

string

incoterms

string

sales_order_delivery_mode

string

sales_order_shipping_method_id

string

ordered

long

production_order_delivery_note_meta

production_order_delivery_note_id

string

key

string

value

string

production_order_delivery_note_updated_at

date

_weld_synced

date

production_order_delivery_note_line

string

production_order_delivery_note_id

string

product_id

string

variant_id

string

text

string

ordered

long

received

long

diff

long

unit_price

double

total_price

double

created_at

date

updated_at

date

production_order_delivery_note_updated_at

date

_weld_synced

date

user

string

firstname

string

lastname

string

nickname

string

telephone

string

title

string

user_type

string

locale

string

variant

string

sku

string

ean

string

cost_price

double

landed_cost

double

booked_landed_cost

double

height

double

height_type

string

length

double

variant_attribute

variant_id

string

key

string

value

string

variant_updated_at

date

_weld_synced

date

variant_meta

variant_id

string

key

string

value

string

variant_updated_at

date

_weld_synced

date

variant_price

variant_id

string

currency

string

sales_price

double

rec_sales_price

double

offer_price

double

b2c_offer_price

double

variant_updated_at

date

_weld_synced

date

variant_available

variant_id

string

available_id

string

inventory_location_id

string

quantity

long

type

string

created_at

date

updated_at

date

variant_updated_at

date

_weld_synced

date

variant_stock

variant_id

string

stock_id

string

inventory_location_id

string

quantity

long

created_at

date

updated_at

date

variant_updated_at

date

_weld_synced

date