| id |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| job_no |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| document_no |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| customer |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| site |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| platform |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| customer_po |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| equipment |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| manufacturer |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| model |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| serial_no |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| tag_no |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| dispatch_date |
date
|
|
|
|
| component_dispatch_photo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| special_requirements |
text
|
utf8mb4_general_ci
|
|
|
| issued_by |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| issued_by_mobile |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| issued_by_date |
date
|
|
|
|
| issued_by_signature |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| approved_by |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| approved_by_mobile |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| approved_by_date |
date
|
|
|
|
| approved_by_signature |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| stamp |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| client_signatory_signature |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| revision_no |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| work_summary |
text
|
utf8mb4_general_ci
|
|
|
| work_items |
longtext
|
utf8mb4_bin
|
|
|
| spare_items |
longtext
|
utf8mb4_bin
|
|
|
| dimensional_readings |
longtext
|
utf8mb4_bin
|
|
|
| float_lift_readings |
longtext
|
utf8mb4_bin
|
|
|
| shaft_runout_readings |
longtext
|
utf8mb4_bin
|
|
|
| photographs |
longtext
|
utf8mb4_bin
|
|
|
| balancing_technician |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| balancing_approved_by |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| balancing_certificate_image |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| balancing_stamp_image |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| pressure_test_report_image |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| status |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| inspected_by |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| checked_approved_by |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| pump_dispatch_checklist |
text
|
utf8mb4_general_ci
|
|
|
| checked_by_signature |
text
|
utf8mb4_general_ci
|
|
|
| checked_by_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| checked_by_date |
date
|
|
|
|
| reviewed_by_signature |
text
|
utf8mb4_general_ci
|
|
|
| reviewed_by_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| reviewed_by_date |
date
|
|
|
|
| shaft_fits |
longtext
|
utf8mb4_bin
|
|
|