摘要 |
PROBLEM TO BE SOLVED: To provide a time limit data history management system which is excellent in versatility.SOLUTION: A first history management system 10 for time limit data includes a DB server 16 for storing time limit data, and a sale price history management unit 22. The DB server 16 includes: a sale price basic table 34 provided with a sale price basic ID, a merchandise ID, and a sale price; a sale price application start table 36 provided with a sale price application start ID, a sale price basic ID, and an application start date; a sale price application end table 38 provided with a sale price application end ID, a sale price basic ID, and an application end date; a sale price application start cancellation table 40 provided with a sale price application start ID; and a sale price application end cancellation table 42 provided with a sale price application end cancellation ID. The sale price history management unit 22 issues SQL to the DB server 16 to request necessary processing in adding, erasing and referring to the time limit data. Erasure of specific sale price data is logically executed by registering a corresponding sale price application start ID and sale price application end ID in the sale price application start cancellation table 40 and the sale price application end cancellation table 42. |