Skip to main content

ERD Management Scripts

This folder contains Python scripts to manage the Mermaid ERD diagrams for the database schema.

Quick Start​

Run the script to generate all ERD files from the schema CSV:

./generate_erd.py

Or using Python:

python3 generate_erd.py

Generated Files​

The script generates the following files directly from schema_output.csv:

  • eerd-full.md - Full ERD with all tables
  • eerd-customer-management.md - Customer Management tables
  • eerd-forms-templates.md - Forms & Templates tables
  • eerd-handover-transfer.md - Handover Transfer tables
  • eerd-misc.md - Miscellaneous tables
  • eerd-notifications-apps.md - Notifications & Apps tables
  • eerd-real-estate.md - Real Estate tables
  • eerd-system-access.md - System Access tables
  • eerd-user-management.md - User Management tables
  • eerd.md - Index file with links to all ERDs

Dependencies​

  • Python 3
  • pathlib
  • csv
  • collections