| id |
int(11)
|
|
|
|
| order_id |
int(11)
|
|
|
|
| product_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| quantity |
decimal(12,3)
|
|
|
|
| unit |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| note |
text
|
utf8mb4_unicode_ci
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| product_code |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| material_id |
int(11)
|
|
|
|
| material_description |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| detected_category |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| length_mm |
decimal(12,2)
|
|
|
|
| width_mm |
decimal(12,2)
|
|
|
|
| height_mm |
decimal(12,2)
|
|
|
|
| line_value |
decimal(14,4)
|
|
|
|
| is_unknown_material |
tinyint(1)
|
|
|
|
| qty |
decimal(12,3)
|
|
|
|
| weight_value |
decimal(12,3)
|
|
|
|
| size_text |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| product_image_path |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| product_color |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|