web/images/db-schema.svg
author Sandro Knauß <bugs@sandroknauss.de>
Tue, 15 Apr 2025 01:22:04 +0200
changeset 315 6c05b77779ea
parent 313 a88add2b3eea
permissions -rw-r--r--
update adresse.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
     1
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
     2
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
     3
 "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
313
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
     4
<!-- Generated by graphviz version 2.42.4 (0)
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
     5
 -->
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
     6
<!-- Title: G Pages: 1 -->
313
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
     7
<svg width="468pt" height="246pt"
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
     8
 viewBox="0.00 0.00 468.00 245.75" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
     9
<g id="graph0" class="graph" transform="scale(0.9 0.9) rotate(0) translate(4 268)">
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    10
<title>G</title>
313
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    11
<polygon fill="white" stroke="transparent" points="-4,4 -4,-268 514,-268 514,4 -4,4"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    12
<!-- apiuser -->
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    13
<g id="node1" class="node">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    14
<title>apiuser</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    15
<text text-anchor="start" x="313" y="-47.4" font-family="Bitstream-Vera Sans" font-size="7.00">apiuser</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    16
<polygon fill="none" stroke="black" points="285.5,-41 285.5,-43 365.5,-43 365.5,-41 285.5,-41"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    17
<text text-anchor="start" x="287.5" y="-33.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    18
<text text-anchor="start" x="287.5" y="-21.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; ng_kunde : INTEGER</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    19
<text text-anchor="start" x="287.5" y="-9.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; apikey : VARCHAR(50)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    20
<polygon fill="none" stroke="black" points="284.5,-4 284.5,-56 366.5,-56 366.5,-4 284.5,-4"/>
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    21
</g>
313
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    22
<!-- userright -->
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    23
<g id="node5" class="node">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    24
<title>userright</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    25
<text text-anchor="start" x="447.5" y="-89.4" font-family="Bitstream-Vera Sans" font-size="7.00">userright</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    26
<polygon fill="none" stroke="black" points="424.5,-83 424.5,-85 501.5,-85 501.5,-83 424.5,-83"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    27
<text text-anchor="start" x="426.5" y="-75.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; user : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    28
<text text-anchor="start" x="426.5" y="-63.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; offer : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    29
<text text-anchor="start" x="426.5" y="-51.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; default : INTEGER</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    30
<polygon fill="none" stroke="black" points="423,-46 423,-98 502,-98 502,-46 423,-46"/>
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    31
</g>
313
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    32
<!-- apiuser&#45;&gt;userright -->
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    33
<g id="edge2" class="edge">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    34
<title>apiuser&#45;&gt;userright</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    35
<path fill="none" stroke="black" d="M384.46,-48.03C394.61,-51.19 405.05,-54.44 414.84,-57.48"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    36
<polygon fill="none" stroke="black" points="385.45,-44.67 374.86,-45.04 383.37,-51.36 385.45,-44.67"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    37
<text text-anchor="middle" x="402.34" y="-51.88" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    38
<text text-anchor="middle" x="384.86" y="-39.44" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text>
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    39
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    40
<!-- offer -->
313
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    41
<g id="node2" class="node">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    42
<title>offer</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    43
<text text-anchor="start" x="318" y="-137.4" font-family="Bitstream-Vera Sans" font-size="7.00">offer</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    44
<polygon fill="none" stroke="black" points="281.5,-131 281.5,-133 370.5,-133 370.5,-131 281.5,-131"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    45
<text text-anchor="start" x="283.5" y="-123.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    46
<text text-anchor="start" x="283.5" y="-111.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; provider : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    47
<text text-anchor="start" x="283.5" y="-99.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; route : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    48
<text text-anchor="start" x="283.5" y="-87.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; typ : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    49
<polygon fill="none" stroke="black" points="280,-82 280,-146 371,-146 371,-82 280,-82"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    50
</g>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    51
<!-- offer&#45;&gt;userright -->
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    52
<g id="edge3" class="edge">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    53
<title>offer&#45;&gt;userright</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    54
<path fill="none" stroke="black" d="M388.91,-94.58C397.69,-91.85 406.58,-89.09 414.99,-86.47"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    55
<polygon fill="none" stroke="black" points="387.59,-91.33 379.08,-97.64 389.67,-98.01 387.59,-91.33"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    56
<text text-anchor="middle" x="402.49" y="-80.87" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    57
<text text-anchor="middle" x="390.08" y="-92.04" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    58
</g>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    59
<!-- status -->
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    60
<g id="node3" class="node">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    61
<title>status</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    62
<text text-anchor="start" x="44.5" y="-251.4" font-family="Bitstream-Vera Sans" font-size="7.00">status</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    63
<polygon fill="none" stroke="black" points="9.5,-245 9.5,-247 98.5,-247 98.5,-245 9.5,-245"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    64
<text text-anchor="start" x="11.5" y="-237.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    65
<text text-anchor="start" x="11.5" y="-225.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; date : DATETIME</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    66
<text text-anchor="start" x="11.5" y="-213.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; recipient : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    67
<text text-anchor="start" x="11.5" y="-201.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; exID : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    68
<text text-anchor="start" x="11.5" y="-189.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; status : INTEGER</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    69
<text text-anchor="start" x="11.5" y="-177.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; sender : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    70
<text text-anchor="start" x="11.5" y="-165.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; data : VARCHAR(2550)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    71
<polygon fill="none" stroke="black" points="8,-160 8,-260 99,-260 99,-160 8,-160"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    72
</g>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    73
<!-- job -->
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    74
<g id="node4" class="node">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    75
<title>job</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    76
<text text-anchor="start" x="184.5" y="-63.4" font-family="Bitstream-Vera Sans" font-size="7.00">job</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    77
<polygon fill="none" stroke="black" points="152.5,-57 152.5,-59 227.5,-59 227.5,-57 152.5,-57"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    78
<text text-anchor="start" x="154.5" y="-49.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    79
<text text-anchor="start" x="154.5" y="-37.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; info : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    80
<text text-anchor="start" x="154.5" y="-25.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; status : VARCHAR(7)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    81
<text text-anchor="start" x="154.5" y="-13.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; user : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    82
<polygon fill="none" stroke="black" points="151,-8 151,-72 228,-72 228,-8 151,-8"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    83
</g>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    84
<!-- job&#45;&gt;apiuser -->
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    85
<g id="edge1" class="edge">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    86
<title>job&#45;&gt;apiuser</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    87
<path fill="none" stroke="black" d="M246.41,-35.83C253.52,-35.3 260.82,-34.75 267.95,-34.22"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    88
<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"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    89
<ellipse fill="none" stroke="black" cx="272.23" cy="-33.9" rx="4" ry="4"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    90
<text text-anchor="middle" x="263.72" y="-36" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    91
<text text-anchor="middle" x="246.24" y="-30.99" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    92
</g>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    93
<!-- message -->
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    94
<g id="node6" class="node">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    95
<title>message</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    96
<text text-anchor="start" x="39.5" y="-125.4" font-family="Bitstream-Vera Sans" font-size="7.00">message</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    97
<polygon fill="none" stroke="black" points="9.5,-119 9.5,-121 98.5,-121 98.5,-119 9.5,-119"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    98
<text text-anchor="start" x="11.5" y="-111.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
    99
