History
| history | DATA STRUCTURE |
|---|---|
| id | SERIAL |
| record_id | INTEGER |
| change_time | TIMESTAMP |
| old_quantity | REAL |
| new_quantity | REAL |
History is a table that automatically logs the change of a record's quantity, to use the 'sum' table.
| history | DATA STRUCTURE |
|---|---|
| id | SERIAL |
| record_id | INTEGER |
| change_time | TIMESTAMP |
| old_quantity | REAL |
| new_quantity | REAL |
History is a table that automatically logs the change of a record's quantity, to use the 'sum' table.