Fields
Name |
Engine |
Collation |
Row Count |
Data Length |
Last Inserted Id |
Comment |
Average Row Length |
Row Format |
Created |
Updated |
Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
customer
|
customer_id
|
smallint(5) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
customer
|
store_id
|
tinyint(3) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
customer
|
first_name
|
varchar(45)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
customer
|
last_name
|
varchar(45)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
customer
|
email
|
varchar(50)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
customer
|
address_id
|
smallint(5) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
customer
|
active
|
tinyint(1)
|
|
|
|
|
NULL
|
NULL
|
|
customer
|
create_date
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
customer
|
last_update
|
timestamp
|
|
|
|
|
NULL
|
NULL
|
|