| id |
int(11)
|
|
|
|
| customer |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| shipment_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('active', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| etd_saa_plan |
date
|
|
|
|
| etd_saa_actual |
date
|
|
|
|
| loading_plan |
date
|
|
|
|
| loading_actual |
date
|
|
|
|
| etd_lcb_plan |
date
|
|
|
|
| etd_lcb_actual |
date
|
|
|
|
| eta_plan |
date
|
|
|
|
| eta_actual |
date
|
|
|
|
| doc1_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc1_due_date |
date
|
|
|
|
| doc1_actual_date |
date
|
|
|
|
| doc1_status |
tinyint(1)
|
|
|
|
| doc2_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc2_due_date |
date
|
|
|
|
| doc2_actual_date |
date
|
|
|
|
| doc2_status |
tinyint(1)
|
|
|
|
| doc2_case_pallet_qty |
int(10)
|
|
|
|
| doc2_container_40ft |
int(10)
|
|
|
|
| doc2_container_20ft |
int(10)
|
|
|
|
| doc3_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc3_due_date |
date
|
|
|
|
| doc3_actual_date |
date
|
|
|
|
| doc3_status |
tinyint(1)
|
|
|
|
| doc4_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc4_due_date |
date
|
|
|
|
| doc4_actual_date |
date
|
|
|
|
| doc4_status |
tinyint(1)
|
|
|
|
| doc5_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc5_due_date |
date
|
|
|
|
| doc5_actual_date |
date
|
|
|
|
| doc5_status |
tinyint(1)
|
|
|
|
| doc6_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc6_due_date |
date
|
|
|
|
| doc6_actual_date |
date
|
|
|
|
| doc6_status |
tinyint(1)
|
|
|
|
| doc7_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc7_due_date |
date
|
|
|
|
| doc7_actual_date |
date
|
|
|
|
| doc7_status |
tinyint(1)
|
|
|
|
| doc8_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc8_due_date |
date
|
|
|
|
| doc8_actual_date |
date
|
|
|
|
| doc8_status |
tinyint(1)
|
|
|
|
| doc9_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc9_due_date |
date
|
|
|
|
| doc9_actual_date |
date
|
|
|
|
| doc9_status |
tinyint(1)
|
|
|
|
| doc10_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc10_due_date |
date
|
|
|
|
| doc10_actual_date |
date
|
|
|
|
| doc10_status |
tinyint(1)
|
|
|
|
| doc11_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc11_due_date |
date
|
|
|
|
| doc11_actual_date |
date
|
|
|
|
| doc11_status |
tinyint(1)
|
|
|
|
| doc12_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc12_due_date |
date
|
|
|
|
| doc12_actual_date |
date
|
|
|
|
| doc12_status |
tinyint(1)
|
|
|
|
| doc13_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc13_due_date |
date
|
|
|
|
| doc13_actual_date |
date
|
|
|
|
| doc13_status |
tinyint(1)
|
|
|
|
| doc14_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc14_due_date |
date
|
|
|
|
| doc14_actual_date |
date
|
|
|
|
| doc14_status |
tinyint(1)
|
|
|
|
| doc15_response |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| doc15_due_date |
date
|
|
|
|
| doc15_actual_date |
date
|
|
|
|
| doc15_status |
tinyint(1)
|
|
|
|
| last_notified_date |
date
|
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| updated_at |
datetime
|
|
|
|
