|
id
|
int(11)
|
|
|
|
|
so_no
|
varchar(20)
|
|
|
|
|
item_sn
|
varchar(50)
|
|
|
|
|
line_no
|
int(11)
|
|
|
|
|
item_id
|
varchar(50)
|
|
|
|
|
item_name
|
varchar(200)
|
|
|
|
|
item_material
|
varchar(100)
|
|
|
|
|
item_drawing
|
varchar(100)
|
|
|
|
|
item_spec
|
varchar(200)
|
|
|
|
|
surface
|
varchar(200)
|
|
|
|
|
quantity
|
decimal(12,2)
|
|
|
0.00
|
|
unit
|
varchar(10)
|
|
|
个
|
|
unit_price
|
decimal(12,4)
|
|
|
0.0000
|
|
amount
|
decimal(12,2)
|
|
|
0.00
|
|
delivery_date
|
date
|
|
|
|
|
remark
|
text
|
|
|
|
|
is_active
|
tinyint(4)
|
|
|
1
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|