If you need a more complex FK that the database cannot provide, like the last example I gave, then you can use...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
a trigger to enforce your referential integrity. You can code a trigger to look in the MEDICAL or CHECKS field for referential integrity depending on the value in a column in the CHECKS table. You will have to code this yourself.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.