| From: | "Ries van Twisk" <ries(at)jongert(dot)nl> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | [OT] Inventory systems (private) |
| Date: | 2002-12-03 13:17:15 |
| Message-ID: | 000401c29ace$4c9d4170$f100000a@IT001 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Troy | 2002-12-03 14:46:46 | Re: [OT] Inventory systems (private) |
| Previous Message | Achilleus Mantzios | 2002-12-03 13:05:23 | Re: SQL QUERY |