Member Avatar for hwoarang69

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
  • 140 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

item should link to sub, and sub should link to main.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.