create table all_properties ( id int primary key; // Same across all different versions! vers int primary key; current boolean; created_by char(40); created_on date; property_name, property_value, etc.... ) create view current_properties as select * from all_properties where current=boolean;