Table ezp54_community.ezorder Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
account_identifier varchar 100 default
created int 10 0
data_text_1 longtext 2147483647  √  null
data_text_2 longtext 2147483647  √  null
email varchar 150  √ 
id int 10  √ 
ezbasket.order_id ezbasket_ibfk_1 R
ezorder_item.order_id ezorder_item_ibfk_1 R
ezorder_status_history.order_id ezorder_status_history_ibfk_2 R
ezpaymentobject.order_id ezpaymentobject_ibfk_1 R
ignore_vat int 10 0
is_archived int 10 0
is_temporary int 10 1
order_nr int 10 0
productcollection_id int 10 0
ezproductcollection.id ezorder_ibfk_1 R
status_id int 10  √  0
ezorder_status.id ezorder_ibfk_2 R
status_modified int 10  √  0
status_modifier_id int 10  √  0
ezuser.contentobject_id ezorder_ibfk_3 R
user_id int 10 0
ezuser.contentobject_id ezorder_ibfk_4 R

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
is_archived Performance Asc ezorder_is_archived
is_temporary Performance Asc ezorder_is_tmp
productcollection_id Performance Asc productcollection_id
status_id Performance Asc status_id
status_modifier_id Performance Asc status_modifier_id
user_id Performance Asc user_id

Close relationships  within of separation: