Tables
ERD
4 tables
Expand all
Collapse all
product
17 columns
product_assigned_category
3 columns
product_primary_category
3 columns
order
47 columns
Loading diagram…
product
product
id
string
c_*
string
creation_date
date
ean
string
last_modified
date
name
string
online_flag
boolean
owning_catalog_id
string
owning_catalog_name
string
page_description
string
page_title
string
searchable
boolean
short_description_markup
string
short_description_source
string
type
boolean
unit_quantity
int
valid_from
date
product_assigned_category
product_id
string
catalog_id
string
category_id
string
product_primary_category
product_id
string
catalog_id
string
category_id
string
order
adjusted_merchandize_total_tax
double
adjusted_shipping_total_tax
double
billing_address_address_1
string
billing_address_address_2
string
billing_address_city
string
billing_address_country_code
string
billing_address_first_name
string
billing_address_full_name
string
billing_address_last_name
string
billing_address_phone
string
billing_address_postal_code
string
billing_address_state_code
string
c_*
double
confirmation_status
string
coupon_items
string
created_by
string
creation_date
long
currency
string
customer_info_customer_id
string
customer_info_customer_name
string
customer_info_customer_no
long
customer_info_email
string
customer_info_guest
boolean
customer_locale
string
export_status
string
invoice_no
string
last_modified
long
merchandize_total_tax
double
notes
string
order_no
string
order_price_adjustments
string
order_total
double
payment_instruments
string
payment_status
string
place_date
long
product_items
string
product_sub_total
double
product_total
double
shipments
string
shipping_items
string
shipping_status
string
shipping_total
double
shipping_total_tax
double
site_id
string
status
string
tax_total
double
taxation
string
Table
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.