Universal Join Table?
Posted by: C L
Date: May 24, 2007 08:42AM

I’m considering dropping all my join tables in favor of one *universal* join table. My universal join table would include these columns: parent_table, parent_id, child_table, child_id. It would allow me to associate a row in any table to a row on any other table. In theory it would also allow me to associate one join in the universal join table with another join in the universal join table, thus allowing for representation of complex relationships.

Is this a common database technique? If so, does it have a name?
Is this technique recommended?

Options: ReplyQuote

Written By
Universal Join Table?
May 24, 2007 08:42AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.