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 |
offices
|
officeCode
|
varchar(10)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
offices
|
city
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
offices
|
phone
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
offices
|
addressLine1
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
offices
|
addressLine2
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
offices
|
state
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
offices
|
country
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
offices
|
postalCode
|
varchar(15)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
offices
|
territory
|
varchar(10)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|