1 (edited by timlitw 2014-10-02 02:54:10)

Topic: help with database design for car parts list

I want to make a database to keep track of used car parts for a body shop that doesn't have an inventory system.  So basicaly it will be a used parts inventory system.

here is the information I need to store
year, make,model, sub model info, name of part, condition of part
for example:
"2007", "Chevrolet", "Traverse", "ST", "front left fender", "small dent behind wheel the rest in very good condition", "paint color black metallic"

I am thinking I want to sort of duplicate the linked list example to start with, does this make sense? Would I make the year part of the linked list?
So I could have table for year, make, model, maybe for submodel - but this could be blank on many models, and part
I think partname, condition and color would be the fields in the part table.

does this make sense or am I not thinking about this correctly.