TABLE: products
id | int unsigned | NOT_NULL
sku | varchar(50) | NOT_NULL
name | varchar(200) | NOT_NULL
category_id | int unsigned | NULL
product_type | enum('Barang','Jasa','Paket') | NOT_NULL
unit | varchar(20) | NULL
description | text | NULL
image_url | varchar(255) | NULL
base_buy_price | decimal(15,2) | NULL
base_sell_price | decimal(15,2) | NOT_NULL
stock_current | decimal(10,2) | NULL
min_stock_alert | decimal(10,2) | NULL
is_active | tinyint(1) | NULL
created_at | timestamp | NOT_NULL
updated_at | timestamp | NOT_NULL

TABLE: categories
id | int unsigned | NOT_NULL
name | varchar(100) | NOT_NULL
description | text | NULL
icon | varchar(50) | NULL
is_active | tinyint(1) | NULL
created_at | timestamp | NOT_NULL
updated_at | timestamp | NOT_NULL