+---------------+-------------+------+-----+------------+-------+
| Field         | Type        | Null | Key | Default    | Extra |
+---------------+-------------+------+-----+------------+-------+
| employee_id   | varchar(9)  |      | PRI |            |       |
| firstname     | varchar(50) |      |     |            |       |
| last_name     | varchar(50) |      |     |            |       |
| title         | varchar(10) |      |     |            |       |
| dept          | varchar(10) |      |     |            |       |
| salary        | mediumint   |      |     |            |       |
| date_hired    | date        |      |     |            |       |
+---------------+-------------+------+-----+------------+-------+