S
S
scdewt2014-10-16 17:51:01
Database
scdewt, 2014-10-16 17:51:01

How to visualize and document the structure of a database?

There is a Postgres database with a bunch of servers, where there are many schemas, in each schema there are many tables with a large set of fields.
There is a need to document both the structure itself and the links in it. However, not all connections are implemented through keys. There are many relationships between tables at the php code level.
That's why I'm looking for a tool that:
- will be able to unload the database structure (at least one database) with all schemas, tables and fields. There are a lot of tables, you can’t draw them manually.
- will give you the opportunity to freely draw / delete links, without affecting the database. Some editors themselves draw links by keys and do not allow adding / changing / deleting links, i.e. readonly mode, which is not suitable.
- can draw links not between tables, but between fields. This is a must and a priority. There are a lot of fields in tables and simple connections "table <-> table" are extremely uninformative.
- the ability to "fumble" data in a large team. In my dreams, I would like to see an analogue of the jira wiki, only for the database, but any other data exchange option will do. I would like to involve the whole team in compiling documentation on the database.
Visually, I imagine it like this (sql designer):
39c635d76c284f938ccda1bcaf3ca4e4.png
So far I have tried:
- phpStorm dataBase - neither draw nor print normally, no links between fields
- navicat - neither draw, nor print normally, no links between fields
- DBVisualizer - did not find ability to draw links
- sql designer - only manual schema creation. I did not find automatic unloading of the current structure.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Sam, 2016-09-29
@sammolove

So far, I have found only one solution for building a diagram using DDL - this is DbSchema - www.dbschema.com/index.html
True, for some reason, on request, he did not extend all the links for me, but there was another option - with a connection to the database. I completed this request to create a schema, connected, and you're done! Then it remains only to arrange the rectangles with the tables in the way that suits you best. There is export to pictures and even to vector svg, which is more suitable for printing. And in order to add SVG to Word, you need to open Incskape and save emf or arbitrarily large with PNG transparency.

S
Sergey Eremin, 2014-10-23
@Sergei_Erjemin

I like dbForge Studio... the schemas are quite reasonable in it. But it's only for MySQL :(

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question