--
-- Host: 127.0.0.1    Database: insb_mis
-- ------------------------------------------------------


--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `entity_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entity_id` bigint unsigned DEFAULT NULL,
  `changes` json DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_log_entity_type_entity_id_index` (`entity_type`,`entity_id`),
  KEY `activity_log_user_id_foreign` (`user_id`),
  CONSTRAINT `activity_log_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_logs`
--

INSERT INTO `activity_logs` VALUES (1,1,'Surveyor',1,'{\"action\": \"updated\", \"changes\": {\"survey_types\": {\"new\": {\"39\": \"A\", \"40\": \"A\", \"41\": \"A\"}, \"old\": []}}, \"surveyor_id\": 1, \"surveyor_name\": \"Sarah Surveyor (Coordinator)\"}','127.0.0.1','2026-04-30 11:02:39','2026-04-30 11:02:39'),(2,1,'Assignment',1,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"APPR-0001\\\",\\\"assignment_id\\\":1,\\\"assigned_to\\\":\\\"Sarah Surveyor (Coordinator)\\\",\\\"current_step\\\":1,\\\"status\\\":\\\"active\\\"}\"','127.0.0.1','2026-04-30 11:03:00','2026-04-30 11:03:00'),(3,1,'Instruction',1,'{\"step\": 1, \"action\": \"created\", \"case_id\": \"APPR-0001\", \"completed\": true, \"current_step\": 2, \"assignment_id\": 1, \"changed_fields\": {\"assigned_by\": {\"to\": \"Nikos Voutsi\", \"from\": null}, \"instructions\": {\"to\": \"EDFEFD\", \"from\": null}, \"assigned_date\": {\"to\": \"2026-04-30\", \"from\": null}, \"lead_surveyor\": {\"to\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"from\": null}, \"flag_notifications\": {\"to\": {\"details\": \"DFAEDFA\"}, \"from\": null}, \"instruction_number\": {\"to\": \"APPR-0001-2026-04-30\", \"from\": null}, \"secondary_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"technical_committe_ref\": {\"to\": \"REF-123\", \"from\": null}, \"technical_instructions\": {\"to\": {\"39\": {\"notes\": \"\\\"[\\\\\\\"1. The vessel must comply with MSC.1\\\\\\\\/Circ.1571 amendments effective 01\\\\\\\\/01\\\\\\\\/2024 regarding fire safety systems.\\\\\\\",\\\\\\\"2. EPIRB battery replacement due if manufacturing date exceeds 5 years.\\\\\\\",\\\\\\\"3. Immersion suits required for all crew \\\\\\\\u2014 verify condition and quantity.\\\\\\\",\\\\\\\"4. Ensure SOLAS Training Manual is updated and available onboard.\\\\\\\"]\\\"\", \"reports\": \"\\\"[\\\\\\\"1215225-SE \\\\\\\\/ 01-2025 \\\\\\\\u2014 Safety Equipment Survey Report\\\\\\\",\\\\\\\"1215225-FF \\\\\\\\/ 01-2025 \\\\\\\\u2014 Fire Fighting Equipment Report\\\\\\\",\\\\\\\"1215225-LSA \\\\\\\\/ 01-2025 \\\\\\\\u2014 Life-Saving Appliances Report\\\\\\\"]\\\"\", \"guidance\": \"\\\"[\\\\\\\"Renewal Safety Equipment survey according to SOLAS Chapter III, Regulation 20. Verify all life-saving appliances, fire-fighting equipment, and navigation systems are in compliance with current INSB Class regulations and applicable IMO amendments. Special attention to: (a) Lifeboat launching arrangements and release mechanisms, (b) Life-raft hydrostatic release units \\\\\\\\u2014 verify service dates, (c) Fire detection systems in accommodation and machinery spaces, (d) Emergency lighting and marking of escape routes, (e) Pyrotechnics \\\\\\\\u2014 verify expiry dates.\\\\\\\"]\\\"\", \"references\": \"\\\"[\\\\\\\"SOLAS Chapter III, Regulation 20\\\\\\\",\\\\\\\"MSC.1\\\\\\\\/Circ.1571\\\\\\\",\\\\\\\"INSB Class Rules Chapter 8, Section 3\\\\\\\"]\\\"\", \"survey_type\": \"Initial\", \"certificates\": \"\\\"[\\\\\\\"Safety Equipment Certificate \\\\\\\\u2014 Full Term (5 years)\\\\\\\",\\\\\\\"Exemption Certificate (if applicable)\\\\\\\"]\\\"\", \"survey_type_id\": 39, \"supporting_docs\": null, \"assigned_surveyor\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"additional_remarks\": \"If vessel carries dangerous goods, verify Document of Compliance for carriage of dangerous goods is valid.\"}}, \"from\": null}, \"technical_committe_date\": {\"to\": \"2026-04-30\", \"from\": null}, \"classification_committe_ref\": {\"to\": \"REF-123\", \"from\": null}, \"classification_committe_date\": {\"to\": \"2026-04-30\", \"from\": null}, \"classification_committe_reference_date\": {\"to\": \"2026-04-30\", \"from\": null}, \"classification_committe_incoming_reference\": {\"to\": \"DFSD\", \"from\": null}}, \"instruction_id\": 1, \"history_version\": 1}','127.0.0.1','2026-04-30 11:03:42','2026-04-30 11:03:42'),(4,1,'Assignment Step 2',1,'{\"step\": 2, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 3, \"assignment_id\": 1, \"changed_fields\": {\"notes\": {\"to\": \"φδσδ\", \"from\": null}, \"sr_form_received_in_order\": {\"to\": true, \"from\": false}, \"certificates_received_in_order\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-04-30 12:35:04','2026-04-30 12:35:04'),(5,1,'Assignment Step 3',4,'{\"step\": 3, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 4, \"assignment_id\": 1, \"changed_fields\": {\"survey_reports_received_completed\": {\"to\": true, \"from\": false}, \"supporting_documentation_received_in_order\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-04-30 12:35:45','2026-04-30 12:35:45'),(6,1,'Assignment Step 4',3,'{\"step\": 4, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 5, \"assignment_id\": 1, \"changed_fields\": {\"observations.0\": {\"to\": {\"id\": 3, \"kind\": null, \"type\": \"memo\", \"status\": \"open\", \"due_date\": null, \"posed_date\": \"2026-05-30\", \"description\": \"ασδα\"}, \"from\": null}, \"observations.1\": {\"to\": {\"id\": 2, \"kind\": null, \"type\": \"memorandum\", \"status\": \"open\", \"due_date\": null, \"posed_date\": \"2026-06-13\", \"description\": \"δσασδ\"}, \"from\": null}, \"observations.2\": {\"to\": {\"id\": 1, \"kind\": \"class\", \"type\": \"recommendation\", \"status\": \"open\", \"due_date\": \"2026-05-29\", \"posed_date\": \"2026-05-29\", \"description\": \"φδασφ\"}, \"from\": null}, \"evaluation_report_accepted\": {\"to\": true, \"from\": false}, \"technical_evaluation_completed\": {\"to\": true, \"from\": false}, \"reports_received_as_per_instructions\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-04-30 12:52:53','2026-04-30 12:52:53'),(7,1,'Assignment Step 5',2,'{\"step\": 5, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 6, \"assignment_id\": 1, \"changed_fields\": {\"notes\": {\"to\": \"δσφσ\", \"from\": null}, \"eval_score\": {\"to\": \"4.0\", \"from\": null}, \"timeliness_score\": {\"to\": \"4.5\", \"from\": null}, \"surveyor_evaluated\": {\"to\": true, \"from\": false}, \"technical_accuracy_score\": {\"to\": \"4.0\", \"from\": null}, \"report_completeness_score\": {\"to\": \"4.0\", \"from\": null}, \"adherence_to_instructions_score\": {\"to\": \"3.5\", \"from\": null}}}','127.0.0.1','2026-04-30 12:58:57','2026-04-30 12:58:57'),(8,1,'Case',1,'\"{\\\"action\\\":\\\"updated\\\",\\\"case_id\\\":\\\"APPR-0001\\\",\\\"changes\\\":{\\\"department_id\\\":{\\\"old\\\":3,\\\"new\\\":2},\\\"created_at\\\":{\\\"old\\\":\\\"2026-03-10T11:43:07.000000Z\\\",\\\"new\\\":\\\"2026-03-10T11:43:07.000000Z\\\"},\\\"updated_at\\\":{\\\"old\\\":\\\"2026-03-10T11:43:10.000000Z\\\",\\\"new\\\":\\\"2026-05-05T09:59:00.000000Z\\\"}}}\"','127.0.0.1','2026-05-05 09:59:00','2026-05-05 09:59:00'),(9,1,'Case',3,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"SSCD-0003\\\"}\"','127.0.0.1','2026-05-05 10:04:30','2026-05-05 10:04:30'),(10,1,'Assignment',3,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"SSCD-0003\\\",\\\"assignment_id\\\":3,\\\"assigned_to\\\":\\\"Sarah Surveyor (Coordinator)\\\",\\\"current_step\\\":1,\\\"status\\\":\\\"active\\\"}\"','127.0.0.1','2026-05-05 10:05:40','2026-05-05 10:05:40'),(11,1,'Case',3,'\"{\\\"action\\\":\\\"updated\\\",\\\"case_id\\\":\\\"SSCD-0003\\\",\\\"changes\\\":{\\\"created_at\\\":{\\\"old\\\":\\\"2026-05-05T10:04:30.000000Z\\\",\\\"new\\\":\\\"2026-05-05T10:04:30.000000Z\\\"},\\\"updated_at\\\":{\\\"old\\\":\\\"2026-05-05T10:04:30.000000Z\\\",\\\"new\\\":\\\"2026-05-05T10:04:30.000000Z\\\"}}}\"','127.0.0.1','2026-05-05 11:09:12','2026-05-05 11:09:12'),(12,1,'Case',3,'\"{\\\"action\\\":\\\"updated\\\",\\\"case_id\\\":\\\"GFSD-0003\\\",\\\"changes\\\":{\\\"case_id\\\":{\\\"old\\\":\\\"SSCD-0003\\\",\\\"new\\\":\\\"GFSD-0003\\\"},\\\"department_id\\\":{\\\"old\\\":5,\\\"new\\\":7},\\\"created_at\\\":{\\\"old\\\":\\\"2026-05-05T10:04:30.000000Z\\\",\\\"new\\\":\\\"2026-05-05T10:04:30.000000Z\\\"},\\\"updated_at\\\":{\\\"old\\\":\\\"2026-05-05T10:04:30.000000Z\\\",\\\"new\\\":\\\"2026-05-05T11:09:20.000000Z\\\"}}}\"','127.0.0.1','2026-05-05 11:09:20','2026-05-05 11:09:20'),(13,1,'Case',3,'\"{\\\"action\\\":\\\"updated\\\",\\\"case_id\\\":\\\"PAD-0003\\\",\\\"changes\\\":{\\\"case_id\\\":{\\\"old\\\":\\\"GFSD-0003\\\",\\\"new\\\":\\\"PAD-0003\\\"},\\\"department_id\\\":{\\\"old\\\":7,\\\"new\\\":5},\\\"created_at\\\":{\\\"old\\\":\\\"2026-05-05T10:04:30.000000Z\\\",\\\"new\\\":\\\"2026-05-05T10:04:30.000000Z\\\"},\\\"updated_at\\\":{\\\"old\\\":\\\"2026-05-05T11:09:20.000000Z\\\",\\\"new\\\":\\\"2026-05-05T11:09:28.000000Z\\\"}}}\"','127.0.0.1','2026-05-05 11:09:28','2026-05-05 11:09:28'),(14,1,'Assignment PA1',1,'{\"step\": \"PA1\", \"action\": \"completed\", \"case_id\": \"PAD-0003\", \"current_step\": 2, \"assignment_id\": 3, \"changed_fields\": {\"due_date\": {\"to\": \"2026-05-05\", \"from\": null}, \"assigned_date\": {\"to\": \"2026-05-05\", \"from\": null}, \"batch_assignment\": {\"to\": false, \"from\": null}, \"requested_items.0\": {\"to\": {\"done_date\": null, \"approval_type\": null, \"survey_type_id\": 39, \"assigned_engineer_id\": 1}, \"from\": null}, \"requested_items.1\": {\"to\": {\"done_date\": null, \"approval_type\": null, \"survey_type_id\": 40, \"assigned_engineer_id\": 1}, \"from\": null}, \"requested_items.2\": {\"to\": {\"done_date\": null, \"approval_type\": null, \"survey_type_id\": 41, \"assigned_engineer_id\": 1}, \"from\": null}, \"assigned_by_user_id\": {\"to\": 1, \"from\": null}, \"assigned_engineer_id\": {\"to\": 1, \"from\": null}}}','127.0.0.1','2026-05-05 11:46:44','2026-05-05 11:46:44'),(15,1,'Case',4,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"PAD-0004\\\"}\"','127.0.0.1','2026-05-05 12:28:04','2026-05-05 12:28:04'),(16,1,'Surveyor',1,'{\"action\": \"updated\", \"changes\": {\"country_id\": {\"new\": 21, \"old\": null}}, \"surveyor_id\": 1, \"surveyor_name\": \"Sarah Surveyor (Coordinator)\"}','127.0.0.1','2026-05-05 12:29:10','2026-05-05 12:29:10'),(17,1,'Surveyor',1,'{\"action\": \"updated\", \"changes\": {\"survey_types\": {\"new\": {\"39\": \"A\", \"40\": \"A\", \"41\": \"A\", \"42\": \"A\", \"43\": \"A\", \"44\": \"A\", \"45\": \"A\", \"46\": \"A\", \"47\": \"A\", \"48\": \"A\", \"49\": \"A\", \"50\": \"A\", \"51\": \"A\", \"52\": \"A\", \"53\": \"A\", \"54\": \"A\", \"55\": \"A\", \"56\": \"A\", \"57\": \"N\", \"58\": \"N\", \"59\": \"N\", \"60\": \"N\", \"61\": \"N\", \"62\": \"N\", \"63\": \"N\"}, \"old\": {\"39\": \"A\", \"40\": \"A\", \"41\": \"A\"}}}, \"surveyor_id\": 1, \"surveyor_name\": \"Sarah Surveyor (Coordinator)\"}','127.0.0.1','2026-05-05 12:40:45','2026-05-05 12:40:45'),(18,1,'Assignment',4,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"PAD-0004\\\",\\\"assignment_id\\\":4,\\\"assigned_to\\\":\\\"Sarah Surveyor (Coordinator)\\\",\\\"current_step\\\":1,\\\"status\\\":\\\"active\\\"}\"','127.0.0.1','2026-05-05 12:40:58','2026-05-05 12:40:58'),(19,1,'Assignment PA1',2,'{\"step\": \"PA1\", \"action\": \"completed\", \"case_id\": \"PAD-0004\", \"current_step\": 2, \"assignment_id\": 4, \"changed_fields\": {\"remarks\": {\"to\": \"αδασδ\", \"from\": null}, \"due_date\": {\"to\": \"2026-05-05\", \"from\": null}, \"assigned_date\": {\"to\": \"2026-05-05\", \"from\": null}, \"batch_assignment\": {\"to\": true, \"from\": null}, \"requested_items.0\": {\"to\": {\"done_date\": null, \"field_values\": {\"13\": true, \"14\": false, \"15\": false}, \"approval_type\": \"approval\", \"survey_type_id\": 46, \"assigned_engineer_id\": 3}, \"from\": null}, \"requested_items.1\": {\"to\": {\"done_date\": null, \"field_values\": {\"10\": false, \"11\": false, \"12\": false}, \"approval_type\": null, \"survey_type_id\": 45, \"assigned_engineer_id\": 3}, \"from\": null}, \"requested_items.2\": {\"to\": {\"done_date\": null, \"field_values\": {\"49\": false, \"50\": false, \"51\": false}, \"approval_type\": null, \"survey_type_id\": 58, \"assigned_engineer_id\": 3}, \"from\": null}, \"assigned_by_user_id\": {\"to\": 1, \"from\": null}, \"assigned_engineer_id\": {\"to\": 3, \"from\": null}}}','127.0.0.1','2026-05-05 13:05:11','2026-05-05 13:05:11'),(20,1,'Assignment PA1',2,'{\"step\": \"PA1\", \"action\": \"completed\", \"case_id\": \"PAD-0004\", \"current_step\": 2, \"assignment_id\": 4, \"changed_fields\": {\"requested_items.0.done_date\": {\"to\": \"2026-05-05\", \"from\": null}, \"requested_items.1.done_date\": {\"to\": \"2026-05-05\", \"from\": null}, \"requested_items.2.done_date\": {\"to\": \"2026-05-05\", \"from\": null}, \"requested_items.1.field_values.10\": {\"to\": true, \"from\": false}, \"requested_items.1.field_values.11\": {\"to\": true, \"from\": false}, \"requested_items.1.field_values.12\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-05 13:19:05','2026-05-05 13:19:05'),(21,1,'Assignment PA1',2,'{\"step\": \"PA1\", \"action\": \"completed\", \"case_id\": \"PAD-0004\", \"current_step\": 2, \"assignment_id\": 4, \"changed_fields\": []}','127.0.0.1','2026-05-05 13:23:42','2026-05-05 13:23:42'),(22,1,'Surveyor',1,'{\"action\": \"updated\", \"changes\": {\"survey_types\": {\"new\": {\"39\": \"A\", \"40\": \"A\", \"41\": \"A\", \"42\": \"A\", \"43\": \"A\", \"44\": \"A\", \"45\": \"A\", \"46\": \"N\", \"47\": \"A\", \"48\": \"A\", \"49\": \"A\", \"50\": \"A\", \"51\": \"A\", \"52\": \"A\", \"53\": \"A\", \"54\": \"A\", \"55\": \"A\", \"56\": \"A\", \"57\": \"N\", \"58\": \"N\", \"59\": \"N\", \"60\": \"N\", \"61\": \"N\", \"62\": \"N\", \"63\": \"N\"}, \"old\": {\"39\": \"A\", \"40\": \"A\", \"41\": \"A\", \"42\": \"A\", \"43\": \"A\", \"44\": \"A\", \"45\": \"A\", \"46\": \"A\", \"47\": \"A\", \"48\": \"A\", \"49\": \"A\", \"50\": \"A\", \"51\": \"A\", \"52\": \"A\", \"53\": \"A\", \"54\": \"A\", \"55\": \"A\", \"56\": \"A\", \"57\": \"N\", \"58\": \"N\", \"59\": \"N\", \"60\": \"N\", \"61\": \"N\", \"62\": \"N\", \"63\": \"N\"}}}, \"surveyor_id\": 1, \"surveyor_name\": \"Sarah Surveyor (Coordinator)\"}','127.0.0.1','2026-05-05 13:35:47','2026-05-05 13:35:47'),(23,4,'Case',5,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"SSCD-0005\\\"}\"','127.0.0.1','2026-05-06 12:07:43','2026-05-06 12:07:43'),(24,1,'Case',2,'\"{\\\"action\\\":\\\"cancelled\\\",\\\"case_id\\\":\\\"SSCD-0008\\\",\\\"old_status\\\":1,\\\"new_status\\\":7}\"','127.0.0.1','2026-05-07 08:38:40','2026-05-07 08:38:40'),(25,1,'Assignment Step 2',1,'{\"step\": 2, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 6, \"assignment_id\": 1, \"changed_fields\": {\"amendment_message_reference\": {\"to\": \"δφγσγφσφδσφδσφδ\", \"from\": null}, \"certificates_received_in_order\": {\"to\": false, \"from\": true}}}','127.0.0.1','2026-05-07 10:11:08','2026-05-07 10:11:08'),(26,1,'Assignment Step 2',1,'{\"step\": 2, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 6, \"assignment_id\": 1, \"changed_fields\": {\"sr_form_received_in_order\": {\"to\": false, \"from\": true}, \"amendment_message_reference\": {\"to\": \"ηγη\", \"from\": \"δφγσγφσφδσφδσφδ\"}, \"sr_form_amendments_requested\": {\"to\": true, \"from\": false}, \"certificates_amendments_requested\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-07 10:11:39','2026-05-07 10:11:39'),(27,1,'Assignment Step 3',4,'{\"step\": 3, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 6, \"assignment_id\": 1, \"changed_fields\": {\"amendment_message_reference\": {\"to\": \"σδφσδφσφδ\", \"from\": null}, \"reports_amendments_requested\": {\"to\": true, \"from\": false}, \"surveyor_credentials_verified\": {\"to\": true, \"from\": false}, \"no_obvious_administrative_errors\": {\"to\": true, \"from\": false}, \"report_references_match_instructions\": {\"to\": true, \"from\": false}, \"missing_supporting_documentation_requested\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-07 10:32:09','2026-05-07 10:32:09'),(28,1,'Assignment Step 3',4,'{\"step\": 3, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 6, \"assignment_id\": 1, \"changed_fields\": {\"amendment_date\": {\"to\": \"2026-05-07\", \"from\": null}}}','127.0.0.1','2026-05-07 10:32:25','2026-05-07 10:32:25'),(29,1,'Assignment Step 6',2,'{\"step\": 6, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 7, \"assignment_id\": 1, \"changed_fields\": {\"certificates.0\": {\"to\": {\"id\": 1, \"kind\": \"statutory\", \"file_path\": null, \"issue_date\": \"2026-05-22\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"International Oil Pollution Prevention Certificate\", \"short_term_reason\": \"ζχψζχψ\", \"certificate_number\": null}, \"from\": null}, \"certificates.1\": {\"to\": {\"id\": 2, \"kind\": \"class\", \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Class Refrigerating Installation\", \"short_term_reason\": \"ζχψζχψ\", \"certificate_number\": null}, \"from\": null}, \"certificates.2\": {\"to\": {\"id\": 3, \"kind\": \"statutory\", \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Fitness for the Carriage of Liquified Gases in Bulk\", \"short_term_reason\": \"ζχψζχψ\", \"certificate_number\": null}, \"from\": null}, \"certificates.3\": {\"to\": {\"id\": 4, \"kind\": \"class\", \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Class Refrigerating Installation\", \"short_term_reason\": \"ζχψζ\", \"certificate_number\": null}, \"from\": null}, \"certificates.4\": {\"to\": {\"id\": 5, \"kind\": \"statutory\", \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Fitness for the Carriage of Liquified Gases in Bulk\", \"short_term_reason\": \"σδφ\", \"certificate_number\": null}, \"from\": null}, \"coordinator_signed\": {\"to\": true, \"from\": false}, \"outstandings_noted\": {\"to\": true, \"from\": false}, \"certificates_issued\": {\"to\": true, \"from\": false}, \"relevant_parties_informed\": {\"to\": true, \"from\": false}, \"technical_director_approved\": {\"to\": true, \"from\": false}, \"outstandings_message_reference\": {\"to\": \"ωσχδωχ\", \"from\": null}, \"forwarded_to_technical_director\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-07 11:17:22','2026-05-07 11:17:22'),(30,1,'Case',6,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"GFSD-0006\\\"}\"','127.0.0.1','2026-05-07 12:44:11','2026-05-07 12:44:11'),(31,1,'Assignment',5,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"GFSD-0006\\\",\\\"assignment_id\\\":5,\\\"assigned_to\\\":\\\"Sarah Surveyor (Coordinator)\\\",\\\"current_step\\\":1,\\\"status\\\":\\\"active\\\"}\"','127.0.0.1','2026-05-07 12:44:22','2026-05-07 12:44:22'),(32,1,'Instruction',2,'{\"step\": 1, \"action\": \"created\", \"case_id\": \"GFSD-0006\", \"completed\": true, \"current_step\": 2, \"assignment_id\": 5, \"changed_fields\": {\"lead_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"flag_notifications\": {\"to\": {\"details\": null}, \"from\": null}, \"instruction_number\": {\"to\": \"GFSD-0006-2026-05-07\", \"from\": null}, \"secondary_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"technical_instructions\": {\"to\": {\"39\": {\"notes\": null, \"reports\": null, \"guidance\": null, \"references\": null, \"survey_type\": \"Initial\", \"certificates\": null, \"survey_type_id\": 39, \"supporting_docs\": null, \"assigned_surveyor\": {\"id\": null, \"name\": null}, \"additional_remarks\": null}}, \"from\": null}}, \"instruction_id\": 2, \"history_version\": 1}','127.0.0.1','2026-05-07 13:46:32','2026-05-07 13:46:32'),(33,1,'Assignment Step 7',4,'{\"step\": 7, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 7, \"assignment_id\": 1, \"changed_fields\": {\"payload\": {\"to\": {\"rows\": {\"category:14:name:1\": {\"remarks\": null, \"done_date\": \"2026-05-11\", \"manual_due\": null, \"manual_rangeto\": null, \"anniversary_date\": null, \"manual_postponed\": null, \"manual_rangefrom\": null}}, \"certificates\": {\"assignment-certificate-1\": {\"kind\": \"statutory\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-22\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"International Oil Pollution Prevention Certificate\", \"short_term_reason\": \"ζχψζχψ\", \"certificate_number\": \"231\", \"assignment_certificate_id\": 1}, \"assignment-certificate-2\": {\"kind\": \"class\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Class Refrigerating Installation\", \"short_term_reason\": \"ζχψζχψ\", \"certificate_number\": \"1234123\", \"assignment_certificate_id\": 2}, \"assignment-certificate-3\": {\"kind\": \"statutory\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Fitness for the Carriage of Liquified Gases in Bulk\", \"short_term_reason\": \"ζχψζχψ\", \"certificate_number\": \"141231\", \"assignment_certificate_id\": 3}, \"assignment-certificate-4\": {\"kind\": \"class\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Class Refrigerating Installation\", \"short_term_reason\": \"ζχψζ\", \"certificate_number\": \"141231132\", \"assignment_certificate_id\": 4}, \"assignment-certificate-5\": {\"kind\": \"statutory\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Fitness for the Carriage of Liquified Gases in Bulk\", \"short_term_reason\": \"σδφ\", \"certificate_number\": \"14231313\", \"assignment_certificate_id\": 5}}, \"observations\": {\"memos\": {\"source-3\": {\"kind\": null, \"status\": \"open\", \"live_id\": null, \"due_date\": null, \"posed_date\": \"2026-05-30\", \"description\": \"ασδα\", \"source_observation_id\": 3}}, \"memoranda\": {\"source-2\": {\"kind\": null, \"status\": \"open\", \"live_id\": null, \"due_date\": null, \"posed_date\": \"2026-06-13\", \"description\": \"δσασδ\", \"source_observation_id\": 2}}, \"recommendations\": {\"source-1\": {\"kind\": \"class\", \"status\": \"open\", \"live_id\": null, \"due_date\": \"2026-05-29\", \"posed_date\": \"2026-05-29\", \"description\": \"φδασφ\", \"source_observation_id\": 1}}}}, \"from\": null}, \"warnings\": {\"to\": [], \"from\": null}, \"forwarded_to_concerned_party\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-11 07:04:33','2026-05-11 07:04:33'),(34,1,'Assignment Step 7',4,'{\"step\": 7, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 8, \"assignment_id\": 1, \"changed_fields\": {\"payload.observations.memos.live-memo-1\": {\"to\": {\"kind\": null, \"status\": \"open\", \"live_id\": 1, \"due_date\": null, \"posed_date\": \"2026-05-30\", \"description\": \"ασδα\", \"source_observation_id\": 3}, \"from\": null}, \"payload.observations.memoranda.live-memorandum-1\": {\"to\": {\"kind\": null, \"status\": \"open\", \"live_id\": 1, \"due_date\": null, \"posed_date\": \"2026-06-13\", \"description\": \"δσασδ\", \"source_observation_id\": 2}, \"from\": null}, \"payload.rows.category:14:name:1.anniversary_date\": {\"to\": \"2026-05-11\", \"from\": null}, \"payload.observations.recommendations.live-recommendation-1\": {\"to\": {\"kind\": \"class\", \"status\": \"open\", \"live_id\": 1, \"due_date\": \"2026-05-29\", \"posed_date\": \"2026-05-29\", \"description\": \"φδασφ\", \"source_observation_id\": 1}, \"from\": null}}}','127.0.0.1','2026-05-11 07:08:38','2026-05-11 07:08:38'),(35,NULL,'App\\Models\\Assignment',1,'{\"event\": \"certificate_issuance_notifications\", \"sent_at\": \"2026-05-11T11:55:08+03:00\", \"emails_sent\": [], \"emails_failed\": [], \"emails_skipped\": [{\"group\": \"owner\", \"reason\": \"no_email_configured\"}, {\"group\": \"office\", \"reason\": \"no_email_configured\"}, {\"group\": \"head_office\", \"reason\": \"no_email_configured\"}], \"in_app_notifications_count\": 1}',NULL,'2026-05-11 08:55:08','2026-05-11 08:55:08'),(36,1,'Assignment Step 2',2,'{\"step\": 2, \"action\": \"completed\", \"case_id\": \"DEMO-SIS-0002\", \"current_step\": 3, \"assignment_id\": 7, \"changed_fields\": {\"sr_form_received_in_order\": {\"to\": true, \"from\": false}, \"certificates_received_in_order\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-11 10:28:05','2026-05-11 10:28:05'),(37,1,'Assignment Step 3',5,'{\"step\": 3, \"action\": \"completed\", \"case_id\": \"DEMO-SIS-0002\", \"current_step\": 4, \"assignment_id\": 7, \"changed_fields\": {\"reports_amendments_requested\": {\"to\": true, \"from\": false}, \"supporting_documentation_received_in_order\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-11 10:40:48','2026-05-11 10:40:48'),(38,1,'Assignment PA2',1,'{\"step\": \"PA2\", \"action\": \"signed\", \"assignment_id\": 3}','127.0.0.1','2026-05-12 10:40:54','2026-05-12 10:40:54'),(39,1,'Assignment PA2',2,'{\"step\": \"PA2\", \"action\": \"signed\", \"assignment_id\": 4}','127.0.0.1','2026-05-12 10:45:37','2026-05-12 10:45:37'),(40,1,'Assignment',10,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"PAD-0003\\\",\\\"assignment_id\\\":10,\\\"assigned_to\\\":\\\"Sarah Surveyor (Coordinator)\\\",\\\"current_step\\\":1,\\\"status\\\":\\\"active\\\"}\"','127.0.0.1','2026-05-12 10:55:34','2026-05-12 10:55:34'),(41,1,'Assignment PA1',3,'{\"step\": \"PA1\", \"action\": \"completed\", \"case_id\": \"PAD-0003\", \"current_step\": 2, \"assignment_id\": 10, \"changed_fields\": {\"remarks\": {\"to\": \"ςδεφςω\", \"from\": null}, \"due_date\": {\"to\": \"2026-05-12\", \"from\": null}, \"assigned_date\": {\"to\": \"2026-05-12\", \"from\": null}, \"batch_assignment\": {\"to\": true, \"from\": null}, \"requested_items.0\": {\"to\": {\"done_date\": null, \"field_values\": [], \"approval_type\": null, \"survey_type_id\": 39, \"assigned_engineer_id\": 3}, \"from\": null}, \"requested_items.1\": {\"to\": {\"done_date\": null, \"field_values\": [], \"approval_type\": null, \"survey_type_id\": 40, \"assigned_engineer_id\": 3}, \"from\": null}, \"requested_items.2\": {\"to\": {\"done_date\": null, \"field_values\": [], \"approval_type\": null, \"survey_type_id\": 41, \"assigned_engineer_id\": 3}, \"from\": null}, \"assigned_by_user_id\": {\"to\": 1, \"from\": null}, \"assigned_engineer_id\": {\"to\": 3, \"from\": null}}}','127.0.0.1','2026-05-12 10:56:03','2026-05-12 10:56:03'),(42,1,'Assignment PA2',3,'{\"step\": \"PA2\", \"action\": \"signed\", \"assignment_id\": 10}','127.0.0.1','2026-05-12 10:56:20','2026-05-12 10:56:20'),(43,1,'Assignment',11,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"PAD-0003\\\",\\\"assignment_id\\\":11,\\\"assigned_to\\\":\\\"Sarah Surveyor (Coordinator)\\\",\\\"current_step\\\":1,\\\"status\\\":\\\"active\\\"}\"','127.0.0.1','2026-05-12 11:04:45','2026-05-12 11:04:45'),(44,1,'Assignment PA1',4,'{\"step\": \"PA1\", \"action\": \"completed\", \"case_id\": \"PAD-0003\", \"current_step\": 2, \"assignment_id\": 11, \"changed_fields\": {\"remarks\": {\"to\": \"τεστ\", \"from\": null}, \"due_date\": {\"to\": \"2026-05-12\", \"from\": null}, \"assigned_date\": {\"to\": \"2026-05-12\", \"from\": null}, \"batch_assignment\": {\"to\": true, \"from\": null}, \"requested_items.0\": {\"to\": {\"done_date\": null, \"field_values\": [], \"approval_type\": null, \"survey_type_id\": 39, \"assigned_engineer_id\": 3}, \"from\": null}, \"requested_items.1\": {\"to\": {\"done_date\": null, \"field_values\": [], \"approval_type\": null, \"survey_type_id\": 40, \"assigned_engineer_id\": 3}, \"from\": null}, \"requested_items.2\": {\"to\": {\"done_date\": null, \"field_values\": [], \"approval_type\": null, \"survey_type_id\": 41, \"assigned_engineer_id\": 3}, \"from\": null}, \"assigned_by_user_id\": {\"to\": 1, \"from\": null}, \"assigned_engineer_id\": {\"to\": 3, \"from\": null}}}','127.0.0.1','2026-05-12 11:05:03','2026-05-12 11:05:03'),(45,1,'Assignment PA2',4,'{\"step\": \"PA2\", \"action\": \"signed\", \"assignment_id\": 11}','127.0.0.1','2026-05-12 11:05:24','2026-05-12 11:05:24'),(46,1,'Assignment',12,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"PAD-0004\\\",\\\"assignment_id\\\":12,\\\"assigned_to\\\":\\\"Sarah Surveyor (Coordinator)\\\",\\\"current_step\\\":1,\\\"status\\\":\\\"active\\\"}\"','127.0.0.1','2026-05-12 11:36:26','2026-05-12 11:36:26'),(47,1,'Assignment PA1',5,'{\"step\": \"PA1\", \"action\": \"completed\", \"case_id\": \"PAD-0004\", \"current_step\": 2, \"assignment_id\": 12, \"changed_fields\": {\"due_date\": {\"to\": \"2026-05-12\", \"from\": null}, \"assigned_date\": {\"to\": \"2026-05-12\", \"from\": null}, \"batch_assignment\": {\"to\": true, \"from\": null}, \"requested_items.0\": {\"to\": {\"done_date\": null, \"field_values\": {\"13\": false, \"14\": false, \"15\": false}, \"approval_type\": \"approval\", \"survey_type_id\": 46, \"assigned_engineer_id\": 3}, \"from\": null}, \"requested_items.1\": {\"to\": {\"done_date\": null, \"field_values\": {\"10\": false, \"11\": false, \"12\": false}, \"approval_type\": null, \"survey_type_id\": 45, \"assigned_engineer_id\": 3}, \"from\": null}, \"requested_items.2\": {\"to\": {\"done_date\": null, \"field_values\": {\"49\": false, \"50\": false, \"51\": false}, \"approval_type\": null, \"survey_type_id\": 58, \"assigned_engineer_id\": 3}, \"from\": null}, \"assigned_by_user_id\": {\"to\": 1, \"from\": null}, \"assigned_engineer_id\": {\"to\": 3, \"from\": null}}}','127.0.0.1','2026-05-12 11:36:42','2026-05-12 11:36:42'),(48,1,'Assignment PA2',5,'{\"step\": \"PA2\", \"action\": \"signed\", \"assignment_id\": 12}','127.0.0.1','2026-05-12 11:37:00','2026-05-12 11:37:00'),(49,1,'Assignment Step6',2,'{\"step\": \"Step6\", \"action\": \"signed\", \"assignment_id\": 1}','127.0.0.1','2026-05-12 12:46:00','2026-05-12 12:46:00'),(50,1,'Assignment Step 4',3,'{\"step\": 4, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 8, \"assignment_id\": 1, \"changed_fields\": {\"reports_considered_in_order\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-12 13:20:10','2026-05-12 13:20:10'),(51,1,'Assignment Step 5',2,'{\"step\": 5, \"action\": \"completed\", \"case_id\": \"APPR-0001\", \"current_step\": 8, \"assignment_id\": 1, \"changed_fields\": {\"eval_score\": {\"to\": \"4.8\", \"from\": \"4.0\"}}}','127.0.0.1','2026-05-12 13:20:37','2026-05-12 13:20:37'),(52,1,'Assignment',13,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"SSCD-0005\\\",\\\"assignment_id\\\":13,\\\"assigned_to\\\":\\\"Sarah Surveyor (Coordinator)\\\",\\\"current_step\\\":1,\\\"status\\\":\\\"active\\\"}\"','127.0.0.1','2026-05-13 06:47:08','2026-05-13 06:47:08'),(53,1,'Instruction',5,'{\"step\": 1, \"action\": \"created\", \"case_id\": \"SSCD-0005\", \"completed\": true, \"current_step\": 2, \"assignment_id\": 13, \"changed_fields\": {\"assigned_by\": {\"to\": \"Nikos Voutsi\", \"from\": null}, \"instructions\": {\"to\": \"SRFDDFSD\", \"from\": null}, \"assigned_date\": {\"to\": \"2026-05-13\", \"from\": null}, \"lead_surveyor\": {\"to\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"from\": null}, \"place_of_audit\": {\"to\": \"DUBAI\", \"from\": null}, \"flag_notifications\": {\"to\": {\"details\": \"SVDS SSSD\"}, \"from\": null}, \"instruction_number\": {\"to\": \"SSCD-0005-2026-05-13\", \"from\": null}, \"secondary_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"technical_committe_ref\": {\"to\": \"REF-1234\", \"from\": null}, \"technical_instructions\": {\"to\": {\"39\": {\"notes\": \"\\\"[\\\\\\\"1. The vessel must comply with MSC.1\\\\\\\\/Circ.1571 amendments effective 01\\\\\\\\/01\\\\\\\\/2024 regarding fire safety systems.\\\\\\\",\\\\\\\"2. EPIRB battery replacement due if manufacturing date exceeds 5 years.\\\\\\\",\\\\\\\"3. Immersion suits required for all crew \\\\\\\\u2014 verify condition and quantity.\\\\\\\",\\\\\\\"4. Ensure SOLAS Training Manual is updated and available onboard.\\\\\\\"]\\\"\", \"reports\": \"\\\"[\\\\\\\"1215225-SE \\\\\\\\/ 01-2025 \\\\\\\\u2014 Safety Equipment Survey Report\\\\\\\",\\\\\\\"1215225-FF \\\\\\\\/ 01-2025 \\\\\\\\u2014 Fire Fighting Equipment Report\\\\\\\",\\\\\\\"1215225-LSA \\\\\\\\/ 01-2025 \\\\\\\\u2014 Life-Saving Appliances Report\\\\\\\"]\\\"\", \"guidance\": \"\\\"[\\\\\\\"Renewal Safety Equipment survey according to SOLAS Chapter III, Regulation 20. Verify all life-saving appliances, fire-fighting equipment, and navigation systems are in compliance with current INSB Class regulations and applicable IMO amendments. Special attention to: (a) Lifeboat launching arrangements and release mechanisms, (b) Life-raft hydrostatic release units \\\\\\\\u2014 verify service dates, (c) Fire detection systems in accommodation and machinery spaces, (d) Emergency lighting and marking of escape routes, (e) Pyrotechnics \\\\\\\\u2014 verify expiry dates.\\\\\\\"]\\\"\", \"references\": \"\\\"[\\\\\\\"SOLAS Chapter III, Regulation 20\\\\\\\",\\\\\\\"MSC.1\\\\\\\\/Circ.1571\\\\\\\",\\\\\\\"INSB Class Rules Chapter 8, Section 3\\\\\\\"]\\\"\", \"survey_type\": \"Initial\", \"certificates\": \"\\\"[\\\\\\\"Safety Equipment Certificate \\\\\\\\u2014 Full Term (5 years)\\\\\\\",\\\\\\\"Exemption Certificate (if applicable)\\\\\\\"]\\\"\", \"survey_type_id\": 39, \"supporting_docs\": null, \"assigned_surveyor\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"additional_remarks\": \"If vessel carries dangerous goods, verify Document of Compliance for carriage of dangerous goods is valid.\"}}, \"from\": null}, \"technical_committe_date\": {\"to\": \"2026-05-13\", \"from\": null}, \"classification_committe_ref\": {\"to\": \"REF-1234\", \"from\": null}, \"classification_committe_date\": {\"to\": \"2026-05-13\", \"from\": null}, \"classification_committe_reference_date\": {\"to\": \"2026-05-13\", \"from\": null}}, \"instruction_id\": 5, \"history_version\": 1}','127.0.0.1','2026-05-13 06:48:06','2026-05-13 06:48:06'),(54,1,'Assignment Step 1',5,'{\"step\": 1, \"action\": \"saved\", \"case_id\": \"SSCD-0005\", \"completed\": true, \"current_step\": 2, \"assignment_id\": 13, \"instruction_number\": \"SSCD-0005-2026-05-13\"}','127.0.0.1','2026-05-13 06:48:06','2026-05-13 06:48:06'),(55,1,'Assignment Step 2',3,'{\"step\": 2, \"action\": \"completed\", \"case_id\": \"SSCD-0005\", \"current_step\": 3, \"assignment_id\": 13, \"changed_fields\": {\"notes\": {\"to\": \"ddfvr er r\", \"from\": null}, \"sr_form_amendments_requested\": {\"to\": true, \"from\": false}, \"amendment_message_references.0\": {\"to\": {\"ref\": \"ref-1234\", \"url\": null}, \"from\": null}}, \"amendments_requested\": true}','127.0.0.1','2026-05-13 07:22:05','2026-05-13 07:22:05'),(56,1,'Assignment Step 4',4,'{\"step\": 4, \"action\": \"completed\", \"case_id\": \"SSCD-0005\", \"current_step\": 5, \"assignment_id\": 13, \"changed_fields\": {\"observations.0\": {\"to\": {\"id\": 4, \"kind\": \"class\", \"type\": \"recommendation\", \"status\": \"open\", \"due_date\": \"2026-06-03\", \"posed_date\": \"2026-05-13\", \"description\": \"rteegte\"}, \"from\": null}, \"amendments_requested\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-13 07:33:23','2026-05-13 07:33:23'),(57,1,'Assignment Step 5',3,'{\"step\": 5, \"action\": \"created\", \"case_id\": \"SSCD-0005\", \"current_step\": 5, \"assignment_id\": 13, \"changed_fields\": {\"notes\": {\"to\": \"sgsdfs\", \"from\": null}, \"eval_score\": {\"to\": \"4.3\", \"from\": null}, \"surveyor_evaluated\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-13 07:37:06','2026-05-13 07:37:06'),(58,1,'Assignment Step 5',3,'{\"step\": 5, \"action\": \"completed\", \"case_id\": \"SSCD-0005\", \"current_step\": 6, \"assignment_id\": 13, \"changed_fields\": []}','127.0.0.1','2026-05-13 07:37:13','2026-05-13 07:37:13'),(59,1,'Assignment Step 6',3,'{\"step\": 6, \"action\": \"created\", \"case_id\": \"SSCD-0005\", \"current_step\": 6, \"assignment_id\": 13, \"changed_fields\": {\"notes\": {\"to\": \"sfsd\", \"from\": null}, \"certificates.0\": {\"to\": {\"id\": 6, \"kind\": null, \"file_path\": null, \"issue_date\": null, \"expiry_date\": null, \"draft_status\": \"draft\", \"validity_type\": \"full_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Class Hull & Machinery\", \"short_term_reason\": null, \"certificate_number\": null}, \"from\": null}, \"certificates.1\": {\"to\": {\"id\": 7, \"kind\": \"class\", \"file_path\": null, \"issue_date\": null, \"expiry_date\": null, \"draft_status\": \"draft\", \"validity_type\": null, \"validity_value\": null, \"certificate_name\": \"\\\\\\\"Exemption Certificate (if applicable)\\\\\\\"]\\\"\", \"short_term_reason\": null, \"certificate_number\": null}, \"from\": null}, \"coordinator_signed\": {\"to\": true, \"from\": false}, \"outstandings_noted\": {\"to\": true, \"from\": false}, \"relevant_parties_informed\": {\"to\": true, \"from\": false}, \"outstandings_message_reference\": {\"to\": \"dsdfsfsf\", \"from\": null}}}','127.0.0.1','2026-05-13 07:43:20','2026-05-13 07:43:20'),(60,1,'Assignment Step 6',3,'{\"step\": 6, \"action\": \"updated\", \"case_id\": \"SSCD-0005\", \"current_step\": 6, \"assignment_id\": 13, \"changed_fields\": {\"certificates.0.kind\": {\"to\": \"class\", \"from\": null}, \"certificates.0.issue_date\": {\"to\": \"2026-05-13\", \"from\": null}, \"certificates.0.expiry_date\": {\"to\": \"2026-06-04\", \"from\": null}, \"certificates.0.certificate_number\": {\"to\": \"sfdsfs\", \"from\": null}}}','127.0.0.1','2026-05-13 07:43:40','2026-05-13 07:43:40'),(61,1,'Assignment Step6',3,'{\"step\": \"Step6\", \"action\": \"signed\", \"assignment_id\": 13}','127.0.0.1','2026-05-13 07:53:09','2026-05-13 07:53:09'),(62,1,'Assignment Step 6',3,'{\"step\": 6, \"action\": \"updated\", \"case_id\": \"SSCD-0005\", \"current_step\": 6, \"assignment_id\": 13, \"changed_fields\": {\"certificates_issued\": {\"to\": true, \"from\": false}, \"technical_director_approved\": {\"to\": true, \"from\": false}, \"forwarded_to_technical_director\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-13 08:02:22','2026-05-13 08:02:22'),(63,1,'Assignment Step 6',3,'{\"step\": 6, \"action\": \"updated\", \"case_id\": \"SSCD-0005\", \"current_step\": 6, \"assignment_id\": 13, \"changed_fields\": {\"certificates.2\": {\"to\": {\"id\": 8, \"kind\": \"statutory\", \"file_path\": null, \"issue_date\": \"2026-05-13\", \"expiry_date\": \"2026-06-04\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Carriage of Dangerous Goods - Document of Compliance\", \"short_term_reason\": null, \"certificate_number\": \"σδφσδφ\"}, \"from\": null}, \"certificates.1.kind\": {\"to\": \"statutory\", \"from\": \"class\"}, \"certificates.1.issue_date\": {\"to\": \"2026-05-13\", \"from\": null}, \"certificates.1.expiry_date\": {\"to\": \"2026-06-04\", \"from\": null}, \"certificates.0.validity_type\": {\"to\": \"short_term\", \"from\": \"full_term\"}, \"certificates.1.validity_type\": {\"to\": \"short_term\", \"from\": null}, \"certificates.1.validity_value\": {\"to\": \"60 months\", \"from\": null}, \"certificates.1.certificate_name\": {\"to\": \"Carriage of Dangerous Goods - Document of Compliance\", \"from\": \"\\\\\\\"Exemption Certificate (if applicable)\\\\\\\"]\\\"\"}, \"certificates.1.certificate_number\": {\"to\": \"σφδφσ\", \"from\": null}}}','127.0.0.1','2026-05-13 08:10:15','2026-05-13 08:10:15'),(64,1,'Assignment Step 6',3,'{\"step\": 6, \"action\": \"completed\", \"case_id\": \"SSCD-0005\", \"current_step\": 7, \"assignment_id\": 13, \"changed_fields\": {\"certificates.0.short_term_reason\": {\"to\": \"σδφσφ\", \"from\": null}, \"certificates.1.short_term_reason\": {\"to\": \"σδφσδ\", \"from\": null}, \"certificates.2.short_term_reason\": {\"to\": \"σδφσδ\", \"from\": null}}}','127.0.0.1','2026-05-13 08:10:38','2026-05-13 08:10:38'),(65,1,'Assignment Step8',13,'{\"step\": \"Step8\", \"notes\": \"Test notes from automated testing - Save Draft check\", \"action\": \"draft_saved\", \"assignment_id\": 13, \"case_completed\": false}','127.0.0.1','2026-05-13 09:07:38','2026-05-13 09:07:38'),(66,1,'Assignment Step8',13,'{\"step\": \"Step8\", \"notes\": \"Test notes from automated testing - Save Draft check\", \"action\": \"completed\", \"assignment_id\": 13, \"case_completed\": true}','127.0.0.1','2026-05-13 09:08:21','2026-05-13 09:08:21'),(67,1,'Assignment Step8',13,'{\"step\": \"Step8\", \"notes\": \"Test notes from automated testing - Save Draft check\", \"action\": \"completed\", \"assignment_id\": 13, \"case_completed\": true}','127.0.0.1','2026-05-13 09:15:36','2026-05-13 09:15:36'),(68,1,'Assignment Step8',13,'{\"step\": \"Step8\", \"notes\": \"Test notes from automated testing - Save Draft check\", \"action\": \"completed\", \"assignment_id\": 13, \"case_completed\": true}','127.0.0.1','2026-05-13 09:32:27','2026-05-13 09:32:27'),(69,1,'Assignment Step 2',3,'{\"step\": 2, \"action\": \"completed\", \"case_id\": \"SSCD-0005\", \"current_step\": 3, \"assignment_id\": 13, \"changed_fields\": [], \"amendments_requested\": true}','127.0.0.1','2026-05-13 09:35:03','2026-05-13 09:35:03'),(70,1,'Assignment Step 4',4,'{\"step\": 4, \"action\": \"completed\", \"case_id\": \"SSCD-0005\", \"current_step\": 5, \"assignment_id\": 13, \"changed_fields\": []}','127.0.0.1','2026-05-13 09:35:56','2026-05-13 09:35:56'),(71,1,'Assignment Step 5',3,'{\"step\": 5, \"action\": \"completed\", \"case_id\": \"SSCD-0005\", \"current_step\": 6, \"assignment_id\": 13, \"changed_fields\": []}','127.0.0.1','2026-05-13 09:36:11','2026-05-13 09:36:11'),(72,1,'Assignment Step6',3,'{\"step\": \"Step6\", \"action\": \"forwarded_for_td_approval\", \"assignment_id\": 13}','127.0.0.1','2026-05-13 09:37:19','2026-05-13 09:37:19'),(73,1,'Assignment Step 6',3,'{\"step\": 6, \"action\": \"completed\", \"case_id\": \"SSCD-0005\", \"current_step\": 7, \"assignment_id\": 13, \"changed_fields\": []}','127.0.0.1','2026-05-13 09:38:31','2026-05-13 09:38:31'),(74,1,'Instruction',6,'{\"step\": 1, \"action\": \"created\", \"case_id\": \"TEEPD-0001\", \"completed\": true, \"current_step\": 2, \"assignment_id\": 14, \"changed_fields\": {\"lead_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"flag_notifications\": {\"to\": {\"details\": null}, \"from\": null}, \"instruction_number\": {\"to\": \"TEEPD-0001-2026-05-13\", \"from\": null}, \"secondary_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"technical_instructions\": {\"to\": [], \"from\": null}}, \"instruction_id\": 6, \"history_version\": 1}','127.0.0.1','2026-05-13 10:50:15','2026-05-13 10:50:15'),(75,1,'Assignment Step 1',6,'{\"step\": 1, \"action\": \"saved\", \"case_id\": \"TEEPD-0001\", \"completed\": true, \"assignment_id\": 14, \"instruction_number\": \"TEEPD-0001-2026-05-13\"}','127.0.0.1','2026-05-13 10:50:15','2026-05-13 10:50:15'),(76,1,'Assignment Step 4',5,'{\"step\": 4, \"action\": \"completed\", \"case_id\": \"TEEPD-0001\", \"current_step\": 5, \"assignment_id\": 14, \"changed_fields\": []}','127.0.0.1','2026-05-13 10:51:01','2026-05-13 10:51:01'),(77,1,'Assignment Step 5',4,'{\"step\": 5, \"action\": \"completed\", \"case_id\": \"TEEPD-0001\", \"current_step\": 6, \"assignment_id\": 14, \"changed_fields\": {\"eval_score\": {\"to\": \"5.0\", \"from\": null}, \"surveyor_evaluated\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-13 10:52:51','2026-05-13 10:52:51'),(78,1,'Assignment Step 7',6,'{\"step\": 7, \"action\": \"completed\", \"case_id\": \"TEEPD-0001\", \"current_step\": 8, \"assignment_id\": 14, \"changed_fields\": {\"payload\": {\"to\": {\"rows\": [], \"certificates\": {\"new-certificate-1\": {\"kind\": \"class\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-13\", \"expiry_date\": \"2031-05-13\", \"draft_status\": \"issued\", \"validity_type\": \"full_term\", \"validity_value\": \"Full Term\", \"certificate_name\": \"Safety Management Certificate\", \"short_term_reason\": null, \"certificate_number\": \"CERT-2026-001\", \"assignment_certificate_id\": null}}, \"observations\": []}, \"from\": null}, \"warnings\": {\"to\": [], \"from\": null}, \"forwarded_to_concerned_party\": {\"to\": true, \"from\": false}}}','127.0.0.1','2026-05-13 10:58:37','2026-05-13 10:58:37'),(79,1,'Case',12,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"PA-0012\\\"}\"','127.0.0.1','2026-05-13 11:20:23','2026-05-13 11:20:23'),(80,1,'Assignment',15,'\"{\\\"action\\\":\\\"created\\\",\\\"case_id\\\":\\\"PA-0012\\\",\\\"assignment_id\\\":15,\\\"assigned_to\\\":\\\"Sarah Surveyor (Coordinator)\\\",\\\"current_step\\\":1,\\\"status\\\":\\\"active\\\"}\"','127.0.0.1','2026-05-13 11:21:00','2026-05-13 11:21:00'),(81,1,'Assignment PA1',6,'{\"step\": \"PA1\", \"action\": \"completed\", \"case_id\": \"PA-0012\", \"current_step\": 2, \"assignment_id\": 15, \"changed_fields\": {\"due_date\": {\"to\": \"2026-05-13\", \"from\": null}, \"assigned_date\": {\"to\": \"2026-05-13\", \"from\": null}, \"batch_assignment\": {\"to\": false, \"from\": null}, \"requested_items.0\": {\"to\": {\"done_date\": null, \"field_values\": {\"13\": false, \"14\": false, \"15\": false}, \"approval_type\": null, \"survey_type_id\": 46, \"assigned_engineer_id\": 1}, \"from\": null}, \"requested_items.1\": {\"to\": {\"done_date\": null, \"field_values\": {\"10\": false, \"11\": false, \"12\": false}, \"approval_type\": null, \"survey_type_id\": 45, \"assigned_engineer_id\": 1}, \"from\": null}, \"assigned_by_user_id\": {\"to\": 1, \"from\": null}, \"assigned_engineer_id\": {\"to\": 3, \"from\": null}}}','127.0.0.1','2026-05-13 11:32:23','2026-05-13 11:32:23'),(82,1,'Assignment PA2',6,'{\"step\": \"PA2\", \"action\": \"created\", \"case_id\": \"PA-0012\", \"current_step\": 2, \"assignment_id\": 15}','127.0.0.1','2026-05-13 11:32:53','2026-05-13 11:32:53'),(83,1,'Assignment PA2',6,'{\"step\": \"PA2\", \"action\": \"completed\", \"case_id\": \"PA-0012\", \"current_step\": 3, \"assignment_id\": 15}','127.0.0.1','2026-05-13 11:33:29','2026-05-13 11:33:29'),(84,1,'Assignment PA3',1,'{\"step\": \"PA3\", \"action\": \"completed\", \"case_id\": \"PA-0012\", \"current_step\": 4, \"assignment_id\": 15}','127.0.0.1','2026-05-13 11:34:04','2026-05-13 11:34:04'),(85,1,'Assignment PA4',15,'{\"step\": \"PA4\", \"action\": \"archived_and_completed\", \"case_id\": \"PA-0012\", \"case_status\": 6, \"assignment_id\": 15, \"archiving_notes\": null, \"assignment_status\": \"completed\"}','127.0.0.1','2026-05-13 11:34:35','2026-05-13 11:34:35');

--
-- Table structure for table `assignment_certificates`
--

CREATE TABLE `assignment_certificates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `master_certificate_type_id` bigint unsigned DEFAULT NULL,
  `certificate_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kind` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `validity_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `validity_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `draft_status` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `short_term_reason` text COLLATE utf8mb4_unicode_ci,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` int unsigned NOT NULL DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignment_certificates_updated_by_foreign` (`updated_by`),
  KEY `assignment_certificates_assignment_position_index` (`assignment_id`,`position`),
  KEY `asgmt_certs_master_type_fk` (`master_certificate_type_id`),
  CONSTRAINT `asgmt_certs_master_type_fk` FOREIGN KEY (`master_certificate_type_id`) REFERENCES `master_certificate_types` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assignment_certificates_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_certificates_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_certificates`
--

INSERT INTO `assignment_certificates` VALUES (1,1,9,'International Oil Pollution Prevention Certificate','statutory','short_term','60 months',NULL,'2026-05-22','2026-05-07','draft','ζχψζχψ',NULL,1,1,'2026-05-07 11:17:22','2026-05-07 11:17:22'),(2,1,2,'Class Refrigerating Installation','class','short_term','60 months',NULL,'2026-05-07','2026-05-07','draft','ζχψζχψ',NULL,2,1,'2026-05-07 11:17:22','2026-05-07 11:17:22'),(3,1,17,'Fitness for the Carriage of Liquified Gases in Bulk','statutory','short_term','60 months',NULL,'2026-05-07','2026-05-07','draft','ζχψζχψ',NULL,3,1,'2026-05-07 11:17:22','2026-05-07 11:17:22'),(4,1,2,'Class Refrigerating Installation','class','short_term','60 months',NULL,'2026-05-07','2026-05-07','draft','ζχψζ',NULL,4,1,'2026-05-07 11:17:22','2026-05-07 11:17:22'),(5,1,17,'Fitness for the Carriage of Liquified Gases in Bulk','statutory','short_term','60 months',NULL,'2026-05-07','2026-05-07','draft','σδφ',NULL,5,1,'2026-05-07 11:17:22','2026-05-07 11:17:22'),(6,13,1,'Class Hull & Machinery','class','short_term','60 months','sfdsfs','2026-05-13','2026-06-04','draft','σδφσφ',NULL,1,1,'2026-05-13 07:43:20','2026-05-13 08:10:38'),(7,13,16,'Carriage of Dangerous Goods - Document of Compliance','statutory','short_term','60 months','σφδφσ','2026-05-13','2026-06-04','draft','σδφσδ',NULL,2,1,'2026-05-13 07:43:20','2026-05-13 08:10:38'),(8,13,16,'Carriage of Dangerous Goods - Document of Compliance','statutory','short_term','60 months','σδφσδφ','2026-05-13','2026-06-04','draft','σδφσδ',NULL,3,1,'2026-05-13 08:10:15','2026-05-13 08:10:38');

--
-- Table structure for table `assignment_evaluation_report_amendments`
--

CREATE TABLE `assignment_evaluation_report_amendments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `message_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amendment_date` date DEFAULT NULL,
  `message_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignment_evaluation_report_amendments_assignment_id_foreign` (`assignment_id`),
  KEY `assignment_evaluation_report_amendments_created_by_foreign` (`created_by`),
  CONSTRAINT `assignment_evaluation_report_amendments_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_evaluation_report_amendments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_evaluation_report_amendments`
