/notations/er
ER in Arq
Entities with attribute rows, keys and cardinalities, linked to the applications and data stores that use them. Exports as Postgres DDL, DBML and JSON Schema; imports SQL DDL.
/01 Fidelity
L2 Import and export round-trip the conformance fixtures.
Arq declares a level only when its test fixtures prove it, and raises it the same way.
/02 What you can model
- data
- Logical Entity, Physical Data Object, Information Concept, Data Store
Preferred relationships: relates to, composes, realizes.
/03 Interchange
| SQL DDL (Postgres) | Import and export |
|---|---|
| DBML | Export |
| JSON Schema | Export |
| SVG and PNG | Export per view |
Every notation draws the same model: an element on this Entity Relationship view can appear on views in other notations too. More in the documentation.