11 Nov
View Constraints
You have a table with all your company’s financial transactions. There is another table which references a subset of these financial transactions (ie. transactions with certain properties).
Your current solution to maintain the integrity is to set up a foreign key, referencing the transactions table, and then write a trigger to make sure that any records reference only transactions that have