docs/database/diagrams/tables/m_adhoc.1degree.svg

<?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="570pt" height="406pt"
 viewBox="0.00 0.00 570.00 406.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 402)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-402 566,-402 566,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_adhoc -->
<g id="node1" class="node">
<title>m_adhoc</title>
<g id="a_node1"><a xlink:href="../../tables/m_adhoc.html" xlink:title="m_adhoc" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="272,-42 272,-394 554,-394 554,-42 272,-42"/>
<polygon fill="#f5f5f5" stroke="transparent" points="274,-370 274,-392 552,-392 552,-370 274,-370"/>
<polygon fill="none" stroke="black" points="274,-370 274,-392 552,-392 552,-370 274,-370"/>
<text text-anchor="start" x="279" y="-379.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_adhoc</text>
<text text-anchor="start" x="517" y="-378.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="274,-348 274,-370 478,-370 478,-348 274,-348"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-365"/>
<text text-anchor="start" x="294" y="-356.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="478,-348 478,-370 552,-370 552,-348 478,-348"/>
<text text-anchor="start" x="481" y="-356.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="274,-326 274,-348 478,-348 478,-326 274,-326"/>
<text text-anchor="start" x="294" y="-334.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="none" stroke="black" points="478,-326 478,-348 552,-348 552,-326 478,-326"/>
<text text-anchor="start" x="481" y="-334.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="274,-304 274,-326 478,-326 478,-304 274,-304"/>
<text text-anchor="start" x="294" y="-312.2" font-family="Helvetica,sans-Serif" font-size="11.00">query</text>
<polygon fill="none" stroke="black" points="478,-304 478,-326 552,-326 552,-304 478,-304"/>
<text text-anchor="start" x="481" y="-312.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[2000]</text>
<polygon fill="none" stroke="black" points="274,-282 274,-304 478,-304 478,-282 274,-282"/>
<text text-anchor="start" x="294" y="-290.2" font-family="Helvetica,sans-Serif" font-size="11.00">table_name</text>
<polygon fill="none" stroke="black" points="478,-282 478,-304 552,-304 552,-282 478,-282"/>
<text text-anchor="start" x="481" y="-290.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="274,-260 274,-282 478,-282 478,-260 274,-260"/>
<text text-anchor="start" x="294" y="-268.2" font-family="Helvetica,sans-Serif" font-size="11.00">table_fields</text>
<polygon fill="none" stroke="black" points="478,-260 478,-282 552,-282 552,-260 478,-260"/>
<text text-anchor="start" x="481" y="-268.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[1000]</text>
<polygon fill="none" stroke="black" points="274,-238 274,-260 478,-260 478,-238 274,-238"/>
<text text-anchor="start" x="294" y="-246.2" font-family="Helvetica,sans-Serif" font-size="11.00">email</text>
<polygon fill="none" stroke="black" points="478,-238 478,-260 552,-260 552,-238 478,-238"/>
<text text-anchor="start" x="481" y="-246.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[500]</text>
<polygon fill="none" stroke="black" points="274,-216 274,-238 478,-238 478,-216 274,-216"/>
<text text-anchor="start" x="294" y="-224.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_active</text>
<polygon fill="none" stroke="black" points="478,-216 478,-238 552,-238 552,-216 478,-216"/>
<text text-anchor="start" x="481" y="-224.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="274,-194 274,-216 478,-216 478,-194 274,-194"/>
<text text-anchor="start" x="294" y="-202.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text>
<polygon fill="none" stroke="black" points="478,-194 478,-216 552,-216 552,-194 478,-194"/>
<text text-anchor="start" x="481" y="-202.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="274,-172 274,-194 478,-194 478,-172 274,-172"/>
<polygon fill="none" stroke="black" points="274,-172 274,-194 478,-194 478,-172 274,-172"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-189"/>
<text text-anchor="start" x="294" y="-180.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="none" stroke="black" points="478,-172 478,-194 552,-194 552,-172 478,-172"/>
<text text-anchor="start" x="481" y="-180.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="274,-150 274,-172 478,-172 478,-150 274,-150"/>
<polygon fill="none" stroke="black" points="274,-150 274,-172 478,-172 478,-150 274,-150"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-167"/>
<text text-anchor="start" x="294" y="-158.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="none" stroke="black" points="478,-150 478,-172 552,-172 552,-150 478,-150"/>
<text text-anchor="start" x="481" y="-158.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="274,-128 274,-150 478,-150 478,-128 274,-128"/>
<text text-anchor="start" x="294" y="-136.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodified_date</text>
<polygon fill="none" stroke="black" points="478,-128 478,-150 552,-150 552,-128 478,-128"/>
<text text-anchor="start" x="481" y="-136.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="274,-106 274,-128 478,-128 478,-106 274,-106"/>
<text text-anchor="start" x="294" y="-114.2" font-family="Helvetica,sans-Serif" font-size="11.00">report_run_frequency_code</text>
<polygon fill="none" stroke="black" points="478,-106 478,-128 552,-128 552,-106 478,-106"/>
<text text-anchor="start" x="481" y="-114.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="274,-84 274,-106 478,-106 478,-84 274,-84"/>
<text text-anchor="start" x="294" y="-92.2" font-family="Helvetica,sans-Serif" font-size="11.00">report_run_every</text>
<polygon fill="none" stroke="black" points="478,-84 478,-106 552,-106 552,-84 478,-84"/>
<text text-anchor="start" x="481" y="-92.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="274,-62 274,-84 478,-84 478,-62 274,-62"/>
<text text-anchor="start" x="294" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_run</text>
<polygon fill="none" stroke="black" points="478,-62 478,-84 552,-84 552,-62 478,-62"/>
<text text-anchor="start" x="481" y="-70.2" font-family="Helvetica,sans-Serif" font-size="11.00">timestamp[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="274,-44 274,-62 367,-62 367,-44 274,-44"/>
<polygon fill="none" stroke="black" points="274,-44 274,-62 367,-62 367,-44 274,-44"/>
<text text-anchor="start" x="277" y="-50.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="367,-44 367,-62 478,-62 478,-44 367,-44"/>
<polygon fill="none" stroke="black" points="367,-44 367,-62 478,-62 478,-44 367,-44"/>
<text text-anchor="start" x="442" y="-50.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="478,-44 478,-62 552,-62 552,-44 478,-44"/>
<polygon fill="none" stroke="black" points="478,-44 478,-62 552,-62 552,-44 478,-44"/>
<text text-anchor="start" x="533" y="-50.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="273,-43 273,-393 553,-393 553,-43 273,-43"/>
</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_adhoc&#45;&gt;m_appuser -->
<g id="edge1" class="edge">
<title>m_adhoc:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M258.49,-181.08C247.36,-177.93 240.73,-172 224.5,-172"/>
<polygon fill="black" stroke="black" points="265.07,-181.95 272.53,-186.57 269.03,-182.48 273,-183 273,-183 273,-183 269.03,-182.48 273.47,-179.43 265.07,-181.95 265.07,-181.95"/>
<ellipse fill="none" stroke="black" cx="261.9" cy="-181.53" rx="3.2" ry="3.2"/>
</g>
<!-- m_adhoc&#45;&gt;m_appuser -->
<g id="edge2" class="edge">
<title>m_adhoc:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M258.49,-162.92C247.36,-166.07 240.73,-172 224.5,-172"/>
<polygon fill="black" stroke="black" points="265.07,-162.05 273.47,-164.57 269.03,-161.52 273,-161 273,-161 273,-161 269.03,-161.52 272.53,-157.43 265.07,-162.05 265.07,-162.05"/>
<ellipse fill="none" stroke="black" cx="261.9" cy="-162.47" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>