| <?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="524pt" height="456pt" |
| viewBox="0.00 0.00 524.00 456.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 452)"> |
| <title>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-452 520,-452 520,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="295,-386 295,-444 454,-444 454,-386 295,-386"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="295.5,-422 295.5,-444 454.5,-444 454.5,-422 295.5,-422"/> |
| <polygon fill="none" stroke="black" points="295.5,-422 295.5,-444 454.5,-444 454.5,-422 295.5,-422"/> |
| <text text-anchor="start" x="300.5" y="-431.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_report_mailing_job</text> |
| <text text-anchor="start" x="419.5" y="-430.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="295.5,-404 295.5,-422 454.5,-422 454.5,-404 295.5,-404"/> |
| <text text-anchor="start" x="298.5" y="-410.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-386 295.5,-404 355.5,-404 355.5,-386 295.5,-386"/> |
| <polygon fill="none" stroke="black" points="295.5,-386 295.5,-404 355.5,-404 355.5,-386 295.5,-386"/> |
| <text text-anchor="start" x="298.5" y="-392.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 4</text> |
| <polygon fill="#ffffff" stroke="transparent" points="355.5,-386 355.5,-404 413.5,-404 413.5,-386 355.5,-386"/> |
| <polygon fill="none" stroke="black" points="355.5,-386 355.5,-404 413.5,-404 413.5,-386 355.5,-386"/> |
| <text text-anchor="start" x="377.5" y="-392.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="413.5,-386 413.5,-404 454.5,-404 454.5,-386 413.5,-386"/> |
| <polygon fill="none" stroke="black" points="413.5,-386 413.5,-404 454.5,-404 454.5,-386 413.5,-386"/> |
| <text text-anchor="start" x="435.5" y="-392.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- stretchy_report --> |
| <g id="node2" class="node"> |
| <title>stretchy_report</title> |
| <g id="a_node2"><a xlink:href="../../tables/stretchy_report.html" xlink:title="stretchy_report" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-225 8,-327 192,-327 192,-225 8,-225"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-305 8,-327 192,-327 192,-305 8,-305"/> |
| <polygon fill="none" stroke="black" points="8,-305 8,-327 192,-327 192,-305 8,-305"/> |
| <text text-anchor="start" x="13" y="-314.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">stretchy_report</text> |
| <text text-anchor="start" x="157" y="-313.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-283 8,-305 192,-305 192,-283 8,-283"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-300"/> |
| <text text-anchor="start" x="28" y="-291.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-261 8,-283 192,-283 192,-261 8,-261"/> |
| <polygon fill="none" stroke="black" points="8,-261 8,-283 192,-283 192,-261 8,-261"/> |
| <text text-anchor="start" x="28" y="-269.2" font-family="Helvetica,sans-Serif" font-size="11.00">report_name</text> |
| <polygon fill="none" stroke="black" points="8,-243 8,-261 192,-261 192,-243 8,-243"/> |
| <text text-anchor="start" x="11" y="-249.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-225 8,-243 76,-243 76,-225 8,-225"/> |
| <polygon fill="none" stroke="black" points="8,-225 8,-243 76,-243 76,-225 8,-225"/> |
| <text text-anchor="start" x="11" y="-231.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| <polygon fill="#ffffff" stroke="transparent" points="76,-225 76,-243 142,-243 142,-225 76,-225"/> |
| <polygon fill="none" stroke="black" points="76,-225 76,-243 142,-243 142,-225 76,-225"/> |
| <text text-anchor="start" x="106" y="-231.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="142,-225 142,-243 192,-243 192,-225 142,-225"/> |
| <polygon fill="none" stroke="black" points="142,-225 142,-243 192,-243 192,-225 142,-225"/> |
| <text text-anchor="start" x="173" y="-231.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_report_mailing_job->stretchy_report --> |
| <g id="edge1" class="edge"> |
| <title>m_report_mailing_job:w->stretchy_report:e</title> |
| <path fill="none" stroke="black" d="M279.98,-411.82C259.43,-408.07 250.84,-395.48 233,-376 205.61,-346.1 233.55,-294 193,-294"/> |
| <polygon fill="black" stroke="black" points="286.53,-412.35 294.21,-416.59 290.51,-412.68 294.5,-413 294.5,-413 294.5,-413 290.51,-412.68 294.79,-409.41 286.53,-412.35 286.53,-412.35"/> |
| <ellipse fill="none" stroke="black" cx="283.34" cy="-412.1" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- scheduled_email_campaign --> |
| <g id="node3" class="node"> |
| <title>scheduled_email_campaign</title> |
| <g id="a_node3"><a xlink:href="../../tables/scheduled_email_campaign.html" xlink:title="scheduled_email_campaign" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="280,-307 280,-365 469,-365 469,-307 280,-307"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="280.5,-343 280.5,-365 469.5,-365 469.5,-343 280.5,-343"/> |
| <polygon fill="none" stroke="black" points="280.5,-343 280.5,-365 469.5,-365 469.5,-343 280.5,-343"/> |
| <text text-anchor="start" x="285.5" y="-352.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">scheduled_email_campaign</text> |
| <text text-anchor="start" x="434.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="280.5,-325 280.5,-343 469.5,-343 469.5,-325 280.5,-325"/> |
| <text text-anchor="start" x="283.5" y="-331.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="280.5,-307 280.5,-325 355.5,-325 355.5,-307 280.5,-307"/> |
| <polygon fill="none" stroke="black" points="280.5,-307 280.5,-325 355.5,-325 355.5,-307 280.5,-307"/> |
| <text text-anchor="start" x="283.5" y="-313.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="355.5,-307 355.5,-325 420.5,-325 420.5,-307 355.5,-307"/> |
| <polygon fill="none" stroke="black" points="355.5,-307 355.5,-325 420.5,-325 420.5,-307 355.5,-307"/> |
| <text text-anchor="start" x="384.5" y="-313.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="420.5,-307 420.5,-325 469.5,-325 469.5,-307 420.5,-307"/> |
| <polygon fill="none" stroke="black" points="420.5,-307 420.5,-325 469.5,-325 469.5,-307 420.5,-307"/> |
| <text text-anchor="start" x="450.5" y="-313.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- scheduled_email_campaign->stretchy_report --> |
| <g id="edge2" class="edge"> |
| <title>scheduled_email_campaign:w->stretchy_report:e</title> |
| <path fill="none" stroke="black" d="M264.97,-332.18C236.01,-324.35 229.9,-294 193,-294"/> |
| <polygon fill="black" stroke="black" points="271.56,-333 279.05,-337.57 275.53,-333.5 279.5,-334 279.5,-334 279.5,-334 275.53,-333.5 279.95,-330.43 271.56,-333 271.56,-333"/> |
| <ellipse fill="none" stroke="black" cx="268.39" cy="-332.61" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- sms_campaign --> |
| <g id="node4" class="node"> |
| <title>sms_campaign</title> |
| <g id="a_node4"><a xlink:href="../../tables/sms_campaign.html" xlink:title="sms_campaign" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="313,-228 313,-286 436,-286 436,-228 313,-228"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="313.5,-264 313.5,-286 436.5,-286 436.5,-264 313.5,-264"/> |
| <polygon fill="none" stroke="black" points="313.5,-264 313.5,-286 436.5,-286 436.5,-264 313.5,-264"/> |
| <text text-anchor="start" x="318.5" y="-273.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">sms_campaign</text> |
| <text text-anchor="start" x="401.5" y="-272.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="313.5,-246 313.5,-264 436.5,-264 436.5,-246 313.5,-246"/> |
| <text text-anchor="start" x="316.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="313.5,-228 313.5,-246 355.5,-246 355.5,-228 313.5,-228"/> |
| <polygon fill="none" stroke="black" points="313.5,-228 313.5,-246 355.5,-246 355.5,-228 313.5,-228"/> |
| <text text-anchor="start" x="316.5" y="-234.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="355.5,-228 355.5,-246 404.5,-246 404.5,-228 355.5,-228"/> |
| <polygon fill="none" stroke="black" points="355.5,-228 355.5,-246 404.5,-246 404.5,-228 355.5,-228"/> |
| <text text-anchor="start" x="368.5" y="-234.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="404.5,-228 404.5,-246 436.5,-246 436.5,-228 404.5,-228"/> |
| <polygon fill="none" stroke="black" points="404.5,-228 404.5,-246 436.5,-246 436.5,-228 404.5,-228"/> |
| <text text-anchor="start" x="417.5" y="-234.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- sms_campaign->stretchy_report --> |
| <g id="edge3" class="edge"> |
| <title>sms_campaign:w->stretchy_report:e</title> |
| <path fill="none" stroke="black" d="M297.98,-255.96C254.75,-261.97 243.63,-294 193,-294"/> |
| <polygon fill="black" stroke="black" points="304.52,-255.53 312.74,-258.59 308.51,-255.26 312.5,-255 312.5,-255 312.5,-255 308.51,-255.26 312.26,-251.41 304.52,-255.53 304.52,-255.53"/> |
| <ellipse fill="none" stroke="black" cx="301.32" cy="-255.74" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- stretchy_report_parameter --> |
| <g id="node5" class="node"> |
| <title>stretchy_report_parameter</title> |
| <g id="a_node5"><a xlink:href="../../tables/stretchy_report_parameter.html" xlink:title="stretchy_report_parameter" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="241,-75 241,-207 508,-207 508,-75 241,-75"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="243.5,-183 243.5,-205 506.5,-205 506.5,-183 243.5,-183"/> |
| <polygon fill="none" stroke="black" points="243.5,-183 243.5,-205 506.5,-205 506.5,-183 243.5,-183"/> |
| <text text-anchor="start" x="248.5" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">stretchy_report_parameter</text> |
| <text text-anchor="start" x="471.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="243.5,-161 243.5,-183 445.5,-183 445.5,-161 243.5,-161"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="248.5" y="-178"/> |
| <text text-anchor="start" x="263.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="445.5,-161 445.5,-183 506.5,-183 506.5,-161 445.5,-161"/> |
| <text text-anchor="start" x="448.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="243.5,-139 243.5,-161 445.5,-161 445.5,-139 243.5,-139"/> |
| <polygon fill="none" stroke="black" points="243.5,-139 243.5,-161 445.5,-161 445.5,-139 243.5,-139"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="248.5" y="-156"/> |
| <text text-anchor="start" x="263.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">report_id</text> |
| <polygon fill="none" stroke="black" points="445.5,-139 445.5,-161 506.5,-161 506.5,-139 445.5,-139"/> |
| <text text-anchor="start" x="448.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="243.5,-117 243.5,-139 445.5,-139 445.5,-117 243.5,-117"/> |
| <polygon fill="none" stroke="black" points="243.5,-117 243.5,-139 445.5,-139 445.5,-117 243.5,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="248.5" y="-134"/> |
| <text text-anchor="start" x="263.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">parameter_id</text> |
| <polygon fill="none" stroke="black" points="445.5,-117 445.5,-139 506.5,-139 506.5,-117 445.5,-117"/> |
| <text text-anchor="start" x="448.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="243.5,-95 243.5,-117 445.5,-117 445.5,-95 243.5,-95"/> |
| <text text-anchor="start" x="263.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">report_parameter_name</text> |
| <polygon fill="none" stroke="black" points="445.5,-95 445.5,-117 506.5,-117 506.5,-95 445.5,-95"/> |
| <text text-anchor="start" x="448.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[45]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="243.5,-77 243.5,-95 335.5,-95 335.5,-77 243.5,-77"/> |
| <polygon fill="none" stroke="black" points="243.5,-77 243.5,-95 335.5,-95 335.5,-77 243.5,-77"/> |
| <text text-anchor="start" x="246.5" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="335.5,-77 335.5,-95 445.5,-95 445.5,-77 335.5,-77"/> |
| <polygon fill="none" stroke="black" points="335.5,-77 335.5,-95 445.5,-95 445.5,-77 335.5,-77"/> |
| <text text-anchor="start" x="409.5" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="445.5,-77 445.5,-95 506.5,-95 506.5,-77 445.5,-77"/> |
| <polygon fill="none" stroke="black" points="445.5,-77 445.5,-95 506.5,-95 506.5,-77 445.5,-77"/> |
| <text text-anchor="start" x="487.5" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="242,-76 242,-206 507,-206 507,-76 242,-76"/> |
| </a> |
| </g> |
| </g> |
| <!-- stretchy_report_parameter->stretchy_report --> |
| <g id="edge5" class="edge"> |
| <title>stretchy_report_parameter:w->stretchy_report:e</title> |
| <path fill="none" stroke="black" d="M228.26,-153.01C188.45,-173.69 254.86,-294 193,-294"/> |
| <polygon fill="black" stroke="black" points="234.67,-151.65 243.24,-153.52 238.59,-150.83 242.5,-150 242.5,-150 242.5,-150 238.59,-150.83 241.76,-146.48 234.67,-151.65 234.67,-151.65"/> |
| <ellipse fill="none" stroke="black" cx="231.54" cy="-152.31" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- stretchy_parameter --> |
| <g id="node6" class="node"> |
| <title>stretchy_parameter</title> |
| <g id="a_node6"><a xlink:href="../../tables/stretchy_parameter.html" xlink:title="stretchy_parameter" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-37 10.5,-161 189.5,-161 189.5,-37 10.5,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="11,-139 11,-161 190,-161 190,-139 11,-139"/> |
| <polygon fill="none" stroke="black" points="11,-139 11,-161 190,-161 190,-139 11,-139"/> |
| <text text-anchor="start" x="16" y="-148.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">stretchy_parameter</text> |
| <text text-anchor="start" x="155" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="11,-117 11,-139 190,-139 190,-117 11,-117"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="16" y="-134"/> |
| <text text-anchor="start" x="31" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="11,-95 11,-117 190,-117 190,-95 11,-95"/> |
| <polygon fill="none" stroke="black" points="11,-95 11,-117 190,-117 190,-95 11,-95"/> |
| <text text-anchor="start" x="31" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">parameter_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="11,-73 11,-95 190,-95 190,-73 11,-73"/> |
| <polygon fill="none" stroke="black" points="11,-73 11,-95 190,-95 190,-73 11,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="16" y="-90"/> |
| <text text-anchor="start" x="31" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text> |
| <polygon fill="none" stroke="black" points="11,-55 11,-73 190,-73 190,-55 11,-55"/> |
| <text text-anchor="start" x="14" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="11,-37 11,-55 81,-55 81,-37 11,-37"/> |
| <polygon fill="none" stroke="black" points="11,-37 11,-55 81,-55 81,-37 11,-37"/> |
| <text text-anchor="start" x="14" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="81,-37 81,-55 144,-55 144,-37 81,-37"/> |
| <polygon fill="none" stroke="black" points="81,-37 81,-55 144,-55 144,-37 81,-37"/> |
| <text text-anchor="start" x="108" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="144,-37 144,-55 190,-55 190,-37 144,-37"/> |
| <polygon fill="none" stroke="black" points="144,-37 144,-55 190,-55 190,-37 144,-37"/> |
| <text text-anchor="start" x="171" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- stretchy_report_parameter->stretchy_parameter --> |
| <g id="edge4" class="edge"> |
| <title>stretchy_report_parameter:w->stretchy_parameter:e</title> |
| <path fill="none" stroke="black" d="M228.02,-128C215.68,-128 208.17,-128 191,-128"/> |
| <polygon fill="black" stroke="black" points="234.5,-128 242.5,-131.6 238.5,-128 242.5,-128 242.5,-128 242.5,-128 238.5,-128 242.5,-124.4 234.5,-128 234.5,-128"/> |
| <ellipse fill="none" stroke="black" cx="231.3" cy="-128" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |