| id |
int(11)
|
|
|
|
| item_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| category_id |
int(11)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| description |
text
|
utf8mb4_unicode_ci
|
|
|
| unit |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| current_stock |
decimal(12,2)
|
|
|
|
| min_stock_alert |
decimal(12,2)
|
|
|
|
| reorder_point |
decimal(12,2)
|
|
|
|
| reorder_quantity |
decimal(12,2)
|
|
|
|
| avg_daily_consumption |
decimal(10,4)
|
|
|
|
| last_reorder_date |
date
|
|
|
|
| warehouse_id |
int(11)
|
|
|
 浏览不相关的值
|
| supplier_id |
int(11)
|
|
|
浏览不相关的值
|
| image |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| account_code |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| housing_city_id |
int(11)
|
|
|
|
