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 |
|
customers
|
customerNumber
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
|
customers
|
customerName
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
customers
|
contactLastName
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
customers
|
contactFirstName
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
customers
|
phone
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
customers
|
addressLine1
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
customers
|
addressLine2
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
customers
|
city
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
customers
|
state
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
customers
|
postalCode
|
varchar(15)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
customers
|
country
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
customers
|
salesRepEmployeeNumber
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
|
customers
|
creditLimit
|
double
|
|
|
|
|
NULL
|
NULL
|
|