1 <?xml version="1.0" encoding="UTF-8" standalone="no"?> |
1 <?xml version="1.0" encoding="UTF-8" standalone="no"?> |
2 <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" |
2 <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" |
3 "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd"> |
3 "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd"> |
4 <!-- Generated by graphviz version 2.26.3 (20100126.1600) |
4 <!-- Generated by graphviz version 2.42.4 (0) |
5 --> |
5 --> |
6 <!-- Title: G Pages: 1 --> |
6 <!-- Title: G Pages: 1 --> |
7 <svg width="468pt" height="126pt" |
7 <svg width="468pt" height="246pt" |
8 viewBox="0.00 0.00 468.00 125.74" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"> |
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"> |
9 <g id="graph1" class="graph" transform="scale(0.83274 0.83274) rotate(0) translate(4 147)"> |
9 <g id="graph0" class="graph" transform="scale(0.9 0.9) rotate(0) translate(4 268)"> |
10 <title>G</title> |
10 <title>G</title> |
11 <polygon fill="white" stroke="white" points="-4,5 -4,-147 559,-147 559,5 -4,5"/> |
11 <polygon fill="white" stroke="transparent" points="-4,4 -4,-268 514,-268 514,4 -4,4"/> |
12 <!-- message --> |
12 <!-- apiuser --> |
13 <g id="node1" class="node"><title>message</title> |
13 <g id="node1" class="node"> |
14 <polygon fill="none" stroke="black" points="8,-18.5 8,-133.5 112,-133.5 112,-18.5 8,-18.5"/> |
14 <title>apiuser</title> |
15 <text text-anchor="start" x="43.5" y="-124.367" font-family="Bitstream-Vera Sans" font-size="7.00">message</text> |
15 <text text-anchor="start" x="313" y="-47.4" font-family="Bitstream-Vera Sans" font-size="7.00">apiuser</text> |
16 <polygon fill="none" stroke="black" points="9,-118 9,-120 111,-120 111,-118 9,-118"/> |
16 <polygon fill="none" stroke="black" points="285.5,-41 285.5,-43 365.5,-43 365.5,-41 285.5,-41"/> |
17 <text text-anchor="start" x="11" y="-110.867" font-family="Bitstream-Vera Sans" font-size="7.00">- id : INTEGER</text> |
17 <text text-anchor="start" x="287.5" y="-33.4" font-family="Bitstream-Vera Sans" font-size="7.00">- name : VARCHAR(100)</text> |
18 <text text-anchor="start" x="11" y="-99.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- recipient : VARCHAR(100)</text> |
18 <text text-anchor="start" x="287.5" y="-21.4" font-family="Bitstream-Vera Sans" font-size="7.00">- ng_kunde : INTEGER</text> |
19 <text text-anchor="start" x="11" y="-88.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- isBilled : BOOLEAN</text> |
19 <text text-anchor="start" x="287.5" y="-9.4" font-family="Bitstream-Vera Sans" font-size="7.00">- apikey : VARCHAR(50)</text> |
20 <text text-anchor="start" x="11" y="-77.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- date : DATETIME</text> |
20 <polygon fill="none" stroke="black" points="284.5,-4 284.5,-56 366.5,-56 366.5,-4 284.5,-4"/> |
21 <text text-anchor="start" x="11" y="-66.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- price : NUMERIC(8, 4)</text> |
21 </g> |
22 <text text-anchor="start" x="11" y="-55.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- count : INTEGER</text> |
22 <!-- userright --> |
23 <text text-anchor="start" x="11" y="-44.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- exID : VARCHAR(100)</text> |
23 <g id="node5" class="node"> |
24 <text text-anchor="start" x="11" y="-33.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- job : VARCHAR(40)</text> |
24 <title>userright</title> |
25 <text text-anchor="start" x="11" y="-22.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- offer : VARCHAR(100)</text> |
25 <text text-anchor="start" x="447.5" y="-89.4" font-family="Bitstream-Vera Sans" font-size="7.00">userright</text> |
|
26 <polygon fill="none" stroke="black" points="424.5,-83 424.5,-85 501.5,-85 501.5,-83 424.5,-83"/> |
|
27 <text text-anchor="start" x="426.5" y="-75.4" font-family="Bitstream-Vera Sans" font-size="7.00">- user : VARCHAR(100)</text> |
|
28 <text text-anchor="start" x="426.5" y="-63.4" font-family="Bitstream-Vera Sans" font-size="7.00">- offer : VARCHAR(100)</text> |
|
29 <text text-anchor="start" x="426.5" y="-51.4" font-family="Bitstream-Vera Sans" font-size="7.00">- default : INTEGER</text> |
|
30 <polygon fill="none" stroke="black" points="423,-46 423,-98 502,-98 502,-46 423,-46"/> |
|
31 </g> |
|
32 <!-- apiuser->userright --> |
|
33 <g id="edge2" class="edge"> |
|
34 <title>apiuser->userright</title> |
|
35 <path fill="none" stroke="black" d="M384.46,-48.03C394.61,-51.19 405.05,-54.44 414.84,-57.48"/> |
|
36 <polygon fill="none" stroke="black" points="385.45,-44.67 374.86,-45.04 383.37,-51.36 385.45,-44.67"/> |
|
37 <text text-anchor="middle" x="402.34" y="-51.88" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text> |
|
38 <text text-anchor="middle" x="384.86" y="-39.44" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text> |
|
39 </g> |
|
40 <!-- offer --> |
|
41 <g id="node2" class="node"> |
|
42 <title>offer</title> |
|
43 <text text-anchor="start" x="318" y="-137.4" font-family="Bitstream-Vera Sans" font-size="7.00">offer</text> |
|
44 <polygon fill="none" stroke="black" points="281.5,-131 281.5,-133 370.5,-133 370.5,-131 281.5,-131"/> |
|
45 <text text-anchor="start" x="283.5" y="-123.4" font-family="Bitstream-Vera Sans" font-size="7.00">- name : VARCHAR(100)</text> |
|
46 <text text-anchor="start" x="283.5" y="-111.4" font-family="Bitstream-Vera Sans" font-size="7.00">- provider : VARCHAR(100)</text> |
|
47 <text text-anchor="start" x="283.5" y="-99.4" font-family="Bitstream-Vera Sans" font-size="7.00">- route : VARCHAR(100)</text> |
|
48 <text text-anchor="start" x="283.5" y="-87.4" font-family="Bitstream-Vera Sans" font-size="7.00">- typ : VARCHAR(100)</text> |
|
49 <polygon fill="none" stroke="black" points="280,-82 280,-146 371,-146 371,-82 280,-82"/> |
|
50 </g> |
|
51 <!-- offer->userright --> |
|
52 <g id="edge3" class="edge"> |
|
53 <title>offer->userright</title> |
|
54 <path fill="none" stroke="black" d="M388.91,-94.58C397.69,-91.85 406.58,-89.09 414.99,-86.47"/> |
|
55 <polygon fill="none" stroke="black" points="387.59,-91.33 379.08,-97.64 389.67,-98.01 387.59,-91.33"/> |
|
56 <text text-anchor="middle" x="402.49" y="-80.87" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text> |
|
57 <text text-anchor="middle" x="390.08" y="-92.04" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text> |
|
58 </g> |
|
59 <!-- status --> |
|
60 <g id="node3" class="node"> |
|
61 <title>status</title> |
|
62 <text text-anchor="start" x="44.5" y="-251.4" font-family="Bitstream-Vera Sans" font-size="7.00">status</text> |
|
63 <polygon fill="none" stroke="black" points="9.5,-245 9.5,-247 98.5,-247 98.5,-245 9.5,-245"/> |
|
64 <text text-anchor="start" x="11.5" y="-237.4" font-family="Bitstream-Vera Sans" font-size="7.00">- id : INTEGER</text> |
|
65 <text text-anchor="start" x="11.5" y="-225.4" font-family="Bitstream-Vera Sans" font-size="7.00">- date : DATETIME</text> |
|
66 <text text-anchor="start" x="11.5" y="-213.4" font-family="Bitstream-Vera Sans" font-size="7.00">- recipient : VARCHAR(100)</text> |
|
67 <text text-anchor="start" x="11.5" y="-201.4" font-family="Bitstream-Vera Sans" font-size="7.00">- exID : VARCHAR(100)</text> |
|
68 <text text-anchor="start" x="11.5" y="-189.4" font-family="Bitstream-Vera Sans" font-size="7.00">- status : INTEGER</text> |
|
69 <text text-anchor="start" x="11.5" y="-177.4" font-family="Bitstream-Vera Sans" font-size="7.00">- sender : VARCHAR(100)</text> |
|
70 <text text-anchor="start" x="11.5" y="-165.4" font-family="Bitstream-Vera Sans" font-size="7.00">- data : VARCHAR(2550)</text> |
|
71 <polygon fill="none" stroke="black" points="8,-160 8,-260 99,-260 99,-160 8,-160"/> |
26 </g> |
72 </g> |
27 <!-- job --> |
73 <!-- job --> |
28 <g id="node3" class="node"><title>job</title> |
74 <g id="node4" class="node"> |
29 <polygon fill="none" stroke="black" points="164.5,-79 164.5,-139 251.5,-139 251.5,-79 164.5,-79"/> |
75 <title>job</title> |
30 <text text-anchor="start" x="202.5" y="-130.367" font-family="Bitstream-Vera Sans" font-size="7.00">job</text> |
76 <text text-anchor="start" x="184.5" y="-63.4" font-family="Bitstream-Vera Sans" font-size="7.00">job</text> |
31 <polygon fill="none" stroke="black" points="166,-124 166,-126 251,-126 251,-124 166,-124"/> |
77 <polygon fill="none" stroke="black" points="152.5,-57 152.5,-59 227.5,-59 227.5,-57 152.5,-57"/> |
32 <text text-anchor="start" x="168" y="-116.867" font-family="Bitstream-Vera Sans" font-size="7.00">- id : INTEGER</text> |
78 <text text-anchor="start" x="154.5" y="-49.4" font-family="Bitstream-Vera Sans" font-size="7.00">- id : INTEGER</text> |
33 <text text-anchor="start" x="168" y="-105.867" font-family="Bitstream-Vera Sans" font-size="7.00">- info : VARCHAR(100)</text> |
79 <text text-anchor="start" x="154.5" y="-37.4" font-family="Bitstream-Vera Sans" font-size="7.00">- info : VARCHAR(100)</text> |
34 <text text-anchor="start" x="168" y="-94.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- status : VARCHAR(7)</text> |
80 <text text-anchor="start" x="154.5" y="-25.4" font-family="Bitstream-Vera Sans" font-size="7.00">- status : VARCHAR(7)</text> |
35 <text text-anchor="start" x="168" y="-83.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- user : VARCHAR(100)</text> |
81 <text text-anchor="start" x="154.5" y="-13.4" font-family="Bitstream-Vera Sans" font-size="7.00">- user : VARCHAR(100)</text> |
|
82 <polygon fill="none" stroke="black" points="151,-8 151,-72 228,-72 228,-8 151,-8"/> |
|
83 </g> |
|
84 <!-- job->apiuser --> |
|
85 <g id="edge1" class="edge"> |
|
86 <title>job->apiuser</title> |
|
87 <path fill="none" stroke="black" d="M246.41,-35.83C253.52,-35.3 260.82,-34.75 267.95,-34.22"/> |
|
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"/> |
|
89 <ellipse fill="none" stroke="black" cx="272.23" cy="-33.9" rx="4" ry="4"/> |
|
90 <text text-anchor="middle" x="263.72" y="-36" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text> |
|
91 <text text-anchor="middle" x="246.24" y="-30.99" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text> |
|
92 </g> |
|
93 <!-- message --> |
|
94 <g id="node6" class="node"> |
|
95 <title>message</title> |
|
96 <text text-anchor="start" x="39.5" y="-125.4" font-family="Bitstream-Vera Sans" font-size="7.00">message</text> |
|
97 <polygon fill="none" stroke="black" points="9.5,-119 9.5,-121 98.5,-121 98.5,-119 9.5,-119"/> |
|
98 <text text-anchor="start" x="11.5" y="-111.4" font-family="Bitstream-Vera Sans" font-size="7.00">- id : INTEGER</text> |
|
99 <text text-anchor="start" x="11.5" y="-99.4" font-family="Bitstream-Vera Sans" font-size="7.00">- recipient : VARCHAR(100)</text> |
|
100 <text text-anchor="start" x="11.5" y="-87.4" font-family="Bitstream-Vera Sans" font-size="7.00">- isBilled : BOOLEAN</text> |
|
101 <text text-anchor="start" x="11.5" y="-75.4" font-family="Bitstream-Vera Sans" font-size="7.00">- date : DATETIME</text> |
|
102 <text text-anchor="start" x="11.5" y="-63.4" font-family="Bitstream-Vera Sans" font-size="7.00">- price : NUMERIC(8, 4)</text> |
|
103 <text text-anchor="start" x="11.5" y="-51.4" font-family="Bitstream-Vera Sans" font-size="7.00">- count : INTEGER</text> |
|
104 <text text-anchor="start" x="11.5" y="-39.4" font-family="Bitstream-Vera Sans" font-size="7.00">- exID : VARCHAR(100)</text> |
|
105 <text text-anchor="start" x="11.5" y="-27.4" font-family="Bitstream-Vera Sans" font-size="7.00">- job : VARCHAR(40)</text> |
|
106 <text text-anchor="start" x="11.5" y="-15.4" font-family="Bitstream-Vera Sans" font-size="7.00">- offer : VARCHAR(100)</text> |
|
107 <polygon fill="none" stroke="black" points="8,-10 8,-134 99,-134 99,-10 8,-10"/> |
|
108 </g> |
|
109 <!-- message->offer --> |
|
110 <g id="edge4" class="edge"> |
|
111 <title>message->offer</title> |
|
112 <path fill="none" stroke="black" d="M117.25,-81.76C161.44,-88.64 220.27,-97.79 263.96,-104.58"/> |
|
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"/> |
|
114 <ellipse fill="none" stroke="black" cx="267.98" cy="-105.21" rx="4" ry="4"/> |
|
115 <text text-anchor="middle" x="259.43" y="-100.22" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text> |
|
116 <text text-anchor="middle" x="118.2" y="-74.6" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text> |
36 </g> |
117 </g> |
37 <!-- message->job --> |
118 <!-- message->job --> |
38 <g id="edge2" class="edge"><title>message->job</title> |
119 <g id="edge5" class="edge"> |
39 <path fill="none" stroke="black" d="M120.197,-89.4224C129.482,-91.4926 139.067,-93.6298 148.34,-95.6974"/> |
120 <title>message->job</title> |
40 <ellipse fill="none" stroke="black" cx="152.488" cy="-96.6224" rx="4.00001" ry="4.00001"/> |
121 <path fill="none" stroke="black" d="M116.81,-57.12C122.78,-55.69 128.8,-54.26 134.68,-52.85"/> |
41 <text text-anchor="middle" x="146.627" y="-97.3455" font-family="Bitstream-Vera Sans" font-size="7.00">+ id</text> |
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"/> |
42 <text text-anchor="middle" x="129.963" y="-84.9699" font-family="Bitstream-Vera Sans" font-size="7.00">+ job</text> |
123 <ellipse fill="none" stroke="black" cx="138.71" cy="-51.89" rx="4" ry="4"/> |
43 </g> |
124 <text text-anchor="middle" x="136.6" y="-45.36" font-family="Bitstream-Vera Sans" font-size="7.00">+ id</text> |
44 <!-- offer --> |
125 <text text-anchor="middle" x="115.08" y="-53.84" font-family="Bitstream-Vera Sans" font-size="7.00">+ job</text> |
45 <g id="node5" class="node"><title>offer</title> |
|
46 <polygon fill="none" stroke="black" points="304.5,-4 304.5,-64 405.5,-64 405.5,-4 304.5,-4"/> |
|
47 <text text-anchor="start" x="347" y="-55.3667" font-family="Bitstream-Vera Sans" font-size="7.00">offer</text> |
|
48 <polygon fill="none" stroke="black" points="306,-49 306,-51 405,-51 405,-49 306,-49"/> |
|
49 <text text-anchor="start" x="308" y="-41.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- name : VARCHAR(100)</text> |
|
50 <text text-anchor="start" x="308" y="-30.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- provider : VARCHAR(100)</text> |
|
51 <text text-anchor="start" x="308" y="-19.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- route : VARCHAR(100)</text> |
|
52 <text text-anchor="start" x="308" y="-8.86667" font-family="Bitstream-Vera Sans" font-size="7.00">- typ : VARCHAR(100)</text> |
|
53 </g> |
|
54 <!-- message->offer --> |
|
55 <g id="edge4" class="edge"><title>message->offer</title> |
|
56 <path fill="none" stroke="black" d="M120.053,-67.45C168.906,-60.4948 237.788,-50.6879 288.339,-43.4907"/> |
|
57 <ellipse fill="none" stroke="black" cx="292.329" cy="-42.9227" rx="4.00001" ry="4.00001"/> |
|
58 <text text-anchor="middle" x="287.912" y="-45.5203" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text> |
|
59 <text text-anchor="middle" x="128.43" y="-59.6886" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text> |
|
60 </g> |
|
61 <!-- userright --> |
|
62 <g id="node2" class="node"><title>userright</title> |
|
63 <polygon fill="none" stroke="black" points="458,-49.5 458,-98.5 546,-98.5 546,-49.5 458,-49.5"/> |
|
64 <text text-anchor="start" x="485" y="-89.3667" font-family="Bitstream-Vera Sans" font-size="7.00">userright</text> |
|
65 <polygon fill="none" stroke="black" points="459,-83 459,-85 545,-85 545,-83 459,-83"/> |
|
66 <text text-anchor="start" x="461" y="-75.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- user : VARCHAR(100)</text> |
|
67 <text text-anchor="start" x="461" y="-64.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- offer : VARCHAR(100)</text> |
|
68 <text text-anchor="start" x="461" y="-53.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- default : INTEGER</text> |
|
69 </g> |
|
70 <!-- apiuser --> |
|
71 <g id="node4" class="node"><title>apiuser</title> |
|
72 <polygon fill="none" stroke="black" points="309,-89.5 309,-138.5 401,-138.5 401,-89.5 309,-89.5"/> |
|
73 <text text-anchor="start" x="341" y="-129.367" font-family="Bitstream-Vera Sans" font-size="7.00">apiuser</text> |
|
74 <polygon fill="none" stroke="black" points="310,-123 310,-125 400,-125 400,-123 310,-123"/> |
|
75 <text text-anchor="start" x="312" y="-115.867" font-family="Bitstream-Vera Sans" font-size="7.00">- name : VARCHAR(100)</text> |
|
76 <text text-anchor="start" x="312" y="-104.867" font-family="Bitstream-Vera Sans" font-size="7.00">- ng_kunde : INTEGER</text> |
|
77 <text text-anchor="start" x="312" y="-93.8667" font-family="Bitstream-Vera Sans" font-size="7.00">- apikey : VARCHAR(50)</text> |
|
78 </g> |
|
79 <!-- job->apiuser --> |
|
80 <g id="edge10" class="edge"><title>job->apiuser</title> |
|
81 <path fill="none" stroke="black" d="M259.827,-110.763C270.366,-111.121 281.558,-111.502 292.424,-111.872"/> |
|
82 <ellipse fill="none" stroke="black" cx="296.657" cy="-112.015" rx="4" ry="4"/> |
|
83 <text text-anchor="middle" x="291.453" y="-113.767" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text> |
|
84 <text text-anchor="middle" x="269.028" y="-104.547" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text> |
|
85 </g> |
|
86 <!-- apiuser->userright --> |
|
87 <g id="edge8" class="edge"><title>apiuser->userright</title> |
|
88 <path fill="none" stroke="black" d="M409.32,-99.2191C422.569,-95.6138 436.713,-91.7653 449.858,-88.1883"/> |
|
89 <text text-anchor="middle" x="442.223" y="-92.3458" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text> |
|
90 <text text-anchor="middle" x="416.955" y="-90.4616" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text> |
|
91 </g> |
|
92 <!-- offer->userright --> |
|
93 <g id="edge6" class="edge"><title>offer->userright</title> |
|
94 <path fill="none" stroke="black" d="M413.521,-49.924C425.531,-53.192 438.098,-56.6116 449.865,-59.8135"/> |
|
95 <text text-anchor="middle" x="440.01" y="-59.2118" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text> |
|
96 <text text-anchor="middle" x="423.375" y="-45.9257" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text> |
|
97 </g> |
126 </g> |
98 </g> |
127 </g> |
99 </svg> |
128 </svg> |