blob: 98e505c1114e920a8114ab59c0257517287dc277 [file] [log] [blame]
<?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="516pt" height="417pt"
viewBox="0.00 0.00 516.00 417.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 413)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-413 512,-413 512,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_import_document -->
<g id="node1" class="node">
<title>m_import_document</title>
<g id="a_node1"><a xlink:href="../../tables/m_import_document.html" xlink:title="m_import_document" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="272,-141 272,-405 500,-405 500,-141 272,-141"/>
<polygon fill="#f5f5f5" stroke="transparent" points="274,-381 274,-403 498,-403 498,-381 274,-381"/>
<polygon fill="none" stroke="black" points="274,-381 274,-403 498,-403 498,-381 274,-381"/>
<text text-anchor="start" x="279" y="-390.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_import_document</text>
<text text-anchor="start" x="463" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="274,-359 274,-381 432,-381 432,-359 274,-359"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-376"/>
<text text-anchor="start" x="294" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="432,-359 432,-381 498,-381 498,-359 432,-359"/>
<text text-anchor="start" x="435" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="274,-337 274,-359 432,-359 432,-337 274,-337"/>
<polygon fill="none" stroke="black" points="274,-337 274,-359 432,-359 432,-337 274,-337"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-354"/>
<text text-anchor="start" x="294" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">document_id</text>
<polygon fill="none" stroke="black" points="432,-337 432,-359 498,-359 498,-337 432,-337"/>
<text text-anchor="start" x="435" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="274,-315 274,-337 432,-337 432,-315 274,-315"/>
<text text-anchor="start" x="294" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">import_time</text>
<polygon fill="none" stroke="black" points="432,-315 432,-337 498,-337 498,-315 432,-315"/>
<text text-anchor="start" x="435" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="274,-293 274,-315 432,-315 432,-293 274,-293"/>
<text text-anchor="start" x="294" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">end_time</text>
<polygon fill="none" stroke="black" points="432,-293 432,-315 498,-315 498,-293 432,-293"/>
<text text-anchor="start" x="435" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="274,-271 274,-293 432,-293 432,-271 274,-271"/>
<text text-anchor="start" x="294" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">entity_type</text>
<polygon fill="none" stroke="black" points="432,-271 432,-293 498,-293 498,-271 432,-271"/>
<text text-anchor="start" x="435" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">tinyint[3]</text>
<polygon fill="none" stroke="black" points="274,-249 274,-271 432,-271 432,-249 274,-249"/>
<text text-anchor="start" x="294" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">completed</text>
<polygon fill="none" stroke="black" points="432,-249 432,-271 498,-271 498,-249 432,-249"/>
<text text-anchor="start" x="435" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="274,-227 274,-249 432,-249 432,-227 274,-227"/>
<text text-anchor="start" x="294" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">total_records</text>
<polygon fill="none" stroke="black" points="432,-227 432,-249 498,-249 498,-227 432,-227"/>
<text text-anchor="start" x="435" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="274,-205 274,-227 432,-227 432,-205 274,-205"/>
<text text-anchor="start" x="294" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">success_count</text>
<polygon fill="none" stroke="black" points="432,-205 432,-227 498,-227 498,-205 432,-205"/>
<text text-anchor="start" x="435" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="274,-183 274,-205 432,-205 432,-183 274,-183"/>
<text text-anchor="start" x="294" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">failure_count</text>
<polygon fill="none" stroke="black" points="432,-183 432,-205 498,-205 498,-183 432,-183"/>
<text text-anchor="start" x="435" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="274,-161 274,-183 432,-183 432,-161 274,-161"/>
<polygon fill="none" stroke="black" points="274,-161 274,-183 432,-183 432,-161 274,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-178"/>
<text text-anchor="start" x="294" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="none" stroke="black" points="432,-161 432,-183 498,-183 498,-161 432,-161"/>
<text text-anchor="start" x="435" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="274,-143 274,-161 344,-161 344,-143 274,-143"/>
<polygon fill="none" stroke="black" points="274,-143 274,-161 344,-161 344,-143 274,-143"/>
<text text-anchor="start" x="277" y="-149.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="344,-143 344,-161 432,-161 432,-143 344,-143"/>
<polygon fill="none" stroke="black" points="344,-143 344,-161 432,-161 432,-143 344,-143"/>
<text text-anchor="start" x="396" y="-149.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="432,-143 432,-161 498,-161 498,-143 432,-143"/>
<polygon fill="none" stroke="black" points="432,-143 432,-161 498,-161 498,-143 432,-143"/>
<text text-anchor="start" x="479" y="-149.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="273,-142 273,-404 499,-404 499,-142 273,-142"/>
</a>
</g>
</g>
<!-- m_appuser -->
<g id="node2" class="node">
<title>m_appuser</title>
<g id="a_node2"><a xlink:href="../../tables/m_appuser.html" xlink:title="m_appuser" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-205 223,-205 223,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-183 8.5,-205 223.5,-205 223.5,-183 8.5,-183"/>
<polygon fill="none" stroke="black" points="8.5,-183 8.5,-205 223.5,-205 223.5,-183 8.5,-183"/>
<text text-anchor="start" x="13.5" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text>
<text text-anchor="start" x="188.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-161 8.5,-183 223.5,-183 223.5,-161 8.5,-161"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-178"/>
<text text-anchor="start" x="28.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-139 8.5,-161 223.5,-161 223.5,-139 8.5,-139"/>
<polygon fill="none" stroke="black" points="8.5,-139 8.5,-161 223.5,-161 223.5,-139 8.5,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-156"/>
<text text-anchor="start" x="28.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-117 8.5,-139 223.5,-139 223.5,-117 8.5,-117"/>
<polygon fill="none" stroke="black" points="8.5,-117 8.5,-139 223.5,-139 223.5,-117 8.5,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-134"/>
<text text-anchor="start" x="28.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-95 8.5,-117 223.5,-117 223.5,-95 8.5,-95"/>
<polygon fill="none" stroke="black" points="8.5,-95 8.5,-117 223.5,-117 223.5,-95 8.5,-95"/>
<text text-anchor="start" x="28.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-73 8.5,-95 223.5,-95 223.5,-73 8.5,-73"/>
<polygon fill="none" stroke="black" points="8.5,-73 8.5,-95 223.5,-95 223.5,-73 8.5,-73"/>
<text text-anchor="start" x="28.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text>
<polygon fill="none" stroke="black" points="8.5,-55 8.5,-73 223.5,-73 223.5,-55 8.5,-55"/>
<text text-anchor="start" x="11.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-37 8.5,-55 93.5,-55 93.5,-37 8.5,-37"/>
<polygon fill="none" stroke="black" points="8.5,-37 8.5,-55 93.5,-55 93.5,-37 8.5,-37"/>
<text text-anchor="start" x="11.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="93.5,-37 93.5,-55 163.5,-55 163.5,-37 93.5,-37"/>
<polygon fill="none" stroke="black" points="93.5,-37 93.5,-55 163.5,-55 163.5,-37 93.5,-37"/>
<text text-anchor="start" x="127.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="163.5,-37 163.5,-55 223.5,-55 223.5,-37 163.5,-37"/>
<polygon fill="none" stroke="black" points="163.5,-37 163.5,-55 223.5,-55 223.5,-37 163.5,-37"/>
<text text-anchor="start" x="198.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 &gt;</text>
</a>
</g>
</g>
<!-- m_import_document&#45;&gt;m_appuser -->
<g id="edge1" class="edge">
<title>m_import_document:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M258.28,-172C247.29,-172 240.16,-172 224.5,-172"/>
<polygon fill="black" stroke="black" points="265,-172 273,-175.6 269,-172 273,-172 273,-172 273,-172 269,-172 273,-168.4 265,-172 265,-172"/>
<ellipse fill="none" stroke="black" cx="261.8" cy="-172" rx="3.2" ry="3.2"/>
</g>
<!-- m_document -->
<g id="node3" class="node">
<title>m_document</title>
<g id="a_node3"><a xlink:href="../../tables/m_document.html" xlink:title="m_document" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="39.5,-301 39.5,-381 191.5,-381 191.5,-301 39.5,-301"/>
<polygon fill="#f5f5f5" stroke="transparent" points="39.5,-359 39.5,-381 191.5,-381 191.5,-359 39.5,-359"/>
<polygon fill="none" stroke="black" points="39.5,-359 39.5,-381 191.5,-381 191.5,-359 39.5,-359"/>
<text text-anchor="start" x="44.5" y="-368.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_document</text>
<text text-anchor="start" x="156.5" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="39.5,-337 39.5,-359 191.5,-359 191.5,-337 39.5,-337"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="44.5" y="-354"/>
<text text-anchor="start" x="59.5" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="39.5,-319 39.5,-337 191.5,-337 191.5,-319 39.5,-319"/>
<text text-anchor="start" x="42.5" y="-325.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="39.5,-301 39.5,-319 91.5,-319 91.5,-301 39.5,-301"/>
<polygon fill="none" stroke="black" points="39.5,-301 39.5,-319 91.5,-319 91.5,-301 39.5,-301"/>
<text text-anchor="start" x="42.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="91.5,-301 91.5,-319 149.5,-319 149.5,-301 91.5,-301"/>
<polygon fill="none" stroke="black" points="91.5,-301 91.5,-319 149.5,-319 149.5,-301 91.5,-301"/>
<text text-anchor="start" x="113.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="149.5,-301 149.5,-319 191.5,-319 191.5,-301 149.5,-301"/>
<polygon fill="none" stroke="black" points="149.5,-301 149.5,-319 191.5,-319 191.5,-301 149.5,-301"/>
<text text-anchor="start" x="172.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_import_document&#45;&gt;m_document -->
<g id="edge2" class="edge">
<title>m_import_document:w&#45;&gt;m_document:e</title>
<path fill="none" stroke="black" d="M258.33,-348C233.87,-348 222.83,-348 192.5,-348"/>
<polygon fill="black" stroke="black" points="265,-348 273,-351.6 269,-348 273,-348 273,-348 273,-348 269,-348 273,-344.4 265,-348 265,-348"/>
<ellipse fill="none" stroke="black" cx="261.8" cy="-348" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>