Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

table design issue

user575089Feb 6 2013 — edited Feb 7 2013
I have an web application. User wants to do the following task every year in the web interface.

(a) save / submit data any number of times for multiple records in a given year in the UI.
(b) approve all records once in a year in the UI..... once approved.... records can not modified by user....will become read only in the UI.


my problem:

Should I make two tables ? one for save/submit for multiple records entered by user and other for approve by user ?

OR

Should I make one table ? save/submit/approve for multiple records all in one table ?

OR

how do I design my table to do this ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2013
Added on Feb 6 2013
13 comments
141 views