docs/database/diagrams/tables/sms_campaign.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="743pt" height="641pt"
 viewBox="0.00 0.00 743.00 641.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 637)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-637 739,-637 739,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>
<!-- sms_campaign -->
<g id="node1" class="node">
<title>sms_campaign</title>
<g id="a_node1"><a xlink:href="../../tables/sms_campaign.html" xlink:title="sms_campaign" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="241,-37 241,-543 487,-543 487,-37 241,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="243,-519 243,-541 485,-541 485,-519 243,-519"/>
<polygon fill="none" stroke="black" points="243,-519 243,-541 485,-541 485,-519 243,-519"/>
<text text-anchor="start" x="248" y="-528.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">sms_campaign</text>
<text text-anchor="start" x="450" y="-527.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="243,-497 243,-519 418,-519 418,-497 243,-497"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="248" y="-514"/>
<text text-anchor="start" x="263" y="-505.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="418,-497 418,-519 485,-519 485,-497 418,-497"/>
<text text-anchor="start" x="421" y="-505.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="243,-475 243,-497 418,-497 418,-475 243,-475"/>
<text text-anchor="start" x="263" y="-483.2" font-family="Helvetica,sans-Serif" font-size="11.00">campaign_name</text>
<polygon fill="none" stroke="black" points="418,-475 418,-497 485,-497 485,-475 418,-475"/>
<text text-anchor="start" x="421" y="-483.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="243,-453 243,-475 418,-475 418,-453 243,-453"/>
<text text-anchor="start" x="263" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">campaign_type</text>
<polygon fill="none" stroke="black" points="418,-453 418,-475 485,-475 485,-453 418,-453"/>
<text text-anchor="start" x="421" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="243,-431 243,-453 418,-453 418,-431 243,-431"/>
<text text-anchor="start" x="263" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">campaign_trigger_type</text>
<polygon fill="none" stroke="black" points="418,-431 418,-453 485,-453 485,-431 418,-431"/>
<text text-anchor="start" x="421" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="243,-409 243,-431 418,-431 418,-409 243,-409"/>
<polygon fill="none" stroke="black" points="243,-409 243,-431 418,-431 418,-409 243,-409"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="248" y="-426"/>
<text text-anchor="start" x="263" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">report_id</text>
<polygon fill="none" stroke="black" points="418,-409 418,-431 485,-431 485,-409 418,-409"/>
<text text-anchor="start" x="421" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="243,-387 243,-409 418,-409 418,-387 243,-387"/>
<text text-anchor="start" x="263" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">provider_id</text>
<polygon fill="none" stroke="black" points="418,-387 418,-409 485,-409 485,-387 418,-387"/>
<text text-anchor="start" x="421" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="243,-365 243,-387 418,-387 418,-365 243,-365"/>
<text text-anchor="start" x="263" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">param_value</text>
<polygon fill="none" stroke="black" points="418,-365 418,-387 485,-387 485,-365 418,-365"/>
<text text-anchor="start" x="421" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">text[65535]</text>
<polygon fill="none" stroke="black" points="243,-343 243,-365 418,-365 418,-343 243,-343"/>
<text text-anchor="start" x="263" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">status_enum</text>
<polygon fill="none" stroke="black" points="418,-343 418,-365 485,-365 485,-343 418,-343"/>
<text text-anchor="start" x="421" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="243,-321 243,-343 418,-343 418,-321 243,-321"/>
<text text-anchor="start" x="263" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">message</text>
<polygon fill="none" stroke="black" points="418,-321 418,-343 485,-343 485,-321 418,-321"/>
<text text-anchor="start" x="421" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">text[65535]</text>
<polygon fill="none" stroke="black" points="243,-299 243,-321 418,-321 418,-299 243,-299"/>
<text text-anchor="start" x="263" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">submittedon_date</text>
<polygon fill="none" stroke="black" points="418,-299 418,-321 485,-321 485,-299 418,-299"/>
<text text-anchor="start" x="421" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="243,-277 243,-299 418,-299 418,-277 243,-277"/>
<text text-anchor="start" x="263" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">submittedon_userid</text>
<polygon fill="none" stroke="black" points="418,-277 418,-299 485,-299 485,-277 418,-277"/>
<text text-anchor="start" x="421" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="243,-255 243,-277 418,-277 418,-255 243,-255"/>
<text text-anchor="start" x="263" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">approvedon_date</text>
<polygon fill="none" stroke="black" points="418,-255 418,-277 485,-277 485,-255 418,-255"/>
<text text-anchor="start" x="421" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="243,-233 243,-255 418,-255 418,-233 243,-233"/>
<text text-anchor="start" x="263" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">approvedon_userid</text>
<polygon fill="none" stroke="black" points="418,-233 418,-255 485,-255 485,-233 418,-233"/>
<text text-anchor="start" x="421" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="243,-211 243,-233 418,-233 418,-211 243,-211"/>
<text text-anchor="start" x="263" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">closedon_date</text>
<polygon fill="none" stroke="black" points="418,-211 418,-233 485,-233 485,-211 418,-211"/>
<text text-anchor="start" x="421" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="243,-189 243,-211 418,-211 418,-189 243,-189"/>
<text text-anchor="start" x="263" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">closedon_userid</text>
<polygon fill="none" stroke="black" points="418,-189 418,-211 485,-211 485,-189 418,-189"/>
<text text-anchor="start" x="421" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="243,-167 243,-189 418,-189 418,-167 243,-167"/>
<text text-anchor="start" x="263" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">recurrence</text>
<polygon fill="none" stroke="black" points="418,-167 418,-189 485,-189 485,-167 418,-167"/>
<text text-anchor="start" x="421" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="243,-145 243,-167 418,-167 418,-145 243,-145"/>
<text text-anchor="start" x="263" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">next_trigger_date</text>
<polygon fill="none" stroke="black" points="418,-145 418,-167 485,-167 485,-145 418,-145"/>
<text text-anchor="start" x="421" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="243,-123 243,-145 418,-145 418,-123 243,-123"/>
<text text-anchor="start" x="263" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_trigger_date</text>
<polygon fill="none" stroke="black" points="418,-123 418,-145 485,-145 485,-123 418,-123"/>
<text text-anchor="start" x="421" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="243,-101 243,-123 418,-123 418,-101 243,-101"/>
<text text-anchor="start" x="263" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">recurrence_start_date</text>
<polygon fill="none" stroke="black" points="418,-101 418,-123 485,-123 485,-101 418,-101"/>
<text text-anchor="start" x="421" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="243,-79 243,-101 418,-101 418,-79 243,-79"/>
<text text-anchor="start" x="263" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_visible</text>
<polygon fill="none" stroke="black" points="418,-79 418,-101 485,-101 485,-79 418,-79"/>
<text text-anchor="start" x="421" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="243,-57 243,-79 418,-79 418,-57 243,-57"/>
<text text-anchor="start" x="263" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_notification</text>
<polygon fill="none" stroke="black" points="418,-57 418,-79 485,-79 485,-57 418,-57"/>
<text text-anchor="start" x="421" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="#ffffff" stroke="transparent" points="243,-39 243,-57 322,-57 322,-39 243,-39"/>
<polygon fill="none" stroke="black" points="243,-39 243,-57 322,-57 322,-39 243,-39"/>
<text text-anchor="start" x="246" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="322,-39 322,-57 418,-57 418,-39 322,-39"/>
<polygon fill="none" stroke="black" points="322,-39 322,-57 418,-57 418,-39 322,-39"/>
<text text-anchor="start" x="382" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="418,-39 418,-57 485,-57 485,-39 418,-39"/>
<polygon fill="none" stroke="black" points="418,-39 418,-57 485,-57 485,-39 418,-39"/>
<text text-anchor="start" x="466" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="242,-38 242,-542 486,-542 486,-38 242,-38"/>
</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,-351 8,-453 192,-453 192,-351 8,-351"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-431 8,-453 192,-453 192,-431 8,-431"/>
<polygon fill="none" stroke="black" points="8,-431 8,-453 192,-453 192,-431 8,-431"/>
<text text-anchor="start" x="13" y="-440.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">stretchy_report</text>
<text text-anchor="start" x="157" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-409 8,-431 192,-431 192,-409 8,-409"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-426"/>
<text text-anchor="start" x="28" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-387 8,-409 192,-409 192,-387 8,-387"/>
<polygon fill="none" stroke="black" points="8,-387 8,-409 192,-409 192,-387 8,-387"/>
<text text-anchor="start" x="28" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">report_name</text>
<polygon fill="none" stroke="black" points="8,-369 8,-387 192,-387 192,-369 8,-369"/>
<text text-anchor="start" x="11" y="-375.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-351 8,-369 76,-369 76,-351 8,-351"/>
<polygon fill="none" stroke="black" points="8,-351 8,-369 76,-369 76,-351 8,-351"/>
<text text-anchor="start" x="11" y="-357.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="76,-351 76,-369 142,-369 142,-351 76,-351"/>
<polygon fill="none" stroke="black" points="76,-351 76,-369 142,-369 142,-351 76,-351"/>
<text text-anchor="start" x="106" y="-357.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="142,-351 142,-369 192,-369 192,-351 142,-351"/>
<polygon fill="none" stroke="black" points="142,-351 142,-369 192,-369 192,-351 142,-351"/>
<text text-anchor="start" x="173" y="-357.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 &gt;</text>
</a>
</g>
</g>
<!-- sms_campaign&#45;&gt;stretchy_report -->
<g id="edge1" class="edge">
<title>sms_campaign:w&#45;&gt;stretchy_report:e</title>
<path fill="none" stroke="black" d="M227.49,-420C216.18,-420 208.99,-420 193,-420"/>
<polygon fill="black" stroke="black" points="234,-420 242,-423.6 238,-420 242,-420 242,-420 242,-420 238,-420 242,-416.4 234,-420 234,-420"/>
<ellipse fill="none" stroke="black" cx="230.8" cy="-420" rx="3.2" ry="3.2"/>
</g>
<!-- sms_messages_outbound -->
<g id="node3" class="node">
<title>sms_messages_outbound</title>
<g id="a_node3"><a xlink:href="../../tables/sms_messages_outbound.html" xlink:title="sms_messages_outbound" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="536,-461 536,-629 727,-629 727,-461 536,-461"/>
<polygon fill="#f5f5f5" stroke="transparent" points="536.5,-607 536.5,-629 727.5,-629 727.5,-607 536.5,-607"/>
<polygon fill="none" stroke="black" points="536.5,-607 536.5,-629 727.5,-629 727.5,-607 536.5,-607"/>
<text text-anchor="start" x="541.5" y="-616.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">sms_messages_outbound</text>
<text text-anchor="start" x="692.5" y="-615.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="536.5,-585 536.5,-607 727.5,-607 727.5,-585 536.5,-585"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="541.5" y="-602"/>
<text text-anchor="start" x="556.5" y="-593.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="536.5,-563 536.5,-585 727.5,-585 727.5,-563 536.5,-563"/>
<polygon fill="none" stroke="black" points="536.5,-563 536.5,-585 727.5,-585 727.5,-563 536.5,-563"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="541.5" y="-580"/>
<text text-anchor="start" x="556.5" y="-571.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text>
<polygon fill="#ffffff" stroke="transparent" points="536.5,-541 536.5,-563 727.5,-563 727.5,-541 536.5,-541"/>
<polygon fill="none" stroke="black" points="536.5,-541 536.5,-563 727.5,-563 727.5,-541 536.5,-541"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="541.5" y="-558"/>
<text text-anchor="start" x="556.5" y="-549.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="536.5,-519 536.5,-541 727.5,-541 727.5,-519 536.5,-519"/>
<polygon fill="none" stroke="black" points="536.5,-519 536.5,-541 727.5,-541 727.5,-519 536.5,-519"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="541.5" y="-536"/>
<text text-anchor="start" x="556.5" y="-527.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text>
<polygon fill="#ffffff" stroke="transparent" points="536.5,-497 536.5,-519 727.5,-519 727.5,-497 536.5,-497"/>
<polygon fill="none" stroke="black" points="536.5,-497 536.5,-519 727.5,-519 727.5,-497 536.5,-497"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="541.5" y="-514"/>
<text text-anchor="start" x="556.5" y="-505.2" font-family="Helvetica,sans-Serif" font-size="11.00">campaign_id</text>
<polygon fill="none" stroke="black" points="536.5,-479 536.5,-497 727.5,-497 727.5,-479 536.5,-479"/>
<text text-anchor="start" x="539.5" y="-485.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="536.5,-461 536.5,-479 616.5,-479 616.5,-461 536.5,-461"/>
<polygon fill="none" stroke="black" points="536.5,-461 536.5,-479 616.5,-479 616.5,-461 536.5,-461"/>
<text text-anchor="start" x="539.5" y="-467.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 4</text>
<polygon fill="#ffffff" stroke="transparent" points="616.5,-461 616.5,-479 684.5,-479 684.5,-461 616.5,-461"/>
<polygon fill="none" stroke="black" points="616.5,-461 616.5,-479 684.5,-479 684.5,-461 616.5,-461"/>
<text text-anchor="start" x="648.5" y="-467.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="684.5,-461 684.5,-479 727.5,-479 727.5,-461 684.5,-461"/>
<polygon fill="none" stroke="black" points="684.5,-461 684.5,-479 727.5,-479 727.5,-461 684.5,-461"/>
<text text-anchor="start" x="717.5" y="-467.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- sms_messages_outbound&#45;&gt;sms_campaign -->
<g id="edge2" class="edge">
<title>sms_messages_outbound:w&#45;&gt;sms_campaign:e</title>
<path fill="none" stroke="black" d="M520.84,-508C509.41,-508 502.16,-508 486,-508"/>
<polygon fill="black" stroke="black" points="527.5,-508 535.5,-511.6 531.5,-508 535.5,-508 535.5,-508 535.5,-508 531.5,-508 535.5,-504.4 527.5,-508 527.5,-508"/>
<ellipse fill="none" stroke="black" cx="524.3" cy="-508" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>