Products 테이블 구조 확인
| Field | Type | Null | Key | Default |
|---|
| id | int | NO | PRI | NULL |
| name | varchar(255) | NO | MUL | NULL |
| sku | varchar(100) | NO | UNI | NULL |
| barcode | varchar(255) | YES | MUL | NULL |
| description | text | YES | | NULL |
| image_path | varchar(255) | YES | | NULL |
| supplier_id | int | YES | MUL | NULL |
| category_id | int | YES | MUL | NULL |
| brand_id | int | YES | MUL | NULL |
| unit_price | decimal(10,2) | YES | | 0.00 |
| cost_price | decimal(10,2) | NO | | 0.00 |
| safety_stock | int | NO | | 5 |
| replenish_unit | int | YES | | 1 |
| last_ordered_at | datetime | YES | | NULL |
| replenishment_unit | int | NO | | 1 |
| has_expiration_date | tinyint(1) | NO | | 0 |
| shelf_life_years | int | YES | | 0 |
| shelf_life_months | int | YES | | 0 |
| shelf_life_days | int | YES | | 0 |
| created_at | timestamp | YES | | CURRENT_TIMESTAMP |
| created_by | int | YES | MUL | NULL |
| updated_at | timestamp | YES | | CURRENT_TIMESTAMP |
| updated_by | int | YES | MUL | NULL |
| quantity | int | NO | | 0 |
| handling_status | varchar(20) | NO | | not-handling |
| units_per_case | int | NO | | 1 |
| order_status | enum('none','ordered') | YES | | none |