|
id
|
int(11)
|
|
|
|
|
pr_code
|
varchar(20)
|
|
|
|
|
department_id
|
int(11)
|
|
|
|
|
currency
|
varchar(10)
|
|
|
VND
|
|
total_amount
|
decimal(15,2)
|
|
|
0.00
|
|
serial_number
|
varchar(255)
|
|
|
|
|
expected_date
|
date
|
|
|
|
|
workflow_status
|
varchar(30)
|
|
|
DRAFT
|
|
requester_id
|
int(11)
|
|
|
|
|
custom_requester_name
|
varchar(255)
|
|
|
|
|
approver_id
|
int(11)
|
|
|
|
|
financial_approver_id
|
int(11)
|
|
|
|
|
buyer_id
|
int(11)
|
|
|
|
|
po_number
|
varchar(50)
|
|
|
|
|
warehouse_keeper_id
|
int(11)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
status
|
tinyint(4)
|
|
|
1
|
|
deleted_at
|
timestamp
|
|
|
|
|
machine_info
|
longtext
|
|
|
|
|
is_urgent
|
tinyint(4)
|
|
|
0
|
|
urgent_reason
|
text
|
|
|
|
|
tag_note
|
varchar(255)
|
|
|
|
|
tag_color
|
varchar(20)
|
|
|
warning
|