Laravel: ENUM or INT with Foreign Key?

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…

Laravel: ENUM or INT with Foreign Key?

Source

0
(0)

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.

Related articles:
– 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/

– – – – –
Try our Laravel QuickAdminPanel: https://bit.ly/quickadminpanel
Enroll in my Laravel courses: https://laraveldaily.teachable.com

0 / 5. 0