Examples: er-editorial-catalog
Examples: er-editorial-catalog
Copy and paste, or save a file and hand it over. For a machine with no network, one “Everything” file is enough.
Everything in this panel, including the contents behind each URL, in one Markdown file — Large, so it goes as a file (copy is for 32 KB and under)
I need a "Entity Relationship" diagram. It is published as text and vectors, so taking the published one and editing it beats redrawing it. ## What this diagram says Places entities, their columns, and the relationships between them, at the logical level. ## When it fits - Agreeing on normalization and where the foreign keys go. - Showing cardinality to someone reading an existing schema. ## When it does not - When indexes or physical layout are the subject: this profile is logical. - When the movement of data is the subject — use Data Flow. ## What this kind validates - Validates entities and columns, primary and unique keys, column-level foreign keys, and cardinality and type agreement. ## What it does not - Does not check agreement with a real database. ## What you can take - https://design-vault.pages.dev/designs/diagram-er/samples/er-editorial-catalog/diagram-spec.json - https://design-vault.pages.dev/designs/diagram-er/samples/er-editorial-catalog/er.drawio - https://design-vault.pages.dev/designs/diagram-er/samples/er-editorial-catalog/er.png - https://design-vault.pages.dev/designs/diagram-er/samples/er-editorial-catalog/er.svg - https://design-vault.pages.dev/designs/diagram-er/samples/er-editorial-catalog/layout.json - https://design-vault.pages.dev/ai/assets/diagram-er.json ## What you can edit The published `.drawio` is uncompressed XML. Open it in draw.io and edit it, or diff it as text. Operations this kind accepts through the engine: alignNodes, distributeNodes, moveNode, resizeNode This kind accepts only geometry operations — it has none that change meaning. ## Writing a new one A `diagram-spec.json` can be written against the schema below. - https://design-vault.pages.dev/schemas/diagram-spec.schema.json - https://design-vault.pages.dev/schemas/layout.schema.json ## What cannot be done here **A spec you write cannot be validated here, and `layout.json` cannot be computed here.** The generator that does both is not published; what is published is the artifacts, the inputs and the schemas. Place the geometry yourself, or hand the spec to someone who has the engine. ## Licence The diagram and its inputs are CC BY 4.0 — carry the credit when you use them. > "Entity Relationship" by zawa, licensed under CC BY 4.0. https://creativecommons.org/licenses/by/4.0/ The schemas are MIT.
/designs/diagram-er/samples/er-editorial-catalog/diagram-spec.json
{
"$schema": "../../../../schemas/diagram-spec.schema.json",
"schemaVersion": "2.0",
"diagramKind": "er",
"id": "editorial-catalog-er",
"title": "Editorial Catalog — Logical ER",
"description": "Logical relational structure for articles, revisions, tags, and their stable references.",
"language": "en",
"nodes": [
{
"id": "articles",
"type": "entity",
"title": "Article",
"description": "Editorial content identity.",
"attributes": [
{
"id": "article-id",
"name": "id",
"dataType": "uuid",
"nullable": false
},
{
"id": "article-slug",
"name": "slug",
"dataType": "text",
"nullable": false
},
{
"id": "article-title",
"name": "title",
"dataType": "text",
"nullable": false
}
],
"primaryKey": {
"id": "articles-pk",
"attributeIds": [
"article-id"
]
},
"uniqueKeys": [
{
"id": "articles-slug-uk",
"attributeIds": [
"article-slug"
]
}
]
},
{
"id": "revisions",
"type": "entity",
"title": "Revision",
"description": "Versioned article body.",
"attributes": [
{
"id": "revision-article-id",
"name": "article_id",
"dataType": "uuid",
"nullable": false
},
{
"id": "revision-number",
"name": "revision_no",
"dataType": "integer",
"nullable": false
},
{
"id": "revision-body",
"name": "body",
"dataType": "text",
"nullable": false
}
],
"primaryKey": {
"id": "revisions-pk",
"attributeIds": [
"revision-article-id",
"revision-number"
]
},
"uniqueKeys": []
},
{
"id": "tags",
"type": "entity",
"title": "Tag",
"description": "Reusable editorial classification.",
"attributes": [
{
"id": "tag-id",
"name": "id",
"dataType": "uuid",
"nullable": false
},
{
"id": "tag-name",
"name": "name",
"dataType": "text",
"nullable": false
}
],
"primaryKey": {
"id": "tags-pk",
"attributeIds": [
"tag-id"
]
},
"uniqueKeys": [
{
"id": "tags-name-uk",
"attributeIds": [
"tag-name"
]
}
]
},
{
"id": "article-tags",
"type": "entity",
"title": "Article Tag",
"description": "Identifying article-to-tag membership.",
"attributes": [
{
"id": "article-tag-article-id",
"name": "article_id",
"dataType": "uuid",
"nullable": false
},
{
"id": "article-tag-tag-id",
"name": "tag_id",
"dataType": "uuid",
"nullable": false
}
],
"primaryKey": {
"id": "article-tags-pk",
"attributeIds": [
"article-tag-article-id",
"article-tag-tag-id"
]
},
"uniqueKeys": []
}
],
"edges": [
{
"id": "article-revisions-fk",
"type": "foreign-key",
"from": "revisions",
"to": "articles",
"title": "has revisions",
"fromAttributeIds": [
"revision-article-id"
],
"toAttributeIds": [
"article-id"
],
"fromCardinality": "zero-or-many",
"toCardinality": "one",
"identifying": true
},
{
"id": "article-tags-article-fk",
"type": "foreign-key",
"from": "article-tags",
"to": "articles",
"title": "classifies article",
"fromAttributeIds": [
"article-tag-article-id"
],
"toAttributeIds": [
"article-id"
],
"fromCardinality": "zero-or-many",
"toCardinality": "one",
"identifying": true
},
{
"id": "article-tags-tag-fk",
"type": "foreign-key",
"from": "article-tags",
"to": "tags",
"title": "uses tag",
"fromAttributeIds": [
"article-tag-tag-id"
],
"toAttributeIds": [
"tag-id"
],
"fromCardinality": "zero-or-many",
"toCardinality": "one",
"identifying": true
}
]
}
/designs/diagram-er/samples/er-editorial-catalog/er.drawio
<?xml version="1.0" encoding="UTF-8"?>
<mxfile host="app.diagrams.net" compressed="false">
<diagram id="editorial-catalog-er" name="Entity Relationship" syncFormat="1.0" diagramKind="er" inputHash="cbaac99586f1055f83f0b0afc37f6e40be4ab8bdd67097616fd59d94a57fcd9d" generatorVersion="0.7.0">
<mxGraphModel dx="1200" dy="820" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="1280" pageHeight="900" math="0" shadow="0">
<root>
<mxCell id="0"/>
<mxCell id="1" parent="0"/>
<mxCell id="diagram-title" value="Editorial Catalog — Logical ER" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=23;fontStyle=1;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="32" y="22" width="720" height="42" as="geometry"/></mxCell>
<mxCell id="legend-0-mark" value="" style="ellipse;html=1;aspect=fixed;fillColor=#FFFFFF;strokeColor=#59697D;strokeWidth=1.6;" vertex="1" parent="1"><mxGeometry x="32" y="85" width="10" height="10" as="geometry"/></mxCell>
<mxCell id="legend-0-text" value="Entity" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=13;fontStyle=0;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="49" y="77" width="170" height="28" as="geometry"/></mxCell>
<mxCell id="legend-1-mark" value="" style="ellipse;html=1;aspect=fixed;fillColor=#FFFFFF;strokeColor=#343A42;strokeWidth=1.6;" vertex="1" parent="1"><mxGeometry x="254" y="85" width="10" height="10" as="geometry"/></mxCell>
<mxCell id="legend-1-text" value="Foreign Key" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=13;fontStyle=0;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="271" y="77" width="170" height="28" as="geometry"/></mxCell>
<mxCell id="legend-2-mark" value="" style="ellipse;html=1;aspect=fixed;fillColor=#FFFFFF;strokeColor=#C58A21;strokeWidth=1.6;" vertex="1" parent="1"><mxGeometry x="476" y="85" width="10" height="10" as="geometry"/></mxCell>
<mxCell id="legend-2-text" value="Identifying FK" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=13;fontStyle=0;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="493" y="77" width="170" height="28" as="geometry"/></mxCell>
<object id="article-revisions-fk" label="" componentId="article-revisions-fk" erType="edge" erRelationshipType="foreign-key" variant="warning" direction="forward" fromAttributeIds="revision-article-id" toAttributeIds="article-id" fromCardinality="zero-or-many" toCardinality="one" identifying="1" relationshipTitle="has revisions"><mxCell style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#C58A21;strokeWidth=1.6;endArrow=open;endFill=0;endSize=8;startArrow=none;exitX=0;exitY=0.48;exitDx=0;exitDy=0;exitPerimeter=1;entryX=1;entryY=0.48;entryDx=0;entryDy=0;entryPerimeter=1;" edge="1" parent="1" source="revisions" target="articles"><mxGeometry relative="1" as="geometry"></mxGeometry></mxCell></object>
<mxCell id="article-revisions-fk--label" value="has revisions<br>[0..* → 1]" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=1;fontColor=#292E35;spacing=0;labelBackgroundColor=#FFFFFF;" vertex="1" parent="1" syncRole="edge-label" ownerId="article-revisions-fk"><mxGeometry x="576.26" y="233" width="107.48" height="34" as="geometry"/></mxCell>
<object id="article-tags-article-fk" label="" componentId="article-tags-article-fk" erType="edge" erRelationshipType="foreign-key" variant="warning" direction="forward" fromAttributeIds="article-tag-article-id" toAttributeIds="article-id" fromCardinality="zero-or-many" toCardinality="one" identifying="1" relationshipTitle="classifies article"><mxCell style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#C58A21;strokeWidth=1.6;endArrow=open;endFill=0;endSize=8;startArrow=none;exitX=0.3;exitY=0;exitDx=0;exitDy=0;exitPerimeter=1;entryX=0.7;entryY=1;entryDx=0;entryDy=0;entryPerimeter=1;" edge="1" parent="1" source="article-tags" target="articles"><mxGeometry relative="1" as="geometry"><Array as="points"><mxPoint x="959" y="460"/><mxPoint x="304" y="460"/></Array></mxGeometry></mxCell></object>
<mxCell id="article-tags-article-fk--label" value="classifies article<br>[0..* → 1]" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=1;fontColor=#292E35;spacing=0;labelBackgroundColor=#FFFFFF;" vertex="1" parent="1" syncRole="edge-label" ownerId="article-tags-article-fk"><mxGeometry x="557.66" y="423" width="144.68" height="34" as="geometry"/></mxCell>
<object id="article-tags-tag-fk" label="" componentId="article-tags-tag-fk" erType="edge" erRelationshipType="foreign-key" variant="warning" direction="forward" fromAttributeIds="article-tag-tag-id" toAttributeIds="tag-id" fromCardinality="zero-or-many" toCardinality="one" identifying="1" relationshipTitle="uses tag"><mxCell style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#C58A21;strokeWidth=1.6;endArrow=open;endFill=0;endSize=8;startArrow=none;exitX=0;exitY=0.62;exitDx=0;exitDy=0;exitPerimeter=1;entryX=1;entryY=0.62;entryDx=0;entryDy=0;entryPerimeter=1;" edge="1" parent="1" source="article-tags" target="tags"><mxGeometry relative="1" as="geometry"></mxGeometry></mxCell></object>
<mxCell id="article-tags-tag-fk--label" value="uses tag<br>[0..* → 1]" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=1;fontColor=#292E35;spacing=0;labelBackgroundColor=#FFFFFF;" vertex="1" parent="1" syncRole="edge-label" ownerId="article-tags-tag-fk"><mxGeometry x="586.76" y="633" width="86.48" height="34" as="geometry"/></mxCell>
<object id="articles" label="" componentId="articles" erType="entity" variant="delegated" erAttributes="[{"id":"article-id","name":"id","dataType":"uuid","nullable":false},{"id":"article-slug","name":"slug","dataType":"text","nullable":false},{"id":"article-title","name":"title","dataType":"text","nullable":false}]" erPrimaryKey="{"id":"articles-pk","attributeIds":["article-id"]}" erUniqueKeys="[{"id":"articles-slug-uk","attributeIds":["article-slug"]}]"><mxCell style="rounded=1;arcSize=4;whiteSpace=wrap;html=1;fillColor=#EDF3FF;strokeColor=#59697D;strokeWidth=1.6;" vertex="1" parent="1"><mxGeometry x="80" y="160" width="320" height="250" as="geometry"/></mxCell></object>
<mxCell id="articles--title" value="Article" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=15;fontStyle=1;fontColor=#292E35;spacing=0;align=center;verticalAlign=middle;" vertex="1" parent="articles" syncRole="title" ownerId="articles"><mxGeometry x="10" y="8" width="300" height="30" as="geometry"/></mxCell>
<mxCell id="articles--description" value="Editorial content identity." style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=0;fontColor=#58616C;spacing=0;align=center;verticalAlign=middle;" vertex="1" parent="articles" syncRole="description" ownerId="articles"><mxGeometry x="12" y="38" width="296" height="28" as="geometry"/></mxCell>
<mxCell id="articles--control-1" value="PK id: uuid" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=1;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="articles" syncRole="control" ownerId="articles"><mxGeometry x="14" y="72" width="292" height="24" as="geometry"/></mxCell>
<mxCell id="articles--control-2" value="UK slug: text" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=0;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="articles" syncRole="control" ownerId="articles"><mxGeometry x="14" y="100" width="292" height="24" as="geometry"/></mxCell>
<mxCell id="articles--control-3" value="title: text" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=0;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="articles" syncRole="control" ownerId="articles"><mxGeometry x="14" y="128" width="292" height="24" as="geometry"/></mxCell>
<object id="revisions" label="" componentId="revisions" erType="entity" variant="delegated" erAttributes="[{"id":"revision-article-id","name":"article_id","dataType":"uuid","nullable":false},{"id":"revision-number","name":"revision_no","dataType":"integer","nullable":false},{"id":"revision-body","name":"body","dataType":"text","nullable":false}]" erPrimaryKey="{"id":"revisions-pk","attributeIds":["revision-article-id","revision-number"]}" erUniqueKeys="[]"><mxCell style="rounded=1;arcSize=4;whiteSpace=wrap;html=1;fillColor=#EDF3FF;strokeColor=#59697D;strokeWidth=1.6;" vertex="1" parent="1"><mxGeometry x="860" y="150" width="330" height="250" as="geometry"/></mxCell></object>
<mxCell id="revisions--title" value="Revision" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=15;fontStyle=1;fontColor=#292E35;spacing=0;align=center;verticalAlign=middle;" vertex="1" parent="revisions" syncRole="title" ownerId="revisions"><mxGeometry x="10" y="8" width="310" height="30" as="geometry"/></mxCell>
<mxCell id="revisions--description" value="Versioned article body." style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=0;fontColor=#58616C;spacing=0;align=center;verticalAlign=middle;" vertex="1" parent="revisions" syncRole="description" ownerId="revisions"><mxGeometry x="12" y="38" width="306" height="28" as="geometry"/></mxCell>
<mxCell id="revisions--control-1" value="PK article_id: uuid" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=1;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="revisions" syncRole="control" ownerId="revisions"><mxGeometry x="14" y="72" width="302" height="24" as="geometry"/></mxCell>
<mxCell id="revisions--control-2" value="PK revision_no: integer" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=1;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="revisions" syncRole="control" ownerId="revisions"><mxGeometry x="14" y="100" width="302" height="24" as="geometry"/></mxCell>
<mxCell id="revisions--control-3" value="body: text" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=0;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="revisions" syncRole="control" ownerId="revisions"><mxGeometry x="14" y="128" width="302" height="24" as="geometry"/></mxCell>
<object id="tags" label="" componentId="tags" erType="entity" variant="delegated" erAttributes="[{"id":"tag-id","name":"id","dataType":"uuid","nullable":false},{"id":"tag-name","name":"name","dataType":"text","nullable":false}]" erPrimaryKey="{"id":"tags-pk","attributeIds":["tag-id"]}" erUniqueKeys="[{"id":"tags-name-uk","attributeIds":["tag-name"]}]"><mxCell style="rounded=1;arcSize=4;whiteSpace=wrap;html=1;fillColor=#EDF3FF;strokeColor=#59697D;strokeWidth=1.6;" vertex="1" parent="1"><mxGeometry x="80" y="540" width="320" height="220" as="geometry"/></mxCell></object>
<mxCell id="tags--title" value="Tag" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=15;fontStyle=1;fontColor=#292E35;spacing=0;align=center;verticalAlign=middle;" vertex="1" parent="tags" syncRole="title" ownerId="tags"><mxGeometry x="10" y="8" width="300" height="30" as="geometry"/></mxCell>
<mxCell id="tags--description" value="Reusable editorial classification." style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=0;fontColor=#58616C;spacing=0;align=center;verticalAlign=middle;" vertex="1" parent="tags" syncRole="description" ownerId="tags"><mxGeometry x="12" y="38" width="296" height="28" as="geometry"/></mxCell>
<mxCell id="tags--control-1" value="PK id: uuid" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=1;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="tags" syncRole="control" ownerId="tags"><mxGeometry x="14" y="72" width="292" height="24" as="geometry"/></mxCell>
<mxCell id="tags--control-2" value="UK name: text" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=0;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="tags" syncRole="control" ownerId="tags"><mxGeometry x="14" y="100" width="292" height="24" as="geometry"/></mxCell>
<object id="article-tags" label="" componentId="article-tags" erType="entity" variant="delegated" erAttributes="[{"id":"article-tag-article-id","name":"article_id","dataType":"uuid","nullable":false},{"id":"article-tag-tag-id","name":"tag_id","dataType":"uuid","nullable":false}]" erPrimaryKey="{"id":"article-tags-pk","attributeIds":["article-tag-article-id","article-tag-tag-id"]}" erUniqueKeys="[]"><mxCell style="rounded=1;arcSize=4;whiteSpace=wrap;html=1;fillColor=#EDF3FF;strokeColor=#59697D;strokeWidth=1.6;" vertex="1" parent="1"><mxGeometry x="860" y="520" width="330" height="230" as="geometry"/></mxCell></object>
<mxCell id="article-tags--title" value="Article Tag" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=15;fontStyle=1;fontColor=#292E35;spacing=0;align=center;verticalAlign=middle;" vertex="1" parent="article-tags" syncRole="title" ownerId="article-tags"><mxGeometry x="10" y="8" width="310" height="30" as="geometry"/></mxCell>
<mxCell id="article-tags--description" value="Identifying article-to-tag membership." style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=0;fontColor=#58616C;spacing=0;align=center;verticalAlign=middle;" vertex="1" parent="article-tags" syncRole="description" ownerId="article-tags"><mxGeometry x="12" y="38" width="306" height="28" as="geometry"/></mxCell>
<mxCell id="article-tags--control-1" value="PK article_id: uuid" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=1;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="article-tags" syncRole="control" ownerId="article-tags"><mxGeometry x="14" y="72" width="302" height="24" as="geometry"/></mxCell>
<mxCell id="article-tags--control-2" value="PK tag_id: uuid" style="text;html=1;strokeColor=none;fillColor=none;whiteSpace=wrap;rounded=0;fontFamily=Meiryo UI;fontSize=12;fontStyle=1;fontColor=#292E35;spacing=0;align=left;verticalAlign=middle;" vertex="1" parent="article-tags" syncRole="control" ownerId="article-tags"><mxGeometry x="14" y="100" width="302" height="24" as="geometry"/></mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>
/designs/diagram-er/samples/er-editorial-catalog/layout.json
{
"$schema": "../../../../schemas/layout.schema.json",
"schemaVersion": "1.0",
"canvas": {
"width": 1280,
"height": 900
},
"nodes": {
"articles": {
"x": 80,
"y": 160,
"width": 320,
"height": 250
},
"revisions": {
"x": 860,
"y": 150,
"width": 330,
"height": 250
},
"tags": {
"x": 80,
"y": 540,
"width": 320,
"height": 220
},
"article-tags": {
"x": 860,
"y": 520,
"width": 330,
"height": 230
}
},
"edges": {
"article-revisions-fk": {
"source": {
"side": "left",
"offset": 0.48
},
"target": {
"side": "right",
"offset": 0.48
},
"label": {
"x": 630,
"y": 250
}
},
"article-tags-article-fk": {
"source": {
"side": "top",
"offset": 0.3
},
"target": {
"side": "bottom",
"offset": 0.7
},
"waypoints": [
{
"x": 959,
"y": 460
},
{
"x": 304,
"y": 460
}
],
"label": {
"x": 630,
"y": 440
}
},
"article-tags-tag-fk": {
"source": {
"side": "left",
"offset": 0.62
},
"target": {
"side": "right",
"offset": 0.62
},
"label": {
"x": 630,
"y": 650
}
}
}
}
/schemas/diagram-spec.schema.json — Large, so it goes as a file (copy is for 32 KB and under)
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://example.local/schemas/diagram-spec.schema.json",
"title": "Editorial diagram semantic specification",
"oneOf": [
{ "$ref": "#/$defs/legacyArchitectureSpec" },
{ "$ref": "#/$defs/architectureSpec" },
{ "$ref": "#/$defs/c4SystemContextSpec" },
{ "$ref": "#/$defs/c4ContainerSpec" },
{ "$ref": "#/$defs/dataFlowSpec" },
{ "$ref": "#/$defs/deploymentSpec" },
{ "$ref": "#/$defs/bpmnLiteSpec" },
{ "$ref": "#/$defs/sequenceSpec" },
{ "$ref": "#/$defs/erSpec" },
{ "$ref": "#/$defs/stateSpec" },
{ "$ref": "#/$defs/decisionTreeSpec" },
{ "$ref": "#/$defs/timelineSpec" },
{ "$ref": "#/$defs/roadmapSpec" },
{ "$ref": "#/$defs/capabilityMapSpec" },
{ "$ref": "#/$defs/executiveViewSpec" }
],
"$defs": {
"baseSpec": {
"type": "object",
"required": ["schemaVersion", "id", "title", "language", "legend", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "type": "string" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"legend": {
"type": "array",
"maxItems": 8,
"items": {
"type": "object",
"additionalProperties": false,
"required": ["label", "variant"],
"properties": {
"label": { "type": "string", "minLength": 1, "maxLength": 60 },
"variant": { "$ref": "#/$defs/variant" }
}
}
},
"boundaries": {
"type": "array",
"maxItems": 50,
"items": { "$ref": "#/$defs/boundary" }
},
"nodes": {
"type": "array",
"minItems": 1,
"items": { "$ref": "#/$defs/node" }
},
"edges": {
"type": "array",
"items": { "$ref": "#/$defs/edge" }
}
}
},
"legacyArchitectureSpec": {
"type": "object",
"allOf": [
{ "$ref": "#/$defs/baseSpec" },
{
"type": "object",
"properties": {
"schemaVersion": { "const": "1.0" }
}
}
],
"unevaluatedProperties": false
},
"architectureSpec": {
"type": "object",
"allOf": [
{ "$ref": "#/$defs/baseSpec" },
{
"type": "object",
"required": ["diagramKind"],
"properties": {
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "architecture" }
}
}
],
"unevaluatedProperties": false
},
"c4SystemContextSpec": {
"type": "object",
"additionalProperties": false,
"required": [
"schemaVersion", "diagramKind", "id", "title", "language", "scopeSystemId",
"scopeBoundaryId", "boundaries", "nodes", "edges"
],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "c4-system-context" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"scopeSystemId": { "$ref": "#/$defs/id" },
"scopeBoundaryId": { "$ref": "#/$defs/id" },
"boundaries": {
"type": "array",
"minItems": 1,
"maxItems": 8,
"items": { "$ref": "#/$defs/c4SystemBoundary" }
},
"nodes": {
"type": "array",
"minItems": 2,
"maxItems": 50,
"items": { "$ref": "#/$defs/c4Element" }
},
"edges": {
"type": "array",
"minItems": 1,
"maxItems": 100,
"items": { "$ref": "#/$defs/c4Relationship" }
}
}
},
"c4SystemBoundary": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "system-boundary" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"c4Element": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["person", "software-system", "external-system"] },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"c4Relationship": {
"type": "object",
"additionalProperties": false,
"required": ["id", "from", "to", "type", "description"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"from": { "$ref": "#/$defs/id" },
"to": { "$ref": "#/$defs/id" },
"type": { "const": "relationship" },
"description": { "type": "string", "minLength": 3, "maxLength": 160 },
"technology": { "type": "string", "minLength": 1, "maxLength": 64 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"c4ContainerSpec": {
"type": "object",
"additionalProperties": false,
"required": [
"schemaVersion", "diagramKind", "id", "title", "language", "contextDiagramId",
"scopeSystemId", "scopeBoundaryId", "boundaries", "nodes", "edges"
],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "c4-container" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"contextDiagramId": { "$ref": "#/$defs/id" },
"scopeSystemId": { "$ref": "#/$defs/id" },
"scopeBoundaryId": { "$ref": "#/$defs/id" },
"boundaries": {
"type": "array",
"minItems": 1,
"maxItems": 8,
"items": { "$ref": "#/$defs/c4SystemBoundary" }
},
"nodes": {
"type": "array",
"minItems": 1,
"maxItems": 80,
"items": { "$ref": "#/$defs/c4ContainerElement" }
},
"edges": {
"type": "array",
"minItems": 1,
"maxItems": 160,
"items": { "$ref": "#/$defs/c4Relationship" }
}
}
},
"c4ContainerElement": {
"oneOf": [
{ "$ref": "#/$defs/c4ContainerPrimary" },
{ "$ref": "#/$defs/c4ContainerSupportingElement" }
]
},
"c4ContainerPrimary": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "containerKind", "title", "description", "technology"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "container" },
"containerKind": { "enum": ["application", "data-store"] },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"technology": { "type": "string", "minLength": 1, "maxLength": 80 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"c4ContainerSupportingElement": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["person", "external-system"] },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"bpmnLiteSpec": {
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "diagramKind", "id", "title", "language", "pool", "lanes", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "bpmn-lite" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"pool": { "$ref": "#/$defs/bpmnPool" },
"lanes": {
"type": "array",
"minItems": 2,
"maxItems": 16,
"items": { "$ref": "#/$defs/bpmnLane" }
},
"nodes": {
"type": "array",
"minItems": 4,
"maxItems": 160,
"items": { "$ref": "#/$defs/bpmnFlowNode" }
},
"edges": {
"type": "array",
"minItems": 3,
"maxItems": 320,
"items": { "$ref": "#/$defs/bpmnSequenceFlow" }
}
}
},
"bpmnPool": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "pool" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"bpmnLane": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "lane" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"bpmnFlowNode": {
"oneOf": [
{ "$ref": "#/$defs/bpmnSimpleFlowNode" },
{ "$ref": "#/$defs/bpmnGateway" }
]
},
"bpmnSimpleFlowNode": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "laneId"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["start-event", "end-event", "task"] },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"laneId": { "$ref": "#/$defs/id" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"bpmnGateway": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "laneId", "gatewayRole"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["exclusive-gateway", "parallel-gateway"] },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"laneId": { "$ref": "#/$defs/id" },
"gatewayRole": { "enum": ["split", "join"] },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"bpmnSequenceFlow": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "from", "to"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "sequence-flow" },
"from": { "$ref": "#/$defs/id" },
"to": { "$ref": "#/$defs/id" },
"condition": { "type": "string", "minLength": 1, "maxLength": 160 },
"isDefault": { "type": "boolean" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"sequenceSpec": {
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "diagramKind", "id", "title", "language", "nodes", "fragments", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "sequence" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"nodes": { "type": "array", "minItems": 2, "maxItems": 32, "items": { "$ref": "#/$defs/sequenceLifeline" } },
"fragments": { "type": "array", "maxItems": 24, "items": { "$ref": "#/$defs/sequenceFragment" } },
"edges": { "type": "array", "minItems": 1, "maxItems": 320, "items": { "$ref": "#/$defs/sequenceMessage" } }
}
},
"sequenceLifeline": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "occurrenceIds"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "lifeline" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"occurrenceIds": { "type": "array", "minItems": 1, "maxItems": 320, "uniqueItems": true, "items": { "$ref": "#/$defs/id" } },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"sequenceFragment": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "operator", "title", "operands"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "combined-fragment" },
"operator": { "enum": ["alt", "opt", "par"] },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"operands": { "type": "array", "minItems": 1, "maxItems": 8, "items": { "$ref": "#/$defs/sequenceOperand" } },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"sequenceOperand": {
"type": "object",
"additionalProperties": false,
"required": ["id", "occurrenceIds"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"guard": { "type": "string", "minLength": 1, "maxLength": 120 },
"occurrenceIds": { "type": "array", "minItems": 1, "maxItems": 160, "uniqueItems": true, "items": { "$ref": "#/$defs/id" } }
}
},
"sequenceMessage": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "from", "to", "title", "sendOccurrenceId", "receiveOccurrenceId"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["sync-message", "async-message", "return-message"] },
"from": { "$ref": "#/$defs/id" },
"to": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"sendOccurrenceId": { "$ref": "#/$defs/id" },
"receiveOccurrenceId": { "$ref": "#/$defs/id" },
"replyTo": { "$ref": "#/$defs/id" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"erSpec": {
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "diagramKind", "id", "title", "language", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "er" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"nodes": { "type": "array", "minItems": 2, "maxItems": 120, "items": { "$ref": "#/$defs/erEntity" } },
"edges": { "type": "array", "maxItems": 240, "items": { "$ref": "#/$defs/erForeignKey" } }
}
},
"erEntity": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description", "attributes", "primaryKey", "uniqueKeys"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "entity" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"attributes": { "type": "array", "minItems": 1, "maxItems": 80, "items": { "$ref": "#/$defs/erAttribute" } },
"primaryKey": { "$ref": "#/$defs/erKey" },
"uniqueKeys": { "type": "array", "maxItems": 24, "items": { "$ref": "#/$defs/erKey" } },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"erAttribute": {
"type": "object",
"additionalProperties": false,
"required": ["id", "name", "dataType", "nullable"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"name": { "type": "string", "minLength": 1, "maxLength": 80 },
"dataType": { "type": "string", "minLength": 1, "maxLength": 80 },
"nullable": { "type": "boolean" }
}
},
"erKey": {
"type": "object",
"additionalProperties": false,
"required": ["id", "attributeIds"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"attributeIds": { "type": "array", "maxItems": 16, "items": { "$ref": "#/$defs/id" } }
}
},
"erForeignKey": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "from", "to", "fromAttributeIds", "toAttributeIds", "fromCardinality", "toCardinality", "identifying"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "foreign-key" },
"from": { "$ref": "#/$defs/id" },
"to": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"fromAttributeIds": { "type": "array", "maxItems": 16, "items": { "$ref": "#/$defs/id" } },
"toAttributeIds": { "type": "array", "maxItems": 16, "items": { "$ref": "#/$defs/id" } },
"fromCardinality": { "$ref": "#/$defs/erCardinality" },
"toCardinality": { "$ref": "#/$defs/erCardinality" },
"identifying": { "type": "boolean" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"erCardinality": { "enum": ["zero-or-one", "one", "zero-or-many", "one-or-many"] },
"stateSpec": {
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "diagramKind", "id", "title", "language", "initialStateId", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "state" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"initialStateId": { "$ref": "#/$defs/id" },
"nodes": { "type": "array", "minItems": 2, "maxItems": 120, "items": { "$ref": "#/$defs/stateNode" } },
"edges": { "type": "array", "minItems": 1, "maxItems": 240, "items": { "$ref": "#/$defs/stateTransition" } }
}
},
"stateNode": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["state", "final-state"] },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"stateTransition": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "from", "to", "event"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "transition" },
"from": { "$ref": "#/$defs/id" },
"to": { "$ref": "#/$defs/id" },
"event": { "type": "string", "minLength": 1, "maxLength": 120 },
"guard": { "type": "string", "minLength": 1, "maxLength": 160 },
"action": { "type": "string", "minLength": 1, "maxLength": 160 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"decisionTreeSpec": {
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "diagramKind", "id", "title", "language", "rootNodeId", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "decision-tree" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"rootNodeId": { "$ref": "#/$defs/id" },
"nodes": { "type": "array", "minItems": 3, "maxItems": 160, "items": { "$ref": "#/$defs/decisionTreeNode" } },
"edges": { "type": "array", "minItems": 2, "maxItems": 320, "items": { "$ref": "#/$defs/decisionBranch" } }
}
},
"decisionTreeNode": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["decision", "outcome"] },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"decisionBranch": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "from", "to", "isDefault"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "branch" },
"from": { "$ref": "#/$defs/id" },
"to": { "$ref": "#/$defs/id" },
"condition": { "type": "string", "minLength": 1, "maxLength": 160 },
"isDefault": { "type": "boolean" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"timelineSpec": {
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "diagramKind", "id", "title", "language", "windowStart", "windowEnd", "workstreams", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "timeline" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"windowStart": { "$ref": "#/$defs/isoDate" },
"windowEnd": { "$ref": "#/$defs/isoDate" },
"workstreams": { "type": "array", "minItems": 1, "maxItems": 6, "items": { "$ref": "#/$defs/timelineWorkstream" } },
"nodes": { "type": "array", "minItems": 1, "maxItems": 40, "items": { "$ref": "#/$defs/timelineItem" } },
"edges": { "type": "array", "maxItems": 80, "items": { "$ref": "#/$defs/timelineDependency" } }
}
},
"timelineWorkstream": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "workstream" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"timelineItem": {
"oneOf": [
{ "$ref": "#/$defs/timelineTask" },
{ "$ref": "#/$defs/timelineMilestone" }
]
},
"timelineTask": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description", "workstreamId", "startDate", "endDate", "status"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "task" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"workstreamId": { "$ref": "#/$defs/id" },
"startDate": { "$ref": "#/$defs/isoDate" },
"endDate": { "$ref": "#/$defs/isoDate" },
"status": { "$ref": "#/$defs/timelineStatus" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"timelineMilestone": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description", "workstreamId", "date", "status"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "milestone" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"workstreamId": { "$ref": "#/$defs/id" },
"date": { "$ref": "#/$defs/isoDate" },
"status": { "$ref": "#/$defs/timelineStatus" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"timelineDependency": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "from", "to"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "finish-to-start" },
"from": { "$ref": "#/$defs/id" },
"to": { "$ref": "#/$defs/id" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"timelineStatus": { "enum": ["planned", "active", "blocked", "done"] },
"isoDate": { "type": "string", "pattern": "^[0-9]{4}-[0-9]{2}-[0-9]{2}$" },
"roadmapSpec": {
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "diagramKind", "id", "title", "language", "vision", "horizons", "themes", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "roadmap" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"vision": { "type": "string", "minLength": 8, "maxLength": 180 },
"horizons": { "type": "array", "minItems": 3, "maxItems": 3, "items": { "$ref": "#/$defs/roadmapHorizon" } },
"themes": { "type": "array", "minItems": 1, "maxItems": 5, "items": { "$ref": "#/$defs/roadmapTheme" } },
"nodes": { "type": "array", "minItems": 1, "maxItems": 24, "items": { "$ref": "#/$defs/roadmapInitiative" } },
"edges": { "type": "array", "maxItems": 0 }
}
},
"roadmapHorizon": {
"type": "object",
"additionalProperties": false,
"required": ["id", "kind", "title", "description"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"kind": { "enum": ["now", "next", "later"] },
"title": { "type": "string", "minLength": 1, "maxLength": 40 },
"description": { "type": "string", "minLength": 3, "maxLength": 120 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"roadmapTheme": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "theme" },
"title": { "type": "string", "minLength": 1, "maxLength": 60 },
"description": { "type": "string", "minLength": 3, "maxLength": 160 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"roadmapInitiative": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description", "outcome", "themeId", "horizonId", "status"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "initiative" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 200 },
"outcome": { "type": "string", "minLength": 8, "maxLength": 220 },
"themeId": { "$ref": "#/$defs/id" },
"horizonId": { "$ref": "#/$defs/id" },
"status": { "enum": ["exploring", "planned", "active", "delivered"] },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"capabilityMapSpec": {
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "diagramKind", "id", "title", "language", "scope", "domains", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "capability-map" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"scope": { "type": "string", "minLength": 8, "maxLength": 220 },
"domains": { "type": "array", "minItems": 2, "maxItems": 6, "items": { "$ref": "#/$defs/capabilityDomain" } },
"nodes": { "type": "array", "minItems": 2, "maxItems": 30, "items": { "$ref": "#/$defs/capability" } },
"edges": { "type": "array", "maxItems": 0 }
}
},
"capabilityDomain": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "domain" },
"title": { "type": "string", "minLength": 1, "maxLength": 60 },
"description": { "type": "string", "minLength": 3, "maxLength": 160 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"capability": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description", "domainId", "strategicImportance"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "capability" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 200 },
"domainId": { "$ref": "#/$defs/id" },
"strategicImportance": { "enum": ["low", "medium", "high"] },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"executiveViewSpec": {
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "diagramKind", "id", "title", "language", "asOfDate", "objective", "recommendation", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "executive-view" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"asOfDate": { "$ref": "#/$defs/isoDate" },
"objective": { "type": "string", "minLength": 8, "maxLength": 220 },
"recommendation": { "type": "string", "minLength": 8, "maxLength": 240 },
"nodes": { "type": "array", "minItems": 4, "maxItems": 13, "items": { "$ref": "#/$defs/executiveItem" } },
"edges": { "type": "array", "maxItems": 0 }
}
},
"executiveItem": {
"oneOf": [
{ "$ref": "#/$defs/executiveIndicator" },
{ "$ref": "#/$defs/executiveRisk" },
{ "$ref": "#/$defs/executiveDecision" }
]
},
"executiveIndicator": {
"type": "object", "additionalProperties": false,
"required": ["id", "type", "title", "description", "value", "target", "trend", "status"],
"properties": {
"id": { "$ref": "#/$defs/id" }, "type": { "const": "indicator" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 200 },
"value": { "type": "string", "minLength": 1, "maxLength": 60 },
"target": { "type": "string", "minLength": 1, "maxLength": 60 },
"trend": { "enum": ["improving", "steady", "declining"] },
"status": { "enum": ["on-track", "at-risk", "off-track"] },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"executiveRisk": {
"type": "object", "additionalProperties": false,
"required": ["id", "type", "title", "description", "impact", "response", "status"],
"properties": {
"id": { "$ref": "#/$defs/id" }, "type": { "const": "risk" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 200 },
"impact": { "enum": ["low", "medium", "high"] },
"response": { "type": "string", "minLength": 3, "maxLength": 220 },
"status": { "enum": ["open", "watch", "mitigated"] },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"executiveDecision": {
"type": "object", "additionalProperties": false,
"required": ["id", "type", "title", "description", "recommendation", "status"],
"properties": {
"id": { "$ref": "#/$defs/id" }, "type": { "const": "decision" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 200 },
"recommendation": { "type": "string", "minLength": 3, "maxLength": 220 },
"status": { "enum": ["open", "approved", "deferred"] },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"dataFlowSpec": {
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "diagramKind", "id", "title", "language", "boundaries", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "data-flow" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"boundaries": {
"type": "array",
"maxItems": 32,
"items": { "$ref": "#/$defs/dataFlowTrustBoundary" }
},
"nodes": {
"type": "array",
"minItems": 2,
"maxItems": 120,
"items": { "$ref": "#/$defs/dataFlowNode" }
},
"edges": {
"type": "array",
"minItems": 1,
"maxItems": 240,
"items": { "$ref": "#/$defs/dataFlowEdge" }
}
}
},
"dataFlowTrustBoundary": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "trustLevel"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "trust-boundary" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"trustLevel": { "enum": ["external", "controlled", "restricted"] },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"dataFlowNode": {
"oneOf": [
{ "$ref": "#/$defs/dataFlowSimpleNode" },
{ "$ref": "#/$defs/dataFlowProcess" },
{ "$ref": "#/$defs/dataFlowDataStore" }
]
},
"dataFlowSimpleNode": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["source", "sink", "external-system"] },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"dataFlowProcess": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description", "transformation"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "process" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"transformation": { "type": "string", "minLength": 3, "maxLength": 160 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"dataFlowDataStore": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description", "classification"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "data-store" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"classification": { "$ref": "#/$defs/dataClassification" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"dataFlowEdge": {
"type": "object",
"additionalProperties": false,
"required": ["id", "from", "to", "type", "dataName", "format", "frequency", "mode", "classification"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"from": { "$ref": "#/$defs/id" },
"to": { "$ref": "#/$defs/id" },
"type": { "const": "data-flow" },
"dataName": { "type": "string", "minLength": 1, "maxLength": 100 },
"format": { "type": "string", "minLength": 1, "maxLength": 80 },
"frequency": { "type": "string", "minLength": 1, "maxLength": 80 },
"mode": { "enum": ["batch", "streaming", "request-response"] },
"classification": { "$ref": "#/$defs/dataClassification" },
"trustBoundaryIds": {
"type": "array",
"maxItems": 32,
"uniqueItems": true,
"items": { "$ref": "#/$defs/id" }
},
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"dataClassification": { "enum": ["public", "internal", "confidential", "restricted"] },
"deploymentSpec": {
"type": "object",
"additionalProperties": false,
"required": [
"schemaVersion", "diagramKind", "id", "title", "language", "environment",
"entryNodeIds", "boundaries", "nodes", "edges"
],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "2.0" },
"diagramKind": { "const": "deployment" },
"id": { "$ref": "#/$defs/id" },
"title": { "type": "string", "minLength": 1, "maxLength": 120 },
"description": { "type": "string", "maxLength": 500 },
"language": { "enum": ["en", "ja", "mixed"] },
"metadata": { "$ref": "#/$defs/metadata" },
"environment": { "type": "string", "minLength": 1, "maxLength": 80 },
"entryNodeIds": {
"type": "array",
"minItems": 1,
"maxItems": 32,
"uniqueItems": true,
"items": { "$ref": "#/$defs/id" }
},
"boundaries": {
"type": "array",
"minItems": 4,
"maxItems": 64,
"items": { "$ref": "#/$defs/deploymentBoundary" }
},
"nodes": {
"type": "array",
"minItems": 2,
"maxItems": 160,
"items": { "$ref": "#/$defs/deploymentNode" }
},
"edges": {
"type": "array",
"minItems": 1,
"maxItems": 320,
"items": { "$ref": "#/$defs/deploymentCommunication" }
}
}
},
"deploymentBoundary": {
"oneOf": [
{ "$ref": "#/$defs/deploymentCloudProvider" },
{ "$ref": "#/$defs/deploymentRegion" },
{ "$ref": "#/$defs/deploymentNetworkBoundary" }
]
},
"deploymentCloudProvider": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "cloud-provider" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"deploymentRegion": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "parentId"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "region" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"parentId": { "$ref": "#/$defs/id" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"deploymentNetworkBoundary": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "parentId", "exposure"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["network", "subnet"] },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"parentId": { "$ref": "#/$defs/id" },
"exposure": { "$ref": "#/$defs/networkExposure" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"deploymentNode": {
"oneOf": [
{ "$ref": "#/$defs/deploymentExternalSystem" },
{ "$ref": "#/$defs/deploymentManagedNode" }
]
},
"deploymentExternalSystem": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description", "technology", "exposure"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "const": "external-system" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"technology": { "type": "string", "minLength": 1, "maxLength": 100 },
"exposure": { "const": "public" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"deploymentManagedNode": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "title", "description", "technology", "exposure", "boundaryId"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["gateway", "load-balancer", "firewall", "host", "service", "database"] },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"description": { "type": "string", "minLength": 3, "maxLength": 240 },
"technology": { "type": "string", "minLength": 1, "maxLength": 100 },
"exposure": { "$ref": "#/$defs/networkExposure" },
"boundaryId": { "$ref": "#/$defs/id" },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"deploymentCommunication": {
"type": "object",
"additionalProperties": false,
"required": ["id", "from", "to", "type", "description", "protocol", "port"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"from": { "$ref": "#/$defs/id" },
"to": { "$ref": "#/$defs/id" },
"type": { "const": "communication" },
"description": { "type": "string", "minLength": 3, "maxLength": 160 },
"protocol": { "type": "string", "minLength": 1, "maxLength": 40 },
"port": { "type": "integer", "minimum": 1, "maximum": 65535 },
"boundaryIds": {
"type": "array",
"maxItems": 64,
"uniqueItems": true,
"items": { "$ref": "#/$defs/id" }
},
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"networkExposure": { "enum": ["public", "private", "restricted"] },
"id": { "type": "string", "pattern": "^[a-z][a-z0-9-]{1,63}$" },
"variant": { "enum": ["realtime", "delegated", "external", "warning", "critical"] },
"status": { "enum": ["planned", "experimental", "beta", "stable", "deprecated", "retired"] },
"metadata": {
"type": "object",
"additionalProperties": { "type": "string", "maxLength": 200 }
},
"boundary": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "variant", "title"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": { "enum": ["system", "network", "trust", "organization", "runtime"] },
"variant": { "$ref": "#/$defs/variant" },
"title": { "type": "string", "minLength": 1, "maxLength": 80 },
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"node": {
"type": "object",
"additionalProperties": false,
"required": ["id", "type", "variant", "status", "title"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"type": {
"enum": [
"actor", "client", "frontend", "backend", "api", "service", "model", "agent",
"tool", "database", "cache", "queue", "event-bus", "storage", "batch-job",
"external-service", "observability", "security", "network", "note"
]
},
"variant": { "$ref": "#/$defs/variant" },
"status": { "$ref": "#/$defs/status" },
"title": { "type": "string", "minLength": 1, "maxLength": 60 },
"subtitle": { "type": "string", "maxLength": 100 },
"icon": { "$ref": "#/$defs/id" },
"controls": {
"type": "array",
"maxItems": 8,
"items": { "type": "string", "minLength": 1, "maxLength": 32 }
},
"metadata": { "$ref": "#/$defs/metadata" }
}
},
"edge": {
"type": "object",
"additionalProperties": false,
"required": ["id", "from", "to", "type", "variant", "direction"],
"properties": {
"id": { "$ref": "#/$defs/id" },
"from": { "$ref": "#/$defs/id" },
"to": { "$ref": "#/$defs/id" },
"type": {
"enum": [
"sync-request", "async-request", "realtime-stream", "event", "batch", "data-read",
"data-write", "control", "monitoring", "authentication"
]
},
"variant": { "$ref": "#/$defs/variant" },
"label": { "type": "string", "maxLength": 80 },
"direction": { "enum": ["forward", "bidirectional"] },
"protocol": { "type": "string", "maxLength": 32 },
"metadata": { "$ref": "#/$defs/metadata" }
}
}
}
}
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://example.local/schemas/layout.schema.json",
"title": "Architecture diagram layout",
"type": "object",
"additionalProperties": false,
"required": ["schemaVersion", "canvas", "nodes", "edges"],
"properties": {
"$schema": { "type": "string" },
"schemaVersion": { "const": "1.0" },
"canvas": {
"type": "object",
"additionalProperties": false,
"required": ["width", "height"],
"properties": {
"width": { "type": "integer", "minimum": 320, "maximum": 10000 },
"height": { "type": "integer", "minimum": 240, "maximum": 10000 }
}
},
"boundaries": {
"type": "object",
"additionalProperties": { "$ref": "#/$defs/boundaryGeometry" }
},
"nodes": {
"type": "object",
"additionalProperties": { "$ref": "#/$defs/nodeGeometry" }
},
"edges": {
"type": "object",
"additionalProperties": { "$ref": "#/$defs/edgeGeometry" }
}
},
"$defs": {
"point": {
"type": "object",
"additionalProperties": false,
"required": ["x", "y"],
"properties": {
"x": { "type": "number", "minimum": 0, "maximum": 10000 },
"y": { "type": "number", "minimum": 0, "maximum": 10000 }
}
},
"port": {
"type": "object",
"additionalProperties": false,
"required": ["side", "offset"],
"properties": {
"side": { "enum": ["top", "right", "bottom", "left"] },
"offset": { "type": "number", "minimum": 0, "maximum": 1 }
}
},
"nodeGeometry": {
"type": "object",
"additionalProperties": false,
"required": ["x", "y", "width", "height"],
"properties": {
"x": { "type": "number", "minimum": 0, "maximum": 10000 },
"y": { "type": "number", "minimum": 0, "maximum": 10000 },
"width": { "type": "number", "minimum": 40, "maximum": 3000 },
"height": { "type": "number", "minimum": 30, "maximum": 3000 }
}
},
"boundaryGeometry": {
"type": "object",
"additionalProperties": false,
"required": ["x", "y", "width", "height"],
"properties": {
"x": { "type": "number", "minimum": 0, "maximum": 10000 },
"y": { "type": "number", "minimum": 0, "maximum": 10000 },
"width": { "type": "number", "minimum": 120, "maximum": 10000 },
"height": { "type": "number", "minimum": 80, "maximum": 10000 }
}
},
"edgeGeometry": {
"type": "object",
"additionalProperties": false,
"required": ["source", "target"],
"properties": {
"source": { "$ref": "#/$defs/port" },
"target": { "$ref": "#/$defs/port" },
"waypoints": {
"type": "array",
"maxItems": 20,
"items": { "$ref": "#/$defs/point" }
},
"label": { "$ref": "#/$defs/point" }
}
}
}
}