so i want to create a database which will have information about item. so first user will have to choice main_catgory, than sub_catgory, than item info. so for ex:
------------
main_catgory
------------
apparel
home decor
beauty
-----------
sub_catgory
------------
male
female
furniture
accessories
bath and body
hair care
-----------------
item
-----------------
image_full_name
image_short_name
our_price
description
features
iam thinking of making 3 different tables.
table 1
table name: item:
row 1 name: id
row 2 name: image_full_name
row 3 name: image_short_name
row 4 name: price
row 5 name: description
row 6 name: features
table 2
table name: main_catgory:
row 1 name: id
row 2 name: catgory
table 3
table name: sub_catgory:
row 1 name: id
row 2 name: catgory
let me know if i should add more rows
