| <?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="841pt" height="886pt" |
| viewBox="0.00 0.00 841.00 886.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 882)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-882 837,-882 837,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="315,-187 315,-619 508,-619 508,-187 315,-187"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="315.5,-597 315.5,-619 508.5,-619 508.5,-597 315.5,-597"/> |
| <polygon fill="none" stroke="black" points="315.5,-597 315.5,-619 508.5,-619 508.5,-597 315.5,-597"/> |
| <text text-anchor="start" x="320.5" y="-606.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text> |
| <text text-anchor="start" x="473.5" y="-605.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="315.5,-575 315.5,-597 508.5,-597 508.5,-575 315.5,-575"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-592"/> |
| <text text-anchor="start" x="335.5" y="-583.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-553 315.5,-575 508.5,-575 508.5,-553 315.5,-553"/> |
| <polygon fill="none" stroke="black" points="315.5,-553 315.5,-575 508.5,-575 508.5,-553 315.5,-553"/> |
| <text text-anchor="start" x="335.5" y="-561.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-531 315.5,-553 508.5,-553 508.5,-531 315.5,-531"/> |
| <polygon fill="none" stroke="black" points="315.5,-531 315.5,-553 508.5,-553 508.5,-531 315.5,-531"/> |
| <text text-anchor="start" x="335.5" y="-539.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-509 315.5,-531 508.5,-531 508.5,-509 315.5,-509"/> |
| <polygon fill="none" stroke="black" points="315.5,-509 315.5,-531 508.5,-531 508.5,-509 315.5,-509"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-526"/> |
| <text text-anchor="start" x="335.5" y="-517.2" font-family="Helvetica,sans-Serif" font-size="11.00">sub_status</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-487 315.5,-509 508.5,-509 508.5,-487 315.5,-487"/> |
| <polygon fill="none" stroke="black" points="315.5,-487 315.5,-509 508.5,-509 508.5,-487 315.5,-487"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-504"/> |
| <text text-anchor="start" x="335.5" y="-495.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-465 315.5,-487 508.5,-487 508.5,-465 315.5,-465"/> |
| <polygon fill="none" stroke="black" points="315.5,-465 315.5,-487 508.5,-487 508.5,-465 315.5,-465"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-482"/> |
| <text text-anchor="start" x="335.5" y="-473.2" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_to_office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-443 315.5,-465 508.5,-465 508.5,-443 315.5,-443"/> |
| <polygon fill="none" stroke="black" points="315.5,-443 315.5,-465 508.5,-465 508.5,-443 315.5,-443"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-460"/> |
| <text text-anchor="start" x="335.5" y="-451.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-421 315.5,-443 508.5,-443 508.5,-421 315.5,-421"/> |
| <polygon fill="none" stroke="black" points="315.5,-421 315.5,-443 508.5,-443 508.5,-421 315.5,-421"/> |
| <text text-anchor="start" x="335.5" y="-429.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-399 315.5,-421 508.5,-421 508.5,-399 315.5,-399"/> |
| <polygon fill="none" stroke="black" points="315.5,-399 315.5,-421 508.5,-421 508.5,-399 315.5,-399"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-416"/> |
| <text text-anchor="start" x="335.5" y="-407.2" font-family="Helvetica,sans-Serif" font-size="11.00">gender_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-377 315.5,-399 508.5,-399 508.5,-377 315.5,-377"/> |
| <polygon fill="none" stroke="black" points="315.5,-377 315.5,-399 508.5,-399 508.5,-377 315.5,-377"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-394"/> |
| <text text-anchor="start" x="335.5" y="-385.2" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-355 315.5,-377 508.5,-377 508.5,-355 315.5,-355"/> |
| <polygon fill="none" stroke="black" points="315.5,-355 315.5,-377 508.5,-377 508.5,-355 315.5,-355"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-372"/> |
| <text text-anchor="start" x="335.5" y="-363.2" font-family="Helvetica,sans-Serif" font-size="11.00">closure_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-333 315.5,-355 508.5,-355 508.5,-333 315.5,-333"/> |
| <polygon fill="none" stroke="black" points="315.5,-333 315.5,-355 508.5,-355 508.5,-333 315.5,-333"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-350"/> |
| <text text-anchor="start" x="335.5" y="-341.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_product</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-311 315.5,-333 508.5,-333 508.5,-311 315.5,-311"/> |
| <polygon fill="none" stroke="black" points="315.5,-311 315.5,-333 508.5,-333 508.5,-311 315.5,-311"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-328"/> |
| <text text-anchor="start" x="335.5" y="-319.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_account</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-289 315.5,-311 508.5,-311 508.5,-289 315.5,-289"/> |
| <polygon fill="none" stroke="black" points="315.5,-289 315.5,-311 508.5,-311 508.5,-289 315.5,-289"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-306"/> |
| <text text-anchor="start" x="335.5" y="-297.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_type_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-267 315.5,-289 508.5,-289 508.5,-267 315.5,-267"/> |
| <polygon fill="none" stroke="black" points="315.5,-267 315.5,-289 508.5,-289 508.5,-267 315.5,-267"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-284"/> |
| <text text-anchor="start" x="335.5" y="-275.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_classification_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-245 315.5,-267 508.5,-267 508.5,-245 315.5,-245"/> |
| <polygon fill="none" stroke="black" points="315.5,-245 315.5,-267 508.5,-267 508.5,-245 315.5,-245"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-262"/> |
| <text text-anchor="start" x="335.5" y="-253.2" font-family="Helvetica,sans-Serif" font-size="11.00">reject_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-223 315.5,-245 508.5,-245 508.5,-223 315.5,-223"/> |
| <polygon fill="none" stroke="black" points="315.5,-223 315.5,-245 508.5,-245 508.5,-223 315.5,-223"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="320.5" y="-240"/> |
| <text text-anchor="start" x="335.5" y="-231.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdraw_reason_cv_id</text> |
| <polygon fill="none" stroke="black" points="315.5,-205 315.5,-223 508.5,-223 508.5,-205 315.5,-205"/> |
| <text text-anchor="start" x="318.5" y="-211.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="315.5,-187 315.5,-205 392.5,-205 392.5,-187 315.5,-187"/> |
| <polygon fill="none" stroke="black" points="315.5,-187 315.5,-205 392.5,-205 392.5,-187 315.5,-187"/> |
| <text text-anchor="start" x="318.5" y="-193.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 13</text> |
| <polygon fill="#ffffff" stroke="transparent" points="392.5,-187 392.5,-205 455.5,-205 455.5,-187 392.5,-187"/> |
| <polygon fill="none" stroke="black" points="392.5,-187 392.5,-205 455.5,-205 455.5,-187 392.5,-187"/> |
| <text text-anchor="start" x="419.5" y="-193.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="455.5,-187 455.5,-205 508.5,-205 508.5,-187 455.5,-187"/> |
| <polygon fill="none" stroke="black" points="455.5,-187 455.5,-205 508.5,-205 508.5,-187 455.5,-187"/> |
| <text text-anchor="start" x="483.5" y="-193.2" font-family="Helvetica,sans-Serif" font-size="11.00">23 ></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="8,-297 8,-487 266,-487 266,-297 8,-297"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-465 8,-487 266,-487 266,-465 8,-465"/> |
| <polygon fill="none" stroke="black" points="8,-465 8,-487 266,-487 266,-465 8,-465"/> |
| <text text-anchor="start" x="13" y="-474.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_staff</text> |
| <text text-anchor="start" x="231" y="-473.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-443 8,-465 266,-465 266,-443 8,-443"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-460"/> |
| <text text-anchor="start" x="28" y="-451.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-421 8,-443 266,-443 266,-421 8,-421"/> |
| <polygon fill="none" stroke="black" points="8,-421 8,-443 266,-443 266,-421 8,-421"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-438"/> |
| <text text-anchor="start" x="28" y="-429.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-399 8,-421 266,-421 266,-399 8,-399"/> |
| <polygon fill="none" stroke="black" points="8,-399 8,-421 266,-421 266,-399 8,-399"/> |
| <text text-anchor="start" x="28" y="-407.2" font-family="Helvetica,sans-Serif" font-size="11.00">display_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-377 8,-399 266,-399 266,-377 8,-377"/> |
| <polygon fill="none" stroke="black" points="8,-377 8,-399 266,-399 266,-377 8,-377"/> |
| <text text-anchor="start" x="28" y="-385.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-355 8,-377 266,-377 266,-355 8,-355"/> |
| <polygon fill="none" stroke="black" points="8,-355 8,-377 266,-377 266,-355 8,-355"/> |
| <text text-anchor="start" x="28" y="-363.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-333 8,-355 266,-355 266,-333 8,-333"/> |
| <polygon fill="none" stroke="black" points="8,-333 8,-355 266,-355 266,-333 8,-333"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-350"/> |
| <text text-anchor="start" x="28" y="-341.2" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text> |
| <polygon fill="none" stroke="black" points="8,-315 8,-333 266,-333 266,-315 8,-315"/> |
| <text text-anchor="start" x="11" y="-321.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-297 8,-315 114,-315 114,-297 8,-297"/> |
| <polygon fill="none" stroke="black" points="8,-297 8,-315 114,-315 114,-297 8,-297"/> |
| <text text-anchor="start" x="11" y="-303.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="114,-297 114,-315 195,-315 195,-297 114,-297"/> |
| <polygon fill="none" stroke="black" points="114,-297 114,-315 195,-315 195,-297 114,-297"/> |
| <text text-anchor="start" x="159" y="-303.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="195,-297 195,-315 266,-315 266,-297 195,-297"/> |
| <polygon fill="none" stroke="black" points="195,-297 195,-315 266,-315 266,-297 195,-297"/> |
| <text text-anchor="start" x="241" y="-303.2" font-family="Helvetica,sans-Serif" font-size="11.00">10 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client->m_staff --> |
| <g id="edge1" class="edge"> |
| <title>m_client:w->m_staff:e</title> |
| <path fill="none" stroke="black" d="M300.09,-454C289.32,-454 282.34,-454 267,-454"/> |
| <polygon fill="black" stroke="black" points="306.5,-454 314.5,-457.6 310.5,-454 314.5,-454 314.5,-454 314.5,-454 310.5,-454 314.5,-450.4 306.5,-454 306.5,-454"/> |
| <ellipse fill="none" stroke="black" cx="303.3" cy="-454" 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="331,-640 331,-874 492,-874 492,-640 331,-640"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="331.5,-852 331.5,-874 492.5,-874 492.5,-852 331.5,-852"/> |
| <polygon fill="none" stroke="black" points="331.5,-852 331.5,-874 492.5,-874 492.5,-852 331.5,-852"/> |
| <text text-anchor="start" x="336.5" y="-861.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_group</text> |
| <text text-anchor="start" x="457.5" y="-860.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="331.5,-830 331.5,-852 492.5,-852 492.5,-830 331.5,-830"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="336.5" y="-847"/> |
| <text text-anchor="start" x="351.5" y="-838.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331.5,-808 331.5,-830 492.5,-830 492.5,-808 331.5,-808"/> |
| <polygon fill="none" stroke="black" points="331.5,-808 331.5,-830 492.5,-830 492.5,-808 331.5,-808"/> |
| <text text-anchor="start" x="351.5" y="-816.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331.5,-786 331.5,-808 492.5,-808 492.5,-786 331.5,-786"/> |
| <polygon fill="none" stroke="black" points="331.5,-786 331.5,-808 492.5,-808 492.5,-786 331.5,-786"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="336.5" y="-803"/> |
| <text text-anchor="start" x="351.5" y="-794.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331.5,-764 331.5,-786 492.5,-786 492.5,-764 331.5,-764"/> |
| <polygon fill="none" stroke="black" points="331.5,-764 331.5,-786 492.5,-786 492.5,-764 331.5,-764"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="336.5" y="-781"/> |
| <text text-anchor="start" x="351.5" y="-772.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331.5,-742 331.5,-764 492.5,-764 492.5,-742 331.5,-742"/> |
| <polygon fill="none" stroke="black" points="331.5,-742 331.5,-764 492.5,-764 492.5,-742 331.5,-742"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="336.5" y="-759"/> |
| <text text-anchor="start" x="351.5" y="-750.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331.5,-720 331.5,-742 492.5,-742 492.5,-720 331.5,-720"/> |
| <polygon fill="none" stroke="black" points="331.5,-720 331.5,-742 492.5,-742 492.5,-720 331.5,-720"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="336.5" y="-737"/> |
| <text text-anchor="start" x="351.5" y="-728.2" font-family="Helvetica,sans-Serif" font-size="11.00">level_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331.5,-698 331.5,-720 492.5,-720 492.5,-698 331.5,-698"/> |
| <polygon fill="none" stroke="black" points="331.5,-698 331.5,-720 492.5,-720 492.5,-698 331.5,-698"/> |
| <text text-anchor="start" x="351.5" y="-706.2" font-family="Helvetica,sans-Serif" font-size="11.00">display_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331.5,-676 331.5,-698 492.5,-698 492.5,-676 331.5,-676"/> |
| <polygon fill="none" stroke="black" points="331.5,-676 331.5,-698 492.5,-698 492.5,-676 331.5,-676"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="336.5" y="-693"/> |
| <text text-anchor="start" x="351.5" y="-684.2" font-family="Helvetica,sans-Serif" font-size="11.00">closure_reason_cv_id</text> |
| <polygon fill="none" stroke="black" points="331.5,-658 331.5,-676 492.5,-676 492.5,-658 331.5,-658"/> |
| <text text-anchor="start" x="334.5" y="-664.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="331.5,-640 331.5,-658 389.5,-658 389.5,-640 331.5,-640"/> |
| <polygon fill="none" stroke="black" points="331.5,-640 331.5,-658 389.5,-658 389.5,-640 331.5,-640"/> |
| <text text-anchor="start" x="334.5" y="-646.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 5</text> |
| <polygon fill="#ffffff" stroke="transparent" points="389.5,-640 389.5,-658 446.5,-658 446.5,-640 389.5,-640"/> |
| <polygon fill="none" stroke="black" points="389.5,-640 389.5,-658 446.5,-658 446.5,-640 389.5,-640"/> |
| <text text-anchor="start" x="410.5" y="-646.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="446.5,-640 446.5,-658 492.5,-658 492.5,-640 446.5,-640"/> |
| <polygon fill="none" stroke="black" points="446.5,-640 446.5,-658 492.5,-658 492.5,-640 446.5,-640"/> |
| <text text-anchor="start" x="467.5" y="-646.2" font-family="Helvetica,sans-Serif" font-size="11.00">11 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_group->m_staff --> |
| <g id="edge2" class="edge"> |
| <title>m_group:w->m_staff:e</title> |
| <path fill="none" stroke="black" d="M316.74,-769.96C269.09,-729.12 334.32,-454 267,-454"/> |
| <polygon fill="black" stroke="black" points="322.99,-772.25 329.26,-778.38 326.74,-773.62 330.5,-775 330.5,-775 330.5,-775 326.74,-773.62 331.74,-771.62 322.99,-772.25 322.99,-772.25"/> |
| <ellipse fill="none" stroke="black" cx="319.98" cy="-771.15" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- sms_messages_outbound --> |
| <g id="node4" class="node"> |
| <title>sms_messages_outbound</title> |
| <g id="a_node4"><a xlink:href="../../tables/sms_messages_outbound.html" xlink:title="sms_messages_outbound" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="557,-172 557,-480 825,-480 825,-172 557,-172"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="559,-456 559,-478 823,-478 823,-456 559,-456"/> |
| <polygon fill="none" stroke="black" points="559,-456 559,-478 823,-478 823,-456 559,-456"/> |
| <text text-anchor="start" x="564" y="-465.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">sms_messages_outbound</text> |
| <text text-anchor="start" x="788" y="-464.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="559,-434 559,-456 750,-456 750,-434 559,-434"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="564" y="-451"/> |
| <text text-anchor="start" x="579" y="-442.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="750,-434 750,-456 823,-456 823,-434 750,-434"/> |
| <text text-anchor="start" x="753" y="-442.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="559,-412 559,-434 750,-434 750,-412 559,-412"/> |
| <polygon fill="none" stroke="black" points="559,-412 559,-434 750,-434 750,-412 559,-412"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="564" y="-429"/> |
| <text text-anchor="start" x="579" y="-420.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text> |
| <polygon fill="none" stroke="black" points="750,-412 750,-434 823,-434 823,-412 750,-412"/> |
| <text text-anchor="start" x="753" y="-420.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="559,-390 559,-412 750,-412 750,-390 559,-390"/> |
| <polygon fill="none" stroke="black" points="559,-390 559,-412 750,-412 750,-390 559,-390"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="564" y="-407"/> |
| <text text-anchor="start" x="579" y="-398.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="none" stroke="black" points="750,-390 750,-412 823,-412 823,-390 750,-390"/> |
| <text text-anchor="start" x="753" y="-398.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="559,-368 559,-390 750,-390 750,-368 559,-368"/> |
| <polygon fill="none" stroke="black" points="559,-368 559,-390 750,-390 750,-368 559,-368"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="564" y="-385"/> |
| <text text-anchor="start" x="579" y="-376.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="none" stroke="black" points="750,-368 750,-390 823,-390 823,-368 750,-368"/> |
| <text text-anchor="start" x="753" y="-376.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="559,-346 559,-368 750,-368 750,-346 559,-346"/> |
| <text text-anchor="start" x="579" y="-354.2" font-family="Helvetica,sans-Serif" font-size="11.00">status_enum</text> |
| <polygon fill="none" stroke="black" points="750,-346 750,-368 823,-368 823,-346 750,-346"/> |
| <text text-anchor="start" x="753" y="-354.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="none" stroke="black" points="559,-324 559,-346 750,-346 750,-324 559,-324"/> |
| <text text-anchor="start" x="579" y="-332.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text> |
| <polygon fill="none" stroke="black" points="750,-324 750,-346 823,-346 823,-324 750,-324"/> |
| <text text-anchor="start" x="753" y="-332.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text> |
| <polygon fill="none" stroke="black" points="559,-302 559,-324 750,-324 750,-302 559,-302"/> |
| <text text-anchor="start" x="579" y="-310.2" font-family="Helvetica,sans-Serif" font-size="11.00">message</text> |
| <polygon fill="none" stroke="black" points="750,-302 750,-324 823,-324 823,-302 750,-302"/> |
| <text text-anchor="start" x="753" y="-310.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[1000]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="559,-280 559,-302 750,-302 750,-280 559,-280"/> |
| <polygon fill="none" stroke="black" points="559,-280 559,-302 750,-302 750,-280 559,-280"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="564" y="-297"/> |
| <text text-anchor="start" x="579" y="-288.2" font-family="Helvetica,sans-Serif" font-size="11.00">campaign_id</text> |
| <polygon fill="none" stroke="black" points="750,-280 750,-302 823,-302 823,-280 750,-280"/> |
| <text text-anchor="start" x="753" y="-288.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="559,-258 559,-280 750,-280 750,-258 559,-258"/> |
| <text text-anchor="start" x="579" y="-266.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="none" stroke="black" points="750,-258 750,-280 823,-280 823,-258 750,-258"/> |
| <text text-anchor="start" x="753" y="-266.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="559,-236 559,-258 750,-258 750,-236 559,-236"/> |
| <text text-anchor="start" x="579" y="-244.2" font-family="Helvetica,sans-Serif" font-size="11.00">submittedon_date</text> |
| <polygon fill="none" stroke="black" points="750,-236 750,-258 823,-258 823,-236 750,-236"/> |
| <text text-anchor="start" x="753" y="-244.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="559,-214 559,-236 750,-236 750,-214 559,-214"/> |
| <text text-anchor="start" x="579" y="-222.2" font-family="Helvetica,sans-Serif" font-size="11.00">delivered_on_date</text> |
| <polygon fill="none" stroke="black" points="750,-214 750,-236 823,-236 823,-214 750,-214"/> |
| <text text-anchor="start" x="753" y="-222.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="none" stroke="black" points="559,-192 559,-214 750,-214 750,-192 559,-192"/> |
| <text text-anchor="start" x="579" y="-200.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_notification</text> |
| <polygon fill="none" stroke="black" points="750,-192 750,-214 823,-214 823,-192 750,-192"/> |
| <text text-anchor="start" x="753" y="-200.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="559,-174 559,-192 646,-192 646,-174 559,-174"/> |
| <polygon fill="none" stroke="black" points="559,-174 559,-192 646,-192 646,-174 559,-174"/> |
| <text text-anchor="start" x="562" y="-180.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 4</text> |
| <polygon fill="#ffffff" stroke="transparent" points="646,-174 646,-192 750,-192 750,-174 646,-174"/> |
| <polygon fill="none" stroke="black" points="646,-174 646,-192 750,-192 750,-174 646,-174"/> |
| <text text-anchor="start" x="714" y="-180.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="750,-174 750,-192 823,-192 823,-174 750,-174"/> |
| <polygon fill="none" stroke="black" points="750,-174 750,-192 823,-192 823,-174 750,-174"/> |
| <text text-anchor="start" x="804" y="-180.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="558,-173 558,-479 824,-479 824,-173 558,-173"/> |
| </a> |
| </g> |
| </g> |
| <!-- sms_messages_outbound->m_client --> |
| <g id="edge4" class="edge"> |
| <title>sms_messages_outbound:w->m_client:e</title> |
| <path fill="none" stroke="black" d="M543.68,-403.34C488.23,-424.75 588.86,-586 509.5,-586"/> |
| <polygon fill="black" stroke="black" points="550.1,-402.29 558.58,-404.55 554.05,-401.64 558,-401 558,-401 558,-401 554.05,-401.64 557.42,-397.45 550.1,-402.29 550.1,-402.29"/> |
| <ellipse fill="none" stroke="black" cx="546.95" cy="-402.81" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- sms_messages_outbound->m_staff --> |
| <g id="edge6" class="edge"> |
| <title>sms_messages_outbound:w->m_staff:e</title> |
| <path fill="none" stroke="black" d="M543.59,-377.47C480.23,-361.86 582.83,-231.36 516,-177 479.97,-147.69 342.11,-146.6 307,-177 259.98,-217.71 329.19,-454 267,-454"/> |
| <polygon fill="black" stroke="black" points="550.04,-378.15 557.62,-382.58 554.02,-378.58 558,-379 558,-379 558,-379 554.02,-378.58 558.38,-375.42 550.04,-378.15 550.04,-378.15"/> |
| <ellipse fill="none" stroke="black" cx="546.86" cy="-377.81" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- sms_messages_outbound->m_group --> |
| <g id="edge5" class="edge"> |
| <title>sms_messages_outbound:w->m_group:e</title> |
| <path fill="none" stroke="black" d="M544.04,-426.87C477.3,-469.01 582.16,-841 493.5,-841"/> |
| <polygon fill="black" stroke="black" points="550.29,-425.14 558.96,-426.47 554.15,-424.07 558,-423 558,-423 558,-423 554.15,-424.07 557.04,-419.53 550.29,-425.14 550.29,-425.14"/> |
| <ellipse fill="none" stroke="black" cx="547.21" cy="-425.99" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- sms_campaign --> |
| <g id="node5" class="node"> |
| <title>sms_campaign</title> |
| <g id="a_node5"><a xlink:href="../../tables/sms_campaign.html" xlink:title="sms_campaign" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="324,-37 324,-139 499,-139 499,-37 324,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="324.5,-117 324.5,-139 499.5,-139 499.5,-117 324.5,-117"/> |
| <polygon fill="none" stroke="black" points="324.5,-117 324.5,-139 499.5,-139 499.5,-117 324.5,-117"/> |
| <text text-anchor="start" x="329.5" y="-126.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">sms_campaign</text> |
| <text text-anchor="start" x="464.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="324.5,-95 324.5,-117 499.5,-117 499.5,-95 324.5,-95"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="329.5" y="-112"/> |
| <text text-anchor="start" x="344.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="324.5,-73 324.5,-95 499.5,-95 499.5,-73 324.5,-73"/> |
| <polygon fill="none" stroke="black" points="324.5,-73 324.5,-95 499.5,-95 499.5,-73 324.5,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="329.5" y="-90"/> |
| <text text-anchor="start" x="344.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">report_id</text> |
| <polygon fill="none" stroke="black" points="324.5,-55 324.5,-73 499.5,-73 499.5,-55 324.5,-55"/> |
| <text text-anchor="start" x="327.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="324.5,-37 324.5,-55 392.5,-55 392.5,-37 324.5,-37"/> |
| <polygon fill="none" stroke="black" points="324.5,-37 324.5,-55 392.5,-55 392.5,-37 324.5,-37"/> |
| <text text-anchor="start" x="327.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="392.5,-37 392.5,-55 454.5,-55 454.5,-37 392.5,-37"/> |
| <polygon fill="none" stroke="black" points="392.5,-37 392.5,-55 454.5,-55 454.5,-37 392.5,-37"/> |
| <text text-anchor="start" x="418.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="454.5,-37 454.5,-55 499.5,-55 499.5,-37 454.5,-37"/> |
| <polygon fill="none" stroke="black" points="454.5,-37 454.5,-55 499.5,-55 499.5,-37 454.5,-37"/> |
| <text text-anchor="start" x="480.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- sms_messages_outbound->sms_campaign --> |
| <g id="edge3" class="edge"> |
| <title>sms_messages_outbound:w->sms_campaign:e</title> |
| <path fill="none" stroke="black" d="M543.75,-288.79C485.85,-267.92 581.05,-106 500.5,-106"/> |
| <polygon fill="black" stroke="black" points="550.09,-289.78 557.45,-294.56 554.05,-290.39 558,-291 558,-291 558,-291 554.05,-290.39 558.55,-287.44 550.09,-289.78 550.09,-289.78"/> |
| <ellipse fill="none" stroke="black" cx="546.93" cy="-289.29" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
