Table     Column        dataType     Constraint
Employee    -              -         engine = innoDB
          empno         int(4)       primary key
          ename         char(10)     not null and unique
          job           varchar(9)   default null
          manager       decimal(4)   (recursive) foreign key
          hireDate      date         default null*
          salary        decimal(7,2) default 1.00 
*or use trigger to assign "now" for new employees