Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kevinpasnik
Starting Member
6 Posts |
 Posted - 2004-07-27 : 17:18:08
|
| I'm building a new e-commerce website for an apparel client. Their products need to be SKU or UPC code specific in order to accommodate color and size attributes.Could anybody recommend an apparel SKU database design or a resource for an apparel SKU database design? I have a good idea what I would like to do but I'm sure there are proven standards and conventions for this type of project.Thank you advance for your advice. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-28 : 08:41:15
|
| Your design is going to depend on the needs of your business. If you have one major vendor for example, you might be able to get by with just putting the SKU, color, size in one table (this would be REALLY rare). If not, you might need to define available colors, sizes, and SKU's by vendor and do matrix tables that join them all together. Why don't you show us what you had in mind, and we'll shoot at it. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Database Design - Apparel Color/Size/SKU