From: Ries van Twisk <ries@jongert.nl>
To: pgsql-sql@postgresql.org
Subject: [OT] Inventory systems (private)
Date: Tue, 3 Dec 2002 14:17:15 +0100
Message-ID: <000401c29ace$4c9d4170$f100000a@IT001> (raw)
Hi All,
is there any whitepaper, document or website that can point me to how to
setup a inventory system?
I'm particulary interested how other people solve the problem of a unknown
number of attributes to a inventory item.
example:
BAL <-- Inventory Item
- Color <- Attribute
- Diameter <- Attribute
- Weight <- Attribute
Car <-- Inventory Item
- Speed <- Attribute
- Size <- Attribute
- Weight <- Attribute
- Color <- Attribute
Computer <-- Inventory Item
- Brand <- Attribute
- Weight <- Attribute
- Windows/Linux <- Attribute
I can ofcource add any number of columns to a table but for a lot of items
there will be a lot of NULL values and currently I don't know how many
attrubutes one item can have (possible between 10 and 20). This can even
change in feature opon request.
Ries
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ries@jongert.nl
Subject: Re: [OT] Inventory systems (private)
In-Reply-To: <000401c29ace$4c9d4170$f100000a@IT001>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox