database model tshirt sizes

From: "NbForYou" <nbforyou(at)hotmail(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: database model tshirt sizes
Date: 2006-03-18 15:03:59
Message-ID: BAY107-DAV1733CA91BFC0258E76EC46DBE50@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

Does anybody know how to build a database model to include sizes for rings, tshirts, etc?

the current database is built like:

table product
=========

productid int8 PK
productname charvar(255)
quantity int4

what i want now is that WHEN (not all products have multiple sizes) there are multiple sizes available. The sizes are stored into the database. I was wondering to include a extra table:

table sizes:
========
productid int8 FK
size varchar(100)

but then i have a quantity problem. Because now not all size quantities can be stored into this table, because it allready exist in my product table.

How do professionals do it? How do they make their model to include sizes if any available?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew T. O'Connor 2006-03-18 15:54:14 Re: n00b autovacuum question
Previous Message Bruno Wolff III 2006-03-18 15:00:19 Re: Help optimizing a slow index scan