web/images/db-schema.svg
branchdevel
changeset 277 f65edc0382cc
child 280 c96d569a8ac8
equal deleted inserted replaced
276:4841b443f1fd 277:f65edc0382cc
       
     1 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
       
     2 <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
       
     3  "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
       
     4 <!-- Generated by graphviz version 2.26.3 (20100126.1600)
       
     5  -->
       
     6 <!-- Title: G Pages: 1 -->
       
     7 <svg width="468pt" height="126pt"
       
     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">
       
     9 <g id="graph1" class="graph" transform="scale(0.83274 0.83274) rotate(0) translate(4 147)">
       
    10 <title>G</title>
       
    11 <polygon fill="white" stroke="white" points="-4,5 -4,-147 559,-147 559,5 -4,5"/>
       
    12 <!-- message -->
       
    13 <g id="node1" class="node"><title>message</title>
       
    14 <polygon fill="none" stroke="black" points="8,-18.5 8,-133.5 112,-133.5 112,-18.5 8,-18.5"/>
       
    15 <text text-anchor="start" x="43.5" y="-124.367" font-family="Bitstream-Vera Sans" font-size="7.00">message</text>
       
    16 <polygon fill="none" stroke="black" points="9,-118 9,-120 111,-120 111,-118 9,-118"/>
       
    17 <text text-anchor="start" x="11" y="-110.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
       
    18 <text text-anchor="start" x="11" y="-99.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; recipient : VARCHAR(100)</text>
       
    19 <text text-anchor="start" x="11" y="-88.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; isBilled : BOOLEAN</text>
       
    20 <text text-anchor="start" x="11" y="-77.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; date : DATETIME</text>
       
    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>
       
    22 <text text-anchor="start" x="11" y="-55.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; count : INTEGER</text>
       
    23 <text text-anchor="start" x="11" y="-44.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; exID : VARCHAR(100)</text>
       
    24 <text text-anchor="start" x="11" y="-33.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; job : VARCHAR(40)</text>
       
    25 <text text-anchor="start" x="11" y="-22.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; offer : VARCHAR(100)</text>
       
    26 </g>
       
    27 <!-- job -->
       
    28 <g id="node3" class="node"><title>job</title>
       
    29 <polygon fill="none" stroke="black" points="164.5,-79 164.5,-139 251.5,-139 251.5,-79 164.5,-79"/>
       
    30 <text text-anchor="start" x="202.5" y="-130.367" 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"/>
       
    32 <text text-anchor="start" x="168" y="-116.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
       
    33 <text text-anchor="start" x="168" y="-105.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; info : VARCHAR(100)</text>
       
    34 <text text-anchor="start" x="168" y="-94.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; status : VARCHAR(7)</text>
       
    35 <text text-anchor="start" x="168" y="-83.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; user : VARCHAR(100)</text>
       
    36 </g>
       
    37 <!-- message&#45;&gt;job -->
       
    38 <g id="edge2" class="edge"><title>message&#45;&gt;job</title>
       
    39 <path fill="none" stroke="black" d="M120.197,-89.4224C129.482,-91.4926 139.067,-93.6298 148.34,-95.6974"/>
       
    40 <ellipse fill="none" stroke="black" cx="152.488" cy="-96.6224" rx="4.00001" ry="4.00001"/>
       
    41 <text text-anchor="middle" x="146.627" y="-97.3455" font-family="Bitstream-Vera Sans" font-size="7.00">+ id</text>
       
    42 <text text-anchor="middle" x="129.963" y="-84.9699" font-family="Bitstream-Vera Sans" font-size="7.00">+ job</text>
       
    43 </g>
       
    44 <!-- offer -->
       
    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">&#45; name : VARCHAR(100)</text>
       
    50 <text text-anchor="start" x="308" y="-30.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; provider : VARCHAR(100)</text>
       
    51 <text text-anchor="start" x="308" y="-19.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; route : VARCHAR(100)</text>
       
    52 <text text-anchor="start" x="308" y="-8.86667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; typ : VARCHAR(100)</text>
       
    53 </g>
       
    54 <!-- message&#45;&gt;offer -->
       
    55 <g id="edge4" class="edge"><title>message&#45;&gt;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">&#45; user : VARCHAR(100)</text>
       
    67 <text text-anchor="start" x="461" y="-64.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; offer : VARCHAR(100)</text>
       
    68 <text text-anchor="start" x="461" y="-53.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; 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">&#45; name : VARCHAR(100)</text>
       
    76 <text text-anchor="start" x="312" y="-104.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; ng_kunde : INTEGER</text>
       
    77 <text text-anchor="start" x="312" y="-93.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; apikey : VARCHAR(50)</text>
       
    78 </g>
       
    79 <!-- job&#45;&gt;apiuser -->
       
    80 <g id="edge10" class="edge"><title>job&#45;&gt;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&#45;&gt;userright -->
       
    87 <g id="edge8" class="edge"><title>apiuser&#45;&gt;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&#45;&gt;userright -->
       
    93 <g id="edge6" class="edge"><title>offer&#45;&gt;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>
       
    98 </g>
       
    99 </svg>