Description

This table stores information about the products available in the warehouse.

Columns

Name Title Datatype Nullable Other Description Last edit
product_id Internal id of a product int(11) NO auto_increment Range 1-1000000 produced in US, Starting from 1000000 - produced abroad, 1-2M China, 2M+ India 10 months ago
product_name Name of the product varchar(100) NO External name of the product, for instance "iPhone 11" 10 months ago
category Ecommetce category varchar(50) NO Like electronics, clothing, etc. 10 months ago
description Long description text YES Just text, without HTML or other markup. 10 months ago
unit_price Original price decimal(10,2) NO Reseller price 10 months ago
stock_quantity How many are in stock int(11) NO 10 months ago