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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