<text text-anchor="start" x="11.5" y="-99.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; recipient : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   100
<text text-anchor="start" x="11.5" y="-87.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; isBilled : BOOLEAN</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   101
<text text-anchor="start" x="11.5" y="-75.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; date : DATETIME</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   102
<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>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   103
<text text-anchor="start" x="11.5" y="-51.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; count : INTEGER</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   104
<text text-anchor="start" x="11.5" y="-39.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; exID : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   105
<text text-anchor="start" x="11.5" y="-27.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; job : VARCHAR(40)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   106
<text text-anchor="start" x="11.5" y="-15.4" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; offer : VARCHAR(100)</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   107
<polygon fill="none" stroke="black" points="8,-10 8,-134 99,-134 99,-10 8,-10"/>
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
   108
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
   109
<!-- message&#45;&gt;offer -->
313
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   110
<g id="edge4" class="edge">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   111
<title>message&#45;&gt;offer</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   112
<path fill="none" stroke="black" d="M117.25,-81.76C161.44,-88.64 220.27,-97.79 263.96,-104.58"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   113
<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"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   114
<ellipse fill="none" stroke="black" cx="267.98" cy="-105.21" rx="4" ry="4"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   115
<text text-anchor="middle" x="259.43" y="-100.22" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   116
<text text-anchor="middle" x="118.2" y="-74.6" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text>
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
   117
</g>
313
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   118
<!-- message&#45;&gt;job -->
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   119
<g id="edge5" class="edge">
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   120
<title>message&#45;&gt;job</title>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   121
<path fill="none" stroke="black" d="M116.81,-57.12C122.78,-55.69 128.8,-54.26 134.68,-52.85"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   122
<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"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   123
<ellipse fill="none" stroke="black" cx="138.71" cy="-51.89" rx="4" ry="4"/>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   124
<text text-anchor="middle" x="136.6" y="-45.36" font-family="Bitstream-Vera Sans" font-size="7.00">+ id</text>
a88add2b3eea use sqlalchemy_schemadisplay module
Sandro Knauß <bugs@sandroknauss.de>
parents: 300
diff changeset
   125
<text text-anchor="middle" x="115.08" y="-53.84" font-family="Bitstream-Vera Sans" font-size="7.00">+ job</text>
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
   126
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
   127
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
   128
</svg>