Another Design Question

[delfy]

i am doing a system that has history tables for most but not all tables in my database.

i have designed triggers that insert updates to my history tables in order to have an audit trasl.

Some genius here in my department has suggested that i also log inserts to my history table so every thing will be in one place and a full history can be obtained by just querying the history table since it will have the original record that was inserted. any thoughts on this?

 

[jbenson001]

It sounds reasonable. You can have a flag column that designates weather it is the original row or an updated row.

Jim