| id |
int(11)
|
|
|
|
| so_no |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| item_sn |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| line_no |
int(11)
|
|
|
|
| item_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| item_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| item_material |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| item_drawing |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| item_spec |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| surface |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| quantity |
decimal(12,2)
|
|
|
|
| unit |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| unit_price |
decimal(12,4)
|
|
|
|
| amount |
decimal(12,2)
|
|
|
|
| delivery_date |
date
|
|
|
|
| remark |
text
|
utf8mb4_unicode_ci
|
|
|
| is_active |
tinyint(4)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
