Tag Info

New answers tagged

2

The standard way is to use a History Table pattern. If you have a table like this: create table foo ( int foo_id primary key, name varchar(x) not null ); You would have a corresponding table create table foo_history ( int foo_id, int version, name varchar(x), inserted_at timestamp not null default current_timestamp, operation_code char(1) ...



Top 50 recent answers are included