Data and databases
Data diagrams answer three separate questions: what the data is, where it is stored, and where it came from. Trying to answer all three in one diagram is the usual reason data documentation goes unread.
Almost everything here is better as text, because schemas change and text changes cheaply.
#In this section
Entity relationship diagramCreate an ER diagram in Confluence. Compare Mermaid, ERD and DBML, then copy a working example.Crow's foot notationRead and write crow's foot notation: one-to-many, many-to-many, optional and mandatory cardinality.Database schema diagramDocument tables, columns, types and foreign keys in Confluence from a text schema definition.Data model diagramDraw conceptual, logical and physical data models and pick the right notation for each level.Star schemaDiagram a star or snowflake schema with a fact table at the centre and its dimension tables around it.Data lineage diagramMap lineage from source system through transformations to the dashboards that consume the data.JSON structure diagramTurn a JSON payload into a readable structure diagram for API docs and webhook contracts.
Get the cardinality right and the rest follows.
