rufuspollock-okfn / opd-product-browser-web

A repository of code, documentation and database scripts for the Open Product Data project.
http://www.product-open-data.com/
64 stars 15 forks source link

Adapt database to a collaborative work #5

Open PhilippePlagnol opened 10 years ago

PhilippePlagnol commented 10 years ago

The table containing products (gtin table) doesn't contain any fields to say who add this line, when, who modify, why etc,... but it's required when you work as a team

What do you recommend ?

rufuspollock commented 10 years ago

I would suggest an audit log approach rather than writing this into the primary table. That is you create a separate table where you log changes that get made.