Karl,
I have developed two automotive parts sites at
http://www.manhonda.com/store/honda/ and
http://www.manhonda.com/store/sports/ which use the schema of their print
catalog: accessory type--->accessory sub category ---> accessory then
product description and a table for make, model, year ...etc. It is not
exact and many times there is additional interaction required for the
customer to get the correct part from the company.
To be exact on the web would be very expansive because in many cases the
manufacture date, the accessories and the options installed in the car is
required to get the EXACT replacement part. Especially since a car made in
Jan may use a type-a widget and a car made in Nov uses a type-g widget
except when made with accessory B where it then needs a type-g2 widget
unless it was manufactured from the west coast plant...<smile> you get the
point.
There is no discernable standard that I have seen and it is a trade off of
functionality, end user knowledge, and design and maintenance costs.
Best Regards,
Dennis Powers
UXB Internet
(203) 879-2844
http://www.uxbinfo.com/
-----Original Message-----
From: Karl Simanonok [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 31, 2001 6:40 PM
To: CF-Talk
Subject: Auto Parts Database?
Can anyone on the list point me toward an existing auto parts database
schema? Because of the many vehicles they can fit on, different ways that
manufacturers refer to them, and the different ways individual parts can be
categorized it seems that a database to accommodate them all must be quite
complex, perhaps with different tables for different types of
parts. Rather than reinvent the wheel I'm hoping someone can help me out
here...
Regards,
Karl Simanonok
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
