Re: staff table-howo to connect with bookings and bus. users table

[Dimitris Papageorgiou]

I want to make some comments.
First,I found this very interesting article(http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/) which says why in some case ENUM col type is not the best option.

Since I am going to add other types in the future the article suggests a table structure like this(this how it would be in my case):

2 columns(bus_user_ID,typeID),the first will be a foreign key and the second VARCHAR-NOT ENUM as it is now the case.The col VARCHAR will describe the type of the business user
What do you think?

And one last question.
Why ENUM is not the best option if more values are going to be added later?