I am attempting to reverse engineer a Database that is in Oracle. I have been able to find the main keys and the referential integrity rules that correspond to the Foreign Keys but cannot locate where the modality/cardinality rules are stored.
Any help regarding to which table to look in or a sample query would be greatly appreciated.
I think you will have to check for referring columns being
nullable
:and for unique indices on referring columns: