0

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
2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by pritaeas
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.