Subject
[PERFORM] database model tshirt
sizes
03/18/06 07:03 AM
PROTECTED]
Sent: Sunday, March 19, 2006 2:59 PM
Subject: Re: [PERFORM] database model tshirt sizes
We have size and color in the product table itself. It is really an
attribute of the product. If you update the availability of the product
often, I would split out the quantity into a separate table
@postgresql.org;
[EMAIL PROTECTED]
Sent: Sunday, March 19, 2006 3:37 PM
Subject: Re: [PERFORM] database model tshirt sizes
another approach would be:
table product:
productid int8 PK
productname charvar(255)
table versions
productid int8 FK
versionid int8 PK
size
color
...
quantity int4
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)