Mercurial Mercurial > iro.hg / file revision
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
web/images/db-schema.svg
author Sandro Knauß <bugs@sandroknauss.de>
Tue, 15 Apr 2025 01:20:56 +0200
changeset 313 a88add2b3eea
parent 300 8d30203f07b3
permissions -rw-r--r--
use sqlalchemy_schemadisplay module

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
 "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<!-- Generated by graphviz version 2.42.4 (0)
 -->
<!-- Title: G Pages: 1 -->
<svg width="468pt" height="246pt"
 viewBox="0.00 0.00 468.00 245.75" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(0.9 0.9) rotate(0) translate(4 268)">
<title>G</title>
<polygon fill="white" stroke="transparent" points="-4,4 -4,-268 514,-268 514,4 -4,4"/>
<!-- apiuser -->
<g id="node1" class="node">
<title>apiuser</title>
<text text-anchor="start" x="313" y="-47.4" font-family="Bitstream-Vera Sans" font-size="7.00">apiuser</text>
<polygon fill="none" stroke="black" points="285.5,-41 285.5,-43 365.5,-43 365.5,-41 285.5,-41"/>
<text text-anchor="start" x="287.5" y="-33.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR(100)</text>
<text text-anchor="start" x="287.5" y="-21.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; ng_kunde : INTEGER</text>
<text text-anchor="start" x="287.5" y="-9.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; apikey : VARCHAR(50)</text>
<polygon fill="none" stroke="black" points="284.5,-4 284.5,-56 366.5,-56 366.5,-4 284.5,-4"/>
</g>
<!-- userright -->
<g id="node5" class="node">
<title>userright</title>
<text text-anchor="start" x="447.5" y="-89.4" font-family="Bitstream-Vera Sans" font-size="7.00">userright</text>
<polygon fill="none" stroke="black" points="424.5,-83 424.5,-85 501.5,-85 501.5,-83 424.5,-83"/>
<text text-anchor="start" x="426.5" y="-75.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; user : VARCHAR(100)</text>
<text text-anchor="start" x="426.5" y="-63.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; offer : VARCHAR(100)</text>
<text text-anchor="start" x="426.5" y="-51.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; default : INTEGER</text>
<polygon fill="none" stroke="black" points="423,-46 423,-98 502,-98 502,-46 423,-46"/>
</g>
<!-- apiuser&#45;&gt;userright -->
<g id="edge2" class="edge">
<title>apiuser&#45;&gt;userright</title>
<path fill="none" stroke="black" d="M384.46,-48.03C394.61,-51.19 405.05,-54.44 414.84,-57.48"/>
<polygon fill="none" stroke="black" points="385.45,-44.67 374.86,-45.04 383.37,-51.36 385.45,-44.67"/>
<text text-anchor="middle" x="402.34" y="-51.88" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
<text text-anchor="middle" x="384.86" y="-39.44" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text>
</g>
<!-- offer -->
<g id="node2" class="node">
<title>offer</title>
<text text-anchor="start" x="318" y="-137.4" font-family="Bitstream-Vera Sans" font-size="7.00">offer</text>
<polygon fill="none" stroke="black" points="281.5,-131 281.5,-133 370.5,-133 370.5,-131 281.5,-131"/>
<text text-anchor="start" x="283.5" y="-123.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR(100)</text>
<text text-anchor="start" x="283.5" y="-111.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; provider : VARCHAR(100)</text>
<text text-anchor="start" x="283.5" y="-99.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; route : VARCHAR(100)</text>
<text text-anchor="start" x="283.5" y="-87.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; typ : VARCHAR(100)</text>
<polygon fill="none" stroke="black" points="280,-82 280,-146 371,-146 371,-82 280,-82"/>
</g>
<!-- offer&#45;&gt;userright -->
<g id="edge3" class="edge">
<title>offer&#45;&gt;userright</title>
<path fill="none" stroke="black" d="M388.91,-94.58C397.69,-91.85 406.58,-89.09 414.99,-86.47"/>
<polygon fill="none" stroke="black" points="387.59,-91.33 379.08,-97.64 389.67,-98.01 387.59,-91.33"/>
<text text-anchor="middle" x="402.49" y="-80.87" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
<text text-anchor="middle" x="390.08" y="-92.04" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text>
</g>
<!-- status -->
<g id="node3" class="node">
<title>status</title>
<text text-anchor="start" x="44.5" y="-251.4" font-family="Bitstream-Vera Sans" font-size="7.00">status</text>
<polygon fill="none" stroke="black" points="9.5,-245 9.5,-247 98.5,-247 98.5,-245 9.5,-245"/>
<text text-anchor="start" x="11.5" y="-237.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
<text text-anchor="start" x="11.5" y="-225.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; date : DATETIME</text>
<text text-anchor="start" x="11.5" y="-213.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; recipient : VARCHAR(100)</text>
<text text-anchor="start" x="11.5" y="-201.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; exID : VARCHAR(100)</text>
<text text-anchor="start" x="11.5" y="-189.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; status : INTEGER</text>
<text text-anchor="start" x="11.5" y="-177.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; sender : VARCHAR(100)</text>
<text text-anchor="start" x="11.5" y="-165.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; data : VARCHAR(2550)</text>
<polygon fill="none" stroke="black" points="8,-160 8,-260 99,-260 99,-160 8,-160"/>
</g>
<!-- job -->
<g id="node4" class="node">
<title>job</title>
<text text-anchor="start" x="184.5" y="-63.4" font-family="Bitstream-Vera Sans" font-size="7.00">job</text>
<polygon fill="none" stroke="black" points="152.5,-57 152.5,-59 227.5,-59 227.5,-57 152.5,-57"/>
<text text-anchor="start" x="154.5" y="-49.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
<text text-anchor="start" x="154.5" y="-37.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; info : VARCHAR(100)</text>
<text text-anchor="start" x="154.5" y="-25.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; status : VARCHAR(7)</text>
<text text-anchor="start" x="154.5" y="-13.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; user : VARCHAR(100)</text>
<polygon fill="none" stroke="black" points="151,-8 151,-72 228,-72 228,-8 151,-8"/>
</g>
<!-- job&#45;&gt;apiuser -->
<g id="edge1" class="edge">
<title>job&#45;&gt;apiuser</title>
<path fill="none" stroke="black" d="M246.41,-35.83C253.52,-35.3 260.82,-34.75 267.95,-34.22"/>
<polygon fill="black" stroke="black" points="246.21,-35.84 235.91,-32.1 241.23,-36.21 236.24,-36.59 236.24,-36.59 236.24,-36.59 241.23,-36.21 236.58,-41.07 246.21,-35.84 246.21,-35.84"/>
<ellipse fill="none" stroke="black" cx="272.23" cy="-33.9" rx="4" ry="4"/>
<text text-anchor="middle" x="263.72" y="-36" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
<text text-anchor="middle" x="246.24" y="-30.99" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text>
</g>
<!-- message -->
<g id="node6" class="node">
<title>message</title>
<text text-anchor="start" x="39.5" y="-125.4" font-family="Bitstream-Vera Sans" font-size="7.00">message</text>
<polygon fill="none" stroke="black" points="9.5,-119 9.5,-121 98.5,-121 98.5,-119 9.5,-119"/>
<text text-anchor="start" x="11.5" y="-111.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
<text text-anchor="start" x="11.5" y="-99.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; recipient : VARCHAR(100)</text>
<text text-anchor="start" x="11.5" y="-87.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; isBilled : BOOLEAN</text>
<text text-anchor="start" x="11.5" y="-75.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; date : DATETIME</text>
<text text-anchor="start" x="11.5" y="-63.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; price : NUMERIC(8, 4)</text>
<text text-anchor="start" x="11.5" y="-51.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; count : INTEGER</text>
<text text-anchor="start" x="11.5" y="-39.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; exID : VARCHAR(100)</text>
<text text-anchor="start" x="11.5" y="-27.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; job : VARCHAR(40)</text>
<text text-anchor="start" x="11.5" y="-15.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; offer : VARCHAR(100)</text>
<polygon fill="none" stroke="black" points="8,-10 8,-134 99,-134 99,-10 8,-10"/>
</g>
<!-- message&#45;&gt;offer -->
<g id="edge4" class="edge">
<title>message&#45;&gt;offer</title>
<path fill="none" stroke="black" d="M117.25,-81.76C161.44,-88.64 220.27,-97.79 263.96,-104.58"/>
<polygon fill="black" stroke="black" points="117.08,-81.73 107.89,-75.75 112.14,-80.97 107.2,-80.2 107.2,-80.2 107.2,-80.2 112.14,-80.97 106.51,-84.64 117.08,-81.73 117.08,-81.73"/>
<ellipse fill="none" stroke="black" cx="267.98" cy="-105.21" rx="4" ry="4"/>
<text text-anchor="middle" x="259.43" y="-100.22" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
<text text-anchor="middle" x="118.2" y="-74.6" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text>
</g>
<!-- message&#45;&gt;job -->
<g id="edge5" class="edge">
<title>message&#45;&gt;job</title>
<path fill="none" stroke="black" d="M116.81,-57.12C122.78,-55.69 128.8,-54.26 134.68,-52.85"/>
<polygon fill="black" stroke="black" points="116.8,-57.12 106.03,-55.07 111.94,-58.28 107.08,-59.44 107.08,-59.44 107.08,-59.44 111.94,-58.28 108.12,-63.82 116.8,-57.12 116.8,-57.12"/>
<ellipse fill="none" stroke="black" cx="138.71" cy="-51.89" rx="4" ry="4"/>
<text text-anchor="middle" x="136.6" y="-45.36" font-family="Bitstream-Vera Sans" font-size="7.00">+ id</text>
<text text-anchor="middle" x="115.08" y="-53.84" font-family="Bitstream-Vera Sans" font-size="7.00">+ job</text>
</g>
</g>
</svg>
iro.hg