--


--
-- Table structure for table `assignment_evaluation_reports`
--

CREATE TABLE `assignment_evaluation_reports` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `reports_considered_in_order` tinyint(1) DEFAULT '0' COMMENT 'req 4.a — survey reports and supporting docs considered and in order',
  `amendments_requested` tinyint(1) DEFAULT '0' COMMENT 'req 4.b — amendments to reports or supporting docs requested',
  `amendment_message_references` json DEFAULT NULL COMMENT 'JSON array of {ref, url, created_at, created_by} — req 4.c',
  `reports_received_as_per_instructions` tinyint(1) NOT NULL DEFAULT '0',
  `technical_evaluation_completed` tinyint(1) NOT NULL DEFAULT '0',
  `evaluation_report_accepted` tinyint(1) NOT NULL DEFAULT '0',
  `evaluation_report_rejected` tinyint(1) NOT NULL DEFAULT '0',
  `evaluation_status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks_text` text COLLATE utf8mb4_unicode_ci,
  `auto_recommendation_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auto_recommendation_observation_id` bigint unsigned DEFAULT NULL,
  `rejection_reason` text COLLATE utf8mb4_unicode_ci,
  `amendment_message_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amendment_date` date DEFAULT NULL,
  `message_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `assignment_evaluation_reports_assignment_id_unique` (`assignment_id`),
  KEY `assignment_evaluation_reports_updated_by_foreign` (`updated_by`),
  CONSTRAINT `assignment_evaluation_reports_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_evaluation_reports_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_evaluation_reports`
--

INSERT INTO `assignment_evaluation_reports` VALUES (3,1,1,0,NULL,1,1,1,0,'rejected',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2026-04-30 12:52:53','2026-05-12 13:20:10'),(4,13,0,1,'[{\"ref\": \"ref-23311\", \"url\": \"\", \"created_at\": \"2026-05-13 10:33\", \"created_by\": \"Nikos\"}]',0,0,0,0,'satisfactory',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2026-05-13 07:33:04','2026-05-13 07:33:22'),(5,14,0,0,NULL,0,0,0,0,'satisfactory',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2026-05-13 10:51:01','2026-05-13 10:51:01');

--
-- Table structure for table `assignment_issue_full_term_outstandings`
--

CREATE TABLE `assignment_issue_full_term_outstandings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `message_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignment_issue_full_term_outstandings_assignment_id_foreign` (`assignment_id`),
  KEY `assignment_issue_full_term_outstandings_created_by_foreign` (`created_by`),
  CONSTRAINT `assignment_issue_full_term_outstandings_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_issue_full_term_outstandings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_issue_full_term_outstandings`
