windowsxp — 2013-02-06T06:18:11-05:00 — #1
I have an web application. User wants to do the following task every year in the web interface.
(i) save / submit data any number of times for multiple records in a given year in the UI.
(ii) approve all records once in a year in the UI..... once approved records user can not modify.
Should I make two tables ? one for save/submit for multiple records entered by user and other for approve user ?
Should I make one table ? save/submit/approve for multiple records all in one table ?
how do I design my table to do this ?
r937 — 2013-02-06T07:55:18-05:00 — #2
i would use two tables, where the "approved" table has one row, one column
rajeev13 — 2013-02-11T02:13:10-05:00 — #3
i like to use a column in "approved" with 0 or 1 in the first table.it be easier to query about.