blob: 4e47739362447ae681ee78eaa94e113c64d5550a [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: twoDegreesRelationshipsDiagram Pages: 1 -->
<svg width="786pt" height="267pt"
viewBox="0.00 0.00 786.00 267.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 263)">
<title>twoDegreesRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-263 782,-263 782,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_report_mailing_job -->
<g id="node1" class="node">
<title>m_report_mailing_job</title>
<g id="a_node1"><a xlink:href="../../tables/m_report_mailing_job.html" xlink:title="m_report_mailing_job" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="183,-41 183,-231 404,-231 404,-41 183,-41"/>
<polygon fill="#f5f5f5" stroke="transparent" points="183.5,-209 183.5,-231 404.5,-231 404.5,-209 183.5,-209"/>
<polygon fill="none" stroke="black" points="183.5,-209 183.5,-231 404.5,-231 404.5,-209 183.5,-209"/>
<text text-anchor="start" x="188.5" y="-218.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_report_mailing_job</text>
<text text-anchor="start" x="369.5" y="-217.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="183.5,-187 183.5,-209 404.5,-209 404.5,-187 183.5,-187"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="188.5" y="-204"/>
<text text-anchor="start" x="203.5" y="-195.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="183.5,-165 183.5,-187 404.5,-187 404.5,-165 183.5,-165"/>
<polygon fill="none" stroke="black" points="183.5,-165 183.5,-187 404.5,-187 404.5,-165 183.5,-165"/>
<text text-anchor="start" x="203.5" y="-173.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="#ffffff" stroke="transparent" points="183.5,-143 183.5,-165 404.5,-165 404.5,-143 183.5,-143"/>
<polygon fill="none" stroke="black" points="183.5,-143 183.5,-165 404.5,-165 404.5,-143 183.5,-143"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="188.5" y="-160"/>
<text text-anchor="start" x="203.5" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="#ffffff" stroke="transparent" points="183.5,-121 183.5,-143 404.5,-143 404.5,-121 183.5,-121"/>
<polygon fill="none" stroke="black" points="183.5,-121 183.5,-143 404.5,-143 404.5,-121 183.5,-121"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="188.5" y="-138"/>
<text text-anchor="start" x="203.5" y="-129.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="#ffffff" stroke="transparent" points="183.5,-99 183.5,-121 404.5,-121 404.5,-99 183.5,-99"/>
<polygon fill="none" stroke="black" points="183.5,-99 183.5,-121 404.5,-121 404.5,-99 183.5,-99"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="188.5" y="-116"/>
<text text-anchor="start" x="203.5" y="-107.2" font-family="Helvetica,sans-Serif" font-size="11.00">stretchy_report_id</text>
<polygon fill="#ffffff" stroke="transparent" points="183.5,-77 183.5,-99 404.5,-99 404.5,-77 183.5,-77"/>
<polygon fill="none" stroke="black" points="183.5,-77 183.5,-99 404.5,-99 404.5,-77 183.5,-77"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="188.5" y="-94"/>
<text text-anchor="start" x="203.5" y="-85.2" font-family="Helvetica,sans-Serif" font-size="11.00">run_as_userid</text>
<polygon fill="none" stroke="black" points="183.5,-59 183.5,-77 404.5,-77 404.5,-59 183.5,-59"/>
<text text-anchor="start" x="186.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="183.5,-41 183.5,-59 274.5,-59 274.5,-41 183.5,-41"/>
<polygon fill="none" stroke="black" points="183.5,-41 183.5,-59 274.5,-59 274.5,-41 183.5,-41"/>
<text text-anchor="start" x="186.5" y="-47.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 4</text>
<polygon fill="#ffffff" stroke="transparent" points="274.5,-41 274.5,-59 347.5,-59 347.5,-41 274.5,-41"/>
<polygon fill="none" stroke="black" points="274.5,-41 274.5,-59 347.5,-59 347.5,-41 274.5,-41"/>
<text text-anchor="start" x="311.5" y="-47.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="347.5,-41 347.5,-59 404.5,-59 404.5,-41 347.5,-41"/>
<polygon fill="none" stroke="black" points="347.5,-41 347.5,-59 404.5,-59 404.5,-41 347.5,-41"/>
<text text-anchor="start" x="385.5" y="-47.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</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="19.5,-116 19.5,-174 122.5,-174 122.5,-116 19.5,-116"/>
<polygon fill="#f5f5f5" stroke="transparent" points="20,-152 20,-174 123,-174 123,-152 20,-152"/>
<polygon fill="none" stroke="black" points="20,-152 20,-174 123,-174 123,-152 20,-152"/>
<text text-anchor="start" x="25" y="-161.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text>
<text text-anchor="start" x="88" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="20,-134 20,-152 123,-152 123,-134 20,-134"/>
<text text-anchor="start" x="23" y="-140.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="20,-116 20,-134 49,-134 49,-116 20,-116"/>
<polygon fill="none" stroke="black" points="20,-116 20,-134 49,-134 49,-116 20,-116"/>
<text text-anchor="start" x="23" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="49,-116 49,-134 91,-134 91,-116 49,-116"/>
<polygon fill="none" stroke="black" points="49,-116 49,-134 91,-134 91,-116 49,-116"/>
<text text-anchor="start" x="55" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="91,-116 91,-134 123,-134 123,-116 91,-116"/>
<polygon fill="none" stroke="black" points="91,-116 91,-134 123,-134 123,-116 91,-116"/>
<text text-anchor="start" x="98" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 &gt;</text>
</a>
</g>
</g>
<!-- m_report_mailing_job&#45;&gt;m_appuser -->
<g id="edge1" class="edge">
<title>m_report_mailing_job:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M168.15,-152.74C152.76,-149.85 144.88,-143 124,-143"/>
<polygon fill="black" stroke="black" points="174.53,-153.3 182.18,-157.59 178.52,-153.65 182.5,-154 182.5,-154 182.5,-154 178.52,-153.65 182.82,-150.41 174.53,-153.3 174.53,-153.3"/>
<ellipse fill="none" stroke="black" cx="171.34" cy="-153.02" rx="3.2" ry="3.2"/>
</g>
<!-- m_report_mailing_job&#45;&gt;m_appuser -->
<g id="edge2" class="edge">
<title>m_report_mailing_job:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M168.15,-133.26C152.76,-136.15 144.88,-143 124,-143"/>
<polygon fill="black" stroke="black" points="174.53,-132.7 182.82,-135.59 178.52,-132.35 182.5,-132 182.5,-132 182.5,-132 178.52,-132.35 182.18,-128.41 174.53,-132.7 174.53,-132.7"/>
<ellipse fill="none" stroke="black" cx="171.34" cy="-132.98" rx="3.2" ry="3.2"/>
</g>
<!-- m_report_mailing_job&#45;&gt;m_appuser -->
<g id="edge3" class="edge">
<title>m_report_mailing_job:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M168.43,-91.96C149.73,-104.57 153.83,-143 124,-143"/>
<polygon fill="black" stroke="black" points="174.8,-90.16 183.47,-91.47 178.65,-89.08 182.5,-88 182.5,-88 182.5,-88 178.65,-89.08 181.53,-84.53 174.8,-90.16 174.8,-90.16"/>
<ellipse fill="none" stroke="black" cx="171.72" cy="-91.03" rx="3.2" ry="3.2"/>
</g>
<!-- stretchy_report -->
<g id="node3" class="node">
<title>stretchy_report</title>
<g id="a_node3"><a xlink:href="../../tables/stretchy_report.html" xlink:title="stretchy_report" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-95 134,-95 134,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-73 8,-95 134,-95 134,-73 8,-73"/>
<polygon fill="none" stroke="black" points="8,-73 8,-95 134,-95 134,-73 8,-73"/>
<text text-anchor="start" x="13" y="-82.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">stretchy_report</text>
<text text-anchor="start" x="99" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-55 8,-73 134,-73 134,-55 8,-55"/>
<text text-anchor="start" x="11" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-55 47,-55 47,-37 8,-37"/>
<polygon fill="none" stroke="black" points="8,-37 8,-55 47,-55 47,-37 8,-37"/>
<text text-anchor="start" x="11" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="47,-37 47,-55 99,-55 99,-37 47,-37"/>
<polygon fill="none" stroke="black" points="47,-37 47,-55 99,-55 99,-37 47,-37"/>
<text text-anchor="start" x="63" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="99,-37 99,-55 134,-55 134,-37 99,-37"/>
<polygon fill="none" stroke="black" points="99,-37 99,-55 134,-55 134,-37 99,-37"/>
<text text-anchor="start" x="115" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 &gt;</text>
</a>
</g>
</g>
<!-- m_report_mailing_job&#45;&gt;stretchy_report -->
<g id="edge4" class="edge">
<title>m_report_mailing_job:w&#45;&gt;stretchy_report:e</title>
<path fill="none" stroke="black" d="M168.94,-105.08C156.02,-93.21 158.42,-64 135,-64"/>
<polygon fill="black" stroke="black" points="174.98,-107.27 181.27,-113.38 178.74,-108.63 182.5,-110 182.5,-110 182.5,-110 178.74,-108.63 183.73,-106.62 174.98,-107.27 174.98,-107.27"/>
<ellipse fill="none" stroke="black" cx="171.97" cy="-106.18" rx="3.2" ry="3.2"/>
</g>
<!-- m_report_mailing_job_run_history -->
<g id="node4" class="node">
<title>m_report_mailing_job_run_history</title>
<g id="a_node4"><a xlink:href="../../tables/m_report_mailing_job_run_history.html" xlink:title="m_report_mailing_job_run_history" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="453,-57 453,-255 770,-255 770,-57 453,-57"/>
<polygon fill="#f5f5f5" stroke="transparent" points="455.5,-231 455.5,-253 768.5,-253 768.5,-231 455.5,-231"/>
<polygon fill="none" stroke="black" points="455.5,-231 455.5,-253 768.5,-253 768.5,-231 455.5,-231"/>
<text text-anchor="start" x="460.5" y="-240.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_report_mailing_job_run_history</text>
<text text-anchor="start" x="733.5" y="-239.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="455.5,-209 455.5,-231 702.5,-231 702.5,-209 455.5,-209"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="460.5" y="-226"/>
<text text-anchor="start" x="475.5" y="-217.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="702.5,-209 702.5,-231 768.5,-231 768.5,-209 702.5,-209"/>
<text text-anchor="start" x="705.5" y="-217.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="455.5,-187 455.5,-209 702.5,-209 702.5,-187 455.5,-187"/>
<polygon fill="none" stroke="black" points="455.5,-187 455.5,-209 702.5,-209 702.5,-187 455.5,-187"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="460.5" y="-204"/>
<text text-anchor="start" x="475.5" y="-195.2" font-family="Helvetica,sans-Serif" font-size="11.00">job_id</text>
<polygon fill="none" stroke="black" points="702.5,-187 702.5,-209 768.5,-209 768.5,-187 702.5,-187"/>
<text text-anchor="start" x="705.5" y="-195.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="455.5,-165 455.5,-187 702.5,-187 702.5,-165 455.5,-165"/>
<text text-anchor="start" x="475.5" y="-173.2" font-family="Helvetica,sans-Serif" font-size="11.00">start_datetime</text>
<polygon fill="none" stroke="black" points="702.5,-165 702.5,-187 768.5,-187 768.5,-165 702.5,-165"/>
<text text-anchor="start" x="705.5" y="-173.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="455.5,-143 455.5,-165 702.5,-165 702.5,-143 455.5,-143"/>
<text text-anchor="start" x="475.5" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">end_datetime</text>
<polygon fill="none" stroke="black" points="702.5,-143 702.5,-165 768.5,-165 768.5,-143 702.5,-143"/>
<text text-anchor="start" x="705.5" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="455.5,-121 455.5,-143 702.5,-143 702.5,-121 455.5,-121"/>
<text text-anchor="start" x="475.5" y="-129.2" font-family="Helvetica,sans-Serif" font-size="11.00">status</text>
<polygon fill="none" stroke="black" points="702.5,-121 702.5,-143 768.5,-143 768.5,-121 702.5,-121"/>
<text text-anchor="start" x="705.5" y="-129.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[10]</text>
<polygon fill="none" stroke="black" points="455.5,-99 455.5,-121 702.5,-121 702.5,-99 455.5,-99"/>
<text text-anchor="start" x="475.5" y="-107.2" font-family="Helvetica,sans-Serif" font-size="11.00">error_message</text>
<polygon fill="none" stroke="black" points="702.5,-99 702.5,-121 768.5,-121 768.5,-99 702.5,-99"/>
<text text-anchor="start" x="705.5" y="-107.2" font-family="Helvetica,sans-Serif" font-size="11.00">text[65535]</text>
<polygon fill="none" stroke="black" points="455.5,-77 455.5,-99 702.5,-99 702.5,-77 455.5,-77"/>
<text text-anchor="start" x="475.5" y="-85.2" font-family="Helvetica,sans-Serif" font-size="11.00">error_log</text>
<polygon fill="none" stroke="black" points="702.5,-77 702.5,-99 768.5,-99 768.5,-77 702.5,-77"/>
<text text-anchor="start" x="705.5" y="-85.2" font-family="Helvetica,sans-Serif" font-size="11.00">text[65535]</text>
<polygon fill="#ffffff" stroke="transparent" points="455.5,-59 455.5,-77 570.5,-77 570.5,-59 455.5,-59"/>
<polygon fill="none" stroke="black" points="455.5,-59 455.5,-77 570.5,-77 570.5,-59 455.5,-59"/>
<text text-anchor="start" x="458.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="570.5,-59 570.5,-77 702.5,-77 702.5,-59 570.5,-59"/>
<polygon fill="none" stroke="black" points="570.5,-59 570.5,-77 702.5,-77 702.5,-59 570.5,-59"/>
<text text-anchor="start" x="666.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="702.5,-59 702.5,-77 768.5,-77 768.5,-59 702.5,-59"/>
<polygon fill="none" stroke="black" points="702.5,-59 702.5,-77 768.5,-77 768.5,-59 702.5,-59"/>
<text text-anchor="start" x="749.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="454,-58 454,-254 769,-254 769,-58 454,-58"/>
</a>
</g>
</g>
<!-- m_report_mailing_job_run_history&#45;&gt;m_report_mailing_job -->
<g id="edge5" class="edge">
<title>m_report_mailing_job_run_history:w&#45;&gt;m_report_mailing_job:e</title>
<path fill="none" stroke="black" d="M439.99,-198C428.68,-198 421.49,-198 405.5,-198"/>
<polygon fill="black" stroke="black" points="446.5,-198 454.5,-201.6 450.5,-198 454.5,-198 454.5,-198 454.5,-198 450.5,-198 454.5,-194.4 446.5,-198 446.5,-198"/>
<ellipse fill="none" stroke="black" cx="443.3" cy="-198" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>