...
Dropped table Y015_REGISTRY_WORKITEM_XREF. Reason: Vessel registration records should not “have knowledge” of work items or requests that have lead to its their creation or modification. This decouples the request management process from vessel registry and allows for applying security, data loss prevention and other polices to these two databases independently.
Added new table Y010_VESSEL_OWNERSHIP, in accordance with the diagrams developed by vincentjoseph.chazhoor (Unlicensed). A couple of deviations here:
Instead of using FK relationship to Y001_VESSEL, which is in another database, we use FK relationship to the Y010_REGISTRY table.
CLIENT_ID column is no longer marked as a FK, as it points to records in a separate database.
Added OFFICIAL_NUMBER field to the Y010_REGISTRY table, as this is how vessel records will be linked to the vessel registry records.
...