Application thats generates database script from diagram
Frontend react app allows to create entity relationship diagram of a database. Backend service creates MSSQL nad MySQL scripts of provided ER diagram.
You can check how it works at: https://gen.sql-generator.pl/
- Drag and drop Entities/Labels from left menu-bar to canvas
- Connect Entities via links (you can drag them out of an entity ports (left/right top squares))
- Double click Entity/Link to modify
- Check how relation diagram is transformed to logical (you may change few things)
- Generate SQL create script
- Save your diagram as file or image so you can show it to your teammates