| id |
int(11)
|
|
|
|
| order_date |
date
|
|
|
|
| product_type |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| item_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| required_date |
date
|
|
|
|
| product_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| brand |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| size |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| remark |
text
|
utf8mb4_unicode_ci
|
|
|
| quantity |
decimal(10,2)
|
|
|
|
| unit |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| price_before_vat |
decimal(10,2)
|
|
|
|
| price_with_vat |
decimal(10,2)
|
|
|
|
| total_amount |
decimal(10,2)
|
|
|
|
| pr_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| foreman |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| job_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| job_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| vendor |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| phone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| po_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| ordered_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| order_date_time |
date
|
|
|
|
| expected_date |
date
|
|
|
|
| received_date |
date
|
|
|
|
| received_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| invoice_no |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
