How to EDIT the central-ledger-schema-DBeaver.erd file

This is a basic guide on how to successfully view/update the central-ledger-schema-DBeaver.erd file.

Prerequisites

Download and install the DBeaver Community DB Manager
The Mojaloop Central-Ledger MySQL Database needs to be up and running, and connectable by the DBeaver
You'll also need a text editor

Create a new db connection in DBeaver under Database Navigator tab for the MySQL instance running.
Under the Projects tab right click and create a New ER Diagram.
Give the diagram a name and select central-ledger db in the wizard.
Copy the central-ledger-schema-DBeaver.erd file from the documentation module to DBeaverData/workspace/General/Diagrams in your DBeaver storage location
Navigate to the newly created erd file using a text editor, search for data-source id and copy its value which looks like mysql5-171ea991174-1218b6e1bf273693.
Navigate with a text editor to the central-ledger-schema-DBeaver.erd file in the ER Diagrams directory and replace its data-source id value with the one copied from the newly created erd file.
The central-ledger-schema-DBeaver.erd should now show the tables as per the central-ledger-schema.png

Last updated 2 years ago