| <?xml version="1.0" encoding="UTF-8" standalone="no"?> |
| <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" |
| "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd"> |
| <!-- Generated by graphviz version 2.43.0 (0) |
| --> |
| <!-- Title: oneDegreeRelationshipsDiagram Pages: 1 --> |
| <svg width="419pt" height="269pt" |
| viewBox="0.00 0.00 419.00 269.00" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"> |
| <g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 265)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-265 415,-265 415,4 -4,4"/> |
| <text text-anchor="middle" x="71.5" y="-7.2" font-family="Helvetica,sans-Serif" font-size="11.00">Generated by SchemaSpy</text> |
| <!-- m_office_transaction --> |
| <g id="node1" class="node"> |
| <title>m_office_transaction</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_office_transaction.html" xlink:title="m_office_transaction" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="169,-37 169,-257 403,-257 403,-37 169,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="171,-233 171,-255 401,-255 401,-233 171,-233"/> |
| <polygon fill="none" stroke="black" points="171,-233 171,-255 401,-255 401,-233 171,-233"/> |
| <text text-anchor="start" x="176" y="-242.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_office_transaction</text> |
| <text text-anchor="start" x="366" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="171,-211 171,-233 331,-233 331,-211 171,-211"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="176" y="-228"/> |
| <text text-anchor="start" x="191" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="331,-211 331,-233 401,-233 401,-211 331,-211"/> |
| <text text-anchor="start" x="334" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="171,-189 171,-211 331,-211 331,-189 171,-189"/> |
| <polygon fill="none" stroke="black" points="171,-189 171,-211 331,-211 331,-189 171,-189"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="176" y="-206"/> |
| <text text-anchor="start" x="191" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">from_office_id</text> |
| <polygon fill="none" stroke="black" points="331,-189 331,-211 401,-211 401,-189 331,-189"/> |
| <text text-anchor="start" x="334" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="171,-167 171,-189 331,-189 331,-167 171,-167"/> |
| <polygon fill="none" stroke="black" points="171,-167 171,-189 331,-189 331,-167 171,-167"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="176" y="-184"/> |
| <text text-anchor="start" x="191" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">to_office_id</text> |
| <polygon fill="none" stroke="black" points="331,-167 331,-189 401,-189 401,-167 331,-167"/> |
| <text text-anchor="start" x="334" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="171,-145 171,-167 331,-167 331,-145 171,-145"/> |
| <text text-anchor="start" x="191" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">currency_code</text> |
| <polygon fill="none" stroke="black" points="331,-145 331,-167 401,-167 401,-145 331,-145"/> |
| <text text-anchor="start" x="334" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[3]</text> |
| <polygon fill="none" stroke="black" points="171,-123 171,-145 331,-145 331,-123 171,-123"/> |
| <text text-anchor="start" x="191" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">currency_digits</text> |
| <polygon fill="none" stroke="black" points="331,-123 331,-145 401,-145 401,-123 331,-123"/> |
| <text text-anchor="start" x="334" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="171,-101 171,-123 331,-123 331,-101 171,-101"/> |
| <text text-anchor="start" x="191" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">transaction_amount</text> |
| <polygon fill="none" stroke="black" points="331,-101 331,-123 401,-123 401,-101 331,-101"/> |
| <text text-anchor="start" x="334" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="171,-79 171,-101 331,-101 331,-79 171,-79"/> |
| <text text-anchor="start" x="191" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">transaction_date</text> |
| <polygon fill="none" stroke="black" points="331,-79 331,-101 401,-101 401,-79 331,-79"/> |
| <text text-anchor="start" x="334" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="171,-57 171,-79 331,-79 331,-57 171,-57"/> |
| <text text-anchor="start" x="191" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text> |
| <polygon fill="none" stroke="black" points="331,-57 331,-79 401,-79 401,-57 331,-57"/> |
| <text text-anchor="start" x="334" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="171,-39 171,-57 242,-57 242,-39 171,-39"/> |
| <polygon fill="none" stroke="black" points="171,-39 171,-57 242,-57 242,-39 171,-39"/> |
| <text text-anchor="start" x="174" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="242,-39 242,-57 331,-57 331,-39 242,-39"/> |
| <polygon fill="none" stroke="black" points="242,-39 242,-57 331,-57 331,-39 242,-39"/> |
| <text text-anchor="start" x="295" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331,-39 331,-57 401,-57 401,-39 331,-39"/> |
| <polygon fill="none" stroke="black" points="331,-39 331,-57 401,-57 401,-39 331,-39"/> |
| <text text-anchor="start" x="382" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="170,-38 170,-256 402,-256 402,-38 170,-38"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_office --> |
| <g id="node2" class="node"> |
| <title>m_office</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_office.html" xlink:title="m_office" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-76 8,-222 120,-222 120,-76 8,-76"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-200 8,-222 120,-222 120,-200 8,-200"/> |
| <polygon fill="none" stroke="black" points="8,-200 8,-222 120,-222 120,-200 8,-200"/> |
| <text text-anchor="start" x="13" y="-209.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_office</text> |
| <text text-anchor="start" x="85" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-178 8,-200 120,-200 120,-178 8,-178"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-195"/> |
| <text text-anchor="start" x="28" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-156 8,-178 120,-178 120,-156 8,-156"/> |
| <polygon fill="none" stroke="black" points="8,-156 8,-178 120,-178 120,-156 8,-156"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-173"/> |
| <text text-anchor="start" x="28" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-134 8,-156 120,-156 120,-134 8,-134"/> |
| <polygon fill="none" stroke="black" points="8,-134 8,-156 120,-156 120,-134 8,-134"/> |
| <text text-anchor="start" x="28" y="-142.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-112 8,-134 120,-134 120,-112 8,-112"/> |
| <polygon fill="none" stroke="black" points="8,-112 8,-134 120,-134 120,-112 8,-112"/> |
| <text text-anchor="start" x="28" y="-120.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="8,-94 8,-112 120,-112 120,-94 8,-94"/> |
| <text text-anchor="start" x="11" y="-100.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-76 8,-94 41,-94 41,-76 8,-76"/> |
| <polygon fill="none" stroke="black" points="8,-76 8,-94 41,-94 41,-76 8,-76"/> |
| <text text-anchor="start" x="11" y="-82.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="41,-76 41,-94 86,-94 86,-76 41,-76"/> |
| <polygon fill="none" stroke="black" points="41,-76 41,-94 86,-94 86,-76 41,-76"/> |
| <text text-anchor="start" x="50" y="-82.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="86,-76 86,-94 120,-94 120,-76 86,-76"/> |
| <polygon fill="none" stroke="black" points="86,-76 86,-94 120,-94 120,-76 86,-76"/> |
| <text text-anchor="start" x="95" y="-82.2" font-family="Helvetica,sans-Serif" font-size="11.00">20 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_office_transaction->m_office --> |
| <g id="edge1" class="edge"> |
| <title>m_office_transaction:w->m_office:e</title> |
| <path fill="none" stroke="black" d="M155.7,-198.18C144.24,-195.06 137.57,-189 121,-189"/> |
| <polygon fill="black" stroke="black" points="162.06,-198.99 169.55,-203.57 166.03,-199.5 170,-200 170,-200 170,-200 166.03,-199.5 170.45,-196.43 162.06,-198.99 162.06,-198.99"/> |
| <ellipse fill="none" stroke="black" cx="158.89" cy="-198.59" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_office_transaction->m_office --> |
| <g id="edge2" class="edge"> |
| <title>m_office_transaction:w->m_office:e</title> |
| <path fill="none" stroke="black" d="M155.7,-179.82C144.24,-182.94 137.57,-189 121,-189"/> |
| <polygon fill="black" stroke="black" points="162.06,-179.01 170.45,-181.57 166.03,-178.5 170,-178 170,-178 170,-178 166.03,-178.5 169.55,-174.43 162.06,-179.01 162.06,-179.01"/> |
| <ellipse fill="none" stroke="black" cx="158.89" cy="-179.41" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |