# Document History

Version | Date | Changes
--- | --- | ---
0.1 | 08/02/2024 | First draft for EMSWe Databases Working Group meeting 1
0.2 | 19/04/2024 | Revision by EMSA as follow up to the EMSWe Databases Working Group meeting 1, with following changes: Changed from AMQP to Kafka protocol for announcement service Added Appendix A explaining the usage of YAML files with tools examples Defined the registration process Clarified the concept of ship, location and hazmat item deactivation/deletion in the specifications All YAML specifications have been updated
0.3 | 07/05/2024 | Revision by EMSA with the following changes: Added Appendix B explaining the meaning of the codes used in the applicable code lists All YAML specifications have been updated Web version made available at the URL: http://emswe-db-sig.emsa.europa.eu
0.4 | 05/07/2024 | Revision by EMSA with the following changes: Updated hyperlinks to open in a new tab Changed max length of "subsidiaryRisk" parameter in ECHD from 4 to 7 characters for consistency with the applicable code list. Schemas of ECHD related services updated accordingly.
1.0 | 17/09/2024 | Revision by EMSA with the following changes: Updated Section 6 - Commissioning Measures with text and attached the necessary zip file for local execution Updated the left panel to add an indication that EMSA is an EU agency Updated URLs for Production environment Updated topic names in Section 3.2.1 - API specification
1.1 | 14/10/2024 | Revision by EMSA with the following changes: Revised Section 4.2 and Chapter 6; clarified the step-by-step process for Member States (MS) to follow in order to establish connections between the Maritime National Single Windows (MNSWs) and the EMSWe databases Added min length restrictions in ESD for attributes "authorityType" in "Authority" class, "id" in "OccurrenceLocation" class, "port" in "Route" class, "port" in "ExemptionAppliesTo" class and "loCode" in "Contact247" class Updated yaml and html files of API Specifications to use correct line endings in parameter descriptions Updated zip file for local execution of commissioning tests
1.2 | 25/09/2025 | Revision by EMSA with the following changes: Updated ECHD API specifications due to hazmat item uniqueness being a combination of "editionType" and "id" attributes. The "editionType" attribute was added outside the details of hazmat item, because when MNSWs process deletions announcements from the ECHD, the combination of "editionType" and "id" attributes must be used to identify the item to be deleted. The "editionType" attribute was duplicated in the message structure to ensure backwards compatibility with previous version of the specifications. Update on the domain for REST APIs endpoints from apim.emswe-db.emsa.europa.eu to oauth-apim.emswe-db.emsa.europa.eu. Missing code lists added in Annex B for alignment with the ESD API specifications. Code lists used by the ECHD added in Annex B. The description fields in the "postal address" object of the ESD YAML specification have been generalized. "MIG" added to the list of acronyms. Link to the EMSWe documentation published on the EMSA website added in Chapter 3. Revised paragraph 4.2 to clarify the procedure for Member States (MS) to connect to the EMSWe DBs in production. Revised paragraph 6.3 to clarify the procedure to be followed by MS after commissioning tests are completed. Updated zip file for local execution of commissioning tests to create data according to the above change. Renamed Appendix B from "Translation of code lists used in API" to "Code lists used in API". Added links to download previous versions of the SIG in the Version number of Version History section.