I have a database design where each time an object (record) is changed I insert a new record with the new data and the previous one is left as is.
The primary key is a regular 64 bit ID (sequence) and in additional I have an object ID (UUID) which is the same in all the object's versions records.
All relations between objects are defined through the Object ID (UUID), that way if some property of an object is changed all relations are still valid.
I've tried to use filters in order to solve one2one and many2one relations between objects but they work only on many2many.
Does anybody has an idea on how this can be solved?
Thanks in advance,