|
id
|
int(11)
|
|
|
|
|
city_id
|
int(11)
|
|
|
 浏览不相关的值
|
|
item_type
|
enum
|
-- |
|
|
|
item_id
|
int(11)
|
|
|
|
|
item_name
|
varchar(300)
|
|
|
|
|
quantity
|
decimal(10,2)
|
|
|
1.00
|
|
unit
|
varchar(50)
|
|
|
قطعة
|
|
location_in_city
|
varchar(200)
|
|
|
|
|
assigned_date
|
date
|
|
|
|
|
assigned_by
|
int(11)
|
|
|
|
|
status
|
enum
|
-- |
|
active
|
|
notes
|
text
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
