Products (Product Details)
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 | 1 year ago |
| product_name | Name of the product | varchar(100) | NO | External name of the product, for instance "iPhone 11" | 1 year ago | |
| category | Ecommetce category | varchar(50) | NO | Like electronics, clothing, etc. | 1 year ago | |
| description | Long description | text | YES | Just text, without HTML or other markup. | 1 year ago | |
| unit_price | Original price | decimal(10,2) | NO | Reseller price | 1 year ago | |
| stock_quantity | How many are in stock | int(11) | NO | 1 year ago |