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