/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
DBMLExport
JSON SchemaExport
SVG and PNGExport 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.