Table schema_generation.orders
InnoDB free: 7168 kB; (`orders_status`) REFER `schema_generation/orders_status`(

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
orders_id int 11  √ 
affiliate_sales.affiliate_orders_id affiliate_sales_ibfk_2
coupon_gv_queue.order_id coupon_gv_queue_ibfk_2
orders_products.orders_id orders_products_ibfk_1
orders_products_attributes.orders_id orders_products_attributes_ibfk_1
orders_products_download.orders_id orders_products_download_ibfk_1
orders_session_info.orders_id orders_session_info_ibfk_1
orders_status_history.orders_id Implied Constraint
orders_total.orders_id orders_total_ibfk_1
customers_id int 11 0
customers.customers_id Implied Constraint
customers_name varchar 64
customers_company varchar 32  √  null
customers_street_address varchar 64
customers_suburb varchar 32  √  null
customers_city varchar 32
customers_postcode varchar 10
customers_state varchar 32  √  null
customers_country varchar 32
customers_telephone varchar 32
customers_email_address varchar 96
customers_address_format_id int 5 0
delivery_name varchar 64
delivery_company varchar 32  √  null
delivery_street_address varchar 64
delivery_suburb varchar 32  √  null
delivery_city varchar 32
delivery_postcode varchar 10
delivery_state varchar 32  √  null
delivery_country varchar 32
delivery_address_format_id int 5 0
billing_name varchar 64
billing_company varchar 32  √  null
billing_street_address varchar 64
billing_suburb varchar 32  √  null
billing_city varchar 32
billing_postcode varchar 10
billing_state varchar 32  √  null
billing_country varchar 32
billing_address_format_id int 5 0
payment_method varchar 32
payment_info text 65535  √  null
payment_id int 11 0
cc_type varchar 20  √  null
cc_owner varchar 64  √  null
cc_number varchar 90  √  null
cc_ccv varchar 90  √  null
cc_expires varchar 90  √  null
cc_start varchar 4  √  null
cc_issue char 3  √  null
cc_bank_phone varchar 32
last_modified datetime 19  √  null
date_purchased datetime 19  √  null
orders_status int 5 0
orders_status.orders_status_id orders_ibfk_1
orders_date_finished datetime 19  √  null
currency char 3  √  null
currency_value decimal 14,6  √  null
account_name varchar 32  √  null
account_number varchar 20  √  null
po_number varchar 12  √  null
purchased_without_account bit 1 0
paypal_ipn_id int 11 0
ipaddy varchar 15
ipisp varchar 15

Table contained 0 rows at Mon Jun 18 16:54 CDT 2007

Indexes:
Column(s) Type Sort Constraint Name
orders_id Primary key Asc PRIMARY
orders_status Performance Asc orders_status

Close relationships  within one two degrees of separation :