I forgot one more option I considered: Even though every ingredient is stored in a different table, I could enforce unique PK across tables. Then I would not ne

I forgot one more option I considered: Even though every ingredient is stored in a different table, I could enforce unique PK across tables. Then I would not need to specify type in the ID. This would mean that I need to lookup every ID to know which tables it belongs in though.