Table designing and linking
Dear gurus
i want to design a table name rings which has the field as
under
id --> primray key
name --> ring name
Description --> all detailed about ring
the rings will be defferent sizes thats y i make another
table of named rings_sizez which has fields
item_id --> it will come from ring table
size_id --> primary key auto
description --> size description such as 5.5,6.5 etc
qty
price
karat etc etc
the question is that is it right soloution or not and
if some one tell me other bettet approch to do so please
tell me
thanks
|