Toad World® Forums

Mandatory Child


#1

When I go to a relationship and check “mandatory child”, I don’t see any difference in the generated script compared to when it is not checked.

How does this get enforced?
How would one enforce it anyway when not using the modeler?

The conceptual rule would make a difference on whether I do an outter join when querying the parent and child tables together. But I don’t see how to enforce the rule when inserting.


#2

Hi,

this is only logical information. It is similar to cardinality settings. When you set cardinality 1:5, triggers will not be generated automatically. How to enforce it? This is on you :slight_smile: It might be solved on app layer…

Regards,

Vaclav