open-ecommerce-api/store-engine

Design and implement a database schema to store product information.

Opened this issue · 2 comments

zamaniamin commented

store product information, including:

  • product_type
  • name
  • slug
  • description
  • is_published
  • created_at
  • updated_at
  • Variants
  • media
  • sku
  • price
  • stock
parsariyahi commented

instead of product_type isn't better to have something like category ?

and a relation to this table. some thing like this:

categories

  • phone
  • tv
  • laptop

product

  • (phone name , (category -> categories[phone]))
zamaniamin commented

instead of product_type isn't better to have something like category ?

and a relation to this table. some thing like this:

categories

* phone

* tv

* laptop

product

* (phone name , (category -> categories[phone]))

product_type and category, they have different meanings and uses.
We will use both of them.I just forgot to add the category to the list. thanks.

  • 👍1