| id |
int(11)
|
|
|
|
| date |
date
|
|
|
|
| category |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| item_name |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| required_date |
date
|
|
|
|
| product_code |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| brand |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| size |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| note |
text
|
utf8mb4_unicode_ci
|
|
|
| quantity |
decimal(10,2)
|
|
|
|
| unit |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| price_before_vat |
decimal(12,2)
|
|
|
|
| price_with_vat |
decimal(12,2)
|
|
|
|
| total_price |
decimal(12,2)
|
|
|
|
| pr_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| foreman |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| job_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| job_name |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| vendor |
varchar(300)
|
utf8mb4_unicode_ci
|
|
|
| vendor_phone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| po_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| order_by |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| order_date |
date
|
|
|
|
| appointment_date |
date
|
|
|
|
| received_date |
date
|
|
|
|
| received_by |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| invoice_number |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| status |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| created_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| created_date |
datetime
|
|
|
|
| updated_at |
timestamp
|
|
|
|
