Is it possible to manually create a list in a column e.g. A, B, C, D
then in a different table reference that list and be able to choose A or B or C or D via an ENUM?
Since you can’t make the column of list type unless it’s a virtual column.
Don’t really want to have to create a table with one column for each possible variation.
When I’ve tried to do this the ENUM just give me one option - “A, B, C, D”