top | item 43810011

(no title)

solids | 10 months ago

Mermaid is also great

https://docs.mermaidchart.com/blog/posts/7-er-diagram-exampl...

discuss

order

nickkell|10 months ago

I use it in my project to document the schema. We keep the markdown file in source control so that we update it whenever we make database changes. We also have an extension that allows viewing it as the diagram in vscode in our .vscode\extensions.json file.

There are some disadvantages however:

1. The foreign key relationships aren't completely clear

2. The diagram became difficult to navigate in vscode as our schema grew in size

blitztime|10 months ago

I found out about mermaid recently and have been using it to make diagrams. How do you use it for data modeling though?

PhilippGille|10 months ago

Did you follow the link that the parent poster posted? It's exactly about how to do data modeling with Mermaid.

Ygg2|10 months ago

What do you mean by data modelling? Which UML part? You start the diagram with a `erDiagram`

    ---
    title: Order example
    ---
    erDiagram
        CUSTOMER ||--o{ ORDER : places