assets/img/schema_db.svg

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE svg
PUBLIC "-//W3C//DTD SVG 1.1//EN"
       "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<svg viewBox="35 30 1117 485" width="1082px" height="455px" xmlns="http://www.w3.org/2000/svg" version="1.1">
   <line x1="719" y1="344" x2="709" y2="344" style="stroke:#b0b;stroke-width:1;"/>
   <line x1="560" y1="130" x2="550" y2="130" style="stroke:#b0b;stroke-width:1;"/>
   <line x1="709" y1="344" x2="560" y2="130" style="stroke:#b0b;stroke-width:1;"/>
   <line x1="711.5" y1="344" x2="715.03553390593" y2="347.53553390593" style="stroke:#b0b;stroke-width:2;"/>
   <line x1="711.5" y1="344" x2="715.03553390593" y2="340.46446609407" style="stroke:#b0b;stroke-width:2;"/>
   <line x1="555" y1="130" x2="558.53553390593" y2="133.53553390593" style="stroke:#b0b;stroke-width:2;"/>
   <line x1="555" y1="130" x2="558.53553390593" y2="126.46446609407" style="stroke:#b0b;stroke-width:2;"/>
   <line x1="973" y1="406" x2="963" y2="406" style="stroke:#bbb;stroke-width:1;"/>
   <line x1="876" y1="304" x2="866" y2="304" style="stroke:#bbb;stroke-width:1;"/>
   <line x1="963" y1="406" x2="876" y2="304" style="stroke:#bbb;stroke-width:1;"/>
   <line x1="965.5" y1="406" x2="969.03553390593" y2="409.53553390593" style="stroke:#bbb;stroke-width:2;"/>
   <line x1="965.5" y1="406" x2="969.03553390593" y2="402.46446609407" style="stroke:#bbb;stroke-width:2;"/>
   <line x1="871" y1="304" x2="874.53553390593" y2="307.53553390593" style="stroke:#bbb;stroke-width:2;"/>
   <line x1="871" y1="304" x2="874.53553390593" y2="300.46446609407" style="stroke:#bbb;stroke-width:2;"/>
   <line x1="430" y1="270" x2="420" y2="270" style="stroke:#c00;stroke-width:1;"/>
   <line x1="242" y1="75" x2="232" y2="75" style="stroke:#c00;stroke-width:1;"/>
   <line x1="420" y1="270" x2="242" y2="75" style="stroke:#c00;stroke-width:1;"/>
   <line x1="422.5" y1="270" x2="426.03553390593" y2="273.53553390593" style="stroke:#c00;stroke-width:2;"/>
   <line x1="422.5" y1="270" x2="426.03553390593" y2="266.46446609407" style="stroke:#c00;stroke-width:2;"/>
   <line x1="237" y1="75" x2="240.53553390593" y2="78.535533905933" style="stroke:#c00;stroke-width:2;"/>
   <line x1="237" y1="75" x2="240.53553390593" y2="71.464466094067" style="stroke:#c00;stroke-width:2;"/>
   <line x1="550" y1="290" x2="560" y2="290" style="stroke:#0bf;stroke-width:1;"/>
   <line x1="509" y1="360" x2="499" y2="360" style="stroke:#0bf;stroke-width:1;"/>
   <line x1="560" y1="290" x2="509" y2="360" style="stroke:#0bf;stroke-width:1;"/>
   <line x1="557.5" y1="290" x2="553.96446609407" y2="293.53553390593" style="stroke:#0bf;stroke-width:2;"/>
   <line x1="557.5" y1="290" x2="553.96446609407" y2="286.46446609407" style="stroke:#0bf;stroke-width:2;"/>
   <line x1="504" y1="360" x2="507.53553390593" y2="363.53553390593" style="stroke:#0bf;stroke-width:2;"/>
   <line x1="504" y1="360" x2="507.53553390593" y2="356.46446609407" style="stroke:#0bf;stroke-width:2;"/>
   <line x1="780" y1="190" x2="770" y2="190" style="stroke:#bbb;stroke-width:1;"/>
   <line x1="560" y1="130" x2="550" y2="130" style="stroke:#bbb;stroke-width:1;"/>
   <line x1="770" y1="190" x2="560" y2="130" style="stroke:#bbb;stroke-width:1;"/>
   <line x1="772.5" y1="190" x2="776.03553390593" y2="193.53553390593" style="stroke:#bbb;stroke-width:2;"/>
   <line x1="772.5" y1="190" x2="776.03553390593" y2="186.46446609407" style="stroke:#bbb;stroke-width:2;"/>
   <line x1="555" y1="130" x2="558.53553390593" y2="133.53553390593" style="stroke:#bbb;stroke-width:2;"/>
   <line x1="555" y1="130" x2="558.53553390593" y2="126.46446609407" style="stroke:#bbb;stroke-width:2;"/>
   <line x1="370" y1="460" x2="360" y2="460" style="stroke:#0bf;stroke-width:1;"/>
   <line x1="242" y1="75" x2="232" y2="75" style="stroke:#0bf;stroke-width:1;"/>
   <line x1="360" y1="460" x2="242" y2="75" style="stroke:#0bf;stroke-width:1;"/>
   <line x1="362.5" y1="460" x2="366.03553390593" y2="463.53553390593" style="stroke:#0bf;stroke-width:2;"/>
   <line x1="362.5" y1="460" x2="366.03553390593" y2="456.46446609407" style="stroke:#0bf;stroke-width:2;"/>
   <line x1="237" y1="75" x2="240.53553390593" y2="78.535533905933" style="stroke:#0bf;stroke-width:2;"/>
   <line x1="237" y1="75" x2="240.53553390593" y2="71.464466094067" style="stroke:#0bf;stroke-width:2;"/>
   <line x1="123" y1="330" x2="133" y2="330" style="stroke:#b0b;stroke-width:1;"/>
   <line x1="91" y1="75" x2="101" y2="75" style="stroke:#b0b;stroke-width:1;"/>
   <line x1="133" y1="330" x2="91" y2="75" style="stroke:#b0b;stroke-width:1;"/>
   <line x1="130.5" y1="330" x2="126.96446609407" y2="333.53553390593" style="stroke:#b0b;stroke-width:2;"/>
   <line x1="130.5" y1="330" x2="126.96446609407" y2="326.46446609407" style="stroke:#b0b;stroke-width:2;"/>
   <line x1="96" y1="75" x2="92.464466094067" y2="78.535533905933" style="stroke:#b0b;stroke-width:2;"/>
   <line x1="96" y1="75" x2="92.464466094067" y2="71.464466094067" style="stroke:#b0b;stroke-width:2;"/>
   <rect width="147" height="20" x="719" y="274" style="fill:#007;stroke:black;"/>
   <text width="147" height="20" x="724" y="288" style="fill:#fff;" font-family="Arial" font-size="16px"> boncommande</text>
   <rect width="147" height="20" x="719" y="294" style="fill:#aea;stroke:black;"/>
   <text width="147" height="20" x="724" y="308" style="fill:black;" font-family="Arial" font-size="16px">idboncommande</text>
   <rect width="147" height="20" x="719" y="314" style="fill:none;stroke:black;"/>
   <text width="147" height="20" x="724" y="328" style="fill:black;" font-family="Arial" font-size="16px">dateboncommande</text>
   <rect width="147" height="20" x="719" y="334" style="fill:none;stroke:black;"/>
   <text width="147" height="20" x="724" y="348" style="fill:black;" font-family="Arial" font-size="16px">idfactures</text>
   <rect width="129" height="20" x="973" y="296" style="fill:#007;stroke:black;"/>
   <text width="129" height="20" x="978" y="310" style="fill:#fff;" font-family="Arial" font-size="16px"> devis</text>
   <rect width="129" height="20" x="973" y="316" style="fill:#aea;stroke:black;"/>
   <text width="129" height="20" x="978" y="330" style="fill:black;" font-family="Arial" font-size="16px">iddevis</text>
   <rect width="129" height="20" x="973" y="336" style="fill:none;stroke:black;"/>
   <text width="129" height="20" x="978" y="350" style="fill:black;" font-family="Arial" font-size="16px">estimationtime</text>
   <rect width="129" height="20" x="973" y="356" style="fill:none;stroke:black;"/>
   <text width="129" height="20" x="978" y="370" style="fill:black;" font-family="Arial" font-size="16px">estimationprice</text>
   <rect width="129" height="20" x="973" y="376" style="fill:none;stroke:black;"/>
   <text width="129" height="20" x="978" y="390" style="fill:black;" font-family="Arial" font-size="16px">datedevis</text>
   <rect width="129" height="20" x="973" y="396" style="fill:none;stroke:black;"/>
   <text width="129" height="20" x="978" y="410" style="fill:black;" font-family="Arial" font-size="16px">idboncommande</text>
   <rect width="120" height="20" x="430" y="100" style="fill:#007;stroke:black;"/>
   <text width="120" height="20" x="435" y="114" style="fill:#fff;" font-family="Arial" font-size="16px"> factures</text>
   <rect width="120" height="20" x="430" y="120" style="fill:#aea;stroke:black;"/>
   <text width="120" height="20" x="435" y="134" style="fill:black;" font-family="Arial" font-size="16px">idfactures</text>
   <rect width="120" height="20" x="430" y="140" style="fill:none;stroke:black;"/>
   <text width="120" height="20" x="435" y="154" style="fill:black;" font-family="Arial" font-size="16px">datefacture</text>
   <rect width="120" height="20" x="430" y="160" style="fill:none;stroke:black;"/>
   <text width="120" height="20" x="435" y="174" style="fill:black;" font-family="Arial" font-size="16px">prestationdates</text>
   <rect width="120" height="20" x="430" y="180" style="fill:none;stroke:black;"/>
   <text width="120" height="20" x="435" y="194" style="fill:black;" font-family="Arial" font-size="16px">prix</text>
   <rect width="120" height="20" x="430" y="200" style="fill:none;stroke:black;"/>
   <text width="120" height="20" x="435" y="214" style="fill:black;" font-family="Arial" font-size="16px">ht</text>
   <rect width="120" height="20" x="430" y="220" style="fill:none;stroke:black;"/>
   <text width="120" height="20" x="435" y="234" style="fill:black;" font-family="Arial" font-size="16px">tauxtva</text>
   <rect width="120" height="20" x="430" y="240" style="fill:none;stroke:black;"/>
   <text width="120" height="20" x="435" y="254" style="fill:black;" font-family="Arial" font-size="16px">ttc</text>
   <rect width="120" height="20" x="430" y="260" style="fill:none;stroke:black;"/>
   <text width="120" height="20" x="435" y="274" style="fill:black;" font-family="Arial" font-size="16px">idsociete</text>
   <rect width="120" height="20" x="430" y="280" style="fill:none;stroke:black;"/>
   <text width="120" height="20" x="435" y="294" style="fill:black;" font-family="Arial" font-size="16px">idpersonnes</text>
   <rect width="112" height="20" x="780" y="100" style="fill:#007;stroke:black;"/>
   <text width="112" height="20" x="785" y="114" style="fill:#fff;" font-family="Arial" font-size="16px"> notecredit</text>
   <rect width="112" height="20" x="780" y="120" style="fill:#aea;stroke:black;"/>
   <text width="112" height="20" x="785" y="134" style="fill:black;" font-family="Arial" font-size="16px">idnotecredit</text>
   <rect width="112" height="20" x="780" y="140" style="fill:none;stroke:black;"/>
   <text width="112" height="20" x="785" y="154" style="fill:black;" font-family="Arial" font-size="16px">reduction</text>
   <rect width="112" height="20" x="780" y="160" style="fill:none;stroke:black;"/>
   <text width="112" height="20" x="785" y="174" style="fill:black;" font-family="Arial" font-size="16px">datenotecredit</text>
   <rect width="112" height="20" x="780" y="180" style="fill:none;stroke:black;"/>
   <text width="112" height="20" x="785" y="194" style="fill:black;" font-family="Arial" font-size="16px">idfactures</text>
   <rect width="129" height="20" x="370" y="330" style="fill:#007;stroke:black;"/>
   <text width="129" height="20" x="375" y="344" style="fill:#fff;" font-family="Arial" font-size="16px"> personnes</text>
   <rect width="129" height="20" x="370" y="350" style="fill:#aea;stroke:black;"/>
   <text width="129" height="20" x="375" y="364" style="fill:black;" font-family="Arial" font-size="16px">idpersonnes</text>
   <rect width="129" height="20" x="370" y="370" style="fill:none;stroke:black;"/>
   <text width="129" height="20" x="375" y="384" style="fill:black;" font-family="Arial" font-size="16px">name</text>
   <rect width="129" height="20" x="370" y="390" style="fill:none;stroke:black;"/>
   <text width="129" height="20" x="375" y="404" style="fill:black;" font-family="Arial" font-size="16px">firstname</text>
   <rect width="129" height="20" x="370" y="410" style="fill:none;stroke:black;"/>
   <text width="129" height="20" x="375" y="424" style="fill:black;" font-family="Arial" font-size="16px">personnesphone</text>
   <rect width="129" height="20" x="370" y="430" style="fill:none;stroke:black;"/>
   <text width="129" height="20" x="375" y="444" style="fill:black;" font-family="Arial" font-size="16px">email</text>
   <rect width="129" height="20" x="370" y="450" style="fill:none;stroke:black;"/>
   <text width="129" height="20" x="375" y="464" style="fill:black;" font-family="Arial" font-size="16px">idsociete</text>
   <rect width="131" height="20" x="101" y="45" style="fill:#007;stroke:black;"/>
   <text width="131" height="20" x="106" y="59" style="fill:#fff;" font-family="Arial" font-size="16px"> societe</text>
   <rect width="131" height="20" x="101" y="65" style="fill:#aea;stroke:black;"/>
   <text width="131" height="20" x="106" y="79" style="fill:black;" font-family="Arial" font-size="16px">idsociete</text>
   <rect width="131" height="20" x="101" y="85" style="fill:none;stroke:black;"/>
   <text width="131" height="20" x="106" y="99" style="fill:black;" font-family="Arial" font-size="16px">socialstatus</text>
   <rect width="131" height="20" x="101" y="105" style="fill:none;stroke:black;"/>
   <text width="131" height="20" x="106" y="119" style="fill:black;" font-family="Arial" font-size="16px">adresse</text>
   <rect width="131" height="20" x="101" y="125" style="fill:none;stroke:black;"/>
   <text width="131" height="20" x="106" y="139" style="fill:black;" font-family="Arial" font-size="16px">country</text>
   <rect width="131" height="20" x="101" y="145" style="fill:none;stroke:black;"/>
   <text width="131" height="20" x="106" y="159" style="fill:black;" font-family="Arial" font-size="16px">tvanumber</text>
   <rect width="131" height="20" x="101" y="165" style="fill:none;stroke:black;"/>
   <text width="131" height="20" x="106" y="179" style="fill:black;" font-family="Arial" font-size="16px">account</text>
   <rect width="131" height="20" x="101" y="185" style="fill:none;stroke:black;"/>
   <text width="131" height="20" x="106" y="199" style="fill:black;" font-family="Arial" font-size="16px">telephonesociete</text>
   <rect width="73" height="20" x="50" y="240" style="fill:#007;stroke:black;"/>
   <text width="73" height="20" x="55" y="254" style="fill:#fff;" font-family="Arial" font-size="16px"> type</text>
   <rect width="73" height="20" x="50" y="260" style="fill:#aea;stroke:black;"/>
   <text width="73" height="20" x="55" y="274" style="fill:black;" font-family="Arial" font-size="16px">idtype</text>
   <rect width="73" height="20" x="50" y="280" style="fill:none;stroke:black;"/>
   <text width="73" height="20" x="55" y="294" style="fill:black;" font-family="Arial" font-size="16px">type</text>
   <rect width="73" height="20" x="50" y="300" style="fill:none;stroke:black;"/>
   <text width="73" height="20" x="55" y="314" style="fill:black;" font-family="Arial" font-size="16px">relation</text>
   <rect width="73" height="20" x="50" y="320" style="fill:none;stroke:black;"/>
   <text width="73" height="20" x="55" y="334" style="fill:black;" font-family="Arial" font-size="16px">idsociete</text>
</svg>