products


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
cart_items.product_id cart_items_ibfk_2 R
order_items.product_id order_items_ibfk_2 R
pos_order_items.product_id pos_order_items_ibfk_2 R
product_stock.product_id product_stock_ibfk_1 R
stock_movements.product_id stock_movements_ibfk_1 R
product_category_id INT 10 √ null
product_categories.id products_ibfk_1 R
name VARCHAR 100 √ null
description TEXT 65535 √ null
price DECIMAL 10,2 √ null
image VARCHAR 255 √ null
unit VARCHAR 20 √ null
barcode VARCHAR 100 √ null
is_active BIT 1 √ 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
product_category_id Performance Asc product_category_id

Relationships

Close relationships within degrees of separation