Any better way to rewrite the following "create table"?
Even on MySQL, you don't need to specify DEFAULT null. That's always the default, well usually always because MySQL is a special monster.


Use PostgreSQL.
UID should be a number, not varchar.
Class_A is pretty silly, even in an enum. If your classes are all one letter, just make them a char(1) or the like and just add "type" to the column name.
Class_A_Speed sounds like a function over a real speed, rather than a category. Just add the function to the database, class_from_speed(speed)


Like this,

CREATE TABLE employee (
  employee_id   int       GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
  name          text,
  class_type    "char",   -- or char(1)
  speed         int
);