Re: Modeling subclasses with references

[Alex Aspiotis]

Without the table definitions I can't say I understand the situation completely.

I assume that U and V are reference tables storing details about properties of the objects stored in I and J. e.g "Status_CD" where 1 = active, 2 = deactivated, 3 = in repair etc.

Given above, you are asking for "if I delete a property that is in use, then I want all objects with that property to be deleted, and their respective superclass as applicable".

My opinion is that this may be a useful feature in some cases but it's not a wide spread need and won't be built out.

To me, that property sounds so important its actually part of the object itself and should be in table A.

Alternatively, you can write a trigger such that "on delete table I (or J), delete related records in table A"