From: | Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Storing properties in a logical way. |
Date: | 2004-09-05 17:51:44 |
Message-ID: | opsdu7wi2ecq72hf@musicbox |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> But after looking closely at the list of a possible properties, i found
> out that some of them depend on others. For example, if item is a
> PDF document, it can have an index. But a document can also have an
> index with links. Logically, a properties like 'index with links'
> don't belong to the verification table - they look like a kind of
> a composite field - 'index with links' is not a stand-alone property,
> but it also implies that an item also has an 'index' property.
> On the other hand, it is impossible to decouple 'index' from
> 'with links', because the second part won't have any meaning without
> the first part.
You mean your properties would be better organized as a tree ?
Or is it even more complicated than that ?
If it's a tree, look at the ways of storing a tree in a table.
From | Date | Subject | |
---|---|---|---|
Next Message | Troels Arvin | 2004-09-05 22:56:56 | INFORMATION_SCHEMA and foreign keys |
Previous Message | Erik Wasser | 2004-09-05 12:53:57 | Full access to a DB with a second user? |