Mercurial Mercurial > iro.hg / comparison
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.
doc/images/db-schema.svg
branchdevel
changeset 271 b218238e76b9
parent 77 7dce6c0f06fb
equal deleted inserted replaced
270:665c3ea02d35 271:b218238e76b9 
     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.26.3 (20100126.1600)
 
     5  -->
 
     5  -->
 
     6 <!-- Title: G Pages: 1 -->
 
     6 <!-- Title: G Pages: 1 -->
 
     7 <svg width="468pt" height="131pt"
 
     7 <svg width="468pt" height="126pt"
 
     8  viewBox="0.00 0.00 468.00 131.29" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
 
     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.89313 0.89313) rotate(0) translate(4 143)">
 
     9 <g id="graph1" class="graph" transform="scale(0.83274 0.83274) rotate(0) translate(4 147)">
 
    10 <title>G</title>
 
    10 <title>G</title>
 
    11 <polygon fill="white" stroke="white" points="-4,5 -4,-143 521,-143 521,5 -4,5"/>
 
    11 <polygon fill="white" stroke="white" points="-4,5 -4,-147 559,-147 559,5 -4,5"/>
 
    12 <!-- message -->
 
    12 <!-- message -->
 
    13 <g id="node1" class="node"><title>message</title>
 
    13 <g id="node1" class="node"><title>message</title>
 
    14 <polygon fill="none" stroke="black" points="8,-25.5 8,-118.5 98,-118.5 98,-25.5 8,-25.5"/>
 
    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="36.5" y="-109.367" font-family="Bitstream-Vera Sans" font-size="7.00">message</text>
 
    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,-103 9,-105 97,-105 97,-103 9,-103"/>
 
    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="-95.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
 
    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="-84.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; recipient : VARCHAR</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="-73.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; isBilled : BOOLEAN</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="-62.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; date : DATETIME</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="-51.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; price : NUMERIC(8, 2)</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="-40.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; job : INTEGER</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="-29.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; offer : VARCHAR</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>
 
    24 </g>
 
    26 </g>
 
    25 <!-- job -->
 
    27 <!-- job -->
 
    26 <g id="node3" class="node"><title>job</title>
 
    28 <g id="node3" class="node"><title>job</title>
 
    27 <polygon fill="none" stroke="black" points="150.5,-75 150.5,-135 235.5,-135 235.5,-75 150.5,-75"/>
 
    29 <polygon fill="none" stroke="black" points="164.5,-79 164.5,-139 251.5,-139 251.5,-79 164.5,-79"/>
 
    28 <text text-anchor="start" x="187.5" y="-126.367" font-family="Bitstream-Vera Sans" font-size="7.00">job</text>
 
    30 <text text-anchor="start" x="202.5" y="-130.367" font-family="Bitstream-Vera Sans" font-size="7.00">job</text>
 
    29 <polygon fill="none" stroke="black" points="152,-120 152,-122 235,-122 235,-120 152,-120"/>
 
    31 <polygon fill="none" stroke="black" points="166,-124 166,-126 251,-126 251,-124 166,-124"/>
 
    30 <text text-anchor="start" x="154" y="-112.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; hash : VARCHAR</text>
 
    32 <text text-anchor="start" x="168" y="-116.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; id : INTEGER</text>
 
    31 <text text-anchor="start" x="154" y="-101.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; info : VARCHAR</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>
 
    32 <text text-anchor="start" x="154" y="-90.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; status : VARCHAR(7)</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>
 
    33 <text text-anchor="start" x="154" y="-79.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; user : VARCHAR</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>
 
    34 </g>
 
    36 </g>
 
    35 <!-- message&#45;&gt;job -->
 
    37 <!-- message&#45;&gt;job -->
 
    36 <g id="edge2" class="edge"><title>message&#45;&gt;job</title>
 
    38 <g id="edge2" class="edge"><title>message&#45;&gt;job</title>
 
    37 <path fill="none" stroke="black" d="M106.327,-84.57C115.412,-86.7114 124.894,-88.9465 134.112,-91.1194"/>
 
    39 <path fill="none" stroke="black" d="M120.197,-89.4224C129.482,-91.4926 139.067,-93.6298 148.34,-95.6974"/>
 
    38 <ellipse fill="none" stroke="black" cx="138.236" cy="-92.0912" rx="4.00001" ry="4.00001"/>
 
    40 <ellipse fill="none" stroke="black" cx="152.488" cy="-96.6224" rx="4.00001" ry="4.00001"/>
 
    39 <text text-anchor="middle" x="132.338" y="-92.7431" font-family="Bitstream-Vera Sans" font-size="7.00">+ hash</text>
 
    41 <text text-anchor="middle" x="146.627" y="-97.3455" font-family="Bitstream-Vera Sans" font-size="7.00">+ id</text>
 
    40 <text text-anchor="middle" x="116.118" y="-80.2359" font-family="Bitstream-Vera Sans" font-size="7.00">+ job</text>
 
    42 <text text-anchor="middle" x="129.963" y="-84.9699" font-family="Bitstream-Vera Sans" font-size="7.00">+ job</text>
 
    41 </g>
 
    43 </g>
 
    42 <!-- offer -->
 
    44 <!-- offer -->
 
    43 <g id="node5" class="node"><title>offer</title>
 
    45 <g id="node5" class="node"><title>offer</title>
 
    44 <polygon fill="none" stroke="black" points="288,-4 288,-64 370,-64 370,-4 288,-4"/>
 
    46 <polygon fill="none" stroke="black" points="304.5,-4 304.5,-64 405.5,-64 405.5,-4 304.5,-4"/>
 
    45 <text text-anchor="start" x="320.5" y="-55.3667" font-family="Bitstream-Vera Sans" font-size="7.00">offer</text>
 
    47 <text text-anchor="start" x="347" y="-55.3667" font-family="Bitstream-Vera Sans" font-size="7.00">offer</text>
 
    46 <polygon fill="none" stroke="black" points="289,-49 289,-51 369,-51 369,-49 289,-49"/>
 
    48 <polygon fill="none" stroke="black" points="306,-49 306,-51 405,-51 405,-49 306,-49"/>
 
    47 <text text-anchor="start" x="291" y="-41.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR</text>
 
    49 <text text-anchor="start" x="308" y="-41.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR(100)</text>
 
    48 <text text-anchor="start" x="291" y="-30.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; provider : VARCHAR</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>
 
    49 <text text-anchor="start" x="291" y="-19.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; route : VARCHAR</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>
 
    50 <text text-anchor="start" x="291" y="-8.86667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; typ : VARCHAR</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>
 
    51 </g>
 
    53 </g>
 
    52 <!-- message&#45;&gt;offer -->
 
    54 <!-- message&#45;&gt;offer -->
 
    53 <g id="edge4" class="edge"><title>message&#45;&gt;offer</title>
 
    55 <g id="edge4" class="edge"><title>message&#45;&gt;offer</title>
 
    54 <path fill="none" stroke="black" d="M106.216,-64.6732C153.699,-58.1357 223.047,-48.5878 271.726,-41.8855"/>
 
    56 <path fill="none" stroke="black" d="M120.053,-67.45C168.906,-60.4948 237.788,-50.6879 288.339,-43.4907"/>
 
    55 <ellipse fill="none" stroke="black" cx="275.694" cy="-41.3393" rx="4.00001" ry="4.00001"/>
 
    57 <ellipse fill="none" stroke="black" cx="292.329" cy="-42.9227" rx="4.00001" ry="4.00001"/>
 
    56 <text text-anchor="middle" x="271.255" y="-43.9165" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
 
    58 <text text-anchor="middle" x="287.912" y="-45.5203" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
 
    57 <text text-anchor="middle" x="114.618" y="-56.9504" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text>
 
    59 <text text-anchor="middle" x="128.43" y="-59.6886" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text>
 
    58 </g>
 
    60 </g>
 
    59 <!-- userright -->
 
    61 <!-- userright -->
 
    60 <g id="node2" class="node"><title>userright</title>
 
    62 <g id="node2" class="node"><title>userright</title>
 
    61 <polygon fill="none" stroke="black" points="422.5,-46.5 422.5,-95.5 507.5,-95.5 507.5,-46.5 422.5,-46.5"/>
 
    63 <polygon fill="none" stroke="black" points="458,-49.5 458,-98.5 546,-98.5 546,-49.5 458,-49.5"/>
 
    62 <text text-anchor="start" x="448.5" y="-86.3667" font-family="Bitstream-Vera Sans" font-size="7.00">userright</text>
 
    64 <text text-anchor="start" x="485" y="-89.3667" font-family="Bitstream-Vera Sans" font-size="7.00">userright</text>
 
    63 <polygon fill="none" stroke="black" points="424,-80 424,-82 507,-82 507,-80 424,-80"/>
 
    65 <polygon fill="none" stroke="black" points="459,-83 459,-85 545,-85 545,-83 459,-83"/>
 
    64 <text text-anchor="start" x="426" y="-72.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; user : VARCHAR</text>
 
    66 <text text-anchor="start" x="461" y="-75.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; user : VARCHAR(100)</text>
 
    65 <text text-anchor="start" x="426" y="-61.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; offer : VARCHAR</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>
 
    66 <text text-anchor="start" x="426" y="-50.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; isDefault : BOOLEAN</text>
 
    68 <text text-anchor="start" x="461" y="-53.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; default : INTEGER</text>
 
    67 </g>
 
    69 </g>
 
    68 <!-- apiuser -->
 
    70 <!-- apiuser -->
 
    69 <g id="node4" class="node"><title>apiuser</title>
 
    71 <g id="node4" class="node"><title>apiuser</title>
 
    70 <polygon fill="none" stroke="black" points="291.5,-90 291.5,-128 366.5,-128 366.5,-90 291.5,-90"/>
 
    72 <polygon fill="none" stroke="black" points="309,-89.5 309,-138.5 401,-138.5 401,-89.5 309,-89.5"/>
 
    71 <text text-anchor="start" x="315.5" y="-119.367" font-family="Bitstream-Vera Sans" font-size="7.00">apiuser</text>
 
    73 <text text-anchor="start" x="341" y="-129.367" font-family="Bitstream-Vera Sans" font-size="7.00">apiuser</text>
 
    72 <polygon fill="none" stroke="black" points="293,-113 293,-115 366,-115 366,-113 293,-113"/>
 
    74 <polygon fill="none" stroke="black" points="310,-123 310,-125 400,-125 400,-123 310,-123"/>
 
    73 <text text-anchor="start" x="295" y="-105.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR</text>
 
    75 <text text-anchor="start" x="312" y="-115.867" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; name : VARCHAR(100)</text>
 
    74 <text text-anchor="start" x="295" y="-94.8667" font-family="Bitstream-Vera Sans" font-size="7.00">&#45; apikey : VARCHAR</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>
 
    75 </g>
 
    78 </g>
 
    76 <!-- job&#45;&gt;apiuser -->
 
    79 <!-- job&#45;&gt;apiuser -->
 
    77 <g id="edge10" class="edge"><title>job&#45;&gt;apiuser</title>
 
    80 <g id="edge10" class="edge"><title>job&#45;&gt;apiuser</title>
 
    78 <path fill="none" stroke="black" d="M243.641,-106.489C253.891,-106.791 264.704,-107.109 275.063,-107.414"/>
 
    81 <path fill="none" stroke="black" d="M259.827,-110.763C270.366,-111.121 281.558,-111.502 292.424,-111.872"/>
 
    79 <ellipse fill="none" stroke="black" cx="279.255" cy="-107.537" rx="4" ry="4"/>
 
    82 <ellipse fill="none" stroke="black" cx="296.657" cy="-112.015" rx="4" ry="4"/>
 
    80 <text text-anchor="middle" x="274.069" y="-109.312" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
 
    83 <text text-anchor="middle" x="291.453" y="-113.767" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
 
    81 <text text-anchor="middle" x="252.825" y="-100.232" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text>
 
    84 <text text-anchor="middle" x="269.028" y="-104.547" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text>
 
    82 </g>
 
    85 </g>
 
    83 <!-- apiuser&#45;&gt;userright -->
 
    86 <!-- apiuser&#45;&gt;userright -->
 
    84 <g id="edge6" class="edge"><title>apiuser&#45;&gt;userright</title>
 
    87 <g id="edge6" class="edge"><title>apiuser&#45;&gt;userright</title>
 
    85 <path fill="none" stroke="black" d="M374.664,-96.2408C387.32,-92.7048 401.136,-88.8443 414.071,-85.23"/>
 
    88 <path fill="none" stroke="black" d="M409.32,-99.2191C422.569,-95.6138 436.713,-91.7653 449.858,-88.1883"/>
 
    86 <text text-anchor="middle" x="406.48" y="-89.4392" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
 
    89 <text text-anchor="middle" x="442.223" y="-92.3458" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
 
    87 <text text-anchor="middle" x="382.256" y="-87.4316" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text>
 
    90 <text text-anchor="middle" x="416.955" y="-90.4616" font-family="Bitstream-Vera Sans" font-size="7.00">+ user</text>
 
    88 </g>
 
    91 </g>
 
    89 <!-- offer&#45;&gt;userright -->
 
    92 <!-- offer&#45;&gt;userright -->
 
    90 <g id="edge8" class="edge"><title>offer&#45;&gt;userright</title>
 
    93 <g id="edge8" class="edge"><title>offer&#45;&gt;userright</title>
 
    91 <path fill="none" stroke="black" d="M378.099,-47.3578C389.816,-50.5456 402.347,-53.9546 414.141,-57.1634"/>
 
    94 <path fill="none" stroke="black" d="M413.521,-49.924C425.531,-53.192 438.098,-56.6116 449.865,-59.8135"/>
 
    92 <text text-anchor="middle" x="404.286" y="-56.5621" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
 
    95 <text text-anchor="middle" x="440.01" y="-59.2118" font-family="Bitstream-Vera Sans" font-size="7.00">+ name</text>
 
    93 <text text-anchor="middle" x="387.954" y="-43.3591" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text>
 
    96 <text text-anchor="middle" x="423.375" y="-45.9257" font-family="Bitstream-Vera Sans" font-size="7.00">+ offer</text>
 
    94 </g>
 
    97 </g>
 
    95 </g>
 
    98 </g>
 
    96 </svg>
 
    99 </svg>
iro.hg