Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9BE51475D01 for ; Tue, 3 Dec 2002 08:15:54 -0500 (EST) Received: from sv003.int.jongert.nl (jongert.nl [194.109.59.87]) by postgresql.org (Postfix) with ESMTP id BDE77475CC4 for ; Tue, 3 Dec 2002 08:15:53 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by sv003.int.jongert.nl (Postfix) with SMTP id AFAFE192; Tue, 3 Dec 2002 14:10:24 +0100 (CET) Received: from IT001 (IT001.int.jongert.nl [10.0.0.241]) by sv003.int.jongert.nl (Postfix) with SMTP id 47896150 for ; Tue, 3 Dec 2002 14:10:24 +0100 (CET) From: "Ries van Twisk" To: Subject: [OT] Inventory systems (private) Date: Tue, 3 Dec 2002 14:17:15 +0100 Message-ID: <000401c29ace$4c9d4170$f100000a@IT001> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 Importance: Normal X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/27 X-Sequence-Number: 10615 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