By having "versioned attributes" do you mean the entire set of attributes is versioned as a group, or individually? Is it an object's state at a specific point in time that you want to version?
--a On 4/20/07, Michael Ruck <[EMAIL PROTECTED]> wrote:
Hello, I'm currently modelling and designing a new database according the following specifications. The general idea is the ability to store arbitrary objects, which have attributes of various kinds. The attributes themselves may be multivalued. The objects being stored need to be versioned, so that there's a way to go back to previous versions of an object. The objects represent metadata of media files and the data itself comes from various automated sources and manual editing by a user. My current idea was the following: - CREATE TABLE objects (id TEXT, version TEXT) - CREATE TABLE attributes (object_id TEXT, version TEXT, name TEXT, order INT, type INT, value TEXT) Is there anyone who has experience with this kind of design, do you have better ideas on modelling this kind of data? Thanks, Mike ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
