Re: Change tracking
| From: | Stephen | Date: | Fri, 31 Oct 2008 19:00:26 +0000 |
| Subject: | Re: Change tracking | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-282725@lists.php.net to get a copy of this message | ||
-- On Fri, 10/31/08, Mike Smith <mikeosmith@gmail.com> wrote:
> [INVENTORY_TABLE]
> fields example data
> part 1027P
> serial 543221-K
> qty 120
> location G-5
>
> I'd like to record what changed. Let's say they
> change the serial. One way
> would be a "static" changes table:
Another way is to never change a record, but to add new ones. You also need to add an effectivity
date field.
Stephen