Re: How to allow incremental versions of the data in a DB
> Each Survey will have a set of Process.
That sounds like a 1:many relationship. But your table structure feels like a many:many relationship. Which is it?
You show 3 tables, each with very few fields; are there other fields in those tables? If not, I would question the split of the tables. For example, having an extra table just for the "deleted" flag seems excessive.
Perhaps I could better understand things if you showed some sample data. It should exemplify the 1:many and many:many relationships. It should be obfuscated if necessary (to hide sensitive data).
Subject
Views
Written By
Posted
1823
June 22, 2012 10:11AM
878
June 29, 2012 11:58PM
888
July 02, 2012 10:08AM
921
July 03, 2012 12:41PM
856
July 06, 2012 10:40AM
Re: How to allow incremental versions of the data in a DB
1044
July 07, 2012 05:54AM
954
July 09, 2012 09:40AM
1062
July 07, 2012 09:02AM
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.