If you have a field with a few value options, is it worth using ENUM, or is it better to have a “lookup table” with a foreign key? In fact, there’s also a third option. Let’s review them all in this video.
– 8 Reasons Why MySQL’s ENUM Data Type Is Evil: http://komlenic.com/244
– Enum Fields VS Varchar VS Int + Joined table: What is Faster? https://www.percona.com/blog/2008/01/24/enum-fields-vs-varchar-vs-int-joined-table-what-is-faster/