|
id
|
int(11)
|
|
|
|
|
update_date
|
date
|
|
|
|
|
category
|
varchar(100)
|
|
|
|
|
product_name
|
varchar(255)
|
|
|
|
|
required_date
|
date
|
|
|
|
|
product_code
|
varchar(100)
|
|
|
|
|
brand
|
varchar(100)
|
|
|
|
|
size
|
varchar(50)
|
|
|
|
|
note
|
text
|
|
|
|
|
quantity
|
decimal(10,2)
|
|
|
|
|
unit
|
varchar(50)
|
|
|
|
|
price_before_vat
|
decimal(15,5)
|
|
|
0.00000
|
|
price_with_vat
|
decimal(15,5)
|
|
|
0.00000
|
|
total_amount
|
decimal(15,5)
|
|
|
0.00000
|
|
pr_number
|
varchar(100)
|
|
|
|
|
foreman
|
varchar(100)
|
|
|
|
|
job
|
varchar(255)
|
|
|
|
|
remarks
|
text
|
|
|
|
|
vendor
|
varchar(255)
|
|
|
|
|
phone_number
|
varchar(20)
|
|
|
|
|
po
|
varchar(100)
|
|
|
|
|
order_person
|
varchar(100)
|
|
|
|
|
order_date
|
date
|
|
|
|
|
delivery_date
|
date
|
|
|
|
|
received_date
|
date
|
|
|
|
|
receiver
|
varchar(100)
|
|
|
|
|
invoice_bill
|
varchar(255)
|
|
|
|
|
image
|
varchar(255)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|