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.