hi,
can we have a enum datatype for a column in a table?
i need to store the position of an employee in the 'employee' table. there'll be just 5 positions available such as 'cashier, storage, admin, owner, etc..'.
for some reason i couldn't create another table to hold the position information and have a foreign key in the 'employee' table to that position table.
i thought i could use an enum data type. i want to hear from you guys, what datatype will suit this requirement. any comment and recommendation will be appreciated.
Thank you.
|