I'm creating a new table and I would like to do it right. The table will be a list of members with their Professional Type and Decile associated.
The Professional Type is a 3-character string. There are only 8 allowable strings for this field. Should I use ENUM or CHAR(3) or something better?
The Decile can be any number between 1-10, but only these numbers. Should I use ENUM or unsigned TINYINT or something better?
Which are the best options for efficiency?