I am making a site that will display items for sale but not sure how to layout my
DB.Should I make a table with the name of each item group
(e.g. Spring,coils.ect..) and then make a table with the name of the different
types of the item and the last table containing the items information.
Not sure if I'm explaining this right, for that I am sorry I am very tired.
So here is what I was thinking
Table
[item_groups]
group_id PK
group_name
Table
[sub_groups]
sub_id PK
group_id FK
sub_names
Table
[items]
item_id PK
sub_id FK
group_id FK
item_name
item_weight
item_price
ect...
would this be the right line of thinking, thanks for any help you guys might have.
Steve