web/images/db-schema.svg
author Sandro Knauß <knauss@netzguerilla.net>
Thu, 27 Sep 2012 17:13:19 +0200
branchdevel
changeset 300 8d30203f07b3
parent 280 c96d569a8ac8
child 313 a88add2b3eea
permissions -rw-r--r--
adding github and bitbucket repositories.
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">
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
     4
<!-- Generated by graphviz version 2.26.3 (20100126.1600)
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 -->
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
     7
<svg width="468pt" height="126pt"
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
     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">
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
     9
<g id="graph1" class="graph" transform="scale(0.83274 0.83274) rotate(0) translate(4 147)">
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    10
<title>G</title>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    11
<polygon fill="white" stroke="white" points="-4,5 -4,-147 559,-147 559,5 -4,5"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    12
<!-- message -->
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    13
<g id="node1" class="node"><title>message</title>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    14
<polygon fill="none" stroke="black" points="8,-18.5 8,-133.5 112,-133.5 112,-18.5 8,-18.5"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    15
<text text-anchor="start" x="43.5" y="-124.367" font-family="Bitstream-Vera Sans" font-size="7.00">message</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    16
<polygon fill="none" stroke="black" points="9,-118 9,-120 111,-120 111,-118 9,-118"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    17
<text text-anchor="start" x="11" y="-110.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    18
<text text-anchor="start" x="11" y="-99.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; recipient : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    19
<text text-anchor="start" x="11" y="-88.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; isBilled : BOOLEAN</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    20
<text text-anchor="start" x="11" y="-77.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; date : DATETIME</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    21
<text text-anchor="start" x="11" y="-66.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; price : NUMERIC(8, 4)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    22
<text text-anchor="start" x="11" y="-55.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; count : INTEGER</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    23
<text text-anchor="start" x="11" y="-44.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; exID : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    24
<text text-anchor="start" x="11" y="-33.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; job : VARCHAR(40)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    25
<text text-anchor="start" x="11" y="-22.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; offer : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    26
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    27
<!-- job -->
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    28
<g id="node3" class="node"><title>job</title>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    29
<polygon fill="none" stroke="black" points="164.5,-79 164.5,-139 251.5,-139 251.5,-79 164.5,-79"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    30
<text text-anchor="start" x="202.5" y="-130.367" font-family="Bitstream-Vera Sans" font-size="7.00">job</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    31
<polygon fill="none" stroke="black" points="166,-124 166,-126 251,-126 251,-124 166,-124"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    32
<text text-anchor="start" x="168" y="-116.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    33
<text text-anchor="start" x="168" y="-105.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; info : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    34
<text text-anchor="start" x="168" y="-94.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; status : VARCHAR(7)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    35
<text text-anchor="start" x="168" y="-83.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; user : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    36
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    37
<!-- message&#45;&gt;job -->
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    38
<g id="edge2" class="edge"><title>message&#45;&gt;job</title>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    39
<path fill="none" stroke="black" d="M120.197,-89.4224C129.482,-91.4926 139.067,-93.6298 148.34,-95.6974"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    40
<ellipse fill="none" stroke="black" cx="152.488" cy="-96.6224" rx="4.00001" ry="4.00001"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    41
<text text-anchor="middle" x="146.627" y="-97.3455" font-family="Bitstream-Vera Sans" font-size="7.00">+ id</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    42
<text text-anchor="middle" x="129.963" y="-84.9699" font-family="Bitstream-Vera Sans" font-size="7.00">+ job</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    43
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    44
<!-- offer -->
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    45
<g id="node5" class="node"><title>offer</title>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    46
<polygon fill="none" stroke="black" points="304.5,-4 304.5,-64 405.5,-64 405.5,-4 304.5,-4"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    47
<text text-anchor="start" x="347" y="-55.3667" font-family="Bitstream-Vera Sans" font-size="7.00">offer</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    48
<polygon fill="none" stroke="black" points="306,-49 306,-51 405,-51 405,-49 306,-49"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    49
<text text-anchor="start" x="308" y="-41.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    50
<text text-anchor="start" x="308" y="-30.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; provider : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    51
<text text-anchor="start" x="308" y="-19.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; route : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    52
<text text-anchor="start" x="308" y="-8.86667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; typ : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    53
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    54
<!-- message&#45;&gt;offer -->
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    55
<g id="edge4" class="edge"><title>message&#45;&gt;offer</title>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    56
<path fill="none" stroke="black" d="M120.053,-67.45C168.906,-60.4948 237.788,-50.6879 288.339,-43.4907"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    57
<ellipse fill="none" stroke="black" cx="292.329" cy="-42.9227" rx="4.00001" ry="4.00001"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    58
<text text-anchor="middle" x="287.912" y="-45.5203" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    59
<text text-anchor="middle" x="128.43" y="-59.6886" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    60
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    61
<!-- userright -->
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    62
<g id="node2" class="node"><title>userright</title>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    63
<polygon fill="none" stroke="black" points="458,-49.5 458,-98.5 546,-98.5 546,-49.5 458,-49.5"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    64
<text text-anchor="start" x="485" y="-89.3667" font-family="Bitstream-Vera Sans" font-size="7.00">userright</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    65
<polygon fill="none" stroke="black" points="459,-83 459,-85 545,-85 545,-83 459,-83"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    66
<text text-anchor="start" x="461" y="-75.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; user : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    67
<text text-anchor="start" x="461" y="-64.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; offer : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    68
<text text-anchor="start" x="461" y="-53.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; default : INTEGER</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    69
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    70
<!-- apiuser -->
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    71
<g id="node4" class="node"><title>apiuser</title>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    72
<polygon fill="none" stroke="black" points="309,-89.5 309,-138.5 401,-138.5 401,-89.5 309,-89.5"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    73
<text text-anchor="start" x="341" y="-129.367" font-family="Bitstream-Vera Sans" font-size="7.00">apiuser</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    74
<polygon fill="none" stroke="black" points="310,-123 310,-125 400,-125 400,-123 310,-123"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    75
<text text-anchor="start" x="312" y="-115.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR(100)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    76
<text text-anchor="start" x="312" y="-104.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; ng_kunde : INTEGER</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    77
<text text-anchor="start" x="312" y="-93.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; apikey : VARCHAR(50)</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    78
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    79
<!-- job&#45;&gt;apiuser -->
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    80
<g id="edge10" class="edge"><title>job&#45;&gt;apiuser</title>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    81
<path fill="none" stroke="black" d="M259.827,-110.763C270.366,-111.121 281.558,-111.502 292.424,-111.872"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    82
<ellipse fill="none" stroke="black" cx="296.657" cy="-112.015" rx="4" ry="4"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    83
<text text-anchor="middle" x="291.453" y="-113.767" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    84
<text text-anchor="middle" x="269.028" y="-104.547" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    85
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    86
<!-- apiuser&#45;&gt;userright -->
300
8d30203f07b3 adding github and bitbucket repositories.
Sandro Knauß <knauss@netzguerilla.net>
parents: 280
diff changeset
    87
<g id="edge8" class="edge"><title>apiuser&#45;&gt;userright</title>
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    88
<path fill="none" stroke="black" d="M409.32,-99.2191C422.569,-95.6138 436.713,-91.7653 449.858,-88.1883"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    89
<text text-anchor="middle" x="442.223" y="-92.3458" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    90
<text text-anchor="middle" x="416.955" y="-90.4616" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    91
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    92
<!-- offer&#45;&gt;userright -->
300
8d30203f07b3 adding github and bitbucket repositories.
Sandro Knauß <knauss@netzguerilla.net>
parents: 280
diff changeset
    93
<g id="edge6" class="edge"><title>offer&#45;&gt;userright</title>
277
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    94
<path fill="none" stroke="black" d="M413.521,-49.924C425.531,-53.192 438.098,-56.6116 449.865,-59.8135"/>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    95
<text text-anchor="middle" x="440.01" y="-59.2118" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    96
<text text-anchor="middle" x="423.375" y="-45.9257" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    97
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    98
</g>
f65edc0382cc prepare for release:
Sandro Knauß <knauss@netzguerilla.net>
parents:
diff changeset
    99
</svg>