docs/database/diagrams/tables/sms_campaign.2degrees.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: twoDegreesRelationshipsDiagram Pages: 1 -->
<svg width="743pt" height="977pt"
 viewBox="0.00 0.00 743.00 977.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 973)">
<title>twoDegreesRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-973 739,-973 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>
<!-- m_client -->
<g id="node1" class="node">
<title>m_client</title>
<g id="a_node1"><a xlink:href="../../tables/m_client.html" xlink:title="m_client" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="316.5,-828 316.5,-886 411.5,-886 411.5,-828 316.5,-828"/>
<polygon fill="#f5f5f5" stroke="transparent" points="317,-864 317,-886 412,-886 412,-864 317,-864"/>
<polygon fill="none" stroke="black" points="317,-864 317,-886 412,-886 412,-864 317,-864"/>
<text text-anchor="start" x="322" y="-873.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text>
<text text-anchor="start" x="377" y="-872.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="317,-846 317,-864 412,-864 412,-846 317,-846"/>
<text text-anchor="start" x="320" y="-852.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="317,-828 317,-846 345,-846 345,-828 317,-828"/>
<polygon fill="none" stroke="black" points="317,-828 317,-846 345,-846 345,-828 317,-828"/>
<text text-anchor="start" x="320" y="-834.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 13</text>
<polygon fill="#ffffff" stroke="transparent" points="345,-828 345,-846 384,-846 384,-828 345,-828"/>
<polygon fill="none" stroke="black" points="345,-828 345,-846 384,-846 384,-828 345,-828"/>
<text text-anchor="start" x="348" y="-834.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="384,-828 384,-846 412,-846 412,-828 384,-828"/>
<polygon fill="none" stroke="black" points="384,-828 384,-846 412,-846 412,-828 384,-828"/>
<text text-anchor="start" x="387" y="-834.2" font-family="Helvetica,sans-Serif" font-size="11.00">23 &gt;</text>
</a>
</g>
</g>
<!-- m_staff -->
<g id="node2" class="node">
<title>m_staff</title>
<g id="a_node2"><a xlink:href="../../tables/m_staff.html" xlink:title="m_staff" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="55.5,-828 55.5,-886 144.5,-886 144.5,-828 55.5,-828"/>
<polygon fill="#f5f5f5" stroke="transparent" points="56,-864 56,-886 145,-886 145,-864 56,-864"/>
<polygon fill="none" stroke="black" points="56,-864 56,-886 145,-886 145,-864 56,-864"/>
<text text-anchor="start" x="61" y="-873.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_staff</text>
<text text-anchor="start" x="110" y="-872.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="56,-846 56,-864 145,-864 145,-846 56,-846"/>
<text text-anchor="start" x="59" y="-852.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="56,-828 56,-846 78,-846 78,-828 56,-828"/>
<polygon fill="none" stroke="black" points="56,-828 56,-846 78,-846 78,-828 56,-828"/>
<text text-anchor="start" x="59" y="-834.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="78,-828 78,-846 117,-846 117,-828 78,-828"/>
<polygon fill="none" stroke="black" points="78,-828 78,-846 117,-846 117,-828 78,-828"/>
<text text-anchor="start" x="81" y="-834.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="117,-828 117,-846 145,-846 145,-828 117,-828"/>
<polygon fill="none" stroke="black" points="117,-828 117,-846 145,-846 145,-828 117,-828"/>
<text text-anchor="start" x="120" y="-834.2" font-family="Helvetica,sans-Serif" font-size="11.00">10 &gt;</text>
</a>
</g>
</g>
<!-- m_client&#45;&gt;m_staff -->
<g id="edge1" class="edge">
<title>m_client:w&#45;&gt;m_staff:e</title>
<path fill="none" stroke="black" d="M301.26,-855C237.6,-855 216.39,-855 146,-855"/>
<polygon fill="black" stroke="black" points="308,-855 316,-858.6 312,-855 316,-855 316,-855 316,-855 312,-855 316,-851.4 308,-855 308,-855"/>
<ellipse fill="none" stroke="black" cx="304.8" cy="-855" rx="3.2" ry="3.2"/>
</g>
<!-- m_group -->
<g id="node3" class="node">
<title>m_group</title>
<g id="a_node3"><a xlink:href="../../tables/m_group.html" xlink:title="m_group" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="318,-907 318,-965 410,-965 410,-907 318,-907"/>
<polygon fill="#f5f5f5" stroke="transparent" points="318,-943 318,-965 410,-965 410,-943 318,-943"/>
<polygon fill="none" stroke="black" points="318,-943 318,-965 410,-965 410,-943 318,-943"/>
<text text-anchor="start" x="323" y="-952.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_group</text>
<text text-anchor="start" x="375" y="-951.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="318,-925 318,-943 410,-943 410,-925 318,-925"/>
<text text-anchor="start" x="321" y="-931.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="318,-907 318,-925 341,-925 341,-907 318,-907"/>
<polygon fill="none" stroke="black" points="318,-907 318,-925 341,-925 341,-907 318,-907"/>
<text text-anchor="start" x="321" y="-913.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 5</text>
<polygon fill="#ffffff" stroke="transparent" points="341,-907 341,-925 381,-925 381,-907 341,-907"/>
<polygon fill="none" stroke="black" points="341,-907 341,-925 381,-925 381,-907 341,-907"/>
<text text-anchor="start" x="345" y="-913.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="381,-907 381,-925 410,-925 410,-907 381,-907"/>
<polygon fill="none" stroke="black" points="381,-907 381,-925 410,-925 410,-907 381,-907"/>
<text text-anchor="start" x="385" y="-913.2" font-family="Helvetica,sans-Serif" font-size="11.00">11 &gt;</text>
</a>
</g>
</g>
<!-- m_group&#45;&gt;m_staff -->
<g id="edge2" class="edge">
<title>m_group:w&#45;&gt;m_staff:e</title>
<path fill="none" stroke="black" d="M302.42,-933C274.02,-928.76 265.12,-911.82 233,-897 194.01,-879.01 188.94,-855 146,-855"/>
<polygon fill="black" stroke="black" points="309.02,-933.45 316.75,-937.59 313.01,-933.73 317,-934 317,-934 317,-934 313.01,-933.73 317.25,-930.41 309.02,-933.45 309.02,-933.45"/>
<ellipse fill="none" stroke="black" cx="305.83" cy="-933.23" rx="3.2" ry="3.2"/>
</g>
<!-- m_report_mailing_job -->
<g id="node4" class="node">
<title>m_report_mailing_job</title>
<g id="a_node4"><a xlink:href="../../tables/m_report_mailing_job.html" xlink:title="m_report_mailing_job" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="284.5,-195 284.5,-253 443.5,-253 443.5,-195 284.5,-195"/>
<polygon fill="#f5f5f5" stroke="transparent" points="285,-231 285,-253 444,-253 444,-231 285,-231"/>
<polygon fill="none" stroke="black" points="285,-231 285,-253 444,-253 444,-231 285,-231"/>
<text text-anchor="start" x="290" y="-240.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_report_mailing_job</text>
<text text-anchor="start" x="409" y="-239.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="285,-213 285,-231 444,-231 444,-213 285,-213"/>
<text text-anchor="start" x="288" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="285,-195 285,-213 345,-213 345,-195 285,-195"/>
<polygon fill="none" stroke="black" points="285,-195 285,-213 345,-213 345,-195 285,-195"/>
<text text-anchor="start" x="288" y="-201.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 4</text>
<polygon fill="#ffffff" stroke="transparent" points="345,-195 345,-213 403,-213 403,-195 345,-195"/>
<polygon fill="none" stroke="black" points="345,-195 345,-213 403,-213 403,-195 345,-195"/>
<text text-anchor="start" x="367" y="-201.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="403,-195 403,-213 444,-213 444,-195 403,-195"/>
<polygon fill="none" stroke="black" points="403,-195 403,-213 444,-213 444,-195 403,-195"/>
<text text-anchor="start" x="425" y="-201.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- stretchy_report -->
<g id="node5" class="node">
<title>stretchy_report</title>
<g id="a_node5"><a xlink:href="../../tables/stretchy_report.html" xlink:title="stretchy_report" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-114 8,-216 192,-216 192,-114 8,-114"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-194 8,-216 192,-216 192,-194 8,-194"/>
<polygon fill="none" stroke="black" points="8,-194 8,-216 192,-216 192,-194 8,-194"/>
<text text-anchor="start" x="13" y="-203.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">stretchy_report</text>
<text text-anchor="start" x="157" y="-202.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-172 8,-194 192,-194 192,-172 8,-172"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-189"/>
<text text-anchor="start" x="28" y="-180.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-150 8,-172 192,-172 192,-150 8,-150"/>
<polygon fill="none" stroke="black" points="8,-150 8,-172 192,-172 192,-150 8,-150"/>
<text text-anchor="start" x="28" y="-158.2" font-family="Helvetica,sans-Serif" font-size="11.00">report_name</text>
<polygon fill="none" stroke="black" points="8,-132 8,-150 192,-150 192,-132 8,-132"/>
<text text-anchor="start" x="11" y="-138.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-114 8,-132 76,-132 76,-114 8,-114"/>
<polygon fill="none" stroke="black" points="8,-114 8,-132 76,-132 76,-114 8,-114"/>
<text text-anchor="start" x="11" y="-120.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="76,-114 76,-132 142,-132 142,-114 76,-114"/>
<polygon fill="none" stroke="black" points="76,-114 76,-132 142,-132 142,-114 76,-114"/>
<text text-anchor="start" x="106" y="-120.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="142,-114 142,-132 192,-132 192,-114 142,-114"/>
<polygon fill="none" stroke="black" points="142,-114 142,-132 192,-132 192,-114 142,-114"/>
<text text-anchor="start" x="173" y="-120.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="edge3" class="edge">
<title>m_report_mailing_job:w&#45;&gt;stretchy_report:e</title>
<path fill="none" stroke="black" d="M269.67,-220.42C238.67,-213.13 231.67,-183 193,-183"/>
<polygon fill="black" stroke="black" points="276.05,-221.12 283.61,-225.58 280.02,-221.56 284,-222 284,-222 284,-222 280.02,-221.56 284.39,-218.42 276.05,-221.12 276.05,-221.12"/>
<ellipse fill="none" stroke="black" cx="272.87" cy="-220.77" rx="3.2" ry="3.2"/>
</g>
<!-- scheduled_email_campaign -->
<g id="node6" class="node">
<title>scheduled_email_campaign</title>
<g id="a_node6"><a xlink:href="../../tables/scheduled_email_campaign.html" xlink:title="scheduled_email_campaign" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="269.5,-116 269.5,-174 458.5,-174 458.5,-116 269.5,-116"/>
<polygon fill="#f5f5f5" stroke="transparent" points="270,-152 270,-174 459,-174 459,-152 270,-152"/>
<polygon fill="none" stroke="black" points="270,-152 270,-174 459,-174 459,-152 270,-152"/>
<text text-anchor="start" x="275" y="-161.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">scheduled_email_campaign</text>
<text text-anchor="start" x="424" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="270,-134 270,-152 459,-152 459,-134 270,-134"/>
<text text-anchor="start" x="273" y="-140.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="270,-116 270,-134 345,-134 345,-116 270,-116"/>
<polygon fill="none" stroke="black" points="270,-116 270,-134 345,-134 345,-116 270,-116"/>
<text text-anchor="start" x="273" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="345,-116 345,-134 410,-134 410,-116 345,-116"/>
<polygon fill="none" stroke="black" points="345,-116 345,-134 410,-134 410,-116 345,-116"/>
<text text-anchor="start" x="374" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="410,-116 410,-134 459,-134 459,-116 410,-116"/>
<polygon fill="none" stroke="black" points="410,-116 410,-134 459,-134 459,-116 410,-116"/>
<text text-anchor="start" x="440" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- scheduled_email_campaign&#45;&gt;stretchy_report -->
<g id="edge4" class="edge">
<title>scheduled_email_campaign:w&#45;&gt;stretchy_report:e</title>
<path fill="none" stroke="black" d="M254.63,-145.27C230.12,-153.73 225.65,-183 193,-183"/>
<polygon fill="black" stroke="black" points="261.1,-144.25 269.56,-146.56 265.05,-143.62 269,-143 269,-143 269,-143 265.05,-143.62 268.44,-139.44 261.1,-144.25 261.1,-144.25"/>
<ellipse fill="none" stroke="black" cx="257.94" cy="-144.74" rx="3.2" ry="3.2"/>
</g>
<!-- sms_campaign -->
<g id="node7" class="node">
<title>sms_campaign</title>
<g id="a_node7"><a xlink:href="../../tables/sms_campaign.html" xlink:title="sms_campaign" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="241,-274 241,-780 487,-780 487,-274 241,-274"/>
<polygon fill="#f5f5f5" stroke="transparent" points="243,-756 243,-778 485,-778 485,-756 243,-756"/>
<polygon fill="none" stroke="black" points="243,-756 243,-778 485,-778 485,-756 243,-756"/>
<text text-anchor="start" x="248" y="-765.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">sms_campaign</text>
<text text-anchor="start" x="450" y="-764.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="243,-734 243,-756 418,-756 418,-734 243,-734"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="248" y="-751"/>
<text text-anchor="start" x="263" y="-742.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="418,-734 418,-756 485,-756 485,-734 418,-734"/>
<text text-anchor="start" x="421" y="-742.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="243,-712 243,-734 418,-734 418,-712 243,-712"/>
<text text-anchor="start" x="263" y="-720.2" font-family="Helvetica,sans-Serif" font-size="11.00">campaign_name</text>
<polygon fill="none" stroke="black" points="418,-712 418,-734 485,-734 485,-712 418,-712"/>
<text text-anchor="start" x="421" y="-720.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="243,-690 243,-712 418,-712 418,-690 243,-690"/>
<text text-anchor="start" x="263" y="-698.2" font-family="Helvetica,sans-Serif" font-size="11.00">campaign_type</text>
<polygon fill="none" stroke="black" points="418,-690 418,-712 485,-712 485,-690 418,-690"/>
<text text-anchor="start" x="421" y="-698.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="243,-668 243,-690 418,-690 418,-668 243,-668"/>
<text text-anchor="start" x="263" y="-676.2" font-family="Helvetica,sans-Serif" font-size="11.00">campaign_trigger_type</text>
<polygon fill="none" stroke="black" points="418,-668 418,-690 485,-690 485,-668 418,-668"/>
<text text-anchor="start" x="421" y="-676.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="243,-646 243,-668 418,-668 418,-646 243,-646"/>
<polygon fill="none" stroke="black" points="243,-646 243,-668 418,-668 418,-646 243,-646"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="248" y="-663"/>
<text text-anchor="start" x="263" y="-654.2" font-family="Helvetica,sans-Serif" font-size="11.00">report_id</text>
<polygon fill="none" stroke="black" points="418,-646 418,-668 485,-668 485,-646 418,-646"/>
<text text-anchor="start" x="421" y="-654.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="243,-624 243,-646 418,-646 418,-624 243,-624"/>
<text text-anchor="start" x="263" y="-632.2" font-family="Helvetica,sans-Serif" font-size="11.00">provider_id</text>
<polygon fill="none" stroke="black" points="418,-624 418,-646 485,-646 485,-624 418,-624"/>
<text text-anchor="start" x="421" y="-632.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="243,-602 243,-624 418,-624 418,-602 243,-602"/>
<text text-anchor="start" x="263" y="-610.2" font-family="Helvetica,sans-Serif" font-size="11.00">param_value</text>
<polygon fill="none" stroke="black" points="418,-602 418,-624 485,-624 485,-602 418,-602"/>
<text text-anchor="start" x="421" y="-610.2" font-family="Helvetica,sans-Serif" font-size="11.00">text[65535]</text>
<polygon fill="none" stroke="black" points="243,-580 243,-602 418,-602 418,-580 243,-580"/>
<text text-anchor="start" x="263" y="-588.2" font-family="Helvetica,sans-Serif" font-size="11.00">status_enum</text>
<polygon fill="none" stroke="black" points="418,-580 418,-602 485,-602 485,-580 418,-580"/>
<text text-anchor="start" x="421" y="-588.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="243,-558 243,-580 418,-580 418,-558 243,-558"/>
<text text-anchor="start" x="263" y="-566.2" font-family="Helvetica,sans-Serif" font-size="11.00">message</text>
<polygon fill="none" stroke="black" points="418,-558 418,-580 485,-580 485,-558 418,-558"/>
<text text-anchor="start" x="421" y="-566.2" font-family="Helvetica,sans-Serif" font-size="11.00">text[65535]</text>
<polygon fill="none" stroke="black" points="243,-536 243,-558 418,-558 418,-536 243,-536"/>
<text text-anchor="start" x="263" y="-544.2" font-family="Helvetica,sans-Serif" font-size="11.00">submittedon_date</text>
<polygon fill="none" stroke="black" points="418,-536 418,-558 485,-558 485,-536 418,-536"/>
<text text-anchor="start" x="421" y="-544.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="243,-514 243,-536 418,-536 418,-514 243,-514"/>
<text text-anchor="start" x="263" y="-522.2" font-family="Helvetica,sans-Serif" font-size="11.00">submittedon_userid</text>
<polygon fill="none" stroke="black" points="418,-514 418,-536 485,-536 485,-514 418,-514"/>
<text text-anchor="start" x="421" y="-522.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="243,-492 243,-514 418,-514 418,-492 243,-492"/>
<text text-anchor="start" x="263" y="-500.2" font-family="Helvetica,sans-Serif" font-size="11.00">approvedon_date</text>
<polygon fill="none" stroke="black" points="418,-492 418,-514 485,-514 485,-492 418,-492"/>
<text text-anchor="start" x="421" y="-500.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="243,-470 243,-492 418,-492 418,-470 243,-470"/>
<text text-anchor="start" x="263" y="-478.2" font-family="Helvetica,sans-Serif" font-size="11.00">approvedon_userid</text>
<polygon fill="none" stroke="black" points="418,-470 418,-492 485,-492 485,-470 418,-470"/>
<text text-anchor="start" x="421" y="-478.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="243,-448 243,-470 418,-470 418,-448 243,-448"/>
<text text-anchor="start" x="263" y="-456.2" font-family="Helvetica,sans-Serif" font-size="11.00">closedon_date</text>
<polygon fill="none" stroke="black" points="418,-448 418,-470 485,-470 485,-448 418,-448"/>
<text text-anchor="start" x="421" y="-456.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="243,-426 243,-448 418,-448 418,-426 243,-426"/>
<text text-anchor="start" x="263" y="-434.2" font-family="Helvetica,sans-Serif" font-size="11.00">closedon_userid</text>
<polygon fill="none" stroke="black" points="418,-426 418,-448 485,-448 485,-426 418,-426"/>
<text text-anchor="start" x="421" y="-434.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="243,-404 243,-426 418,-426 418,-404 243,-404"/>
<text text-anchor="start" x="263" y="-412.2" font-family="Helvetica,sans-Serif" font-size="11.00">recurrence</text>
<polygon fill="none" stroke="black" points="418,-404 418,-426 485,-426 485,-404 418,-404"/>
<text text-anchor="start" x="421" y="-412.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="243,-382 243,-404 418,-404 418,-382 243,-382"/>
<text text-anchor="start" x="263" y="-390.2" font-family="Helvetica,sans-Serif" font-size="11.00">next_trigger_date</text>
<polygon fill="none" stroke="black" points="418,-382 418,-404 485,-404 485,-382 418,-382"/>
<text text-anchor="start" x="421" y="-390.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="243,-360 243,-382 418,-382 418,-360 243,-360"/>
<text text-anchor="start" x="263" y="-368.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_trigger_date</text>
<polygon fill="none" stroke="black" points="418,-360 418,-382 485,-382 485,-360 418,-360"/>
<text text-anchor="start" x="421" y="-368.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="243,-338 243,-360 418,-360 418,-338 243,-338"/>
<text text-anchor="start" x="263" y="-346.2" font-family="Helvetica,sans-Serif" font-size="11.00">recurrence_start_date</text>
<polygon fill="none" stroke="black" points="418,-338 418,-360 485,-360 485,-338 418,-338"/>
<text text-anchor="start" x="421" y="-346.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="243,-316 243,-338 418,-338 418,-316 243,-316"/>
<text text-anchor="start" x="263" y="-324.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_visible</text>
<polygon fill="none" stroke="black" points="418,-316 418,-338 485,-338 485,-316 418,-316"/>
<text text-anchor="start" x="421" y="-324.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="243,-294 243,-316 418,-316 418,-294 243,-294"/>
<text text-anchor="start" x="263" y="-302.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_notification</text>
<polygon fill="none" stroke="black" points="418,-294 418,-316 485,-316 485,-294 418,-294"/>
<text text-anchor="start" x="421" y="-302.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="#ffffff" stroke="transparent" points="243,-276 243,-294 322,-294 322,-276 243,-276"/>
<polygon fill="none" stroke="black" points="243,-276 243,-294 322,-294 322,-276 243,-276"/>
<text text-anchor="start" x="246" y="-282.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="322,-276 322,-294 418,-294 418,-276 322,-276"/>
<polygon fill="none" stroke="black" points="322,-276 322,-294 418,-294 418,-276 322,-276"/>
<text text-anchor="start" x="382" y="-282.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="418,-276 418,-294 485,-294 485,-276 418,-276"/>
<polygon fill="none" stroke="black" points="418,-276 418,-294 485,-294 485,-276 418,-276"/>
<text text-anchor="start" x="466" y="-282.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="242,-275 242,-779 486,-779 486,-275 242,-275"/>
</a>
</g>
</g>
<!-- sms_campaign&#45;&gt;stretchy_report -->
<g id="edge5" class="edge">
<title>sms_campaign:w&#45;&gt;stretchy_report:e</title>
<path fill="none" stroke="black" d="M227.88,-653.46C151.95,-610.08 293.52,-183 193,-183"/>
<polygon fill="black" stroke="black" points="234.24,-655.05 241.12,-660.49 238.12,-656.03 242,-657 242,-657 242,-657 238.12,-656.03 242.88,-653.51 234.24,-655.05 234.24,-655.05"/>
<ellipse fill="none" stroke="black" cx="231.14" cy="-654.28" rx="3.2" ry="3.2"/>
</g>
<!-- sms_messages_outbound -->
<g id="node8" class="node">
<title>sms_messages_outbound</title>
<g id="a_node8"><a xlink:href="../../tables/sms_messages_outbound.html" xlink:title="sms_messages_outbound" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="536,-749 536,-917 727,-917 727,-749 536,-749"/>
<polygon fill="#f5f5f5" stroke="transparent" points="536.5,-895 536.5,-917 727.5,-917 727.5,-895 536.5,-895"/>
<polygon fill="none" stroke="black" points="536.5,-895 536.5,-917 727.5,-917 727.5,-895 536.5,-895"/>
<text text-anchor="start" x="541.5" y="-904.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="-903.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="536.5,-873 536.5,-895 727.5,-895 727.5,-873 536.5,-873"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="541.5" y="-890"/>
<text text-anchor="start" x="556.5" y="-881.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="536.5,-851 536.5,-873 727.5,-873 727.5,-851 536.5,-851"/>
<polygon fill="none" stroke="black" points="536.5,-851 536.5,-873 727.5,-873 727.5,-851 536.5,-851"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="541.5" y="-868"/>
<text text-anchor="start" x="556.5" y="-859.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text>
<polygon fill="#ffffff" stroke="transparent" points="536.5,-829 536.5,-851 727.5,-851 727.5,-829 536.5,-829"/>
<polygon fill="none" stroke="black" points="536.5,-829 536.5,-851 727.5,-851 727.5,-829 536.5,-829"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="541.5" y="-846"/>
<text text-anchor="start" x="556.5" y="-837.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="536.5,-807 536.5,-829 727.5,-829 727.5,-807 536.5,-807"/>
<polygon fill="none" stroke="black" points="536.5,-807 536.5,-829 727.5,-829 727.5,-807 536.5,-807"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="541.5" y="-824"/>
<text text-anchor="start" x="556.5" y="-815.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text>
<polygon fill="#ffffff" stroke="transparent" points="536.5,-785 536.5,-807 727.5,-807 727.5,-785 536.5,-785"/>
<polygon fill="none" stroke="black" points="536.5,-785 536.5,-807 727.5,-807 727.5,-785 536.5,-785"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="541.5" y="-802"/>
<text text-anchor="start" x="556.5" y="-793.2" font-family="Helvetica,sans-Serif" font-size="11.00">campaign_id</text>
<polygon fill="none" stroke="black" points="536.5,-767 536.5,-785 727.5,-785 727.5,-767 536.5,-767"/>
<text text-anchor="start" x="539.5" y="-773.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="536.5,-749 536.5,-767 616.5,-767 616.5,-749 536.5,-749"/>
<polygon fill="none" stroke="black" points="536.5,-749 536.5,-767 616.5,-767 616.5,-749 536.5,-749"/>
<text text-anchor="start" x="539.5" y="-755.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 4</text>
<polygon fill="#ffffff" stroke="transparent" points="616.5,-749 616.5,-767 684.5,-767 684.5,-749 616.5,-749"/>
<polygon fill="none" stroke="black" points="616.5,-749 616.5,-767 684.5,-767 684.5,-749 616.5,-749"/>
<text text-anchor="start" x="648.5" y="-755.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="684.5,-749 684.5,-767 727.5,-767 727.5,-749 684.5,-749"/>
<polygon fill="none" stroke="black" points="684.5,-749 684.5,-767 727.5,-767 727.5,-749 684.5,-749"/>
<text text-anchor="start" x="717.5" y="-755.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- sms_messages_outbound&#45;&gt;m_client -->
<g id="edge7" class="edge">
<title>sms_messages_outbound:w&#45;&gt;m_client:e</title>
<path fill="none" stroke="black" d="M520.83,-840.39C477.81,-842.73 462.6,-855 413,-855"/>
<polygon fill="black" stroke="black" points="527.5,-840.21 535.59,-843.6 531.5,-840.11 535.5,-840 535.5,-840 535.5,-840 531.5,-840.11 535.41,-836.4 527.5,-840.21 527.5,-840.21"/>
<ellipse fill="none" stroke="black" cx="524.3" cy="-840.29" rx="3.2" ry="3.2"/>
</g>
<!-- sms_messages_outbound&#45;&gt;m_staff -->
<g id="edge9" class="edge">
<title>sms_messages_outbound:w&#45;&gt;m_staff:e</title>
<path fill="none" stroke="black" d="M520.93,-817.89C398.23,-816.08 359.85,-792.15 233,-818 191.83,-826.39 188.02,-855 146,-855"/>
<polygon fill="black" stroke="black" points="527.5,-817.94 535.47,-821.6 531.5,-817.97 535.5,-818 535.5,-818 535.5,-818 531.5,-817.97 535.53,-814.4 527.5,-817.94 527.5,-817.94"/>
<ellipse fill="none" stroke="black" cx="524.3" cy="-817.92" rx="3.2" ry="3.2"/>
</g>
<!-- sms_messages_outbound&#45;&gt;m_group -->
<g id="edge8" class="edge">
<title>sms_messages_outbound:w&#45;&gt;m_group:e</title>
<path fill="none" stroke="black" d="M521.35,-866.12C511.86,-873.16 509.77,-887.66 495,-897 460.52,-918.8 451.79,-934 411,-934"/>
<polygon fill="black" stroke="black" points="527.82,-864.24 536.51,-865.46 531.66,-863.12 535.5,-862 535.5,-862 535.5,-862 531.66,-863.12 534.49,-858.54 527.82,-864.24 527.82,-864.24"/>
<ellipse fill="none" stroke="black" cx="524.75" cy="-865.13" rx="3.2" ry="3.2"/>
</g>
<!-- sms_messages_outbound&#45;&gt;sms_campaign -->
<g id="edge6" class="edge">
<title>sms_messages_outbound:w&#45;&gt;sms_campaign:e</title>
<path fill="none" stroke="black" d="M521.5,-790.92C507.53,-778.02 511.42,-745 486,-745"/>
<polygon fill="black" stroke="black" points="527.98,-793.27 534.27,-799.38 531.74,-794.64 535.5,-796 535.5,-796 535.5,-796 531.74,-794.64 536.73,-792.62 527.98,-793.27 527.98,-793.27"/>
<ellipse fill="none" stroke="black" cx="524.97" cy="-792.18" rx="3.2" ry="3.2"/>
</g>
<!-- stretchy_report_parameter -->
<g id="node9" class="node">
<title>stretchy_report_parameter</title>
<g id="a_node9"><a xlink:href="../../tables/stretchy_report_parameter.html" xlink:title="stretchy_report_parameter" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="271.5,-37 271.5,-95 456.5,-95 456.5,-37 271.5,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="272,-73 272,-95 457,-95 457,-73 272,-73"/>
<polygon fill="none" stroke="black" points="272,-73 272,-95 457,-95 457,-73 272,-73"/>
<text text-anchor="start" x="277" y="-82.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">stretchy_report_parameter</text>
<text text-anchor="start" x="422" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="272,-55 272,-73 457,-73 457,-55 272,-55"/>
<text text-anchor="start" x="275" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="272,-37 272,-55 349,-55 349,-37 272,-37"/>
<polygon fill="none" stroke="black" points="272,-37 272,-55 349,-55 349,-37 272,-37"/>
<text text-anchor="start" x="275" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="349,-37 349,-55 416,-55 416,-37 349,-37"/>
<polygon fill="none" stroke="black" points="349,-37 349,-55 416,-55 416,-37 349,-37"/>
<text text-anchor="start" x="380" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="416,-37 416,-55 457,-55 457,-37 416,-37"/>
<polygon fill="none" stroke="black" points="416,-37 416,-55 457,-55 457,-37 416,-37"/>
<text text-anchor="start" x="447" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- stretchy_report_parameter&#45;&gt;stretchy_report -->
<g id="edge10" class="edge">
<title>stretchy_report_parameter:w&#45;&gt;stretchy_report:e</title>
<path fill="none" stroke="black" d="M256.81,-67.44C245.64,-74.29 243.89,-90.33 233,-106 210.99,-137.67 231.56,-183 193,-183"/>
<polygon fill="black" stroke="black" points="263.23,-65.88 271.85,-67.5 267.11,-64.94 271,-64 271,-64 271,-64 267.11,-64.94 270.15,-60.5 263.23,-65.88 263.23,-65.88"/>
<ellipse fill="none" stroke="black" cx="260.12" cy="-66.64" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>