DrawSQL makes it easy for teams to collaborate on creating and maintaining schema diagrams. With a single source of truth, there's no need for manually syncing diagram files between different developers and offline tools anymore. Source: 12 months ago

To be honest, since you are just getting started, I think you should reconsider simplifying this app to begin with. Built something easier and get some more experience before jumping in the ocean. Maybe start by focusing only on the parent company and sub-companies. However, I strongly recommend you to try and make a diagram of your database with relations and columns as it can you a lot of time. I personally use... Source: about 1 year ago

After googling some, I found DrawSQL, which is a start. But I don't like its interface, and the inability to download the schemas in any form (at least not from what I can see). Source: over 1 year ago

Hey! Me with my team use this tool - https://drawsql.app/ We find it very useful. Suppose it may be helpful for someone else 🐱‍🚀. Source: about 2 years ago

I was try to learn mysql for a few days and I came across DrawSQL. I really like the smooth ui and how its beautifuly visualize foreign keys. I tried to think how would I implement something like this but it wasn't much help. I also try to find it on internet and but no help. Source: over 2 years ago

Also, reducing your problem down to a minimal reproducible example, along with some sample data (and ideally a http://sqlfiddle.com/ or https://dbfiddle.uk/ link) will get you much better answers. Source: about 1 year ago

Http://dbfiddle.uk has an AdventureWorks test DB that you could use. Source: about 1 year ago

If you used https://dbfiddle.uk to create a table, load it up with a minimum set of representative rows, then created a minimal, yet representative "first query" and then mocked up what you want your "second query"'s output to look like based on the example data, it might be way easier to comprehend what you are talking about. Source: over 1 year ago

Put it in a fiddle, like dbfiddle.uk or sqlfiddle.com. Source: over 1 year ago

I don't mean to take anything away from this post - its quite amazing and I can't wait to play with it more - but wanted to mention that there are sites out there that I believe solve the training portion maybe a little bit better, at least if all you want is to train on SQL not DBA type actions. My favorite is https://dbfiddle.uk/ - the ability to link and fork a set of statements is extremely handy. - Source: Hacker News / over 1 year ago