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