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 |
|
Employees
|
EmployeeID
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
|
Employees
|
LastName
|
varchar(20)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
FirstName
|
varchar(10)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
Title
|
varchar(30)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
TitleOfCourtesy
|
varchar(25)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
BirthDate
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
|
Employees
|
HireDate
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
|
Employees
|
Address
|
varchar(60)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
City
|
varchar(15)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
Region
|
varchar(15)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
PostalCode
|
varchar(10)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
Country
|
varchar(15)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
HomePhone
|
varchar(24)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
Extension
|
varchar(4)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
Photo
|
longblob
|
|
|
|
|
NULL
|
NULL
|
|
|
Employees
|
Notes
|
mediumtext
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
ReportsTo
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
|
Employees
|
PhotoPath
|
varchar(255)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
|
Employees
|
Salary
|
float
|
|
|
|
|
NULL
|
NULL
|
|