--

INSERT INTO `assignment_issue_full_term_outstandings` VALUES (3,1,'ωσχδωχ',NULL,NULL,1,'2026-05-07 11:17:22','2026-05-07 11:17:22'),(4,13,'dsdfsfsf',NULL,NULL,1,'2026-05-13 07:43:20','2026-05-13 07:43:20');

--
-- Table structure for table `assignment_issue_full_terms`
--

CREATE TABLE `assignment_issue_full_terms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `unsigned_pdf_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signed_pdf_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signed_at` timestamp NULL DEFAULT NULL,
  `forwarded_at` timestamp NULL DEFAULT NULL,
  `return_reason` text COLLATE utf8mb4_unicode_ci,
  `td_actioned_at` timestamp NULL DEFAULT NULL,
  `td_actioned_by` bigint unsigned DEFAULT NULL,
  `coordinator_signed` tinyint(1) NOT NULL DEFAULT '0',
  `forwarded_to_technical_director` tinyint(1) NOT NULL DEFAULT '0',
  `technical_director_approved` tinyint(1) NOT NULL DEFAULT '0',
  `certificates_issued` tinyint(1) NOT NULL DEFAULT '0',
  `outstandings_noted` tinyint(1) NOT NULL DEFAULT '0',
  `relevant_parties_informed` tinyint(1) NOT NULL DEFAULT '0',
  `certificate_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outstandings_message_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outstandings_message_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `assignment_issue_full_terms_assignment_id_unique` (`assignment_id`),
  KEY `assignment_issue_full_terms_updated_by_foreign` (`updated_by`),
  KEY `assignment_issue_full_terms_td_actioned_by_foreign` (`td_actioned_by`),
  CONSTRAINT `assignment_issue_full_terms_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_issue_full_terms_td_actioned_by_foreign` FOREIGN KEY (`td_actioned_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assignment_issue_full_terms_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_issue_full_terms`
--

INSERT INTO `assignment_issue_full_terms` VALUES (2,1,'signed_by_user','step6/2/unsigned_20260512154553.pdf','signed/step6/2/unsigned_20260512154553.pdf','2026-05-12 12:46:00',NULL,NULL,NULL,NULL,1,1,1,1,1,1,NULL,'ωσχδωχ',NULL,NULL,1,'2026-05-07 11:17:22','2026-05-12 12:46:00'),(3,13,'pending_td_approval','step6/3/unsigned_20260513105300.pdf','signed/step6/3/unsigned_20260513105300.pdf','2026-05-13 07:53:09','2026-05-13 09:37:19',NULL,NULL,NULL,1,1,1,1,1,1,NULL,'dsdfsfsf',NULL,'sfsd',1,'2026-05-13 07:43:20','2026-05-13 09:37:19');

--
-- Table structure for table `assignment_observations`
--

CREATE TABLE `assignment_observations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `source_step` tinyint unsigned NOT NULL DEFAULT '4',
  `type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kind` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `posed_date` date DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `due_date` date DEFAULT NULL,
  `status` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT 'open',
  `position` int unsigned NOT NULL DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignment_observations_updated_by_foreign` (`updated_by`),
  KEY `assignment_observations_assignment_step_type_index` (`assignment_id`,`source_step`,`type`),
  KEY `assignment_observations_code_index` (`code`),
  CONSTRAINT `assignment_observations_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_observations_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_observations`
--

INSERT INTO `assignment_observations` VALUES (1,1,4,'recommendation',NULL,'class','2026-05-29','φδασφ','2026-05-29','open',1,1,'2026-04-30 12:52:53','2026-04-30 12:52:53'),(2,1,4,'memorandum',NULL,NULL,'2026-06-13','δσασδ',NULL,'open',2,1,'2026-04-30 12:52:53','2026-04-30 12:52:53'),(3,1,4,'memo',NULL,NULL,'2026-05-30','ασδα',NULL,'open',3,1,'2026-04-30 12:52:53','2026-04-30 12:52:53'),(4,13,4,'recommendation',NULL,'class','2026-05-13','rteegte','2026-06-03','open',1,1,'2026-05-13 07:33:22','2026-05-13 07:33:22');

--
-- Table structure for table `assignment_pa1_case_elaborations`
--

CREATE TABLE `assignment_pa1_case_elaborations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `assigned_engineer_id` bigint unsigned DEFAULT NULL,
  `assigned_by_user_id` bigint unsigned DEFAULT NULL,
  `assigned_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `batch_assignment` tinyint(1) NOT NULL DEFAULT '0',
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `assignment_pa1_case_elaborations_assignment_id_unique` (`assignment_id`),
  KEY `assignment_pa1_case_elaborations_assigned_engineer_id_index` (`assigned_engineer_id`),
  KEY `assignment_pa1_case_elaborations_assigned_by_user_id_index` (`assigned_by_user_id`),
  KEY `assignment_pa1_case_elaborations_updated_by_index` (`updated_by`),
  CONSTRAINT `assignment_pa1_case_elaborations_assigned_by_user_id_foreign` FOREIGN KEY (`assigned_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assignment_pa1_case_elaborations_assigned_engineer_id_foreign` FOREIGN KEY (`assigned_engineer_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assignment_pa1_case_elaborations_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_pa1_case_elaborations_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_pa1_case_elaborations`
--

INSERT INTO `assignment_pa1_case_elaborations` VALUES (1,3,1,1,'2026-05-05','2026-05-05',0,NULL,1,'2026-05-05 11:46:44','2026-05-05 11:46:44'),(2,4,3,1,'2026-05-05','2026-05-05',1,'αδασδ',1,'2026-05-05 13:05:11','2026-05-05 13:05:11'),(3,10,3,1,'2026-05-12','2026-05-12',1,'ςδεφςω',1,'2026-05-12 10:56:03','2026-05-12 10:56:03'),(4,11,3,1,'2026-05-12','2026-05-12',1,'τεστ',1,'2026-05-12 11:05:03','2026-05-12 11:05:03'),(5,12,3,1,'2026-05-12','2026-05-12',1,NULL,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(6,15,3,1,'2026-05-13','2026-05-13',0,NULL,1,'2026-05-13 11:32:23','2026-05-13 11:32:23');

--
-- Table structure for table `assignment_pa1_checklist_field_values`
--

CREATE TABLE `assignment_pa1_checklist_field_values` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_pa1_checklist_id` bigint unsigned NOT NULL,
  `checklist_field_id` bigint unsigned NOT NULL,
  `is_checked` tinyint(1) NOT NULL DEFAULT '0',
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pa1_checklist_field_values_unique` (`assignment_pa1_checklist_id`,`checklist_field_id`),
  KEY `pa1_chk_val_chk_id_idx` (`assignment_pa1_checklist_id`),
  KEY `pa1_chk_val_field_id_idx` (`checklist_field_id`),
  KEY `pa1_chk_val_updated_by_idx` (`updated_by`),
  CONSTRAINT `pa1_chk_val_chk_id_fk` FOREIGN KEY (`assignment_pa1_checklist_id`) REFERENCES `assignment_pa1_checklists` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pa1_chk_val_field_id_fk` FOREIGN KEY (`checklist_field_id`) REFERENCES `plan_approval_checklist_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pa1_chk_val_updated_by_fk` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_pa1_checklist_field_values`
--

INSERT INTO `assignment_pa1_checklist_field_values` VALUES (1,4,13,1,1,'2026-05-05 13:05:11','2026-05-05 13:05:11'),(2,4,14,0,1,'2026-05-05 13:05:11','2026-05-05 13:05:11'),(3,4,15,0,1,'2026-05-05 13:05:11','2026-05-05 13:05:11'),(4,5,10,1,1,'2026-05-05 13:05:11','2026-05-05 13:19:05'),(5,5,11,1,1,'2026-05-05 13:05:11','2026-05-05 13:19:05'),(6,5,12,1,1,'2026-05-05 13:05:11','2026-05-05 13:19:05'),(7,6,49,0,1,'2026-05-05 13:05:11','2026-05-05 13:05:11'),(8,6,50,0,1,'2026-05-05 13:05:11','2026-05-05 13:05:11'),(9,6,51,0,1,'2026-05-05 13:05:11','2026-05-05 13:05:11'),(10,13,13,0,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(11,13,14,0,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(12,13,15,0,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(13,14,10,0,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(14,14,11,0,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(15,14,12,0,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(16,15,49,0,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(17,15,50,0,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(18,15,51,0,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(19,16,13,0,1,'2026-05-13 11:32:23','2026-05-13 11:32:23'),(20,16,14,0,1,'2026-05-13 11:32:23','2026-05-13 11:32:23'),(21,16,15,0,1,'2026-05-13 11:32:23','2026-05-13 11:32:23'),(22,17,10,0,1,'2026-05-13 11:32:23','2026-05-13 11:32:23'),(23,17,11,0,1,'2026-05-13 11:32:23','2026-05-13 11:32:23'),(24,17,12,0,1,'2026-05-13 11:32:23','2026-05-13 11:32:23');

--
-- Table structure for table `assignment_pa1_checklists`
--

CREATE TABLE `assignment_pa1_checklists` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `survey_type_id` bigint unsigned NOT NULL,
  `approval_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checklist_template_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checklist_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assigned_engineer_id` bigint unsigned DEFAULT NULL,
  `done_date` date DEFAULT NULL,
  `sort_order` int unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `assignment_pa1_checklists_assignment_id_survey_type_id_unique` (`assignment_id`,`survey_type_id`),
  KEY `assignment_pa1_checklists_assignment_id_index` (`assignment_id`),
  KEY `assignment_pa1_checklists_survey_type_id_index` (`survey_type_id`),
  KEY `assignment_pa1_checklists_assigned_engineer_id_index` (`assigned_engineer_id`),
  CONSTRAINT `assignment_pa1_checklists_assigned_engineer_id_foreign` FOREIGN KEY (`assigned_engineer_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assignment_pa1_checklists_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_pa1_checklists_survey_type_id_foreign` FOREIGN KEY (`survey_type_id`) REFERENCES `survey_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_pa1_checklists`
--

INSERT INTO `assignment_pa1_checklists` VALUES (1,3,39,NULL,NULL,NULL,1,NULL,1,'2026-05-05 11:46:44','2026-05-05 11:46:44'),(2,3,40,NULL,NULL,NULL,1,NULL,2,'2026-05-05 11:46:44','2026-05-05 11:46:44'),(3,3,41,NULL,NULL,NULL,1,NULL,3,'2026-05-05 11:46:44','2026-05-05 11:46:44'),(4,4,46,'approval',NULL,'DSS Study Checklist',3,'2026-05-05',1,'2026-05-05 13:05:11','2026-05-05 13:19:05'),(5,4,45,NULL,NULL,'IEA Study Checklist',3,'2026-05-05',2,'2026-05-05 13:05:11','2026-05-05 13:19:05'),(6,4,58,NULL,NULL,'BWMP Study Checklist',3,'2026-05-05',3,'2026-05-05 13:05:11','2026-05-05 13:19:05'),(7,10,39,NULL,NULL,NULL,3,NULL,1,'2026-05-12 10:56:03','2026-05-12 10:56:03'),(8,10,40,NULL,NULL,NULL,3,NULL,2,'2026-05-12 10:56:03','2026-05-12 10:56:03'),(9,10,41,NULL,NULL,NULL,3,NULL,3,'2026-05-12 10:56:03','2026-05-12 10:56:03'),(10,11,39,NULL,NULL,NULL,3,NULL,1,'2026-05-12 11:05:03','2026-05-12 11:05:03'),(11,11,40,NULL,NULL,NULL,3,NULL,2,'2026-05-12 11:05:03','2026-05-12 11:05:03'),(12,11,41,NULL,NULL,NULL,3,NULL,3,'2026-05-12 11:05:03','2026-05-12 11:05:03'),(13,12,46,'approval',NULL,'DSS Study Checklist',3,NULL,1,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(14,12,45,NULL,NULL,'IEA Study Checklist',3,NULL,2,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(15,12,58,NULL,NULL,'BWMP Study Checklist',3,NULL,3,'2026-05-12 11:36:42','2026-05-12 11:36:42'),(16,15,46,NULL,NULL,'DSS Study Checklist',1,NULL,1,'2026-05-13 11:32:23','2026-05-13 11:32:23'),(17,15,45,NULL,NULL,'IEA Study Checklist',1,NULL,2,'2026-05-13 11:32:23','2026-05-13 11:32:23');

--
-- Table structure for table `assignment_pa1_outstandings`
--

CREATE TABLE `assignment_pa1_outstandings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `message_reference` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message_url` text COLLATE utf8mb4_unicode_ci,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignment_pa1_outstandings_assignment_id_index` (`assignment_id`),
  KEY `assignment_pa1_outstandings_created_by_index` (`created_by`),
  CONSTRAINT `assignment_pa1_outstandings_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_pa1_outstandings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_pa1_outstandings`
--


--
-- Table structure for table `assignment_pa2_approval_documents`
--

CREATE TABLE `assignment_pa2_approval_documents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `document_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_date` date DEFAULT NULL,
  `approval_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'approval',
  `conditions` text COLLATE utf8mb4_unicode_ci,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `signed_at` timestamp NULL DEFAULT NULL,
  `forwarded_at` timestamp NULL DEFAULT NULL,
  `td_actioned_at` timestamp NULL DEFAULT NULL,
  `td_actioned_by` bigint unsigned DEFAULT NULL,
  `return_reason` text COLLATE utf8mb4_unicode_ci,
  `unsigned_pdf_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signed_pdf_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificates_issued` tinyint(1) NOT NULL DEFAULT '0',
  `outstandings_notified` tinyint(1) NOT NULL DEFAULT '0',
  `outstandings_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outstandings_message` text COLLATE utf8mb4_unicode_ci,
  `created_by` bigint unsigned DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `assignment_pa2_approval_documents_assignment_id_unique` (`assignment_id`),
  CONSTRAINT `assignment_pa2_approval_documents_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_pa2_approval_documents`
--

INSERT INTO `assignment_pa2_approval_documents` VALUES (1,3,'PAD-0003-PA-20260512','2026-05-12','approval',NULL,NULL,'signed_by_user','2026-05-12 10:40:54',NULL,NULL,NULL,NULL,'pa2/1/unsigned_20260512134046.pdf','signed/pa2/1/unsigned_20260512134046.pdf',0,0,NULL,NULL,1,1,'2026-05-12 09:14:55','2026-05-12 10:40:54'),(2,4,'PAD-0004-PA-20260512','2026-05-12','approval',NULL,NULL,'signed_by_user','2026-05-12 10:45:37',NULL,NULL,NULL,NULL,'pa2/2/unsigned_20260512134529.pdf','signed/pa2/2/unsigned_20260512134529.pdf',0,0,NULL,NULL,1,1,'2026-05-12 10:45:29','2026-05-12 10:45:37'),(3,10,'PAD-0003-PA-20260512','2026-05-12','approval','ψψβδβδ','φδγδφγδ','signed_by_user','2026-05-12 10:56:20',NULL,NULL,NULL,NULL,'pa2/3/unsigned_20260512135612.pdf','signed/pa2/3/unsigned_20260512135612.pdf',0,0,NULL,NULL,1,1,'2026-05-12 10:56:12','2026-05-12 10:56:20'),(4,11,'PAD-0003-PA-20260512','2026-05-12','approval','τεστ','δφδφ εδ σ ρ αα ρ','signed_by_user','2026-05-12 11:05:24',NULL,NULL,NULL,NULL,'pa2/4/unsigned_20260512140517.pdf','signed/pa2/4/unsigned_20260512140517.pdf',1,0,NULL,NULL,1,1,'2026-05-12 11:05:16','2026-05-12 11:05:24'),(5,12,'PAD-0004-PA-20260512','2026-05-12','approval','φσφδσ','σδφσδ','signed_by_user','2026-05-12 11:37:00',NULL,NULL,NULL,NULL,'pa2/5/unsigned_20260512143651.pdf','signed/pa2/5/unsigned_20260512143651.pdf',0,1,NULL,NULL,1,1,'2026-05-12 11:36:51','2026-05-12 11:37:00'),(6,15,'PA-0012-PA-20260513','2026-05-13','approval',NULL,NULL,'draft',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,1,1,'2026-05-13 11:32:53','2026-05-13 11:33:29');

--
-- Table structure for table `assignment_pa3_completions`
--

CREATE TABLE `assignment_pa3_completions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `sr_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_date` date DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `applicant_notified` tinyint(1) NOT NULL DEFAULT '0',
  `notified_at` timestamp NULL DEFAULT NULL,
  `notification_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notification_subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notification_message` text COLLATE utf8mb4_unicode_ci,
  `created_by` bigint unsigned DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `assignment_pa3_completions_assignment_id_unique` (`assignment_id`),
  CONSTRAINT `assignment_pa3_completions_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_pa3_completions`
--

INSERT INTO `assignment_pa3_completions` VALUES (1,15,'PA-0012-SR-20260513','2026-05-13',NULL,0,NULL,NULL,'Completion Notification — Case PA-0012','Dear Sir/Madam,\n\nWe are pleased to inform you that case PA-0012 for vessel A.M.K. MARIN has been completed.\n\nSurvey types: \n\nPlease do not hesitate to contact us for any further information.\n\nKind regards,\nINSB',1,1,'2026-05-13 11:34:04','2026-05-13 11:34:04');

--
-- Table structure for table `assignment_receive_report_amendments`
--

CREATE TABLE `assignment_receive_report_amendments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `message_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amendment_date` date DEFAULT NULL,
  `message_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignment_receive_report_amendments_assignment_id_foreign` (`assignment_id`),
  KEY `assignment_receive_report_amendments_created_by_foreign` (`created_by`),
  CONSTRAINT `assignment_receive_report_amendments_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_receive_report_amendments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_receive_report_amendments`
--

INSERT INTO `assignment_receive_report_amendments` VALUES (7,1,'σδφσδφσφδ',NULL,NULL,NULL,1,'2026-05-07 10:32:09','2026-05-07 10:32:09'),(8,1,'σδφσδφσφδ','2026-05-07',NULL,NULL,1,'2026-05-07 10:32:25','2026-05-07 10:32:25');

--
-- Table structure for table `assignment_receive_sr_certificates`
--

CREATE TABLE `assignment_receive_sr_certificates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `sr_form_received_in_order` tinyint(1) NOT NULL DEFAULT '0',
  `safety_equipment_report_received` tinyint(1) NOT NULL DEFAULT '0',
  `sr_form_amendments_requested` tinyint(1) NOT NULL DEFAULT '0',
  `certificates_received_in_order` tinyint(1) NOT NULL DEFAULT '0',
  `supporting_documents_received` tinyint(1) NOT NULL DEFAULT '0',
  `certificates_amendments_requested` tinyint(1) NOT NULL DEFAULT '0',
  `amendment_message_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amendment_message_references` json DEFAULT NULL COMMENT 'JSON array of {ref, url} objects — history of amendment messages',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `assignment_receive_sr_certificates_assignment_id_unique` (`assignment_id`),
  KEY `assignment_receive_sr_certificates_updated_by_foreign` (`updated_by`),
  CONSTRAINT `assignment_receive_sr_certificates_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_receive_sr_certificates_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_receive_sr_certificates`
--

INSERT INTO `assignment_receive_sr_certificates` VALUES (1,1,0,0,1,0,0,1,'ηγη',NULL,'φδσδ',1,'2026-04-30 12:35:04','2026-05-07 10:11:39'),(2,7,1,0,0,1,0,0,NULL,NULL,NULL,1,'2026-05-11 10:28:05','2026-05-11 10:28:05'),(3,13,0,0,1,0,0,0,NULL,'[{\"ref\": \"ref-1234\", \"url\": \"\"}]','ddfvr er r',1,'2026-05-13 07:22:05','2026-05-13 07:22:05');

--
-- Table structure for table `assignment_step_extra_forms`
--

CREATE TABLE `assignment_step_extra_forms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `wizard_step` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `form_template_code` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `context_key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'blue',
  `icon` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'file-alt',
  `sort_order` smallint unsigned NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignment_step_extra_forms_wizard_step_index` (`wizard_step`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_step_extra_forms`
--


--
-- Table structure for table `assignment_surveyor`
--

CREATE TABLE `assignment_surveyor` (
  `surveyor_id` bigint unsigned NOT NULL,
  `assignment_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `assignment_surveyor_unique` (`surveyor_id`,`assignment_id`),
  KEY `assignment_surveyor_surveyor_id_index` (`surveyor_id`),
  KEY `assignment_surveyor_assignment_id_index` (`assignment_id`),
  CONSTRAINT `assignment_surveyor_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_surveyor_surveyor_id_foreign` FOREIGN KEY (`surveyor_id`) REFERENCES `surveyors` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_surveyor`
--


--
-- Table structure for table `assignment_surveyor_evaluations`
--

CREATE TABLE `assignment_surveyor_evaluations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `surveyor_id` bigint unsigned DEFAULT NULL,
  `surveyor_evaluated` tinyint(1) NOT NULL DEFAULT '0',
  `score_time_period` tinyint unsigned DEFAULT NULL,
  `score_compliance` tinyint unsigned DEFAULT NULL,
  `score_completeness` tinyint unsigned DEFAULT NULL,
  `score_omissions` tinyint unsigned DEFAULT NULL,
  `score_terminology` tinyint unsigned DEFAULT NULL,
  `eval_score` decimal(2,1) DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `assignment_surveyor_evaluations_assignment_id_unique` (`assignment_id`),
  KEY `assignment_surveyor_evaluations_updated_by_foreign` (`updated_by`),
  KEY `assignment_surveyor_evaluations_surveyor_id_foreign` (`surveyor_id`),
  CONSTRAINT `assignment_surveyor_evaluations_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_surveyor_evaluations_surveyor_id_foreign` FOREIGN KEY (`surveyor_id`) REFERENCES `surveyors` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assignment_surveyor_evaluations_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_surveyor_evaluations`
--

INSERT INTO `assignment_surveyor_evaluations` VALUES (2,1,1,1,4,4,4,5,2,4.8,'δσφσ',1,'2026-04-30 12:58:57','2026-05-12 13:20:37'),(3,13,1,1,4,3,4,3,3,4.3,'sgsdfs',1,'2026-05-13 07:37:06','2026-05-13 07:37:06'),(4,14,NULL,1,4,4,4,5,3,5.0,NULL,1,'2026-05-13 10:52:51','2026-05-13 10:52:51');

--
-- Table structure for table `assignment_surveys`
--

CREATE TABLE `assignment_surveys` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `survey_type_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignment_surveys_assignment_id_index` (`assignment_id`),
  KEY `assignment_surveys_survey_type_id_index` (`survey_type_id`),
  CONSTRAINT `assignment_surveys_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_surveys_survey_type_id_foreign` FOREIGN KEY (`survey_type_id`) REFERENCES `survey_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_surveys`
--

INSERT INTO `assignment_surveys` VALUES (1,1,39,'2026-04-30 11:03:00','2026-04-30 11:03:00'),(2,3,39,'2026-05-05 10:05:40','2026-05-05 10:05:40'),(3,4,46,'2026-05-05 12:40:58','2026-05-05 12:40:58'),(4,5,39,'2026-05-07 12:44:22','2026-05-07 12:44:22'),(5,10,40,'2026-05-12 10:55:34','2026-05-12 10:55:34'),(6,11,41,'2026-05-12 11:04:45','2026-05-12 11:04:45'),(7,12,45,'2026-05-12 11:36:26','2026-05-12 11:36:26'),(8,13,39,'2026-05-13 06:47:08','2026-05-13 06:47:08');

--
-- Table structure for table `assignment_update_survey_statuses`
--

CREATE TABLE `assignment_update_survey_statuses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `forwarded_to_concerned_party` tinyint(1) NOT NULL DEFAULT '0',
  `payload` json DEFAULT NULL,
  `warnings` json DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `assignment_update_survey_statuses_assignment_id_unique` (`assignment_id`),
  KEY `assignment_update_survey_statuses_updated_by_foreign` (`updated_by`),
  CONSTRAINT `assignment_update_survey_statuses_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignment_update_survey_statuses_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignment_update_survey_statuses`
--

INSERT INTO `assignment_update_survey_statuses` VALUES (4,1,1,'{\"rows\": {\"category:14:name:1\": {\"remarks\": null, \"done_date\": \"2026-05-11\", \"manual_due\": null, \"manual_rangeto\": null, \"anniversary_date\": \"2026-05-11\", \"manual_postponed\": null, \"manual_rangefrom\": null}}, \"certificates\": {\"assignment-certificate-1\": {\"kind\": \"statutory\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-22\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"International Oil Pollution Prevention Certificate\", \"short_term_reason\": \"ζχψζχψ\", \"certificate_number\": \"231\", \"assignment_certificate_id\": 1}, \"assignment-certificate-2\": {\"kind\": \"class\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Class Refrigerating Installation\", \"short_term_reason\": \"ζχψζχψ\", \"certificate_number\": \"1234123\", \"assignment_certificate_id\": 2}, \"assignment-certificate-3\": {\"kind\": \"statutory\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Fitness for the Carriage of Liquified Gases in Bulk\", \"short_term_reason\": \"ζχψζχψ\", \"certificate_number\": \"141231\", \"assignment_certificate_id\": 3}, \"assignment-certificate-4\": {\"kind\": \"class\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Class Refrigerating Installation\", \"short_term_reason\": \"ζχψζ\", \"certificate_number\": \"141231132\", \"assignment_certificate_id\": 4}, \"assignment-certificate-5\": {\"kind\": \"statutory\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-07\", \"expiry_date\": \"2026-05-07\", \"draft_status\": \"draft\", \"validity_type\": \"short_term\", \"validity_value\": \"60 months\", \"certificate_name\": \"Fitness for the Carriage of Liquified Gases in Bulk\", \"short_term_reason\": \"σδφ\", \"certificate_number\": \"14231313\", \"assignment_certificate_id\": 5}}, \"observations\": {\"memos\": {\"source-3\": {\"kind\": null, \"status\": \"open\", \"live_id\": null, \"due_date\": null, \"posed_date\": \"2026-05-30\", \"description\": \"ασδα\", \"source_observation_id\": 3}, \"live-memo-1\": {\"kind\": null, \"status\": \"open\", \"live_id\": 1, \"due_date\": null, \"posed_date\": \"2026-05-30\", \"description\": \"ασδα\", \"source_observation_id\": 3}}, \"memoranda\": {\"source-2\": {\"kind\": null, \"status\": \"open\", \"live_id\": null, \"due_date\": null, \"posed_date\": \"2026-06-13\", \"description\": \"δσασδ\", \"source_observation_id\": 2}, \"live-memorandum-1\": {\"kind\": null, \"status\": \"open\", \"live_id\": 1, \"due_date\": null, \"posed_date\": \"2026-06-13\", \"description\": \"δσασδ\", \"source_observation_id\": 2}}, \"recommendations\": {\"source-1\": {\"kind\": \"class\", \"status\": \"open\", \"live_id\": null, \"due_date\": \"2026-05-29\", \"posed_date\": \"2026-05-29\", \"description\": \"φδασφ\", \"source_observation_id\": 1}, \"live-recommendation-1\": {\"kind\": \"class\", \"status\": \"open\", \"live_id\": 1, \"due_date\": \"2026-05-29\", \"posed_date\": \"2026-05-29\", \"description\": \"φδασφ\", \"source_observation_id\": 1}}}}','[]',NULL,1,'2026-05-11 07:04:33','2026-05-11 07:08:38'),(6,14,1,'{\"rows\": [], \"certificates\": {\"new-certificate-1\": {\"kind\": \"class\", \"live_id\": null, \"file_path\": null, \"issue_date\": \"2026-05-13\", \"expiry_date\": \"2031-05-13\", \"draft_status\": \"issued\", \"validity_type\": \"full_term\", \"validity_value\": \"Full Term\", \"certificate_name\": \"Safety Management Certificate\", \"short_term_reason\": null, \"certificate_number\": \"CERT-2026-001\", \"assignment_certificate_id\": null}}, \"observations\": []}','[]',NULL,1,'2026-05-13 10:58:37','2026-05-13 10:58:37');

--
-- Table structure for table `assignments`
--

CREATE TABLE `assignments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `case_id` bigint unsigned NOT NULL,
  `department_id` bigint unsigned DEFAULT NULL,
  `assigned_to` bigint unsigned DEFAULT NULL,
  `assignment_date` date NOT NULL,
  `status` enum('active','completed','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `current_step` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1-8 or PA1-PA4',
  `other_functions_notes` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `assignments_case_id_foreign` (`case_id`),
  KEY `assignments_department_id_foreign` (`department_id`),
  KEY `assignments_assigned_to_index` (`assigned_to`),
  KEY `assignments_created_by_foreign` (`created_by`),
  CONSTRAINT `assignments_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `surveyors` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assignments_case_id_foreign` FOREIGN KEY (`case_id`) REFERENCES `cases` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assignments_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assignments`
--

INSERT INTO `assignments` VALUES (1,1,3,1,'2026-04-30','active',1,'2026-04-30 11:03:00','2026-05-11 07:08:38','8',NULL),(3,3,5,1,'2026-05-05','active',1,'2026-05-05 10:05:40','2026-05-05 11:18:03','2',NULL),(4,4,5,1,'2026-05-05','active',1,'2026-05-05 12:40:58','2026-05-07 14:22:08','4',NULL),(5,6,7,1,'2026-05-07','active',1,'2026-05-07 12:44:22','2026-05-07 13:46:32','2',NULL),(6,7,2,NULL,'2026-04-29','active',1,'2026-05-11 07:34:19','2026-05-11 07:34:19','3',NULL),(7,8,2,NULL,'2026-05-06','active',1,'2026-05-11 07:34:19','2026-05-11 10:40:48','4',NULL),(8,9,1,NULL,'2026-04-21','active',1,'2026-05-11 07:34:19','2026-05-11 07:34:19','3',NULL),(9,10,6,NULL,'2026-05-08','active',1,'2026-05-11 07:34:19','2026-05-11 07:34:19','3',NULL),(10,3,5,1,'2026-05-12','active',1,'2026-05-12 10:55:34','2026-05-12 10:56:03','2',NULL),(11,3,5,1,'2026-05-12','active',1,'2026-05-12 11:04:45','2026-05-12 11:05:03','2',NULL),(12,4,5,1,'2026-05-12','active',1,'2026-05-12 11:36:26','2026-05-12 11:36:42','2',NULL),(13,5,2,1,'2026-05-13','active',1,'2026-05-13 06:47:08','2026-05-13 09:38:31','7','Test notes from automated testing - Save Draft check'),(14,11,7,NULL,'2026-05-13','active',NULL,'2026-05-13 10:48:25','2026-05-13 10:58:37','8',NULL),(15,12,5,1,'2026-05-13','completed',1,'2026-05-13 11:21:00','2026-05-13 11:34:35','4',NULL);

--
-- Table structure for table `auto_backups`
--

CREATE TABLE `auto_backups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `auto_backups`
--

INSERT INTO `auto_backups` VALUES (1,'Daily','Backup every day','2026-03-12 11:46:47','2026-03-12 11:46:47'),(2,'Weekly','Backup every week','2026-03-12 11:46:47','2026-03-12 11:46:47'),(3,'Monthly','Backup every month','2026-03-12 11:46:47','2026-03-12 11:46:47'),(4,'Disabled','Disable automatic backups','2026-03-12 11:46:47','2026-03-12 11:46:47');

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `survey_type` text COLLATE utf8mb4_unicode_ci,
  `ship_id` bigint unsigned NOT NULL,
  `ship_insbnumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preferred_date` date NOT NULL,
  `alternative_date` date DEFAULT NULL,
  `additional_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `reference_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `port` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `applicant_fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` VALUES (7,21,'Hull - Intermediate, Machinery - Special',102,NULL,'2025-09-25',NULL,NULL,'SRV-100005','2025-09-25 08:02:31','2025-09-25 08:02:31','σαδασ',NULL),(8,21,'Load Line - Renewal',302,NULL,'2025-09-25',NULL,NULL,'SRV-100006','2025-09-25 08:10:08','2025-09-25 08:10:08','sas',NULL),(9,21,'Hull - Annual',248,NULL,'2025-09-25',NULL,NULL,'SRV-100007','2025-09-25 08:19:06','2025-09-25 08:19:06','dfdasa',NULL),(10,21,'Hull - Annual',301,NULL,'2025-09-26','2025-09-30','adsa','SRV-100008','2025-09-25 08:26:14','2025-09-25 08:26:14','Piraeus','MICHAEL PANAGIOTOPOULOS'),(11,21,'αδαα',301,NULL,'2025-09-26','2025-10-09','adasd','SRV-100009','2025-09-26 13:31:48','2025-09-26 13:31:48','Piraeus',NULL),(12,21,'Machinery - Special, Bottom Survey on Dry Dock - -',102,NULL,'2025-09-30',NULL,NULL,'SRV-100010','2025-09-29 07:18:22','2025-09-29 07:18:22','sfsdfs',NULL),(13,21,'MLC Shipboard Inspection (5) - Renewal',435,NULL,'2025-10-02',NULL,NULL,'SRV-100011','2025-10-02 07:48:39','2025-10-02 07:48:39','ασδ',NULL),(14,21,'MLC Shipboard Inspection (5) - Renewal',435,NULL,'2025-10-02',NULL,NULL,'SRV-100012','2025-10-02 07:56:43','2025-10-02 07:56:43','adsa','adsda'),(15,21,'Load Line - Renewal',102,NULL,'2025-10-02',NULL,NULL,'SRV-100013','2025-10-02 07:58:40','2025-10-02 07:58:40','dasda',NULL),(16,21,'Load Line - Renewal',301,NULL,'2025-10-02',NULL,NULL,'SRV-100014','2025-10-02 08:00:14','2025-10-02 08:00:14','sasd',NULL),(17,21,'dsa, dsaasda, Hull - Special, Hull - Annual, ISM Company audit (5) - Renewal',102,NULL,'2025-10-02',NULL,NULL,'SRV-100015','2025-10-02 09:09:27','2025-10-02 09:09:27','asda',NULL),(18,21,'Hull - Special',102,NULL,'2025-10-02',NULL,NULL,'SRV-100016','2025-10-02 09:44:46','2025-10-02 09:44:46','piraeus',NULL),(19,21,'Hull - Special',301,NULL,'2025-10-02',NULL,NULL,'SRV-100017','2025-10-02 09:48:03','2025-10-02 09:48:03','daa',NULL),(20,21,'Hull - Special',102,NULL,'2025-10-02',NULL,NULL,'SRV-100018','2025-10-02 09:51:07','2025-10-02 09:51:07','adad',NULL),(21,21,'Hull - Special',102,NULL,'2025-10-23',NULL,NULL,'SRV-100019','2025-10-02 09:54:49','2025-10-02 09:54:49','ada',NULL),(22,21,'Hull - Intermediate',102,NULL,'2025-10-31','2025-11-06','jadc is guisadga','SRV-100020','2025-10-02 10:08:22','2025-10-02 10:08:22','Piraeus','Nikos Voutsinas'),(23,21,'Hull - Special',102,NULL,'2025-10-02','2025-10-16','asdas','SRV-100021','2025-10-02 10:17:48','2025-10-02 10:17:48','Piraeus',NULL),(24,21,'ISM vessel audit (5) - Renewal',126,NULL,'2025-10-02',NULL,NULL,'SRV-100022','2025-10-02 10:27:58','2025-10-02 10:27:58','adasdda',NULL),(25,21,'Inventory of Hazardous Material(s) - Renewal',103,NULL,'2025-10-09',NULL,NULL,'SRV-100023','2025-10-09 06:50:19','2025-10-09 06:50:19','PIRAEUS',NULL),(26,21,'Bottom Survey on Dry Dock - -',437,NULL,'2025-10-09',NULL,NULL,'SRV-100024','2025-10-09 06:57:12','2025-10-09 06:57:12','KAVALA',NULL),(27,21,'Hull - Special, Hull - Annual, Load Line - Renewal, d, df, dfa, dfad, dfads, dfadsf, dfadsfa',302,NULL,'2025-10-13',NULL,NULL,'SRV-100025','2025-10-13 07:20:33','2025-10-13 07:20:33','Piraeus',NULL),(28,21,'Machinery - Special, Hull - Special, MLC Shipboard Inspection (5) - Renewal, w, we, wew, weww, wewwe',102,NULL,'2025-10-13',NULL,NULL,'SRV-100026','2025-10-13 07:21:43','2025-10-13 07:21:43','Kavala',NULL),(29,21,'d, da, daf, dafd, dafda, dafdas',301,NULL,'2025-10-13',NULL,NULL,'SRV-100027','2025-10-13 07:25:49','2025-10-13 07:25:49','SDDFS',NULL),(30,21,'Hull - Special, Hull - Intermediate, a, ad, adf, adfa, adfas, adfasa',302,NULL,'2025-10-13',NULL,NULL,'SRV-100028','2025-10-13 07:30:56','2025-10-13 07:30:56','adas',NULL),(31,21,'α, ασ, ασδ, ασδα, ασδασ',302,NULL,'2025-10-13',NULL,NULL,'SRV-100029','2025-10-13 07:32:51','2025-10-13 07:32:51','αδσα',NULL),(32,21,'α, αδ, αδσ, αδσα, αδσαα, αδσααα, αδσαααδ',302,NULL,'2025-10-13',NULL,NULL,'SRV-100030','2025-10-13 07:34:37','2025-10-13 07:34:37','αδασδα',NULL),(33,21,'α, αδ, αδφ, αδφα, αδφαδ, αδφαδδ, αδφαδδα',286,NULL,'2025-10-13',NULL,NULL,'SRV-100031','2025-10-13 07:39:02','2025-10-13 07:39:02','ασδα',NULL),(34,21,'A, AF, AFD, AFDA, AFDAS, AFDASD',302,NULL,'2025-10-13',NULL,NULL,'SRV-100032','2025-10-13 07:50:59','2025-10-13 07:50:59','ADS',NULL),(35,21,'αδασδ',302,NULL,'2025-10-13',NULL,NULL,'SRV-100033','2025-10-13 07:57:17','2025-10-13 07:57:17','αδαδσα',NULL),(36,21,'Hull - Special',362,NULL,'2025-10-22',NULL,'dsdf','SRV-100034','2025-10-22 12:24:59','2025-10-22 12:24:59','Piraeus',NULL),(37,21,'Hull - Special, Hull - Intermediate',450,NULL,'2025-11-20','2025-11-21','RTWRT','SRV-100035','2025-11-17 13:31:04','2025-11-17 13:31:04','PIRAEUS','Nikos Voutsi'),(38,21,'Hull - Special, Hull - Intermediate',450,NULL,'2025-11-20','2025-11-21','RTWRT','SRV-100036','2025-11-17 13:31:27','2025-11-17 13:31:27','PIRAEUS','Nikos Voutsi'),(39,21,'Pleasure Yachts - Renewal',49,NULL,'2025-11-26','2025-12-06','SDFSFS','SRV-100037','2025-11-17 13:35:11','2025-11-17 13:35:11','PIRAEUS','ADFFDAS'),(40,21,'Load Line - Annual, Safety Construction - Annual',303,NULL,'2025-11-19','2025-11-20','ADAS','SRV-100038','2025-11-17 13:37:45','2025-11-17 13:37:45','PIRAEUS PORT','ASDADS'),(41,21,'Crew Accommodation (4) - Renewal',63,NULL,'2025-11-21','2025-11-23','SFSDFS','SRV-100039','2025-11-17 13:41:43','2025-11-17 13:41:43','KAVALA','SDFS'),(42,21,'Pleasure Yachts - Renewal',49,NULL,'2025-11-29','2025-11-30','DFASDA','SRV-100040','2025-11-17 13:43:05','2025-11-17 13:43:05','PIRAEUS','ASDADA'),(43,21,'Hull - Intermediate',78,NULL,'2025-12-05','2025-12-06','FSDF','SRV-100041','2025-11-17 13:46:53','2025-11-17 13:46:53','PIRAEUS','SDFSDFD'),(44,21,'Hull - Annual',11,NULL,'2025-11-19','2025-11-21','DSDA','SRV-100042','2025-11-17 13:52:42','2025-11-17 13:52:42','PIRAEUS','ASDASD'),(45,21,'Hull - Intermediate',78,NULL,'2025-11-21','2025-11-27','ADSDA','SRV-100043','2025-11-17 13:54:37','2025-11-17 13:54:37','PIRAEUS','ASDASDA'),(49,21,'Hull - Intermediate',160,'6423','2025-12-03',NULL,NULL,'SRV-100047','2025-12-01 09:48:01','2025-12-01 09:48:01','test_port','test applicant'),(50,21,'Bottom Survey on Dry Dock - -',160,'6423','2025-12-17',NULL,NULL,'SRV-100048','2025-12-01 10:02:57','2025-12-01 10:02:57','PIRAEUS','TEST TEST'),(54,21,'Hull - Annual',356,'6830','2025-12-19',NULL,NULL,'SRV-100003','2025-12-02 08:15:03','2025-12-02 08:15:03','hgfyhg','dfsvcsd'),(55,21,'Load Line - Annual',160,'6423','2025-12-03','2025-12-04','FSG','SRV-100004','2025-12-02 08:38:14','2025-12-02 08:38:14','THESSALONIKI','nikos voutsi'),(56,21,'Safety Equipment (non-convention) - Annual',483,'6958','2025-12-30','2025-12-31','DFAQQ','SRV-21-100005','2025-12-02 09:10:37','2025-12-02 09:10:37','AMSTERDAM','nikos'),(57,21,'Hull - Annual',450,'6837','2025-12-11',NULL,'sdfs','SRV-21-100006','2025-12-02 09:13:19','2025-12-02 09:13:19','sdfs','ssdfs'),(58,21,'International Air Pollution Prevention - Renewal, International Sewage Pollution Prevention - Renewal, Inventory of Hazardous Material(s) - Renewal, Anti-fouling Systems - Renewal',490,'6952','2025-12-04',NULL,NULL,'SRV-21-100007','2025-12-04 12:11:59','2025-12-04 12:11:59','PIRAUES','TEST'),(59,21,'MLC Shipboard Inspection (5) - Interim, ISM Company audit (5) - Renewal, ISPS vessel audit (5) - Interim',490,'6952','2025-12-04',NULL,'SADA','SRV-21-100008','2025-12-04 12:13:40','2025-12-04 12:13:40','PIRAEUS','TEST'),(60,21,'ISM Company audit (5) - Renewal, ISM vessel audit (5) - Renewal, ISPS vessel audit (5) - Renewal, MLC Shipboard Inspection (5) - Renewal',490,'6952','2025-12-06','2025-12-07','DDAS','SRV-21-100009','2025-12-04 12:20:30','2025-12-04 12:20:30','KAVALA','NIKOS VOUTSI');

--
-- Table structure for table `case_services`
--

CREATE TABLE `case_services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `case_id` bigint unsigned NOT NULL,
  `survey_type_id` bigint unsigned NOT NULL,
  `source` enum('manual','book_survey','portal') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'manual',
  `approval_type` enum('approval','acceptance') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Acceptance for PA only',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `case_survey_type_case_record_id_index` (`case_id`),
  KEY `case_survey_type_survey_type_id_index` (`survey_type_id`),
  CONSTRAINT `case_survey_type_case_record_id_foreign` FOREIGN KEY (`case_id`) REFERENCES `cases` (`id`) ON DELETE CASCADE,
  CONSTRAINT `case_survey_type_survey_type_id_foreign` FOREIGN KEY (`survey_type_id`) REFERENCES `survey_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `case_services`
--

INSERT INTO `case_services` VALUES (3,1,39,'manual','approval',NULL,'2026-03-27 10:14:55','2026-03-27 10:14:55'),(4,3,39,'manual',NULL,NULL,'2026-05-05 10:04:30','2026-05-05 10:04:30'),(5,3,40,'manual',NULL,NULL,'2026-05-05 10:04:30','2026-05-05 10:04:30'),(6,3,41,'manual',NULL,NULL,'2026-05-05 10:04:30','2026-05-05 10:04:30'),(7,4,46,'manual','approval',NULL,'2026-05-05 12:28:04','2026-05-05 12:28:04'),(8,4,45,'manual',NULL,NULL,'2026-05-05 12:28:04','2026-05-05 12:28:04'),(9,4,58,'manual',NULL,NULL,'2026-05-05 12:28:04','2026-05-05 12:28:04'),(10,5,39,'manual',NULL,NULL,'2026-05-06 12:07:43','2026-05-06 12:07:43'),(11,6,39,'manual',NULL,NULL,'2026-05-07 12:44:11','2026-05-07 12:44:11'),(12,12,46,'manual',NULL,NULL,'2026-05-13 11:20:23','2026-05-13 11:20:23'),(13,12,45,'manual',NULL,NULL,'2026-05-13 11:20:23','2026-05-13 11:20:23');

--
-- Table structure for table `case_statuses`
--

CREATE TABLE `case_statuses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `case_statuses`
--

INSERT INTO `case_statuses` VALUES (1,'Application Received','2026-03-10 08:58:52','2026-03-10 08:58:52'),(2,'Application Received (New Entry)','2026-03-10 08:58:52','2026-03-10 08:58:52'),(3,'Requirements sent','2026-03-10 08:58:52','2026-03-10 08:58:52'),(4,'Instructions released','2026-03-10 08:58:52','2026-03-10 08:58:52'),(5,'Case partly completed','2026-03-10 08:58:52','2026-03-10 08:58:52'),(6,'Case completed','2026-03-10 08:58:52','2026-03-10 08:58:52'),(7,'Cases cancelled','2026-03-10 08:58:52','2026-03-10 08:58:52'),(8,'Reports received','2026-03-10 08:58:52','2026-03-10 08:58:52'),(9,'Reports assigned','2026-03-10 08:58:52','2026-03-10 08:58:52'),(10,'Reports considered','2026-03-10 08:58:52','2026-03-10 08:58:52'),(11,'Non-active archive','2026-05-11 07:17:54','2026-05-11 07:17:54'),(12,'Pause','2026-05-11 10:23:32','2026-05-11 10:23:32');

--
-- Table structure for table `cases`
--

CREATE TABLE `cases` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `case_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ship_id` bigint unsigned NOT NULL,
  `applicant_id` bigint unsigned NOT NULL,
  `managing_company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `status` bigint unsigned NOT NULL,
  `status_id` bigint unsigned DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT NULL,
  `department_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cases_case_id_unique` (`case_id`),
  KEY `cases_ship_id_foreign` (`ship_id`),
  KEY `cases_applicant_id_foreign` (`applicant_id`),
  KEY `cases_status_foreign` (`status`),
  KEY `cases_created_by_foreign` (`created_by`),
  KEY `cases_department_id_foreign` (`department_id`),
  CONSTRAINT `cases_applicant_id_foreign` FOREIGN KEY (`applicant_id`) REFERENCES `offices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cases_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `cases_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `cases_ship_id_foreign` FOREIGN KEY (`ship_id`) REFERENCES `ships` (`ship_id`) ON DELETE CASCADE,
  CONSTRAINT `cases_status_foreign` FOREIGN KEY (`status`) REFERENCES `case_statuses` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cases`
--

INSERT INTO `cases` VALUES (1,'APPR-0001',1,1,NULL,NULL,10,NULL,1,2,'2026-03-10 11:43:07','2026-05-12 13:20:37'),(2,'SSCD-0008',4,3,NULL,NULL,7,NULL,1,1,'2026-03-10 11:51:33','2026-05-07 08:38:40'),(3,'PAD-0003',478,44,'δφσδφ','σδφσφ',1,NULL,1,5,'2026-05-05 10:04:30','2026-05-05 11:09:28'),(4,'PAD-0004',323,46,NULL,NULL,1,NULL,1,5,'2026-05-05 12:28:04','2026-05-05 12:28:04'),(5,'SSCD-0005',159,46,'jfjh',NULL,3,NULL,4,2,'2026-05-06 12:07:43','2026-05-13 09:38:31'),(6,'GFSD-0006',244,44,'φδσαφ','ασδφαδα',1,NULL,1,7,'2026-05-07 12:44:11','2026-05-07 12:44:11'),(7,'DEMO-SIS-0001',417,1,NULL,'Annual hull survey – pending admin check',4,NULL,1,2,'2026-05-11 07:34:19','2026-05-11 07:34:19'),(8,'DEMO-SIS-0002',233,1,NULL,'Intermediate survey – awaiting report review',3,NULL,1,2,'2026-05-11 07:34:19','2026-05-11 10:40:48'),(9,'DEMO-MMSC-0001',92,1,NULL,'ISM/ISPS audit – reports pending coordinator check',4,NULL,1,1,'2026-05-11 07:34:19','2026-05-11 07:34:19'),(10,'DEMO-OFH-0001',333,1,NULL,'Offshore unit inspection – Step 3 pending',4,NULL,1,6,'2026-05-11 07:34:19','2026-05-11 07:34:19'),(11,'TEEPD-0001',89,1,NULL,NULL,10,NULL,NULL,7,'2026-05-13 10:48:06','2026-05-13 10:52:51'),(12,'PA-0012',323,44,NULL,NULL,6,NULL,1,5,'2026-05-13 11:20:23','2026-05-13 11:34:35');

--
-- Table structure for table `certificates`
--

CREATE TABLE `certificates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `shipid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `no` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `issued` date DEFAULT NULL,
  `expiry` date DEFAULT NULL,
  `extended` date DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kind` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source_assignment_id` bigint unsigned DEFAULT NULL,
  `assignment_certificate_id` bigint unsigned DEFAULT NULL,
  `validity_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `draft_status` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `certificates_shipid_index` (`shipid`),
  KEY `certificates_shipid_source_assignment_index` (`shipid`,`source_assignment_id`),
  KEY `certificates_assignment_certificate_index` (`assignment_certificate_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `certificates`
--

INSERT INTO `certificates` VALUES (1,'1','International Oil Pollution Prevention Certificate','231','2026-05-22','2026-05-07',NULL,'60 months','draft','Statutory',1,1,'short_term','draft',NULL,'ζχψζχψ','2026-05-11 07:04:33','2026-05-11 07:04:33',NULL),(2,'1','Class Refrigerating Installation','1234123','2026-05-07','2026-05-07',NULL,'60 months','draft','Class',1,2,'short_term','draft',NULL,'ζχψζχψ','2026-05-11 07:04:33','2026-05-11 07:04:33',NULL),(3,'1','Fitness for the Carriage of Liquified Gases in Bulk','141231','2026-05-07','2026-05-07',NULL,'60 months','draft','Statutory',1,3,'short_term','draft',NULL,'ζχψζχψ','2026-05-11 07:04:33','2026-05-11 07:04:33',NULL),(4,'1','Class Refrigerating Installation','141231132','2026-05-07','2026-05-07',NULL,'60 months','draft','Class',1,4,'short_term','draft',NULL,'ζχψζ','2026-05-11 07:04:33','2026-05-11 07:04:33',NULL),(5,'1','Fitness for the Carriage of Liquified Gases in Bulk','14231313','2026-05-07','2026-05-07',NULL,'60 months','draft','Statutory',1,5,'short_term','draft',NULL,'σδφ','2026-05-11 07:04:33','2026-05-11 07:04:33',NULL),(6,'89','Safety Management Certificate','CERT-2026-001','2026-05-13','2031-05-13',NULL,'Full Term','issued','Class',14,NULL,'full_term','issued',NULL,NULL,'2026-05-13 10:58:37','2026-05-13 10:58:37',NULL);

--
-- Table structure for table `class_action_reasons`
--

CREATE TABLE `class_action_reasons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `class_action_reasons_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `class_action_reasons`
--

INSERT INTO `class_action_reasons` VALUES (1,'OS','Overdue Surveys','2026-04-30 08:12:04','2026-04-30 08:12:04'),(2,'OREC','Overdue Recommendations','2026-04-30 08:12:04','2026-04-30 08:12:04'),(3,'NCCC','Non-Compliance with condition(s) of Class','2026-04-30 08:12:04','2026-04-30 08:12:04'),(4,'OWR','At Owner\'s request','2026-04-30 08:12:04','2026-04-30 08:12:04'),(5,'TOC','Transfer of Class to other society','2026-04-30 08:12:04','2026-04-30 08:12:04'),(6,'DMG','Due to damage occurred','2026-04-30 08:12:04','2026-04-30 08:12:04');

--
-- Table structure for table `class_action_statuses`
--

CREATE TABLE `class_action_statuses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `class_action_statuses_title_unique` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `class_action_statuses`
--

INSERT INTO `class_action_statuses` VALUES (1,'Draft','2026-04-30 08:12:04','2026-04-30 08:12:04'),(2,'Pending Approval','2026-04-30 08:12:04','2026-04-30 08:12:04'),(3,'Approved','2026-04-30 08:12:04','2026-04-30 08:12:04'),(4,'Notifications Sent','2026-04-30 08:12:04','2026-04-30 08:12:04'),(5,'Records Archived','2026-04-30 08:12:04','2026-04-30 08:12:04'),(6,'Completed','2026-04-30 08:12:04','2026-04-30 08:12:04');

--
-- Table structure for table `class_action_types`
--

CREATE TABLE `class_action_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `class_action_types_title_unique` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `class_action_types`
--

INSERT INTO `class_action_types` VALUES (1,'Suspension','2026-04-30 08:12:04','2026-04-30 08:12:04'),(2,'Withdrawal','2026-04-30 08:12:04','2026-04-30 08:12:04'),(3,'Reinstatement','2026-04-30 08:12:04','2026-04-30 08:12:04');

--
-- Table structure for table `class_actions`
--

CREATE TABLE `class_actions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `action_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notice_date` date DEFAULT NULL,
  `notice_from` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notice_to` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ship_id` bigint unsigned NOT NULL,
  `insb_class_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `imo_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flag` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class_action_type_id` bigint unsigned NOT NULL,
  `class_action_status_id` bigint unsigned NOT NULL,
  `class_reason_id` bigint unsigned DEFAULT NULL,
  `reason_details` text COLLATE utf8mb4_unicode_ci,
  `notification_recipients` json DEFAULT NULL,
  `submitted_at` timestamp NULL DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `approved_by` bigint unsigned DEFAULT NULL,
  `initiated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `class_actions_action_id_unique` (`action_id`),
  KEY `class_actions_ship_id_index` (`ship_id`),
  KEY `class_actions_class_action_type_id_index` (`class_action_type_id`),
  KEY `class_actions_class_action_status_id_index` (`class_action_status_id`),
  KEY `class_actions_class_reason_id_index` (`class_reason_id`),
  KEY `class_actions_initiated_by_index` (`initiated_by`),
  KEY `class_actions_approved_by_index` (`approved_by`),
  CONSTRAINT `class_actions_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `class_actions_class_action_status_id_foreign` FOREIGN KEY (`class_action_status_id`) REFERENCES `class_action_statuses` (`id`) ON DELETE RESTRICT,
  CONSTRAINT `class_actions_class_action_type_id_foreign` FOREIGN KEY (`class_action_type_id`) REFERENCES `class_action_types` (`id`) ON DELETE RESTRICT,
  CONSTRAINT `class_actions_class_reason_id_foreign` FOREIGN KEY (`class_reason_id`) REFERENCES `class_action_reasons` (`id`) ON DELETE RESTRICT,
  CONSTRAINT `class_actions_initiated_by_foreign` FOREIGN KEY (`initiated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `class_actions_ship_id_foreign` FOREIGN KEY (`ship_id`) REFERENCES `ships` (`ship_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `class_actions`
--

INSERT INTO `class_actions` VALUES (1,'CA-2026-0001','2026-04-28',NULL,NULL,73,'6124','8972261','Panama',1,1,1,NULL,'[\"insb_station\", \"mous\", \"internally\"]',NULL,NULL,NULL,1,'2026-04-28 13:39:47','2026-04-28 14:30:54');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `countries_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'Unknown','ΧΧ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(5,'Afghanistan','AF','2025-03-12 23:43:26','2025-03-12 23:43:26'),(6,'Åland Islands','AX','2025-03-12 23:43:26','2025-03-12 23:43:26'),(7,'Albania','AL','2025-03-12 23:43:26','2025-03-12 23:43:26'),(8,'Algeria','DZ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(9,'American Samoa','AS','2025-03-12 23:43:26','2025-03-12 23:43:26'),(10,'Andorra','AD','2025-03-12 23:43:26','2025-03-12 23:43:26'),(11,'Angola','AO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(12,'Anguilla','AI','2025-03-12 23:43:26','2025-03-12 23:43:26'),(13,'Antarctica','AQ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(14,'Antigua and Barbuda','AG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(15,'Argentina','AR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(16,'Armenia','AM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(17,'Aruba','AW','2025-03-12 23:43:26','2025-03-12 23:43:26'),(18,'Australia','AU','2025-03-12 23:43:26','2025-03-12 23:43:26'),(19,'Austria','AT','2025-03-12 23:43:26','2025-03-12 23:43:26'),(20,'Azerbaijan','AZ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(21,'Bahamas','BS','2025-03-12 23:43:26','2025-03-12 23:43:26'),(22,'Bahrain','BH','2025-03-12 23:43:26','2025-03-12 23:43:26'),(23,'Bangladesh','BD','2025-03-12 23:43:26','2025-03-12 23:43:26'),(24,'Barbados','BB','2025-03-12 23:43:26','2025-03-12 23:43:26'),(25,'Belarus','BY','2025-03-12 23:43:26','2025-03-12 23:43:26'),(26,'Belgium','BE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(27,'Belize','BZ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(28,'Benin','BJ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(29,'Bermuda','BM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(30,'Bhutan','BT','2025-03-12 23:43:26','2025-03-12 23:43:26'),(31,'Bolivia (Plurinational State of)','BO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(32,'Bonaire, Sint Eustatius and Saba','BQ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(33,'Bosnia and Herzegovina','BA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(34,'Botswana','BW','2025-03-12 23:43:26','2025-03-12 23:43:26'),(35,'Bouvet Island','BV','2025-03-12 23:43:26','2025-03-12 23:43:26'),(36,'Brazil','BR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(37,'British Indian Ocean Territory','IO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(38,'Brunei Darussalam','BN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(39,'Bulgaria','BG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(40,'Burkina Faso','BF','2025-03-12 23:43:26','2025-03-12 23:43:26'),(41,'Burundi','BI','2025-03-12 23:43:26','2025-03-12 23:43:26'),(42,'Cabo Verde','CV','2025-03-12 23:43:26','2025-03-12 23:43:26'),(43,'Cambodia','KH','2025-03-12 23:43:26','2025-03-12 23:43:26'),(44,'Cameroon','CM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(45,'Canada','CA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(46,'Cayman Islands','KY','2025-03-12 23:43:26','2025-03-12 23:43:26'),(47,'Central African Republic','CF','2025-03-12 23:43:26','2025-03-12 23:43:26'),(48,'Chad','TD','2025-03-12 23:43:26','2025-03-12 23:43:26'),(49,'Chile','CL','2025-03-12 23:43:26','2025-03-12 23:43:26'),(50,'China','CN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(51,'Christmas Island','CX','2025-03-12 23:43:26','2025-03-12 23:43:26'),(52,'Cocos (Keeling) Islands','CC','2025-03-12 23:43:26','2025-03-12 23:43:26'),(53,'Colombia','CO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(54,'Comoros','KM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(55,'Congo (the Democratic Republic of the)','CD','2025-03-12 23:43:26','2025-03-12 23:43:26'),(56,'Republic of the Congo','CG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(57,'Cook Islands','CK','2025-03-12 23:43:26','2025-03-12 23:43:26'),(58,'Costa Rica','CR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(59,'Côte d\'Ivoire','CI','2025-03-12 23:43:26','2025-03-12 23:43:26'),(60,'Croatia','HR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(61,'Cuba','CU','2025-03-12 23:43:26','2025-03-12 23:43:26'),(62,'Curaçao','CW','2025-03-12 23:43:26','2025-03-12 23:43:26'),(63,'Cyprus','CY','2025-03-12 23:43:26','2025-03-12 23:43:26'),(64,'Czech Republic','CZ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(65,'Denmark','DK','2025-03-12 23:43:26','2025-03-12 23:43:26'),(66,'Djibouti','DJ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(67,'Dominica','DM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(68,'Dominican Republic','DO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(69,'Ecuador','EC','2025-03-12 23:43:26','2025-03-12 23:43:26'),(70,'Egypt','EG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(71,'El Salvador','SV','2025-03-12 23:43:26','2025-03-12 23:43:26'),(72,'Equatorial Guinea','GQ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(73,'Eritrea','ER','2025-03-12 23:43:26','2025-03-12 23:43:26'),(74,'Estonia','EE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(75,'Ethiopia','ET','2025-03-12 23:43:26','2025-03-12 23:43:26'),(76,'Falkland Islands (the) [Malvinas]','FK','2025-03-12 23:43:26','2025-03-12 23:43:26'),(77,'Faroe Islands','FO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(78,'Fiji','FJ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(79,'Finland','FI','2025-03-12 23:43:26','2025-03-12 23:43:26'),(80,'France','FR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(81,'French Guiana','GF','2025-03-12 23:43:26','2025-03-12 23:43:26'),(82,'French Polynesia','PF','2025-03-12 23:43:26','2025-03-12 23:43:26'),(83,'French Southern Territories','TF','2025-03-12 23:43:26','2025-03-12 23:43:26'),(84,'Gabon','GA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(85,'Gambia','GM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(86,'Georgia','GE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(87,'Germany','DE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(88,'Ghana','GH','2025-03-12 23:43:26','2025-03-12 23:43:26'),(89,'Gibraltar','GI','2025-03-12 23:43:26','2025-03-12 23:43:26'),(90,'Greece','GR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(91,'Greenland','GL','2025-03-12 23:43:26','2025-03-12 23:43:26'),(92,'Grenada','GD','2025-03-12 23:43:26','2025-03-12 23:43:26'),(93,'Guadeloupe','GP','2025-03-12 23:43:26','2025-03-12 23:43:26'),(94,'Guam','GU','2025-03-12 23:43:26','2025-03-12 23:43:26'),(95,'Guatemala','GT','2025-03-12 23:43:26','2025-03-12 23:43:26'),(96,'Guernsey','GG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(97,'Guinea','GN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(98,'Guinea Bissau','GW','2025-03-12 23:43:26','2025-03-12 23:43:26'),(99,'Guyana','GY','2025-03-12 23:43:26','2025-03-12 23:43:26'),(100,'Haiti','HT','2025-03-12 23:43:26','2025-03-12 23:43:26'),(101,'Heard Island and McDonald Islands','HM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(102,'Holy See','VA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(103,'Honduras','HN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(104,'Hong Kong','HK','2025-03-12 23:43:26','2025-03-12 23:43:26'),(105,'Hungary','HU','2025-03-12 23:43:26','2025-03-12 23:43:26'),(106,'Iceland','IS','2025-03-12 23:43:26','2025-03-12 23:43:26'),(107,'India','IN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(108,'Indonesia','ID','2025-03-12 23:43:26','2025-03-12 23:43:26'),(109,'Iran (Islamic Republic of)','IR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(110,'Iraq','IQ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(111,'Ireland','IE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(112,'Isle of Man','IM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(113,'Israel','IL','2025-03-12 23:43:26','2025-03-12 23:43:26'),(114,'Italy','IT','2025-03-12 23:43:26','2025-03-12 23:43:26'),(115,'Jamaica','JM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(116,'Japan','JP','2025-03-12 23:43:26','2025-03-12 23:43:26'),(117,'Jersey','JE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(118,'Jordan','JO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(119,'Kazakhstan','KZ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(120,'Kenya','KE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(121,'Kiribati','KI','2025-03-12 23:43:26','2025-03-12 23:43:26'),(122,'Korea (the Democratic People\'s Republic of)','KP','2025-03-12 23:43:26','2025-03-12 23:43:26'),(123,'Korea (the Republic of)','KR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(124,'Kuwait','KW','2025-03-12 23:43:26','2025-03-12 23:43:26'),(125,'Kyrgyzstan','KG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(126,'Lao People\'s Democratic Republic','LA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(127,'Latvia','LV','2025-03-12 23:43:26','2025-03-12 23:43:26'),(128,'Lebanon','LB','2025-03-12 23:43:26','2025-03-12 23:43:26'),(129,'Lesotho','LS','2025-03-12 23:43:26','2025-03-12 23:43:26'),(130,'Liberia','LR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(131,'Libya','LY','2025-03-12 23:43:26','2025-03-12 23:43:26'),(132,'Liechtenstein','LI','2025-03-12 23:43:26','2025-03-12 23:43:26'),(133,'Lithuania','LT','2025-03-12 23:43:26','2025-03-12 23:43:26'),(134,'Luxembourg','LU','2025-03-12 23:43:26','2025-03-12 23:43:26'),(135,'Macao','MO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(136,'Macedonia (the former Yugoslav Republic of)','MK','2025-03-12 23:43:26','2025-03-12 23:43:26'),(137,'Madagascar','MG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(138,'Malawi','MW','2025-03-12 23:43:26','2025-03-12 23:43:26'),(139,'Malaysia','MY','2025-03-12 23:43:26','2025-03-12 23:43:26'),(140,'Maldives','MV','2025-03-12 23:43:26','2025-03-12 23:43:26'),(141,'Mali','ML','2025-03-12 23:43:26','2025-03-12 23:43:26'),(142,'Malta','MT','2025-03-12 23:43:26','2025-03-12 23:43:26'),(143,'Marshall Islands','MH','2025-03-12 23:43:26','2025-03-12 23:43:26'),(144,'Martinique','MQ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(145,'Mauritania','MR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(146,'Mauritius','MU','2025-03-12 23:43:26','2025-03-12 23:43:26'),(147,'Mayotte','YT','2025-03-12 23:43:26','2025-03-12 23:43:26'),(148,'Mexico','MX','2025-03-12 23:43:26','2025-03-12 23:43:26'),(149,'Micronesia (Federated States of)','FM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(150,'Moldova (the Republic of)','MD','2025-03-12 23:43:26','2025-03-12 23:43:26'),(151,'Monaco','MC','2025-03-12 23:43:26','2025-03-12 23:43:26'),(152,'Mongolia','MN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(153,'Montenegro','ME','2025-03-12 23:43:26','2025-03-12 23:43:26'),(154,'Montserrat','MS','2025-03-12 23:43:26','2025-03-12 23:43:26'),(155,'Morocco','MA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(156,'Mozambique','MZ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(157,'Myanmar','MM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(158,'Namibia','NA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(159,'Nauru','NR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(160,'Nepal','NP','2025-03-12 23:43:26','2025-03-12 23:43:26'),(161,'Netherlands','NL','2025-03-12 23:43:26','2025-03-12 23:43:26'),(162,'New Caledonia','NC','2025-03-12 23:43:26','2025-03-12 23:43:26'),(163,'New Zealand','NZ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(164,'Nicaragua','NI','2025-03-12 23:43:26','2025-03-12 23:43:26'),(165,'Niger','NE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(166,'Nigeria','NG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(167,'Niue','NU','2025-03-12 23:43:26','2025-03-12 23:43:26'),(168,'Norfolk Island','NF','2025-03-12 23:43:26','2025-03-12 23:43:26'),(169,'Northern Mariana Islands','MP','2025-03-12 23:43:26','2025-03-12 23:43:26'),(170,'Norway','NO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(171,'Oman','OM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(172,'Pakistan','PK','2025-03-12 23:43:26','2025-03-12 23:43:26'),(173,'Palau','PW','2025-03-12 23:43:26','2025-03-12 23:43:26'),(174,'Palestine, State of','PS','2025-03-12 23:43:26','2025-03-12 23:43:26'),(175,'Panama','PA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(176,'Papua New Guinea','PG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(177,'Paraguay','PY','2025-03-12 23:43:26','2025-03-12 23:43:26'),(178,'Peru','PE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(179,'Philippines','PH','2025-03-12 23:43:26','2025-03-12 23:43:26'),(180,'Pitcairn','PN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(181,'Poland','PL','2025-03-12 23:43:26','2025-03-12 23:43:26'),(182,'Portugal','PT','2025-03-12 23:43:26','2025-03-12 23:43:26'),(183,'Puerto Rico','PR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(184,'Qatar','QA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(185,'Réunion','RE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(186,'Romania','RO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(187,'Russian Federation','RU','2025-03-12 23:43:26','2025-03-12 23:43:26'),(188,'Rwanda','RW','2025-03-12 23:43:26','2025-03-12 23:43:26'),(189,'Saint Barthélemy','BL','2025-03-12 23:43:26','2025-03-12 23:43:26'),(190,'Saint Helena, Ascension and Tristan da Cunha','SH','2025-03-12 23:43:26','2025-03-12 23:43:26'),(191,'Saint Kitts and Nevis','KN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(192,'Saint Lucia','LC','2025-03-12 23:43:26','2025-03-12 23:43:26'),(193,'Saint Martin (French part)','MF','2025-03-12 23:43:26','2025-03-12 23:43:26'),(194,'Saint Pierre and Miquelon','PM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(195,'St. Vincent','VC','2025-03-12 23:43:26','2025-03-12 23:43:26'),(196,'Samoa','WS','2025-03-12 23:43:26','2025-03-12 23:43:26'),(197,'San Marino','SM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(198,'Sao Tome','ST','2025-03-12 23:43:26','2025-03-12 23:43:26'),(199,'Saudi Arabia','SA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(200,'Senegal','SN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(201,'Serbia','RS','2025-03-12 23:43:26','2025-03-12 23:43:26'),(202,'Seychelles','SC','2025-03-12 23:43:26','2025-03-12 23:43:26'),(203,'Sierra Leone','SL','2025-03-12 23:43:26','2025-03-12 23:43:26'),(204,'Singapore','SG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(205,'Sint Maarten (Dutch part)','SX','2025-03-12 23:43:26','2025-03-12 23:43:26'),(206,'Slovakia','SK','2025-03-12 23:43:26','2025-03-12 23:43:26'),(207,'Slovenia','SI','2025-03-12 23:43:26','2025-03-12 23:43:26'),(208,'Solomon Islands','SB','2025-03-12 23:43:26','2025-03-12 23:43:26'),(209,'Somalia','SO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(210,'South Africa','ZA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(211,'South Georgia and the South Sandwich Islands','GS','2025-03-12 23:43:26','2025-03-12 23:43:26'),(212,'South Sudan','SS','2025-03-12 23:43:26','2025-03-12 23:43:26'),(213,'Spain','ES','2025-03-12 23:43:26','2025-03-12 23:43:26'),(214,'Sri Lanka','LK','2025-03-12 23:43:26','2025-03-12 23:43:26'),(215,'Sudan','SD','2025-03-12 23:43:26','2025-03-12 23:43:26'),(216,'Suriname','SR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(217,'Svalbard and Jan Mayen','SJ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(218,'Swaziland','SZ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(219,'Sweden','SE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(220,'Switzerland','CH','2025-03-12 23:43:26','2025-03-12 23:43:26'),(221,'Syria','SY','2025-03-12 23:43:26','2025-03-12 23:43:26'),(222,'Taiwan (Province of China)','TW','2025-03-12 23:43:26','2025-03-12 23:43:26'),(223,'Tajikistan','TJ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(224,'Tanzania','TZ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(225,'Thailand','TH','2025-03-12 23:43:26','2025-03-12 23:43:26'),(226,'Timor-Leste','TL','2025-03-12 23:43:26','2025-03-12 23:43:26'),(227,'Togo','TG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(228,'Tokelau','TK','2025-03-12 23:43:26','2025-03-12 23:43:26'),(229,'Tonga','TO','2025-03-12 23:43:26','2025-03-12 23:43:26'),(230,'Trinidad and Tobago','TT','2025-03-12 23:43:26','2025-03-12 23:43:26'),(231,'Tunisia','TN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(232,'Turkey','TR','2025-03-12 23:43:26','2025-03-12 23:43:26'),(233,'Turkmenistan','TM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(234,'Turks and Caicos Islands','TC','2025-03-12 23:43:26','2025-03-12 23:43:26'),(235,'Tuvalu','TV','2025-03-12 23:43:26','2025-03-12 23:43:26'),(236,'Uganda','UG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(237,'Ukraine','UA','2025-03-12 23:43:26','2025-03-12 23:43:26'),(238,'United Arab Emirates','AE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(239,'United Kingdom','GB','2025-03-12 23:43:26','2025-03-12 23:43:26'),(240,'United States Minor Outlying Islands','UM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(241,'United States of America','US','2025-03-12 23:43:26','2025-03-12 23:43:26'),(242,'Uruguay','UY','2025-03-12 23:43:26','2025-03-12 23:43:26'),(243,'Uzbekistan','UZ','2025-03-12 23:43:26','2025-03-12 23:43:26'),(244,'Vanuatu','VU','2025-03-12 23:43:26','2025-03-12 23:43:26'),(245,'Venezuela','VE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(246,'Viet Nam','VN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(247,'Virgin Islands (British)','VG','2025-03-12 23:43:26','2025-03-12 23:43:26'),(248,'Virgin Islands (U.S.)','VI','2025-03-12 23:43:26','2025-03-12 23:43:26'),(249,'Wallis and Futuna','WF','2025-03-12 23:43:26','2025-03-12 23:43:26'),(250,'Western Sahara*','EH','2025-03-12 23:43:26','2025-03-12 23:43:26'),(251,'Yemen','YE','2025-03-12 23:43:26','2025-03-12 23:43:26'),(252,'Zambia','ZM','2025-03-12 23:43:26','2025-03-12 23:43:26'),(253,'Zimbabwe','ZW','2025-03-12 23:43:26','2025-03-12 23:43:26'),(254,'Netherlands Antilles','AN','2025-03-12 23:43:26','2025-03-12 23:43:26'),(255,'Delaware','DW','2025-03-12 23:43:26','2025-03-12 23:43:26');

--
-- Table structure for table `email_notifications`
--

CREATE TABLE `email_notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_notifications`
--

INSERT INTO `email_notifications` VALUES (1,'All Notifications','Receive all email notifications','2026-03-12 11:46:47','2026-03-12 11:46:47'),(2,'Important Only','Receive only important notifications','2026-03-12 11:46:47','2026-03-12 11:46:47'),(3,'Disabled','Disable all email notifications','2026-03-12 11:46:47','2026-03-12 11:46:47');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `form_submissions`
--

CREATE TABLE `form_submissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `form_template_id` bigint unsigned DEFAULT NULL,
  `form_template_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qms_document_id` bigint unsigned DEFAULT NULL,
  `qms_document_version_id` bigint unsigned DEFAULT NULL,
  `linked_entity_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linked_entity_id` bigint unsigned DEFAULT NULL,
  `context_key` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template_version` int unsigned NOT NULL DEFAULT '1',
  `step_number` int DEFAULT NULL,
  `data` json DEFAULT NULL,
  `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `submitted_by` bigint unsigned DEFAULT NULL,
  `submitted_at` timestamp NULL DEFAULT NULL,
  `pdf_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signed_pdf_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `signed_by` bigint unsigned DEFAULT NULL,
  `signed_at` timestamp NULL DEFAULT NULL,
  `forwarded_to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forwarded_by` bigint unsigned DEFAULT NULL,
  `forwarded_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `form_submissions_form_template_id_status_index` (`form_template_id`,`status`),
  KEY `form_submissions_form_template_code_template_version_index` (`form_template_code`,`template_version`),
  KEY `form_submissions_submitted_by_submitted_at_index` (`submitted_by`,`submitted_at`),
  KEY `form_submissions_qms_document_id_fk` (`qms_document_id`),
  KEY `form_submissions_qms_document_version_id_fk` (`qms_document_version_id`),
  KEY `form_submissions_context_lookup_idx` (`linked_entity_type`,`linked_entity_id`,`context_key`),
  KEY `form_submissions_signed_by_foreign` (`signed_by`),
  KEY `form_submissions_forwarded_by_foreign` (`forwarded_by`),
  CONSTRAINT `form_submissions_form_template_id_foreign` FOREIGN KEY (`form_template_id`) REFERENCES `form_templates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `form_submissions_forwarded_by_foreign` FOREIGN KEY (`forwarded_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `form_submissions_qms_document_id_fk` FOREIGN KEY (`qms_document_id`) REFERENCES `qms_documents` (`id`) ON DELETE SET NULL,
  CONSTRAINT `form_submissions_qms_document_version_id_fk` FOREIGN KEY (`qms_document_version_id`) REFERENCES `qms_document_versions` (`id`) ON DELETE SET NULL,
  CONSTRAINT `form_submissions_signed_by_foreign` FOREIGN KEY (`signed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `form_submissions_submitted_by_foreign` FOREIGN KEY (`submitted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `form_submissions`
--

INSERT INTO `form_submissions` VALUES (1,2,'F-4517-1',NULL,NULL,'case',1,'case.requested_services',1,NULL,'{\"date\": \"2026-03-10\", \"flag\": null, \"remarks\": \"\", \"vessel_name\": \"GRAN FINALE\", \"applicant_name\": \"INSB ARGENTINA\", \"managing_company\": null, \"requested_services\": \"Initial\"}','draft',1,NULL,NULL,NULL,'2026-04-30 10:59:12','2026-04-30 10:59:12',NULL,NULL,NULL,NULL,NULL),(10,17,'F-4517-13',NULL,NULL,NULL,NULL,NULL,1,NULL,'{\"date\": \"2026-04-30\", \"vessel_name\": \"TEST VESSEL\", \"applicant_name\": \"Test Applicant\"}','Finalized',1,'2026-04-30 11:37:08','forms/f-4517-13_20260430_143708_10.pdf',NULL,'2026-04-30 11:37:08','2026-04-30 11:37:08',NULL,NULL,NULL,NULL,NULL),(12,4,'F-4517-2',NULL,NULL,'assignment',1,'assignment.receive_sr_certificates',1,NULL,'{\"gt\": \"451\", \"date\": \"2026-03-10\", \"flag\": \"Afghanistan\", \"imo_no\": \"9022180\", \"insb_no\": \"1035PY\", \"attention\": \"\", \"case_type\": \"\", \"from_dept\": \"\", \"vessel_name\": \"GRAN FINALE\", \"opening_file\": \"\", \"class_surveys\": \"\", \"surveyor_name\": \"Sarah Surveyor (Coordinator)\", \"surveys_dated\": \"\", \"additional_ref\": \"\", \"type_of_vessel\": null, \"recommendations\": \"\", \"statutory_surveys\": \"\", \"instruction_number\": \"APPR-0001-2026-04-30\", \"instructions_dated\": \"\", \"additional_ref_dated\": \"\"}','draft',1,NULL,NULL,NULL,'2026-04-30 11:37:42','2026-04-30 11:37:42',NULL,NULL,NULL,NULL,NULL),(14,17,'F-4517-13',NULL,NULL,NULL,NULL,NULL,1,NULL,'{\"date\": \"2026-05-01\", \"vessel_name\": \"UPDATED VESSEL\"}','draft',1,NULL,NULL,NULL,'2026-04-30 11:43:29','2026-04-30 11:43:29',NULL,NULL,NULL,NULL,NULL),(40,6,'F-4517-6',NULL,NULL,'assignment',1,'assignment.receive_reports',1,NULL,'{\"date\": \"2026-03-10\", \"flag\": \"Afghanistan\", \"remarks\": \"\", \"services\": \"Initial\", \"from_dept\": \"\", \"vessel_name\": \"GRAN FINALE\", \"vessel_type\": null, \"insb_class_no\": \"1035PY\", \"surveyor_name\": \"Sarah Surveyor (Coordinator)\", \"plans_forwarded\": \"\", \"insb_class_office\": \"INSB ARGENTINA\", \"instruction_number\": \"APPR-0001-2026-04-30\", \"delivered_to_stes_on\": \"\", \"delivered_to_officer_on\": \"\", \"surveyor_last_monitoring\": \"\", \"responsible_technical_officer\": \"\", \"surveyor_last_refreshment_course\": \"\"}','draft',1,NULL,NULL,NULL,'2026-04-30 12:35:17','2026-04-30 12:35:17',NULL,NULL,NULL,NULL,NULL),(41,14,'F-4517-9',NULL,NULL,'assignment',1,'assignment.issue_full_term',1,NULL,'{\"date\": \"2026-03-10\", \"flag\": \"Afghanistan\", \"imo_no\": \"9022180\", \"remarks\": \"\", \"ship_name\": \"GRAN FINALE\", \"valid_until\": \"\", \"ref_of_request\": \"APPR-0001\", \"head_of_division\": \"\", \"reason_of_issuance\": \"\"}','draft',1,NULL,NULL,NULL,'2026-05-06 08:09:14','2026-05-06 08:09:14',NULL,NULL,NULL,NULL,NULL),(42,2,'F-4517-1',NULL,NULL,'assignment',1,'assignment.flag_notification',1,NULL,'{\"date\": \"2026-03-10\", \"flag\": \"Afghanistan\", \"remarks\": \"\", \"vessel_name\": \"GRAN FINALE\", \"applicant_name\": \"INSB ARGENTINA\", \"managing_company\": null, \"requested_services\": \"Initial\"}','draft',1,NULL,NULL,NULL,'2026-05-07 10:00:20','2026-05-07 10:00:20',NULL,NULL,NULL,NULL,NULL),(43,5,'F-4517-16',NULL,NULL,'assignment',1,'assignment.receive_reports',1,NULL,'{\"date\": \"2026-03-10\", \"from_dept\": \"\", \"vessel_name\": \"GRAN FINALE\", \"particulars_gt\": \"451\", \"dates_indicated\": \"\", \"particulars_dwt\": \"0\", \"particulars_imo\": \"9022180\", \"particulars_flag\": \"Afghanistan\", \"service_suppliers\": \"\", \"staff_member_name\": \"\", \"instruction_number\": \"APPR-0001-2026-04-30\", \"managers_indicated\": \"\", \"reports_dully_signed\": \"\", \"particulars_call_sign\": \"J 8 Y 2969\", \"supporting_docs_match\": \"\", \"particulars_vessel_name\": \"GRAN FINALE\", \"particulars_year_of_build\": \"2003\", \"place_of_survey_indicated\": \"\", \"particulars_type_of_vessel\": null, \"correctness_of_form_numbers\": \"\", \"particulars_port_of_registry\": \"Kingstown\"}','draft',1,NULL,NULL,NULL,'2026-05-07 10:31:37','2026-05-07 10:31:37',NULL,NULL,NULL,NULL,NULL),(44,7,'F-4517-5',NULL,NULL,'assignment',1,'assignment.receive_reports',1,NULL,'{\"gt\": \"451\", \"date\": \"2026-03-10\", \"flag\": \"Afghanistan\", \"imo_no\": \"9022180\", \"insb_no\": \"1035PY\", \"remarks\": \"\", \"applicant\": \"INSB ARGENTINA\", \"from_dept\": \"\", \"ship_name\": \"GRAN FINALE\", \"officer_name\": \"\", \"plans_calculations\": \"\", \"received_by_pad_on\": \"\"}','draft',1,NULL,NULL,NULL,'2026-05-07 10:48:53','2026-05-07 10:48:53',NULL,NULL,NULL,NULL,NULL),(45,NULL,'F-4517-GR-NAE',NULL,NULL,'assignment',5,'teep.nae_form',1,NULL,'{\"nae_code\": \"\", \"issue_date\": \"2026-05-07\", \"nae_number\": \"Auto-generated\", \"owner_name\": \"ASDADS\", \"owner_email\": \"\", \"owner_phone\": \"\", \"sig_ap_name\": \"\", \"survey_port\": \"\", \"surveyor_id\": \"1\", \"owner_phone2\": \"\", \"sig_nae_name\": \"\", \"attention_areas\": \"ZXCZXCZCX\", \"sig_approval_name\": \"\", \"additional_instructions\": \"\", \"selected_survey_type_ids\": [\"39\"]}','draft',1,NULL,NULL,NULL,'2026-05-07 13:22:51','2026-05-07 13:24:40',NULL,NULL,NULL,NULL,NULL),(46,NULL,'F-1.3-ANATHESI',NULL,NULL,'assignment',5,'teep.anathesi',1,NULL,'{\"notes\": \"\\\\X\\\\ZX\", \"reviewer_id\": \"1\", \"vessel_name\": \"ΠΣ17 ΥΠΟΠΥΡΑΓΟΣ ΛΕΜΟΝΙΔΗΣ ΙΩΑΝΝΗΣ\", \"assigned_date\": \"2026-05-07\", \"nae_reference\": \"\\\\\\\\ZX\"}','draft',1,NULL,NULL,NULL,'2026-05-07 13:23:48','2026-05-07 13:23:48',NULL,NULL,NULL,NULL,NULL),(47,NULL,'F-4517-GR-ENIMERWSI',NULL,NULL,'assignment',5,'teep.enimerwsi',1,NULL,'{\"gt\": \"\", \"imo_no\": \"\", \"date_to\": \"\", \"org_name\": \"INSB\", \"sig_date\": \"2026-05-07\", \"sig_name\": \"ZXCZX\", \"date_from\": \"\", \"sig_place\": \"Πειραιάς\", \"build_year\": \"2011\", \"surveyor_a\": \"\\\\ZX\\\\ZX\", \"surveyor_b\": \"\\\\ZX\\\\XZ\", \"survey_type\": \"Initial\", \"vessel_name\": \"ΠΣ17 ΥΠΟΠΥΡΑΓΟΣ ΛΕΜΟΝΙΔΗΣ ΙΩΑΝΝΗΣ\", \"vessel_type\": \"\", \"survey_place\": \"\", \"applicable_regs\": \"ΠΔ 917/79, SOLAS, MARPOL\", \"special_instructions\": \"\"}','submitted',1,'2026-05-07 13:24:16',NULL,NULL,'2026-05-07 13:24:03','2026-05-07 13:24:16',NULL,NULL,NULL,NULL,NULL),(48,4,'F-4517-2',NULL,NULL,'assignment',4,'assignment.pa3_sr_form',1,NULL,'{\"gt\": \"3949\", \"date\": \"2026-05-05\", \"flag\": \"Guinea Bissau\", \"imo_no\": \"7610103\", \"insb_no\": \"6020\", \"attention\": \"\", \"case_type\": \"\", \"from_dept\": \"\", \"case_number\": \"PAD-0004\", \"vessel_name\": \"A.M.K. MARIN\", \"opening_file\": \"\", \"class_surveys\": \"\", \"surveyor_name\": \"Sarah Surveyor (Coordinator)\", \"surveys_dated\": \"\", \"additional_ref\": \"\", \"type_of_vessel\": null, \"recommendations\": \"\", \"surveyor_office\": \"INSB ARGENTINA\", \"outstanding_items\": \"\", \"statutory_surveys\": \"\", \"instruction_number\": null, \"instructions_dated\": \"\", \"surveyor_signature\": \"\", \"additional_ref_dated\": \"\", \"survey_types_completed\": \"Damage Stability Study, Inclining Experiment Analysis, Water Ballast Management Plan (BWMP)\"}','draft',1,NULL,NULL,NULL,'2026-05-08 11:44:31','2026-05-08 11:44:31',NULL,NULL,NULL,NULL,NULL),(49,13,'F-4517-14',NULL,NULL,'assignment',1,'assignment.issue_full_term',1,NULL,'{\"gt\": \"451\", \"nt\": \"135\", \"lbp\": \"40.51\", \"date\": \"2026-03-10\", \"flag\": \"Afghanistan\", \"imo_no\": \"9022180\", \"ship_name\": \"GRAN FINALE\", \"issued_from\": \"\", \"type_of_ship\": null, \"insb_class_no\": \"1035PY\", \"head_of_department\": \"\", \"drafts_attached_note\": \"\", \"certificates_to_be_issued\": \"\", \"checklist_i_manuals_approved\": \"\", \"checklist_ii_no_overdue_surveys\": \"\", \"checklist_iv_no_unrectified_psc\": \"\", \"checklist_iii_no_pending_surveys\": \"\", \"checklist_vi_no_administrative_reasons\": \"\", \"checklist_v_no_outstanding_recommendations\": \"\"}','draft',1,NULL,NULL,NULL,'2026-05-12 13:09:21','2026-05-12 13:09:21',NULL,NULL,NULL,NULL,NULL),(50,11,'F-4517-11',NULL,NULL,'assignment',1,'assignment.surveyor_evaluation',1,NULL,'{\"gt\": \"451\", \"date\": \"2026-03-10\", \"imo_no\": \"9022180\", \"insb_no\": \"1035PY\", \"comments\": \"\", \"services\": \"Initial\", \"d_omissions\": \"\", \"vessel_name\": \"GRAN FINALE\", \"b_compliance\": \"\", \"a_time_period\": \"\", \"surveyor_name\": \"Sarah Surveyor (Coordinator)\", \"c_completeness\": \"\", \"type_of_vessel\": null, \"date_of_surveys\": \"\", \"regional_office\": \"INSB ARGENTINA\", \"e_perceptibility\": \"\", \"technical_officer\": \"\", \"instruction_number\": \"APPR-0001-2026-04-30\"}','draft',1,NULL,NULL,NULL,'2026-05-12 13:24:57','2026-05-12 13:24:57',NULL,NULL,NULL,NULL,NULL),(51,13,'F-4517-14',NULL,NULL,'assignment',13,'assignment.issue_full_term',1,NULL,'{\"gt\": \"3939\", \"nt\": \"1181\", \"lbp\": \"87.78\", \"date\": \"2026-05-06\", \"flag\": null, \"imo_no\": \"N/A\", \"ship_name\": \"ADN130\", \"issued_from\": \"\", \"type_of_ship\": null, \"insb_class_no\": \"6421\", \"head_of_department\": \"\", \"drafts_attached_note\": \"\", \"certificates_to_be_issued\": \"\", \"checklist_i_manuals_approved\": \"\", \"checklist_ii_no_overdue_surveys\": \"\", \"checklist_iv_no_unrectified_psc\": \"\", \"checklist_iii_no_pending_surveys\": \"\", \"checklist_vi_no_administrative_reasons\": \"\", \"checklist_v_no_outstanding_recommendations\": \"\"}','draft',1,NULL,NULL,NULL,'2026-05-13 07:40:48','2026-05-13 07:40:48',NULL,NULL,NULL,NULL,NULL),(52,14,'F-4517-9',NULL,NULL,'assignment',13,'assignment.issue_full_term',1,NULL,'{\"date\": \"2026-05-06\", \"flag\": null, \"imo_no\": \"N/A\", \"remarks\": \"\", \"ship_name\": \"ADN130\", \"valid_until\": \"\", \"ref_of_request\": \"SSCD-0005\", \"head_of_division\": \"\", \"reason_of_issuance\": \"\"}','draft',1,NULL,NULL,NULL,'2026-05-13 07:40:55','2026-05-13 07:40:55',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `form_templates`
--

CREATE TABLE `form_templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `layout` json NOT NULL,
  `version` int unsigned NOT NULL DEFAULT '1',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `qms_folder_id` bigint unsigned DEFAULT NULL,
  `qms_document_id` bigint unsigned DEFAULT NULL,
  `qms_document_version_id` bigint unsigned DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `form_templates_code_version_unique` (`code`,`version`),
  KEY `form_templates_status_created_by_index` (`status`,`created_by`),
  KEY `form_templates_created_by_foreign` (`created_by`),
  KEY `form_templates_qms_folder_id_fk` (`qms_folder_id`),
  KEY `form_templates_qms_document_id_fk` (`qms_document_id`),
  KEY `form_templates_qms_document_version_id_fk` (`qms_document_version_id`),
  KEY `form_templates_version_index` (`version`),
  CONSTRAINT `form_templates_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `form_templates_qms_document_id_fk` FOREIGN KEY (`qms_document_id`) REFERENCES `qms_documents` (`id`) ON DELETE SET NULL,
  CONSTRAINT `form_templates_qms_document_version_id_fk` FOREIGN KEY (`qms_document_version_id`) REFERENCES `qms_document_versions` (`id`) ON DELETE SET NULL,
  CONSTRAINT `form_templates_qms_folder_id_fk` FOREIGN KEY (`qms_folder_id`) REFERENCES `qms_folders` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `form_templates`
--

INSERT INTO `form_templates` VALUES (1,'Notification of Requested Services','F-4517',NULL,'{\"fields\": []}',1,0,'Archived',NULL,NULL,NULL,NULL,'2026-03-27 12:34:46','2026-04-29 09:55:00'),(2,'F-4517-1 — Notification of Requested Services','F-4517-1','Cover note issued from the case for the requested surveys / services.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"applicant_name\", \"type\": \"text\", \"label\": \"Applicant\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.applicant.name\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"managing_company\", \"type\": \"text\", \"label\": \"Managing Company\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.managing_company\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"requested_services\", \"type\": \"textarea\", \"label\": \"Requested Services\", \"width\": \"full\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.services_summary\"}, {\"name\": \"remarks\", \"type\": \"textarea\", \"label\": \"Remarks\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 10:55:47'),(3,'F-4517-SR — Report of Completion of Surveys / Audits','F-4517-SR','Submitted by the attending surveyor within 48h from completion.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"GT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"type_of_vessel\", \"type\": \"text\", \"label\": \"Type of Vessel\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"managing_company\", \"type\": \"text\", \"label\": \"Owning / Managing Company\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.managing_company\"}, {\"name\": \"instruction_number\", \"type\": \"text\", \"label\": \"Survey Instructions Reference\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.instruction.instruction_number\"}, {\"name\": \"surveys_completed_on\", \"type\": \"date\", \"label\": \"Surveys Completed On\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"place_of_surveys\", \"type\": \"text\", \"label\": \"Place of Surveys\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"hull_machinery_surveys\", \"type\": \"textarea\", \"label\": \"Hull / Machinery Surveys\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"statutory_surveys\", \"type\": \"textarea\", \"label\": \"Statutory Surveys\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"audits\", \"type\": \"checkbox\", \"label\": \"Audits\", \"width\": \"full\", \"options\": \"ISM,ISPS,MLC\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"other_surveys\", \"type\": \"textarea\", \"label\": \"Other Surveys\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"results\", \"type\": \"radio\", \"label\": \"Results\", \"width\": \"full\", \"options\": \"1 - Surveys/Audits carried out satisfactorily. No recommendation,2 - Surveys/Audits carried out satisfactorily. Minor recommendation,3 - Recommendations and/or remarks and/or outstanding items\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"surveyor_name\", \"type\": \"text\", \"label\": \"Surveyor / Auditor Name\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor.name\"}, {\"name\": \"surveyor_signature\", \"type\": \"signature\", \"label\": \"Surveyor / Auditor Signature\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 11:27:42'),(4,'F-4517-2 — Notification of Completion of Surveys','F-4517-2','From SAS Dpt. / Offshore Vessels Division to Documentary Dpt.','{\"fields\": [{\"name\": \"from_dept\", \"type\": \"radio\", \"label\": \"From\", \"width\": \"full\", \"options\": \"SIS Dpt.,Offshore Vessels Division\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"case_type\", \"type\": \"radio\", \"label\": \"Case Type\", \"width\": \"full\", \"options\": \"First Entry Case,Existing Vessel\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"attention\", \"type\": \"text\", \"label\": \"Attention\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"case_number\", \"type\": \"text\", \"label\": \"Case Reference No.\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"case.case_id\"}, {\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"insb_no\", \"type\": \"text\", \"label\": \"INSB No.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO No.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"type_of_vessel\", \"type\": \"text\", \"label\": \"Type of Vessel\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"GT\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"survey_types_completed\", \"type\": \"textarea\", \"label\": \"Survey Types Completed\", \"width\": \"full\", \"required\": false, \"auto_populate_from\": \"case.services_summary\"}, {\"name\": \"instruction_number\", \"type\": \"text\", \"label\": \"Ref. of Instructions\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.instruction.instruction_number\"}, {\"name\": \"instructions_dated\", \"type\": \"date\", \"label\": \"Instructions Dated\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"additional_ref\", \"type\": \"text\", \"label\": \"Additional Ref. of Instructions\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"additional_ref_dated\", \"type\": \"date\", \"label\": \"Additional Ref. Dated\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"surveyor_name\", \"type\": \"text\", \"label\": \"Surveys Carried Out By\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor.name\"}, {\"name\": \"surveyor_office\", \"type\": \"text\", \"label\": \"Surveyor Office\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"assignment.surveyor.office.name\"}, {\"name\": \"surveys_dated\", \"type\": \"date\", \"label\": \"Surveys Carried Out Dated\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"class_surveys\", \"type\": \"textarea\", \"label\": \"Class Surveys Completed\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"statutory_surveys\", \"type\": \"textarea\", \"label\": \"Statutory Surveys Completed\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"recommendations\", \"type\": \"textarea\", \"label\": \"Recommendations Posed by Acting Surveyor\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"outstanding_items\", \"type\": \"textarea\", \"label\": \"Outstanding Items\", \"width\": \"full\", \"required\": false}, {\"name\": \"opening_file\", \"type\": \"radio\", \"label\": \"Opening File\", \"width\": \"full\", \"options\": \"Yes,No,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"surveyor_signature\", \"type\": \"signature\", \"label\": \"Surveyor Signature\", \"width\": \"half\", \"required\": false, \"img_width\": 150, \"img_height\": 80}], \"context_key\": \"step_2\", \"workflow_step\": \"W8\"}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 12:14:16'),(5,'F-4517-16 — SAS Dpt. Checklist (Admin POV)','F-4517-16','Checklist for consideration of survey reports from administrative point of view.','{\"fields\": [{\"name\": \"from_dept\", \"type\": \"radio\", \"label\": \"From\", \"width\": \"full\", \"options\": \"SAS Dpt.,Offshore Vessels Division\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"instruction_number\", \"type\": \"text\", \"label\": \"Ref. Number of Surveys Requirements\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.instruction.instruction_number\"}, {\"name\": \"whitespace_69f1d574efcb5\", \"type\": \"whitespace\", \"label\": \"Whitespace\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"particulars_vessel_name\", \"type\": \"radio\", \"label\": \"A1. Vessel Name correctly indicated\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"particulars_imo\", \"type\": \"radio\", \"label\": \"A2. IMO Number correctly indicated\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"particulars_flag\", \"type\": \"radio\", \"label\": \"A3. Flag correctly indicated\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"particulars_port_of_registry\", \"type\": \"radio\", \"label\": \"A4. Port of Registry correctly indicated\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.registry_port\"}, {\"name\": \"particulars_call_sign\", \"type\": \"radio\", \"label\": \"A5. Call Sign correctly indicated\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.call_sign\"}, {\"name\": \"particulars_gt\", \"type\": \"radio\", \"label\": \"A6. Gross Tonnage (GT) correctly indicated\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"particulars_dwt\", \"type\": \"radio\", \"label\": \"A7. Dead Weight (DWT) correctly indicated\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.dwt\"}, {\"name\": \"particulars_year_of_build\", \"type\": \"radio\", \"label\": \"A8. Year of Build correctly indicated\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.build_year\"}, {\"name\": \"particulars_type_of_vessel\", \"type\": \"radio\", \"label\": \"A9. Type of Vessel correctly indicated\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"whitespace_69f1d574efcc6\", \"type\": \"whitespace\", \"label\": \"Whitespace\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"reports_dully_signed\", \"type\": \"radio\", \"label\": \"B1. Surveys reports duly signed\", \"width\": \"full\", \"options\": \"YES,NO\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"dates_indicated\", \"type\": \"radio\", \"label\": \"B2. Dates of surveys clearly indicated\", \"width\": \"full\", \"options\": \"YES,NO\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"place_of_survey_indicated\", \"type\": \"radio\", \"label\": \"B3. Place of survey clearly indicated\", \"width\": \"full\", \"options\": \"YES,NO\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"correctness_of_form_numbers\", \"type\": \"radio\", \"label\": \"B4. Correctness of surveys forms numbers\", \"width\": \"full\", \"options\": \"YES,NO\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"whitespace_69f1d574efcca\", \"type\": \"whitespace\", \"label\": \"Whitespace\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"supporting_docs_match\", \"type\": \"radio\", \"label\": \"C. Supporting documentation reflects survey requirements\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"service_suppliers\", \"type\": \"radio\", \"label\": \"D. Service Suppliers status\", \"width\": \"full\", \"options\": \"APPROVED,ACCEPTED,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"managers_indicated\", \"type\": \"radio\", \"label\": \"E. Particulars of Ship\'s Managers clearly indicated\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"staff_member_name\", \"type\": \"text\", \"label\": \"SAS Dpt. / Offshore Division Staff Member Name\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 11:08:22'),(6,'F-4517-6 — Submission of Surveys Reports to STES Dpt.','F-4517-6','Forwards survey reports and engineering plans to STES Dpt.','{\"fields\": [{\"name\": \"from_dept\", \"type\": \"radio\", \"label\": \"From\", \"width\": \"full\", \"options\": \"SAS Dpt.,Offshore Vessels Division\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"surveyor_name\", \"type\": \"text\", \"label\": \"Surveyor\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor.name\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Vessel\'s Flag\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"surveyor_last_monitoring\", \"type\": \"date\", \"label\": \"Surveyor\'s Last Monitoring\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"insb_class_no\", \"type\": \"text\", \"label\": \"INSB Class No.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"surveyor_last_refreshment_course\", \"type\": \"date\", \"label\": \"Surveyor\'s Last Refreshment Course\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"vessel_type\", \"type\": \"text\", \"label\": \"Vessel\'s Type\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"instruction_number\", \"type\": \"text\", \"label\": \"Ref. of Surveys Requirements\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.instruction.instruction_number\"}, {\"name\": \"insb_class_office\", \"type\": \"text\", \"label\": \"INSB Class Office\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor.office.name\"}, {\"name\": \"services\", \"type\": \"text\", \"label\": \"Type of Surveys\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.services_summary\"}, {\"name\": \"plans_forwarded\", \"type\": \"textarea\", \"label\": \"Type of Plans / Engineering Studies submitted and forwarded to Plan Appraisal Division\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"remarks\", \"type\": \"textarea\", \"label\": \"Remarks\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"delivered_to_stes_on\", \"type\": \"date\", \"label\": \"Surveys Reports delivered to STES Dpt. on\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"delivered_to_officer_on\", \"type\": \"date\", \"label\": \"Surveys Reports delivered to the Technical Officer on\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"responsible_technical_officer\", \"type\": \"text\", \"label\": \"Responsible STES Dpt. Technical Officer\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 11:08:22'),(7,'F-4517-5 — Submission to Plan Appraisal Division','F-4517-5','Cover letter for dispatch of plans / technical documents to Plan Appraisal Division.','{\"fields\": [{\"name\": \"from_dept\", \"type\": \"radio\", \"label\": \"From\", \"width\": \"full\", \"options\": \"SAS Dpt.,Offshore Vessels Division\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"ship_name\", \"type\": \"text\", \"label\": \"Ship\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"GT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"applicant\", \"type\": \"text\", \"label\": \"Applicant\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.applicant.name\"}, {\"name\": \"insb_no\", \"type\": \"text\", \"label\": \"INSB No.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"plans_calculations\", \"type\": \"textarea\", \"label\": \"Plans / Manuals / Calculations submitted\", \"width\": \"full\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"remarks\", \"type\": \"textarea\", \"label\": \"Remarks\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"officer_name\", \"type\": \"text\", \"label\": \"Officer Name\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"received_by_pad_on\", \"type\": \"text\", \"label\": \"Received by Plan Appraisal Division on\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 11:08:22'),(8,'F-4517-10 — Survey Reports Consideration & Evaluation Form','F-4517-10','STES Dpt. evaluation of surveys reports.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"ship_name\", \"type\": \"text\", \"label\": \"Ship\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"GT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"nt\", \"type\": \"text\", \"label\": \"NT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.net_tonnage\"}, {\"name\": \"lbp\", \"type\": \"text\", \"label\": \"LBP\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.length_bp\"}, {\"name\": \"type_of_ship\", \"type\": \"text\", \"label\": \"Type of Ship\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"insb_class_no\", \"type\": \"text\", \"label\": \"INSB Class No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"instruction_number\", \"type\": \"text\", \"label\": \"Technical Requirements Ref. No.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.instruction.instruction_number\"}, {\"name\": \"assessment\", \"type\": \"radio\", \"label\": \"Assessment\", \"width\": \"full\", \"options\": \"Satisfactory,Unsatisfactory,Requires Amendment\", \"required\": false}, {\"name\": \"attachments\", \"type\": \"checkbox\", \"label\": \"Attachments\", \"width\": \"full\", \"options\": \"CD with photos,CD with UTM,Other\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"attachments_other\", \"type\": \"text\", \"label\": \"Attachments — Other (specify)\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"class_surveys_considered\", \"type\": \"textarea\", \"label\": \"Class Surveys Considered\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"statutory_surveys_considered\", \"type\": \"textarea\", \"label\": \"Statutory Surveys Considered\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"type_of_tailshaft\", \"type\": \"radio\", \"label\": \"Type of Tailshaft Survey\", \"width\": \"full\", \"options\": \"COMPLETE,PARTIAL,MODIFIED\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"tailshaft_method\", \"type\": \"radio\", \"label\": \"Tailshaft Method\", \"width\": \"full\", \"options\": \"METHOD 1,METHOD 2,METHOD 3,METHOD 4\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"special_note\", \"type\": \"textarea\", \"label\": \"Special Note\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"technical_officer\", \"type\": \"text\", \"label\": \"Technical Officer\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 12:47:33'),(9,'F-4517-20 — Service Suppliers Control','F-4517-20','Form for the service suppliers control based on their reports.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"insb_no\", \"type\": \"text\", \"label\": \"INSB No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"GT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"type_of_vessel\", \"type\": \"text\", \"label\": \"Type of Vessel\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"instruction_number\", \"type\": \"text\", \"label\": \"Ref. of Surveys Requirements\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.instruction.instruction_number\"}, {\"name\": \"surveyor_name\", \"type\": \"text\", \"label\": \"Surveyor\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor.name\"}, {\"name\": \"date_of_surveys\", \"type\": \"date\", \"label\": \"Date of Surveys\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"services\", \"type\": \"text\", \"label\": \"Type of Surveys\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.services_summary\"}, {\"name\": \"type_class_renewal\", \"type\": \"radio\", \"label\": \"Class Survey Type\", \"width\": \"full\", \"options\": \"INITIAL,RENEWAL\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"type_safety_equipment\", \"type\": \"radio\", \"label\": \"Safety Equipment Type\", \"width\": \"full\", \"options\": \"INITIAL,RENEWAL\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"type_safety_radio\", \"type\": \"radio\", \"label\": \"Safety Radio Type\", \"width\": \"full\", \"options\": \"INITIAL,RENEWAL\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"category_of_services\", \"type\": \"text\", \"label\": \"Category of Services\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"name_of_service_supplier\", \"type\": \"text\", \"label\": \"Name of Service Supplier\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"a_perceptibility\", \"type\": \"radio\", \"label\": \"A. Level of perceptibility of used terminology\", \"width\": \"full\", \"options\": \"3 - Very Good,2 - Good,1 - Fair\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"b_completeness\", \"type\": \"radio\", \"label\": \"B. Level of Certificate / Report Completeness\", \"width\": \"full\", \"options\": \"3 - Very Good,2 - Good,1 - Fair\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"notes\", \"type\": \"textarea\", \"label\": \"Notes\", \"width\": \"full\", \"required\": false}, {\"name\": \"technical_officer\", \"type\": \"text\", \"label\": \"Technical Officer\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 12:47:33'),(10,'F-4517-7 — Service Suppliers Control (legacy alias of F-4517-20)','F-4517-7','Legacy code preserved so the assignment Step 4 button keeps working. Same fields as F-4517-20.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"insb_no\", \"type\": \"text\", \"label\": \"INSB No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"GT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"type_of_vessel\", \"type\": \"text\", \"label\": \"Type of Vessel\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"instruction_number\", \"type\": \"text\", \"label\": \"Ref. of Surveys Requirements\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.instruction.instruction_number\"}, {\"name\": \"surveyor_name\", \"type\": \"text\", \"label\": \"Surveyor\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor.name\"}, {\"name\": \"date_of_surveys\", \"type\": \"date\", \"label\": \"Date of Surveys\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"services\", \"type\": \"text\", \"label\": \"Type of Surveys\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.services_summary\"}, {\"name\": \"type_class_renewal\", \"type\": \"radio\", \"label\": \"Class Survey Type\", \"width\": \"full\", \"options\": \"INITIAL,RENEWAL\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"type_safety_equipment\", \"type\": \"radio\", \"label\": \"Safety Equipment Type\", \"width\": \"full\", \"options\": \"INITIAL,RENEWAL\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"type_safety_radio\", \"type\": \"radio\", \"label\": \"Safety Radio Type\", \"width\": \"full\", \"options\": \"INITIAL,RENEWAL\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"category_of_services\", \"type\": \"text\", \"label\": \"Category of Services\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"name_of_service_supplier\", \"type\": \"text\", \"label\": \"Name of Service Supplier\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"a_perceptibility\", \"type\": \"radio\", \"label\": \"A. Level of perceptibility of used terminology\", \"width\": \"full\", \"options\": \"3 - Very Good,2 - Good,1 - Fair\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"b_completeness\", \"type\": \"radio\", \"label\": \"B. Level of Certificate / Report Completeness\", \"width\": \"full\", \"options\": \"3 - Very Good,2 - Good,1 - Fair\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"technical_officer\", \"type\": \"text\", \"label\": \"Technical Officer\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 11:08:22'),(11,'F-4517-11 — Surveyors Evaluation Form','F-4517-11','Form for the Surveyors evaluation based on consideration / evaluation of survey reports.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"insb_no\", \"type\": \"text\", \"label\": \"INSB No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"GT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"type_of_vessel\", \"type\": \"text\", \"label\": \"Type of Vessel\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"instruction_number\", \"type\": \"text\", \"label\": \"Ref. of Surveys Requirements\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.instruction.instruction_number\"}, {\"name\": \"regional_office\", \"type\": \"text\", \"label\": \"Regional Office\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor.office.name\"}, {\"name\": \"surveyor_name\", \"type\": \"text\", \"label\": \"Surveyor\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor.name\"}, {\"name\": \"date_of_surveys\", \"type\": \"date\", \"label\": \"Date of Surveys\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"services\", \"type\": \"text\", \"label\": \"Type of Surveys\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.services_summary\"}, {\"name\": \"a_time_period\", \"type\": \"radio\", \"label\": \"A. Time period of submission of survey reports & supporting documentation\", \"width\": \"full\", \"options\": \"4 - On time (within 30 days),3 - Insignificant delay (up to 15 days),1 - Significant delay (up to 30 days)\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"b_compliance\", \"type\": \"radio\", \"label\": \"B. Compliance of submitted reports with the corresponding written surveys requirements\", \"width\": \"full\", \"options\": \"4 - Complete,3 - Minor documentation missing,1 - Major documentation missing\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"c_completeness\", \"type\": \"radio\", \"label\": \"C. Level of Surveys Reports Completeness\", \"width\": \"full\", \"options\": \"4 - As appropriate,2 - Few vacancies,1 - Many vacancies\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"d_omissions\", \"type\": \"radio\", \"label\": \"D. Omissions Observed\", \"width\": \"full\", \"options\": \"5 - Non-Observations,3 - Very minor observations,1 - Minor observations\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"e_perceptibility\", \"type\": \"radio\", \"label\": \"E. Level of perceptibility of used terminology\", \"width\": \"full\", \"options\": \"3 - Very Good,2 - Good,1 - Medium\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"comments\", \"type\": \"textarea\", \"label\": \"Comments\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"technical_officer\", \"type\": \"text\", \"label\": \"Technical Officer\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 11:08:22'),(12,'F-4517-21 — Surveyors Evaluation Form (legacy alias of F-4517-11)','F-4517-21','Legacy code preserved so the assignment Step 5 button keeps working. Same fields as F-4517-11.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"insb_no\", \"type\": \"text\", \"label\": \"INSB No.\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"GT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"type_of_vessel\", \"type\": \"text\", \"label\": \"Type of Vessel\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"instruction_number\", \"type\": \"text\", \"label\": \"Ref. of Surveys Requirements\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.instruction.instruction_number\"}, {\"name\": \"regional_office\", \"type\": \"text\", \"label\": \"Regional Office\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor.office.name\"}, {\"name\": \"surveyor_name\", \"type\": \"text\", \"label\": \"Surveyor\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor.name\"}, {\"name\": \"date_of_surveys\", \"type\": \"date\", \"label\": \"Date of Surveys\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"services\", \"type\": \"text\", \"label\": \"Type of Surveys\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.services_summary\"}, {\"name\": \"a_time_period\", \"type\": \"radio\", \"label\": \"A. Time period of submission of survey reports & supporting documentation\", \"width\": \"full\", \"options\": \"4 - On time (within 30 days),3 - Insignificant delay (up to 15 days),1 - Significant delay (up to 30 days)\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"b_compliance\", \"type\": \"radio\", \"label\": \"B. Compliance of submitted reports with the corresponding written surveys requirements\", \"width\": \"full\", \"options\": \"4 - Complete,3 - Minor documentation missing,1 - Major documentation missing\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"c_completeness\", \"type\": \"radio\", \"label\": \"C. Level of Surveys Reports Completeness\", \"width\": \"full\", \"options\": \"4 - As appropriate,2 - Few vacancies,1 - Many vacancies\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"d_omissions\", \"type\": \"radio\", \"label\": \"D. Omissions Observed\", \"width\": \"full\", \"options\": \"5 - Non-Observations,3 - Very minor observations,1 - Minor observations\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"e_perceptibility\", \"type\": \"radio\", \"label\": \"E. Level of perceptibility of used terminology\", \"width\": \"full\", \"options\": \"3 - Very Good,2 - Good,1 - Medium\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"comments\", \"type\": \"textarea\", \"label\": \"Comments\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"recommended_actions\", \"type\": \"textarea\", \"label\": \"Recommended Actions\", \"width\": \"full\", \"required\": false}, {\"name\": \"technical_officer\", \"type\": \"text\", \"label\": \"Technical Officer\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}], \"context_key\": \"assignment.surveyor_evaluation\", \"workflow_step\": \"W5\"}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 12:57:22'),(13,'F-4517-14 — Instruction for the Issuance of Certificates','F-4517-14','Issued by SIS Dpt. / Doc. Dpt. / Offshore Vessel Division / Yacht Dpt.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"issued_from\", \"type\": \"radio\", \"label\": \"Issued From\", \"width\": \"full\", \"options\": \"SIS Dpt.,Doc. Dpt.,Offshore Vessel Div.,Yacht Dpt.\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"ship_name\", \"type\": \"text\", \"label\": \"Ship\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO No.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"GT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"nt\", \"type\": \"text\", \"label\": \"NT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.net_tonnage\"}, {\"name\": \"lbp\", \"type\": \"text\", \"label\": \"LBP\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.length_bp\"}, {\"name\": \"type_of_ship\", \"type\": \"text\", \"label\": \"Type of Ship\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"insb_class_no\", \"type\": \"text\", \"label\": \"INSB Class No.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"certificates_to_be_issued\", \"type\": \"textarea\", \"label\": \"Certificates to be Issued (Type / Int. / Short / Full Term / Validity)\", \"width\": \"full\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"drafts_attached_note\", \"type\": \"textarea\", \"label\": \"Note: drafts of certificates to be issued must be attached to this form.\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"whitespace_69f1d574efd70\", \"type\": \"whitespace\", \"label\": \"Whitespace\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"checklist_i_manuals_approved\", \"type\": \"radio\", \"label\": \"i) All applicable manuals approved as per QP-37/F-01\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"checklist_ii_no_overdue_surveys\", \"type\": \"radio\", \"label\": \"ii) No overdue surveys (per ship\'s survey status)\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"checklist_iii_no_pending_surveys\", \"type\": \"radio\", \"label\": \"iii) No pending surveys to be completed\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"checklist_iv_no_unrectified_psc\", \"type\": \"radio\", \"label\": \"iv) No unrectified PSC detention recommendations\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"checklist_v_no_outstanding_recommendations\", \"type\": \"radio\", \"label\": \"v) No outstanding recommendations recorded at memos\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"checklist_vi_no_administrative_reasons\", \"type\": \"radio\", \"label\": \"vi) No administrative reasons for not releasing certificates\", \"width\": \"full\", \"options\": \"YES,NO,N/A\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"head_of_department\", \"type\": \"text\", \"label\": \"Head of Department / Division\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}], \"context_key\": \"assignment.issue_full_term\", \"workflow_step\": \"W6a\"}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 13:16:10'),(14,'F-4517-9 — Instructions for Issuance of Fresh Short-Term Certificates','F-4517-9','Issued by Head of Division for short-term certificate replacement.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"ref_of_request\", \"type\": \"text\", \"label\": \"Ref. of Request\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.case_id\"}, {\"name\": \"ship_name\", \"type\": \"text\", \"label\": \"Ship\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO Number\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"valid_until\", \"type\": \"date\", \"label\": \"New Short-Term Certificate(s) valid until\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"reason_of_issuance\", \"type\": \"textarea\", \"label\": \"Reason of Issuance of new Short-Term Certificate(s)\", \"width\": \"full\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"remarks\", \"type\": \"textarea\", \"label\": \"Remarks\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"head_of_division\", \"type\": \"text\", \"label\": \"Head of the Division\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}], \"context_key\": \"assignment.issue_full_term\", \"workflow_step\": \"W6b\"}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 13:16:10'),(15,'F-4517-12 — Survey Status Form','F-4517-12','Issued by the Head of Documentary Dpt.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"ship_name\", \"type\": \"text\", \"label\": \"Ship\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"GT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"nt\", \"type\": \"text\", \"label\": \"NT\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.net_tonnage\"}, {\"name\": \"lbp\", \"type\": \"text\", \"label\": \"LBP\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.length_bp\"}, {\"name\": \"type_of_ship\", \"type\": \"text\", \"label\": \"Type of Ship\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"insb_class_no\", \"type\": \"text\", \"label\": \"INSB Class No.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"class_surveys_status\", \"type\": \"textarea\", \"label\": \"Class Surveys (Done / Due / Postponed / Remarks)\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"statutory_surveys_status\", \"type\": \"textarea\", \"label\": \"Statutory Surveys (Done / Due / Postponed / Remarks)\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"tailshaft_type\", \"type\": \"radio\", \"label\": \"Type of Tailshaft Survey\", \"width\": \"full\", \"options\": \"COMPLETE,PARTIAL,MODIFIED\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"tailshaft_method\", \"type\": \"radio\", \"label\": \"Tailshaft Method\", \"width\": \"full\", \"options\": \"METHOD 1,METHOD 2,METHOD 3,METHOD 4\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"recommendations\", \"type\": \"textarea\", \"label\": \"Recommendations (Posed Date / Description / Due Date)\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.recommendations_text\"}, {\"name\": \"memoranda\", \"type\": \"textarea\", \"label\": \"Memoranda\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.memoranda_text\"}, {\"name\": \"memos\", \"type\": \"textarea\", \"label\": \"Memos\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.memos_text\"}, {\"name\": \"remarks\", \"type\": \"textarea\", \"label\": \"Remarks\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"head_of_doc_dpt\", \"type\": \"text\", \"label\": \"Head of Documentary Dpt.\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 11:08:22'),(16,'F-4517-15 — Notice for Class / Statutory Suspension or Withdrawal','F-4517-15','Issued by Head of Documentary Dpt., approved by Technical Manager.','{\"fields\": [{\"name\": \"reference_no\", \"type\": \"text\", \"label\": \"Reference No.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel\'s Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"insb_class_no\", \"type\": \"text\", \"label\": \"INSB Class No.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"reason\", \"type\": \"radio\", \"label\": \"Reason for Class Suspension / Withdrawal\", \"width\": \"full\", \"options\": \"1 - OS Overdue Surveys,2 - OREC Overdue Recommendations,3 - NCCC Non-Compliance with conditions of Class,4 - OWR At Owners request,5 - TOC Transfer of Class to other society,6 - DMG Due to damage occurred\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"whitespace_69f1d574efda1\", \"type\": \"whitespace\", \"label\": \"Whitespace\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"notification_parties\", \"type\": \"checkbox\", \"label\": \"Notification addressed to\", \"width\": \"full\", \"options\": \"Owners / Managers,INSB Class Station Monitoring Vessel,Flag Administration,MoUs (Paris / Tokyo / USCG / Black Sea / Mediterranean / Indian),Internally (MMSC / SAS / Plan Appraisal)\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"survey_status_to_be_updated\", \"type\": \"checkbox\", \"label\": \"Survey Status will be updated\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"head_of_doc_dpt\", \"type\": \"text\", \"label\": \"Head of Documentary Dpt.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"approved_by_technical_manager\", \"type\": \"text\", \"label\": \"Approved by — Technical Manager\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-04-30 11:08:22'),(17,'F-4517-13 — Transfer of Ships Records to Non-Active Archive or Destroy','F-4517-13','Issued by Head of Documentary Dpt.','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"case.date\"}, {\"name\": \"action\", \"type\": \"radio\", \"label\": \"Action\", \"width\": \"full\", \"options\": \"TRANSFER,DESTROY\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"transfer_destination\", \"type\": \"text\", \"label\": \"Transfer Destination (if TRANSFER)\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"entries\", \"type\": \"textarea\", \"label\": \"File List (INSB Class No. | Vessel Name | IMO No. | Flag | File Reference | Reason)\", \"width\": \"full\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"placeholder\": \"One entry per line\"}, {\"name\": \"remarks\", \"type\": \"textarea\", \"label\": \"Remarks\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"issued_by\", \"type\": \"text\", \"label\": \"Issued By — Head of Documentary Dpt.\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"countersigned_by\", \"type\": \"text\", \"label\": \"Countersigned By — Technical Director\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"action_completed_on\", \"type\": \"date\", \"label\": \"Action Completed On\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"staff_member_in_charge\", \"type\": \"text\", \"label\": \"Department\'s Staff Member in Charge\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-29 09:52:35','2026-05-11 06:47:17'),(18,'CCD-01/TD — Classification Committee Decision','CCD-01/TD','Classification Committee Decision Form (W6-7)','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"required\": true, \"auto_populate_from\": \"system.date\"}, {\"name\": \"case_number\", \"type\": \"text\", \"label\": \"Case Reference No.\", \"width\": \"half\", \"required\": true, \"auto_populate_from\": \"case.case_id\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Name of Vessel\", \"width\": \"half\", \"required\": true, \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO Number\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"type_of_vessel\", \"type\": \"text\", \"label\": \"Type of Vessel\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"Gross Tonnage\", \"width\": \"third\", \"required\": false, \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"insb_no\", \"type\": \"text\", \"label\": \"INSB Class No.\", \"width\": \"third\", \"required\": false, \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"applicant\", \"type\": \"text\", \"label\": \"Applicant\", \"width\": \"third\", \"required\": false, \"auto_populate_from\": \"case.applicant.name\"}, {\"name\": \"requested_services\", \"type\": \"textarea\", \"label\": \"Requested Services\", \"width\": \"full\", \"required\": false, \"auto_populate_from\": \"case.services_summary\"}, {\"name\": \"committee_date\", \"type\": \"date\", \"label\": \"Committee Meeting Date\", \"width\": \"half\", \"required\": true}, {\"name\": \"committee_decision\", \"type\": \"radio\", \"label\": \"Committee Decision\", \"width\": \"full\", \"options\": \"Approve,Reject,Defer\", \"required\": true}, {\"name\": \"decision_conditions\", \"type\": \"textarea\", \"label\": \"Conditions / Requirements\", \"width\": \"full\", \"required\": false}, {\"name\": \"decision_notes\", \"type\": \"textarea\", \"label\": \"Notes / Remarks\", \"width\": \"full\", \"required\": false}, {\"name\": \"head_of_department\", \"type\": \"text\", \"label\": \"Head of Department\", \"width\": \"half\", \"required\": false}, {\"name\": \"committee_signature\", \"type\": \"signature\", \"label\": \"Signature\", \"width\": \"half\", \"required\": false, \"img_width\": 150, \"img_height\": 80}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-30 12:04:53','2026-04-30 12:04:53'),(19,'TC Form — Technical Committee Review','TC-FORM','Technical Committee Review Form (W6-7)','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"required\": true, \"auto_populate_from\": \"system.date\"}, {\"name\": \"case_number\", \"type\": \"text\", \"label\": \"Case Reference No.\", \"width\": \"half\", \"required\": true, \"auto_populate_from\": \"case.case_id\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Name of Vessel\", \"width\": \"half\", \"required\": true, \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO Number\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"third\", \"required\": false, \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"Gross Tonnage\", \"width\": \"third\", \"required\": false, \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"type_of_vessel\", \"type\": \"text\", \"label\": \"Type of Vessel\", \"width\": \"third\", \"required\": false, \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"insb_no\", \"type\": \"text\", \"label\": \"INSB Class No.\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"requested_services\", \"type\": \"textarea\", \"label\": \"Requested Services\", \"width\": \"full\", \"required\": false, \"auto_populate_from\": \"case.services_summary\"}, {\"name\": \"technical_requirements\", \"type\": \"textarea\", \"label\": \"Technical Requirements\", \"width\": \"full\", \"required\": false}, {\"name\": \"committee_date\", \"type\": \"date\", \"label\": \"Committee Meeting Date\", \"width\": \"half\", \"required\": true}, {\"name\": \"committee_recommendation\", \"type\": \"radio\", \"label\": \"Recommendation\", \"width\": \"full\", \"options\": \"Proceed,Reject,Refer Back\", \"required\": true}, {\"name\": \"recommendation_details\", \"type\": \"textarea\", \"label\": \"Recommendation Details\", \"width\": \"full\", \"required\": false}, {\"name\": \"special_conditions\", \"type\": \"textarea\", \"label\": \"Special Conditions\", \"width\": \"full\", \"required\": false}, {\"name\": \"technical_officer\", \"type\": \"text\", \"label\": \"Technical Officer\", \"width\": \"half\", \"required\": false}, {\"name\": \"lead_surveyor\", \"type\": \"text\", \"label\": \"Lead Surveyor\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"assignment.instruction.lead_surveyor.name\"}]}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-30 12:04:53','2026-04-30 12:04:53'),(20,'Technical Instructions','TECH-INST','Technical Instructions Output Document (W7-8) — auto-populated output template','{\"fields\": [{\"name\": \"date\", \"type\": \"date\", \"label\": \"Date\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"system.date\"}, {\"name\": \"instruction_number\", \"type\": \"text\", \"label\": \"Instruction No.\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"assignment.instruction.instruction_number\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Name of Vessel\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO Number\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"vessel.imo_number\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"third\", \"required\": false, \"auto_populate_from\": \"vessel.flag.name\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"Gross Tonnage\", \"width\": \"third\", \"required\": false, \"auto_populate_from\": \"vessel.gross_tonnage\"}, {\"name\": \"nt\", \"type\": \"text\", \"label\": \"Net Tonnage\", \"width\": \"third\", \"required\": false, \"auto_populate_from\": \"vessel.net_tonnage\"}, {\"name\": \"type_of_vessel\", \"type\": \"text\", \"label\": \"Type of Vessel\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"vessel.type_name\"}, {\"name\": \"insb_no\", \"type\": \"text\", \"label\": \"INSB Class No.\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"surveyor_name\", \"type\": \"text\", \"label\": \"Assigned Surveyor\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"assignment.surveyor.name\"}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"assignment.department.name\"}, {\"name\": \"survey_scope\", \"type\": \"textarea\", \"label\": \"Survey Scope / Services\", \"width\": \"full\", \"required\": false, \"auto_populate_from\": \"case.services_summary\"}, {\"name\": \"technical_instructions\", \"type\": \"textarea\", \"label\": \"Technical Instructions\", \"width\": \"full\", \"required\": false}, {\"name\": \"special_requirements\", \"type\": \"textarea\", \"label\": \"Special Requirements\", \"width\": \"full\", \"required\": false}, {\"name\": \"lead_surveyor\", \"type\": \"text\", \"label\": \"Lead Surveyor\", \"width\": \"half\", \"required\": false, \"auto_populate_from\": \"assignment.instruction.lead_surveyor.name\"}, {\"name\": \"lead_surveyor_signature\", \"type\": \"signature\", \"label\": \"Lead Surveyor Signature\", \"width\": \"half\", \"required\": false, \"img_width\": 150, \"img_height\": 80}], \"template_type\": \"output\"}',1,1,'Active',1,NULL,NULL,NULL,'2026-04-30 12:04:53','2026-04-30 12:04:53'),(21,'F-4517-GR-NAE — Ναυτιλιακή Ανάθεση Επιθεώρησης (Greek Flag)','F-4517-GR-NAE','Survey assignment instructions for Greek Flag vessels. Auto-fills vessel/owner data; 8 sections covering surveys, surveyor, certificates, reports, supporting docs, attention areas, additional instructions; 3 signatures (ΑΠ Responsible, ΝΑΕ Responsible, Approval/Τομεάρχης).','{\"fields\": [{\"name\": \"s1_header\", \"type\": \"heading\", \"label\": \"1. Vessel Particulars\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"vessel_name\", \"type\": \"text\", \"label\": \"Vessel Name\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.name\"}, {\"name\": \"imo_no\", \"type\": \"text\", \"label\": \"IMO Number\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.imo\"}, {\"name\": \"flag\", \"type\": \"text\", \"label\": \"Flag\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.flag\"}, {\"name\": \"vessel_type\", \"type\": \"text\", \"label\": \"Type of Vessel\", \"width\": \"third\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.type\"}, {\"name\": \"gt\", \"type\": \"text\", \"label\": \"Gross Tonnage (GT)\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.gt\"}, {\"name\": \"insb_no\", \"type\": \"text\", \"label\": \"INSB Number\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.insb_number\"}, {\"name\": \"s2_header\", \"type\": \"heading\", \"label\": \"2. Shipowner & Manager\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"owner\", \"type\": \"text\", \"label\": \"Shipowner\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.owner\"}, {\"name\": \"manager\", \"type\": \"text\", \"label\": \"Managing Company\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"vessel.manager\"}, {\"name\": \"s3_header\", \"type\": \"heading\", \"label\": \"3. Surveys & Assigned Surveyor\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"survey_types\", \"type\": \"textarea\", \"label\": \"Surveys to be Performed\", \"width\": \"full\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.survey_types\"}, {\"name\": \"assigned_surveyor\", \"type\": \"text\", \"label\": \"Assigned Surveyor\", \"width\": \"half\", \"options\": \"\", \"required\": true, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.surveyor_name\"}, {\"name\": \"place_of_survey\", \"type\": \"text\", \"label\": \"Place of Survey\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"tentative_date\", \"type\": \"date\", \"label\": \"Tentative Survey Date\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"instruction_ref\", \"type\": \"text\", \"label\": \"Survey Instructions Reference\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\", \"auto_populate_from\": \"assignment.instruction_number\"}, {\"name\": \"s4_header\", \"type\": \"heading\", \"label\": \"4. Certificates to be Issued\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"certificates\", \"type\": \"textarea\", \"label\": \"Certificates to be Issued\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"s5_header\", \"type\": \"heading\", \"label\": \"5. Reports Required\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"reports_required\", \"type\": \"textarea\", \"label\": \"Reports Required from Surveyor\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"s6_header\", \"type\": \"heading\", \"label\": \"6. Supporting Documents\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"supporting_docs\", \"type\": \"textarea\", \"label\": \"Supporting Documents Required\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"s7_header\", \"type\": \"heading\", \"label\": \"7. Special Attention Areas\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"attention_areas\", \"type\": \"textarea\", \"label\": \"Areas Requiring Special Attention\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"s8_header\", \"type\": \"heading\", \"label\": \"8. Additional Instructions\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"additional_instr\", \"type\": \"textarea\", \"label\": \"Additional Instructions\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"sig_header\", \"type\": \"heading\", \"label\": \"Signatures\", \"width\": \"full\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"ap_responsible_name\", \"type\": \"text\", \"label\": \"ΑΠ Responsible — Name\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"ap_responsible_signature\", \"type\": \"signature\", \"label\": \"ΑΠ Responsible — Signature\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"nae_responsible_name\", \"type\": \"text\", \"label\": \"ΝΑΕ Responsible — Name\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"nae_responsible_signature\", \"type\": \"signature\", \"label\": \"ΝΑΕ Responsible — Signature\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"approval_name\", \"type\": \"text\", \"label\": \"Approval (Τομεάρχης) — Name\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}, {\"name\": \"approval_signature\", \"type\": \"signature\", \"label\": \"Approval (Τομεάρχης) — Signature\", \"width\": \"half\", \"options\": \"\", \"required\": false, \"img_width\": \"150\", \"img_height\": \"80\"}]}',1,1,'Active',NULL,NULL,NULL,NULL,'2026-05-07 12:38:57','2026-05-07 12:38:57');

--
-- Table structure for table `imap_attachments`
--

CREATE TABLE `imap_attachments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email_id` bigint unsigned NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` text COLLATE utf8mb4_unicode_ci,
  `mime` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `imap_attachments_email_id_index` (`email_id`),
  CONSTRAINT `imap_attachments_email_id_foreign` FOREIGN KEY (`email_id`) REFERENCES `imap_emails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `imap_attachments`
--


--
-- Table structure for table `imap_contacts`
--

CREATE TABLE `imap_contacts` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`email`),
  KEY `imap_contacts_name_index` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `imap_contacts`
--


--
-- Table structure for table `imap_emails`
--

CREATE TABLE `imap_emails` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email_account_id` bigint unsigned NOT NULL,
  `thread_id` bigint unsigned NOT NULL,
  `message_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to` json DEFAULT NULL,
  `cc` json DEFAULT NULL,
  `bcc` json DEFAULT NULL,
  `reply_to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` datetime NOT NULL,
  `body_html` longtext COLLATE utf8mb4_unicode_ci,
  `body_text` longtext COLLATE utf8mb4_unicode_ci,
  `headers` json NOT NULL,
  `folder` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `in_reply_to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `references` json DEFAULT NULL,
  `uid` int NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `imap_emails_email_account_id_uid_folder_unique` (`email_account_id`,`uid`,`folder`),
  UNIQUE KEY `imap_emails_message_id_unique` (`message_id`),
  KEY `imap_emails_thread_id_index` (`thread_id`),
  KEY `imap_emails_message_id_index` (`message_id`),
  KEY `imap_emails_date_index` (`date`),
  KEY `imap_emails_from_index` (`from`),
  CONSTRAINT `imap_emails_email_account_id_foreign` FOREIGN KEY (`email_account_id`) REFERENCES `imap_email_accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `imap_emails_thread_id_foreign` FOREIGN KEY (`thread_id`) REFERENCES `imap_threads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `imap_emails`
--


--
-- Table structure for table `imap_inline_images`
--

CREATE TABLE `imap_inline_images` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email_id` bigint unsigned NOT NULL,
  `content_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` text COLLATE utf8mb4_unicode_ci,
  `mime` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `imap_inline_images_email_id_index` (`email_id`),
  KEY `imap_inline_images_content_id_index` (`content_id`),
  CONSTRAINT `imap_inline_images_email_id_foreign` FOREIGN KEY (`email_id`) REFERENCES `imap_emails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `imap_inline_images`
--


--
-- Table structure for table `imap_threads`
--

CREATE TABLE `imap_threads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `imap_threads_subject_index` (`subject`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `imap_threads`
--


--
-- Table structure for table `instruction_histories`
--

CREATE TABLE `instruction_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `assignment_id` bigint unsigned NOT NULL,
  `instruction_id` bigint unsigned DEFAULT NULL,
  `version` int unsigned NOT NULL,
  `action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `snapshot` json NOT NULL,
  `changed_fields` json DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `instruction_histories_assignment_id_version_unique` (`assignment_id`,`version`),
  KEY `instruction_histories_instruction_id_foreign` (`instruction_id`),
  KEY `instruction_histories_updated_by_foreign` (`updated_by`),
  CONSTRAINT `instruction_histories_assignment_id_foreign` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `instruction_histories_instruction_id_foreign` FOREIGN KEY (`instruction_id`) REFERENCES `instructions` (`id`) ON DELETE SET NULL,
  CONSTRAINT `instruction_histories_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `instruction_histories`
--

INSERT INTO `instruction_histories` VALUES (1,1,1,1,'created','{\"assigned_by\": \"Nikos Voutsi\", \"instructions\": \"EDFEFD\", \"assigned_date\": \"2026-04-30\", \"lead_surveyor\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"place_of_audit\": null, \"tentative_date\": null, \"flag_notifications\": {\"details\": \"DFAEDFA\"}, \"instruction_number\": \"APPR-0001-2026-04-30\", \"secondary_surveyor\": {\"id\": null, \"name\": null}, \"technical_committe_ref\": \"REF-123\", \"technical_instructions\": {\"39\": {\"notes\": \"\\\"[\\\\\\\"1. The vessel must comply with MSC.1\\\\\\\\/Circ.1571 amendments effective 01\\\\\\\\/01\\\\\\\\/2024 regarding fire safety systems.\\\\\\\",\\\\\\\"2. EPIRB battery replacement due if manufacturing date exceeds 5 years.\\\\\\\",\\\\\\\"3. Immersion suits required for all crew \\\\\\\\u2014 verify condition and quantity.\\\\\\\",\\\\\\\"4. Ensure SOLAS Training Manual is updated and available onboard.\\\\\\\"]\\\"\", \"reports\": \"\\\"[\\\\\\\"1215225-SE \\\\\\\\/ 01-2025 \\\\\\\\u2014 Safety Equipment Survey Report\\\\\\\",\\\\\\\"1215225-FF \\\\\\\\/ 01-2025 \\\\\\\\u2014 Fire Fighting Equipment Report\\\\\\\",\\\\\\\"1215225-LSA \\\\\\\\/ 01-2025 \\\\\\\\u2014 Life-Saving Appliances Report\\\\\\\"]\\\"\", \"guidance\": \"\\\"[\\\\\\\"Renewal Safety Equipment survey according to SOLAS Chapter III, Regulation 20. Verify all life-saving appliances, fire-fighting equipment, and navigation systems are in compliance with current INSB Class regulations and applicable IMO amendments. Special attention to: (a) Lifeboat launching arrangements and release mechanisms, (b) Life-raft hydrostatic release units \\\\\\\\u2014 verify service dates, (c) Fire detection systems in accommodation and machinery spaces, (d) Emergency lighting and marking of escape routes, (e) Pyrotechnics \\\\\\\\u2014 verify expiry dates.\\\\\\\"]\\\"\", \"references\": \"\\\"[\\\\\\\"SOLAS Chapter III, Regulation 20\\\\\\\",\\\\\\\"MSC.1\\\\\\\\/Circ.1571\\\\\\\",\\\\\\\"INSB Class Rules Chapter 8, Section 3\\\\\\\"]\\\"\", \"survey_type\": \"Initial\", \"certificates\": \"\\\"[\\\\\\\"Safety Equipment Certificate \\\\\\\\u2014 Full Term (5 years)\\\\\\\",\\\\\\\"Exemption Certificate (if applicable)\\\\\\\"]\\\"\", \"survey_type_id\": 39, \"supporting_docs\": null, \"assigned_surveyor\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"additional_remarks\": \"If vessel carries dangerous goods, verify Document of Compliance for carriage of dangerous goods is valid.\"}}, \"technical_committe_date\": \"2026-04-30\", \"classification_committe_ref\": \"REF-123\", \"classification_committe_date\": \"2026-04-30\", \"classification_committe_reference_date\": \"2026-04-30\", \"classification_committe_incoming_reference\": \"DFSD\"}','{\"assigned_by\": {\"to\": \"Nikos Voutsi\", \"from\": null}, \"instructions\": {\"to\": \"EDFEFD\", \"from\": null}, \"assigned_date\": {\"to\": \"2026-04-30\", \"from\": null}, \"lead_surveyor\": {\"to\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"from\": null}, \"flag_notifications\": {\"to\": {\"details\": \"DFAEDFA\"}, \"from\": null}, \"instruction_number\": {\"to\": \"APPR-0001-2026-04-30\", \"from\": null}, \"secondary_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"technical_committe_ref\": {\"to\": \"REF-123\", \"from\": null}, \"technical_instructions\": {\"to\": {\"39\": {\"notes\": \"\\\"[\\\\\\\"1. The vessel must comply with MSC.1\\\\\\\\/Circ.1571 amendments effective 01\\\\\\\\/01\\\\\\\\/2024 regarding fire safety systems.\\\\\\\",\\\\\\\"2. EPIRB battery replacement due if manufacturing date exceeds 5 years.\\\\\\\",\\\\\\\"3. Immersion suits required for all crew \\\\\\\\u2014 verify condition and quantity.\\\\\\\",\\\\\\\"4. Ensure SOLAS Training Manual is updated and available onboard.\\\\\\\"]\\\"\", \"reports\": \"\\\"[\\\\\\\"1215225-SE \\\\\\\\/ 01-2025 \\\\\\\\u2014 Safety Equipment Survey Report\\\\\\\",\\\\\\\"1215225-FF \\\\\\\\/ 01-2025 \\\\\\\\u2014 Fire Fighting Equipment Report\\\\\\\",\\\\\\\"1215225-LSA \\\\\\\\/ 01-2025 \\\\\\\\u2014 Life-Saving Appliances Report\\\\\\\"]\\\"\", \"guidance\": \"\\\"[\\\\\\\"Renewal Safety Equipment survey according to SOLAS Chapter III, Regulation 20. Verify all life-saving appliances, fire-fighting equipment, and navigation systems are in compliance with current INSB Class regulations and applicable IMO amendments. Special attention to: (a) Lifeboat launching arrangements and release mechanisms, (b) Life-raft hydrostatic release units \\\\\\\\u2014 verify service dates, (c) Fire detection systems in accommodation and machinery spaces, (d) Emergency lighting and marking of escape routes, (e) Pyrotechnics \\\\\\\\u2014 verify expiry dates.\\\\\\\"]\\\"\", \"references\": \"\\\"[\\\\\\\"SOLAS Chapter III, Regulation 20\\\\\\\",\\\\\\\"MSC.1\\\\\\\\/Circ.1571\\\\\\\",\\\\\\\"INSB Class Rules Chapter 8, Section 3\\\\\\\"]\\\"\", \"survey_type\": \"Initial\", \"certificates\": \"\\\"[\\\\\\\"Safety Equipment Certificate \\\\\\\\u2014 Full Term (5 years)\\\\\\\",\\\\\\\"Exemption Certificate (if applicable)\\\\\\\"]\\\"\", \"survey_type_id\": 39, \"supporting_docs\": null, \"assigned_surveyor\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"additional_remarks\": \"If vessel carries dangerous goods, verify Document of Compliance for carriage of dangerous goods is valid.\"}}, \"from\": null}, \"technical_committe_date\": {\"to\": \"2026-04-30\", \"from\": null}, \"classification_committe_ref\": {\"to\": \"REF-123\", \"from\": null}, \"classification_committe_date\": {\"to\": \"2026-04-30\", \"from\": null}, \"classification_committe_reference_date\": {\"to\": \"2026-04-30\", \"from\": null}, \"classification_committe_incoming_reference\": {\"to\": \"DFSD\", \"from\": null}}',1,1,'2026-04-30 11:03:42','2026-04-30 11:03:42'),(2,5,2,1,'created','{\"assigned_by\": null, \"instructions\": null, \"assigned_date\": null, \"lead_surveyor\": {\"id\": null, \"name\": null}, \"place_of_audit\": null, \"tentative_date\": null, \"flag_notifications\": {\"details\": null}, \"instruction_number\": \"GFSD-0006-2026-05-07\", \"secondary_surveyor\": {\"id\": null, \"name\": null}, \"technical_committe_ref\": null, \"technical_instructions\": {\"39\": {\"notes\": null, \"reports\": null, \"guidance\": null, \"references\": null, \"survey_type\": \"Initial\", \"certificates\": null, \"survey_type_id\": 39, \"supporting_docs\": null, \"assigned_surveyor\": {\"id\": null, \"name\": null}, \"additional_remarks\": null}}, \"technical_committe_date\": null, \"classification_committe_ref\": null, \"classification_committe_date\": null, \"classification_committe_reference_date\": null, \"classification_committe_incoming_reference\": null}','{\"lead_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"flag_notifications\": {\"to\": {\"details\": null}, \"from\": null}, \"instruction_number\": {\"to\": \"GFSD-0006-2026-05-07\", \"from\": null}, \"secondary_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"technical_instructions\": {\"to\": {\"39\": {\"notes\": null, \"reports\": null, \"guidance\": null, \"references\": null, \"survey_type\": \"Initial\", \"certificates\": null, \"survey_type_id\": 39, \"supporting_docs\": null, \"assigned_surveyor\": {\"id\": null, \"name\": null}, \"additional_remarks\": null}}, \"from\": null}}',1,1,'2026-05-07 13:46:32','2026-05-07 13:46:32'),(3,13,5,1,'created','{\"assigned_by\": \"Nikos Voutsi\", \"instructions\": \"SRFDDFSD\", \"assigned_date\": \"2026-05-13\", \"lead_surveyor\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"place_of_audit\": \"DUBAI\", \"tentative_date\": null, \"flag_notifications\": {\"details\": \"SVDS SSSD\"}, \"instruction_number\": \"SSCD-0005-2026-05-13\", \"secondary_surveyor\": {\"id\": null, \"name\": null}, \"technical_committe_ref\": \"REF-1234\", \"technical_instructions\": {\"39\": {\"notes\": \"\\\"[\\\\\\\"1. The vessel must comply with MSC.1\\\\\\\\/Circ.1571 amendments effective 01\\\\\\\\/01\\\\\\\\/2024 regarding fire safety systems.\\\\\\\",\\\\\\\"2. EPIRB battery replacement due if manufacturing date exceeds 5 years.\\\\\\\",\\\\\\\"3. Immersion suits required for all crew \\\\\\\\u2014 verify condition and quantity.\\\\\\\",\\\\\\\"4. Ensure SOLAS Training Manual is updated and available onboard.\\\\\\\"]\\\"\", \"reports\": \"\\\"[\\\\\\\"1215225-SE \\\\\\\\/ 01-2025 \\\\\\\\u2014 Safety Equipment Survey Report\\\\\\\",\\\\\\\"1215225-FF \\\\\\\\/ 01-2025 \\\\\\\\u2014 Fire Fighting Equipment Report\\\\\\\",\\\\\\\"1215225-LSA \\\\\\\\/ 01-2025 \\\\\\\\u2014 Life-Saving Appliances Report\\\\\\\"]\\\"\", \"guidance\": \"\\\"[\\\\\\\"Renewal Safety Equipment survey according to SOLAS Chapter III, Regulation 20. Verify all life-saving appliances, fire-fighting equipment, and navigation systems are in compliance with current INSB Class regulations and applicable IMO amendments. Special attention to: (a) Lifeboat launching arrangements and release mechanisms, (b) Life-raft hydrostatic release units \\\\\\\\u2014 verify service dates, (c) Fire detection systems in accommodation and machinery spaces, (d) Emergency lighting and marking of escape routes, (e) Pyrotechnics \\\\\\\\u2014 verify expiry dates.\\\\\\\"]\\\"\", \"references\": \"\\\"[\\\\\\\"SOLAS Chapter III, Regulation 20\\\\\\\",\\\\\\\"MSC.1\\\\\\\\/Circ.1571\\\\\\\",\\\\\\\"INSB Class Rules Chapter 8, Section 3\\\\\\\"]\\\"\", \"survey_type\": \"Initial\", \"certificates\": \"\\\"[\\\\\\\"Safety Equipment Certificate \\\\\\\\u2014 Full Term (5 years)\\\\\\\",\\\\\\\"Exemption Certificate (if applicable)\\\\\\\"]\\\"\", \"survey_type_id\": 39, \"supporting_docs\": null, \"assigned_surveyor\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"additional_remarks\": \"If vessel carries dangerous goods, verify Document of Compliance for carriage of dangerous goods is valid.\"}}, \"technical_committe_date\": \"2026-05-13\", \"classification_committe_ref\": \"REF-1234\", \"classification_committe_date\": \"2026-05-13\", \"classification_committe_reference_date\": \"2026-05-13\", \"classification_committe_incoming_reference\": null}','{\"assigned_by\": {\"to\": \"Nikos Voutsi\", \"from\": null}, \"instructions\": {\"to\": \"SRFDDFSD\", \"from\": null}, \"assigned_date\": {\"to\": \"2026-05-13\", \"from\": null}, \"lead_surveyor\": {\"to\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"from\": null}, \"place_of_audit\": {\"to\": \"DUBAI\", \"from\": null}, \"flag_notifications\": {\"to\": {\"details\": \"SVDS SSSD\"}, \"from\": null}, \"instruction_number\": {\"to\": \"SSCD-0005-2026-05-13\", \"from\": null}, \"secondary_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"technical_committe_ref\": {\"to\": \"REF-1234\", \"from\": null}, \"technical_instructions\": {\"to\": {\"39\": {\"notes\": \"\\\"[\\\\\\\"1. The vessel must comply with MSC.1\\\\\\\\/Circ.1571 amendments effective 01\\\\\\\\/01\\\\\\\\/2024 regarding fire safety systems.\\\\\\\",\\\\\\\"2. EPIRB battery replacement due if manufacturing date exceeds 5 years.\\\\\\\",\\\\\\\"3. Immersion suits required for all crew \\\\\\\\u2014 verify condition and quantity.\\\\\\\",\\\\\\\"4. Ensure SOLAS Training Manual is updated and available onboard.\\\\\\\"]\\\"\", \"reports\": \"\\\"[\\\\\\\"1215225-SE \\\\\\\\/ 01-2025 \\\\\\\\u2014 Safety Equipment Survey Report\\\\\\\",\\\\\\\"1215225-FF \\\\\\\\/ 01-2025 \\\\\\\\u2014 Fire Fighting Equipment Report\\\\\\\",\\\\\\\"1215225-LSA \\\\\\\\/ 01-2025 \\\\\\\\u2014 Life-Saving Appliances Report\\\\\\\"]\\\"\", \"guidance\": \"\\\"[\\\\\\\"Renewal Safety Equipment survey according to SOLAS Chapter III, Regulation 20. Verify all life-saving appliances, fire-fighting equipment, and navigation systems are in compliance with current INSB Class regulations and applicable IMO amendments. Special attention to: (a) Lifeboat launching arrangements and release mechanisms, (b) Life-raft hydrostatic release units \\\\\\\\u2014 verify service dates, (c) Fire detection systems in accommodation and machinery spaces, (d) Emergency lighting and marking of escape routes, (e) Pyrotechnics \\\\\\\\u2014 verify expiry dates.\\\\\\\"]\\\"\", \"references\": \"\\\"[\\\\\\\"SOLAS Chapter III, Regulation 20\\\\\\\",\\\\\\\"MSC.1\\\\\\\\/Circ.1571\\\\\\\",\\\\\\\"INSB Class Rules Chapter 8, Section 3\\\\\\\"]\\\"\", \"survey_type\": \"Initial\", \"certificates\": \"\\\"[\\\\\\\"Safety Equipment Certificate \\\\\\\\u2014 Full Term (5 years)\\\\\\\",\\\\\\\"Exemption Certificate (if applicable)\\\\\\\"]\\\"\", \"survey_type_id\": 39, \"supporting_docs\": null, \"assigned_surveyor\": {\"id\": 1, \"name\": \"Sarah Surveyor (Coordinator)\"}, \"additional_remarks\": \"If vessel carries dangerous goods, verify Document of Compliance for carriage of dangerous goods is valid.\"}}, \"from\": null}, \"technical_committe_date\": {\"to\": \"2026-05-13\", \"from\": null}, \"classification_committe_ref\": {\"to\": \"REF-1234\", \"from\": null}, \"classification_committe_date\": {\"to\": \"2026-05-13\", \"from\": null}, \"classification_committe_reference_date\": {\"to\": \"2026-05-13\", \"from\": null}}',1,1,'2026-05-13 06:48:06','2026-05-13 06:48:06'),(4,14,6,1,'created','{\"assigned_by\": null, \"instructions\": null, \"assigned_date\": null, \"lead_surveyor\": {\"id\": null, \"name\": null}, \"place_of_audit\": null, \"tentative_date\": null, \"flag_notifications\": {\"details\": null}, \"instruction_number\": \"TEEPD-0001-2026-05-13\", \"secondary_surveyor\": {\"id\": null, \"name\": null}, \"technical_committe_ref\": null, \"technical_instructions\": [], \"technical_committe_date\": null, \"classification_committe_ref\": null, \"classification_committe_date\": null, \"classification_committe_reference_date\": null, \"classification_committe_incoming_reference\": null}','{\"lead_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"flag_notifications\": {\"to\": {\"details\": null}, \"from\": null}, \"instruction_number\": {\"to\": \"TEEPD-0001-2026-05-13\", \"from\": null}, \"secondary_surveyor\": {\"to\": {\"id\": null, \"name\": null}, \"from\": null}, \"technical_instructions\": {\"to\": [], \"from\": null}}',1,1,'2026-05-13 10:50:15','2026-05-13 10:50:15');

--
