Table NameNameData TypePrimary KeyUniqueRequiredAutoincrementCharsetCollationComment
employeesemployeeNumberint(11)
employeeslastNamevarchar(50)latin1latin1_swedish_ci
employeesfirstNamevarchar(50)latin1latin1_swedish_ci
employeesextensionvarchar(10)latin1latin1_swedish_ci
employeesemailvarchar(100)latin1latin1_swedish_ci
employeesofficeCodevarchar(10)latin1latin1_swedish_ci
employeesreportsToint(11)
employeesjobTitlevarchar(50)latin1latin1_swedish_ci