Solution: Specify Values in Data
Let's solve the antipattern 31 Flavors by specifying values in the data.
There’s a better solution to restrict values in a column: creating a lookup table with one row for each value that we allow in the Bugs.status
column and then declaring a foreign key constraint on Bugs.status
to reference the new table.
Get hands-on with 1400+ tech skills courses.