Table Name | Name | Data Type | Primary Key | Unique | Required | Autoincrement | Charset | Collation | Comment |
employees | employeeNumber | int(11) | |||||||
employees | lastName | varchar(50) | latin1 | latin1_swedish_ci | |||||
employees | firstName | varchar(50) | latin1 | latin1_swedish_ci | |||||
employees | extension | varchar(10) | latin1 | latin1_swedish_ci | |||||
employees | varchar(100) | latin1 | latin1_swedish_ci | ||||||
employees | officeCode | varchar(10) | latin1 | latin1_swedish_ci | |||||
employees | reportsTo | int(11) | |||||||
employees | jobTitle | varchar(50) | latin1 | latin1_swedish_ci |