Do I need to write a trigger for such a simple constraint?
- by Paul Hanbury
I really had a hard time knowing what words to put into the title of my question, as I am not especially sure if there is a database pattern related to my problem. I will try to simplify matters as much as possible to get directly to the heart of the issue.
Suppose I have some tables.
The first one is a list of widget types:
create table…