Table schema_generation.customers
InnoDB free: 7168 kB

 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
customers_id int 11  √ 
address_book.customers_id address_book_ibfk_1
article_reviews.customers_id Implied Constraint
coupon_email_track.customer_id_sent coupon_email_track_ibfk_2
coupon_gv_customer.customer_id coupon_gv_customer_ibfk_1
coupon_gv_queue.customer_id coupon_gv_queue_ibfk_1
coupon_redeem_track.customer_id coupon_redeem_track_ibfk_2
customers_basket.customers_id customers_basket_ibfk_1
customers_basket_attributes.customers_id customers_basket_attributes_ibfk_1
customers_info.customers_info_id customers_info_ibfk_1
customers_wishlist.customers_id customers_wishlist_ibfk_2
customers_wishlist_attributes.customers_id customers_wishlist_attributes_ibfk_2
orders.customers_id Implied Constraint
products_notifications.customers_id products_notifications_ibfk_2
reviews.customers_id Implied Constraint
purchased_without_account bit 1 0
customers_gender char 1
customers_firstname varchar 32
customers_lastname varchar 32
customers_dob datetime 19 0000-00-00 00:00:00
customers_email_address varchar 96
customers_default_address_id int 11 0
customers_telephone varchar 32
customers_fax varchar 32  √  null
customers_password varchar 40
customers_newsletter char 1  √  null
customers_selected_template varchar 20  √  null
customers_group_id smallint 5 0
customers_group_ra enum 2 0
customers_payment_allowed varchar 255
customers_shipment_allowed varchar 255
customers_validation_code varchar 48
customers_validation char 1 0
customers_email_registered varchar 32

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

Indexes:
Column(s) Type Sort Constraint Name
customers_id Primary key Asc PRIMARY
purchased_without_account Performance Asc purchased_without_account

Close relationships  within one two degrees of separation :