ENUM vs Check Constraint vs Lookup Table: Which Is Better? 

📝 Bonus PDF: This ERD, descriptions of each table and column with sample data, and SQL scripts to create all of the tables on your own database: www.databasestar.com/dbdesign...
🎓 Learn how to design an effective database and create it using SQL: databasestar.mykajabi.com/edd...
There are a few ways you can restrict the values in a particular column.
In this video, I'll demonstrate the different ways you can do this, the advantages of each, and which method I recommend.
You'll learn about the ENUM concept in SQL, using a check constraint, and using a lookup table.
⏱ TIMESTAMPS:
00:00 - Our scenario
00:54 - Option 1: ENUM
02:43 - Option 2: Check Constraint
04:55 - Option 3: Lookup Table
🔗 VIDEO LINKS:
Scripts from this video: github.com/bbrumm/databasesta...

Наука