Design and implement a database schema to store product information.

open-ecommerce-api / store-engine

An ecommerce backend-API created using Django and DRF (Django Rest Framework).

GNU General Public License v3.0

13 stars 10 forks source link

Design and implement a database schema to store product information. #71

Open zamaniamin opened 1 year ago

zamaniamin commented 1 year ago

store product information, including:

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

parsariyahi commented 1 year ago

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

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

product

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

zamaniamin commented 1 year ago

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.