You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
creating table for every children of resource to save parent-child relationship (parent key, child key) and updating table accordingly for create/delete of resource/child.
The text was updated successfully, but these errors were encountered:
(A) RDBMS semantics don't allow let one column have a relationship with multiple tables.
(B) "many" side resources should have reference to "one" side resource in "one" to "many" relationship.
( we should prevent let a column has multiple values )
so I believe joining with multiple child tables are the only way to do this right.
creating table for every children of resource to save parent-child relationship (parent key, child key) and updating table accordingly for create/delete of resource/child.
The text was updated successfully, but these errors were encountered: