| <?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="622pt" height="787pt" |
| viewBox="0.00 0.00 622.00 787.15" 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 783.15)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-783.15 618,-783.15 618,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="192,-343.15 192,-775.15 385,-775.15 385,-343.15 192,-343.15"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="192.5,-753.15 192.5,-775.15 385.5,-775.15 385.5,-753.15 192.5,-753.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-753.15 192.5,-775.15 385.5,-775.15 385.5,-753.15 192.5,-753.15"/> |
| <text text-anchor="start" x="197.5" y="-762.35" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client</text> |
| <text text-anchor="start" x="350.5" y="-761.35" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="192.5,-731.15 192.5,-753.15 385.5,-753.15 385.5,-731.15 192.5,-731.15"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-748.149"/> |
| <text text-anchor="start" x="212.5" y="-739.35" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-709.15 192.5,-731.15 385.5,-731.15 385.5,-709.15 192.5,-709.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-709.15 192.5,-731.15 385.5,-731.15 385.5,-709.15 192.5,-709.15"/> |
| <text text-anchor="start" x="212.5" y="-717.35" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-687.15 192.5,-709.15 385.5,-709.15 385.5,-687.15 192.5,-687.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-687.15 192.5,-709.15 385.5,-709.15 385.5,-687.15 192.5,-687.15"/> |
| <text text-anchor="start" x="212.5" y="-695.35" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-665.15 192.5,-687.15 385.5,-687.15 385.5,-665.15 192.5,-665.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-665.15 192.5,-687.15 385.5,-687.15 385.5,-665.15 192.5,-665.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-682.149"/> |
| <text text-anchor="start" x="212.5" y="-673.35" font-family="Helvetica,sans-Serif" font-size="11.00">sub_status</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-643.15 192.5,-665.15 385.5,-665.15 385.5,-643.15 192.5,-643.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-643.15 192.5,-665.15 385.5,-665.15 385.5,-643.15 192.5,-643.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-660.149"/> |
| <text text-anchor="start" x="212.5" y="-651.35" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-621.15 192.5,-643.15 385.5,-643.15 385.5,-621.15 192.5,-621.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-621.15 192.5,-643.15 385.5,-643.15 385.5,-621.15 192.5,-621.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-638.149"/> |
| <text text-anchor="start" x="212.5" y="-629.35" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_to_office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-599.15 192.5,-621.15 385.5,-621.15 385.5,-599.15 192.5,-599.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-599.15 192.5,-621.15 385.5,-621.15 385.5,-599.15 192.5,-599.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-616.149"/> |
| <text text-anchor="start" x="212.5" y="-607.35" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-577.15 192.5,-599.15 385.5,-599.15 385.5,-577.15 192.5,-577.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-577.15 192.5,-599.15 385.5,-599.15 385.5,-577.15 192.5,-577.15"/> |
| <text text-anchor="start" x="212.5" y="-585.35" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-555.15 192.5,-577.15 385.5,-577.15 385.5,-555.15 192.5,-555.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-555.15 192.5,-577.15 385.5,-577.15 385.5,-555.15 192.5,-555.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-572.149"/> |
| <text text-anchor="start" x="212.5" y="-563.35" font-family="Helvetica,sans-Serif" font-size="11.00">gender_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-533.15 192.5,-555.15 385.5,-555.15 385.5,-533.15 192.5,-533.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-533.15 192.5,-555.15 385.5,-555.15 385.5,-533.15 192.5,-533.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-550.149"/> |
| <text text-anchor="start" x="212.5" y="-541.35" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-511.15 192.5,-533.15 385.5,-533.15 385.5,-511.15 192.5,-511.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-511.15 192.5,-533.15 385.5,-533.15 385.5,-511.15 192.5,-511.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-528.149"/> |
| <text text-anchor="start" x="212.5" y="-519.35" font-family="Helvetica,sans-Serif" font-size="11.00">closure_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-489.15 192.5,-511.15 385.5,-511.15 385.5,-489.15 192.5,-489.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-489.15 192.5,-511.15 385.5,-511.15 385.5,-489.15 192.5,-489.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-506.149"/> |
| <text text-anchor="start" x="212.5" y="-497.35" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_product</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-467.15 192.5,-489.15 385.5,-489.15 385.5,-467.15 192.5,-467.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-467.15 192.5,-489.15 385.5,-489.15 385.5,-467.15 192.5,-467.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-484.149"/> |
| <text text-anchor="start" x="212.5" y="-475.35" font-family="Helvetica,sans-Serif" font-size="11.00">default_savings_account</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-445.15 192.5,-467.15 385.5,-467.15 385.5,-445.15 192.5,-445.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-445.15 192.5,-467.15 385.5,-467.15 385.5,-445.15 192.5,-445.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-462.149"/> |
| <text text-anchor="start" x="212.5" y="-453.35" font-family="Helvetica,sans-Serif" font-size="11.00">client_type_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-423.15 192.5,-445.15 385.5,-445.15 385.5,-423.15 192.5,-423.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-423.15 192.5,-445.15 385.5,-445.15 385.5,-423.15 192.5,-423.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-440.149"/> |
| <text text-anchor="start" x="212.5" y="-431.35" font-family="Helvetica,sans-Serif" font-size="11.00">client_classification_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-401.15 192.5,-423.15 385.5,-423.15 385.5,-401.15 192.5,-401.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-401.15 192.5,-423.15 385.5,-423.15 385.5,-401.15 192.5,-401.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-418.149"/> |
| <text text-anchor="start" x="212.5" y="-409.35" font-family="Helvetica,sans-Serif" font-size="11.00">reject_reason_cv_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-379.15 192.5,-401.15 385.5,-401.15 385.5,-379.15 192.5,-379.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-379.15 192.5,-401.15 385.5,-401.15 385.5,-379.15 192.5,-379.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197.5" y="-396.149"/> |
| <text text-anchor="start" x="212.5" y="-387.35" font-family="Helvetica,sans-Serif" font-size="11.00">withdraw_reason_cv_id</text> |
| <polygon fill="none" stroke="black" points="192.5,-361.15 192.5,-379.15 385.5,-379.15 385.5,-361.15 192.5,-361.15"/> |
| <text text-anchor="start" x="195.5" y="-367.35" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="192.5,-343.15 192.5,-361.15 269.5,-361.15 269.5,-343.15 192.5,-343.15"/> |
| <polygon fill="none" stroke="black" points="192.5,-343.15 192.5,-361.15 269.5,-361.15 269.5,-343.15 192.5,-343.15"/> |
| <text text-anchor="start" x="195.5" y="-349.35" font-family="Helvetica,sans-Serif" font-size="11.00">< 13</text> |
| <polygon fill="#ffffff" stroke="transparent" points="269.5,-343.15 269.5,-361.15 332.5,-361.15 332.5,-343.15 269.5,-343.15"/> |
| <polygon fill="none" stroke="black" points="269.5,-343.15 269.5,-361.15 332.5,-361.15 332.5,-343.15 269.5,-343.15"/> |
| <text text-anchor="start" x="296.5" y="-349.35" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="332.5,-343.15 332.5,-361.15 385.5,-361.15 385.5,-343.15 332.5,-343.15"/> |
| <polygon fill="none" stroke="black" points="332.5,-343.15 332.5,-361.15 385.5,-361.15 385.5,-343.15 332.5,-343.15"/> |
| <text text-anchor="start" x="360.5" y="-349.35" font-family="Helvetica,sans-Serif" font-size="11.00">23 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_code_value --> |
| <g id="node2" class="node"> |
| <title>m_code_value</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_code_value.html" xlink:title="m_code_value" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-343.15 8,-467.15 143,-467.15 143,-343.15 8,-343.15"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-445.15 8.5,-467.15 143.5,-467.15 143.5,-445.15 8.5,-445.15"/> |
| <polygon fill="none" stroke="black" points="8.5,-445.15 8.5,-467.15 143.5,-467.15 143.5,-445.15 8.5,-445.15"/> |
| <text text-anchor="start" x="13.5" y="-454.35" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_code_value</text> |
| <text text-anchor="start" x="108.5" y="-453.35" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-423.15 8.5,-445.15 143.5,-445.15 143.5,-423.15 8.5,-423.15"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-440.149"/> |
| <text text-anchor="start" x="28.5" y="-431.35" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-401.15 8.5,-423.15 143.5,-423.15 143.5,-401.15 8.5,-401.15"/> |
| <polygon fill="none" stroke="black" points="8.5,-401.15 8.5,-423.15 143.5,-423.15 143.5,-401.15 8.5,-401.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-418.149"/> |
| <text text-anchor="start" x="28.5" y="-409.35" font-family="Helvetica,sans-Serif" font-size="11.00">code_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-379.15 8.5,-401.15 143.5,-401.15 143.5,-379.15 8.5,-379.15"/> |
| <polygon fill="none" stroke="black" points="8.5,-379.15 8.5,-401.15 143.5,-401.15 143.5,-379.15 8.5,-379.15"/> |
| <text text-anchor="start" x="28.5" y="-387.35" font-family="Helvetica,sans-Serif" font-size="11.00">code_value</text> |
| <polygon fill="none" stroke="black" points="8.5,-361.15 8.5,-379.15 143.5,-379.15 143.5,-361.15 8.5,-361.15"/> |
| <text text-anchor="start" x="11.5" y="-367.35" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-343.15 8.5,-361.15 53.5,-361.15 53.5,-343.15 8.5,-343.15"/> |
| <polygon fill="none" stroke="black" points="8.5,-343.15 8.5,-361.15 53.5,-361.15 53.5,-343.15 8.5,-343.15"/> |
| <text text-anchor="start" x="11.5" y="-349.35" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="53.5,-343.15 53.5,-361.15 103.5,-361.15 103.5,-343.15 53.5,-343.15"/> |
| <polygon fill="none" stroke="black" points="53.5,-343.15 53.5,-361.15 103.5,-361.15 103.5,-343.15 53.5,-343.15"/> |
| <text text-anchor="start" x="67.5" y="-349.35" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="103.5,-343.15 103.5,-361.15 143.5,-361.15 143.5,-343.15 103.5,-343.15"/> |
| <polygon fill="none" stroke="black" points="103.5,-343.15 103.5,-361.15 143.5,-361.15 143.5,-343.15 103.5,-343.15"/> |
| <text text-anchor="start" x="118.5" y="-349.35" font-family="Helvetica,sans-Serif" font-size="11.00">25 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_client->m_code_value --> |
| <g id="edge1" class="edge"> |
| <title>m_client:w->m_code_value:e</title> |
| <path fill="none" stroke="black" d="M176.9,-434.15C166.43,-434.15 159.51,-434.15 144.5,-434.15"/> |
| <polygon fill="black" stroke="black" points="183.5,-434.15 191.5,-437.75 187.5,-434.15 191.5,-434.15 191.5,-434.15 191.5,-434.15 187.5,-434.15 191.5,-430.55 183.5,-434.15 183.5,-434.15"/> |
| <ellipse fill="none" stroke="black" cx="180.3" cy="-434.15" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client->m_code_value --> |
| <g id="edge2" class="edge"> |
| <title>m_client:w->m_code_value:e</title> |
| <path fill="none" stroke="black" d="M177.33,-452.52C166.51,-446.27 161.62,-434.15 144.5,-434.15"/> |
| <polygon fill="black" stroke="black" points="183.75,-454.16 190.61,-459.64 187.63,-455.16 191.5,-456.15 191.5,-456.15 191.5,-456.15 187.63,-455.16 192.39,-452.66 183.75,-454.16 183.75,-454.16"/> |
| <ellipse fill="none" stroke="black" cx="180.65" cy="-453.37" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client->m_code_value --> |
| <g id="edge3" class="edge"> |
| <title>m_client:w->m_code_value:e</title> |
| <path fill="none" stroke="black" d="M177.7,-517.66C156.95,-499.73 182.78,-434.15 144.5,-434.15"/> |
| <polygon fill="black" stroke="black" points="183.89,-519.68 190.39,-525.57 187.7,-520.91 191.5,-522.15 191.5,-522.15 191.5,-522.15 187.7,-520.91 192.61,-518.73 183.89,-519.68 183.89,-519.68"/> |
| <ellipse fill="none" stroke="black" cx="180.85" cy="-518.69" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client->m_code_value --> |
| <g id="edge4" class="edge"> |
| <title>m_client:w->m_code_value:e</title> |
| <path fill="none" stroke="black" d="M177.44,-562.89C142.54,-542.56 200.94,-434.15 144.5,-434.15"/> |
| <polygon fill="black" stroke="black" points="183.71,-564.34 190.69,-569.66 187.6,-565.24 191.5,-566.15 191.5,-566.15 191.5,-566.15 187.6,-565.24 192.31,-562.64 183.71,-564.34 183.71,-564.34"/> |
| <ellipse fill="none" stroke="black" cx="180.59" cy="-563.62" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client->m_code_value --> |
| <g id="edge5" class="edge"> |
| <title>m_client:w->m_code_value:e</title> |
| <path fill="none" stroke="black" d="M177.33,-415.78C166.51,-422.03 161.62,-434.15 144.5,-434.15"/> |
| <polygon fill="black" stroke="black" points="183.75,-414.14 192.39,-415.64 187.63,-413.14 191.5,-412.15 191.5,-412.15 191.5,-412.15 187.63,-413.14 190.61,-408.66 183.75,-414.14 183.75,-414.14"/> |
| <ellipse fill="none" stroke="black" cx="180.65" cy="-414.93" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client->m_code_value --> |
| <g id="edge6" class="edge"> |
| <title>m_client:w->m_code_value:e</title> |
| <path fill="none" stroke="black" d="M176.91,-674.34C98.69,-652.19 248.5,-434.15 144.5,-434.15"/> |
| <polygon fill="black" stroke="black" points="183.56,-675.16 191.06,-679.72 187.53,-675.66 191.5,-676.15 191.5,-676.15 191.5,-676.15 187.53,-675.66 191.94,-672.58 183.56,-675.16 183.56,-675.16"/> |
| <ellipse fill="none" stroke="black" cx="180.39" cy="-674.77" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_client->m_code_value --> |
| <g id="edge7" class="edge"> |
| <title>m_client:w->m_code_value:e</title> |
| <path fill="none" stroke="black" d="M177.85,-395.2C165.47,-406.75 167.08,-434.15 144.5,-434.15"/> |
| <polygon fill="black" stroke="black" points="184,-392.92 192.75,-393.53 187.75,-391.54 191.5,-390.15 191.5,-390.15 191.5,-390.15 187.75,-391.54 190.25,-386.77 184,-392.92 184,-392.92"/> |
| <ellipse fill="none" stroke="black" cx="181" cy="-394.03" 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="208,-88.15 208,-322.15 369,-322.15 369,-88.15 208,-88.15"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="208.5,-300.15 208.5,-322.15 369.5,-322.15 369.5,-300.15 208.5,-300.15"/> |
| <polygon fill="none" stroke="black" points="208.5,-300.15 208.5,-322.15 369.5,-322.15 369.5,-300.15 208.5,-300.15"/> |
| <text text-anchor="start" x="213.5" y="-309.35" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_group</text> |
| <text text-anchor="start" x="334.5" y="-308.35" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="208.5,-278.15 208.5,-300.15 369.5,-300.15 369.5,-278.15 208.5,-278.15"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="213.5" y="-295.149"/> |
| <text text-anchor="start" x="228.5" y="-286.35" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="208.5,-256.15 208.5,-278.15 369.5,-278.15 369.5,-256.15 208.5,-256.15"/> |
| <polygon fill="none" stroke="black" points="208.5,-256.15 208.5,-278.15 369.5,-278.15 369.5,-256.15 208.5,-256.15"/> |
| <text text-anchor="start" x="228.5" y="-264.35" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="208.5,-234.15 208.5,-256.15 369.5,-256.15 369.5,-234.15 208.5,-234.15"/> |
| <polygon fill="none" stroke="black" points="208.5,-234.15 208.5,-256.15 369.5,-256.15 369.5,-234.15 208.5,-234.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="213.5" y="-251.149"/> |
| <text text-anchor="start" x="228.5" y="-242.35" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="208.5,-212.15 208.5,-234.15 369.5,-234.15 369.5,-212.15 208.5,-212.15"/> |
| <polygon fill="none" stroke="black" points="208.5,-212.15 208.5,-234.15 369.5,-234.15 369.5,-212.15 208.5,-212.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="213.5" y="-229.149"/> |
| <text text-anchor="start" x="228.5" y="-220.35" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="208.5,-190.15 208.5,-212.15 369.5,-212.15 369.5,-190.15 208.5,-190.15"/> |
| <polygon fill="none" stroke="black" points="208.5,-190.15 208.5,-212.15 369.5,-212.15 369.5,-190.15 208.5,-190.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="213.5" y="-207.149"/> |
| <text text-anchor="start" x="228.5" y="-198.35" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="208.5,-168.15 208.5,-190.15 369.5,-190.15 369.5,-168.15 208.5,-168.15"/> |
| <polygon fill="none" stroke="black" points="208.5,-168.15 208.5,-190.15 369.5,-190.15 369.5,-168.15 208.5,-168.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="213.5" y="-185.149"/> |
| <text text-anchor="start" x="228.5" y="-176.35" font-family="Helvetica,sans-Serif" font-size="11.00">level_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="208.5,-146.15 208.5,-168.15 369.5,-168.15 369.5,-146.15 208.5,-146.15"/> |
| <polygon fill="none" stroke="black" points="208.5,-146.15 208.5,-168.15 369.5,-168.15 369.5,-146.15 208.5,-146.15"/> |
| <text text-anchor="start" x="228.5" y="-154.35" font-family="Helvetica,sans-Serif" font-size="11.00">display_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="208.5,-124.15 208.5,-146.15 369.5,-146.15 369.5,-124.15 208.5,-124.15"/> |
| <polygon fill="none" stroke="black" points="208.5,-124.15 208.5,-146.15 369.5,-146.15 369.5,-124.15 208.5,-124.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="213.5" y="-141.149"/> |
| <text text-anchor="start" x="228.5" y="-132.35" font-family="Helvetica,sans-Serif" font-size="11.00">closure_reason_cv_id</text> |
| <polygon fill="none" stroke="black" points="208.5,-106.15 208.5,-124.15 369.5,-124.15 369.5,-106.15 208.5,-106.15"/> |
| <text text-anchor="start" x="211.5" y="-112.35" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="208.5,-88.15 208.5,-106.15 266.5,-106.15 266.5,-88.15 208.5,-88.15"/> |
| <polygon fill="none" stroke="black" points="208.5,-88.15 208.5,-106.15 266.5,-106.15 266.5,-88.15 208.5,-88.15"/> |
| <text text-anchor="start" x="211.5" y="-94.35" font-family="Helvetica,sans-Serif" font-size="11.00">< 5</text> |
| <polygon fill="#ffffff" stroke="transparent" points="266.5,-88.15 266.5,-106.15 323.5,-106.15 323.5,-88.15 266.5,-88.15"/> |
| <polygon fill="none" stroke="black" points="266.5,-88.15 266.5,-106.15 323.5,-106.15 323.5,-88.15 266.5,-88.15"/> |
| <text text-anchor="start" x="287.5" y="-94.35" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="323.5,-88.15 323.5,-106.15 369.5,-106.15 369.5,-88.15 323.5,-88.15"/> |
| <polygon fill="none" stroke="black" points="323.5,-88.15 323.5,-106.15 369.5,-106.15 369.5,-88.15 323.5,-88.15"/> |
| <text text-anchor="start" x="344.5" y="-94.35" font-family="Helvetica,sans-Serif" font-size="11.00">11 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_group->m_code_value --> |
| <g id="edge8" class="edge"> |
| <title>m_group:w->m_code_value:e</title> |
| <path fill="none" stroke="black" d="M194.03,-140.34C150.11,-180.04 207.1,-434.15 144.5,-434.15"/> |
| <polygon fill="black" stroke="black" points="200.03,-138.02 208.79,-138.51 203.77,-136.59 207.5,-135.15 207.5,-135.15 207.5,-135.15 203.77,-136.59 206.21,-131.79 200.03,-138.02 200.03,-138.02"/> |
| <ellipse fill="none" stroke="black" cx="197.05" cy="-139.18" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_group_roles --> |
| <g id="node4" class="node"> |
| <title>m_group_roles</title> |
| <g id="a_node4"><a xlink:href="../../tables/m_group_roles.html" xlink:title="m_group_roles" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="434,-236.15 434,-368.15 606,-368.15 606,-236.15 434,-236.15"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="436,-344.15 436,-366.15 604,-366.15 604,-344.15 436,-344.15"/> |
| <polygon fill="none" stroke="black" points="436,-344.15 436,-366.15 604,-366.15 604,-344.15 436,-344.15"/> |
| <text text-anchor="start" x="441" y="-353.35" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_group_roles</text> |
| <text text-anchor="start" x="569" y="-352.35" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="436,-322.15 436,-344.15 554,-344.15 554,-322.15 436,-322.15"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="441" y="-339.149"/> |
| <text text-anchor="start" x="456" y="-330.35" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="554,-322.15 554,-344.15 604,-344.15 604,-322.15 554,-322.15"/> |
| <text text-anchor="start" x="557" y="-330.35" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="436,-300.15 436,-322.15 554,-322.15 554,-300.15 436,-300.15"/> |
| <polygon fill="none" stroke="black" points="436,-300.15 436,-322.15 554,-322.15 554,-300.15 436,-300.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="441" y="-317.149"/> |
| <text text-anchor="start" x="456" y="-308.35" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="none" stroke="black" points="554,-300.15 554,-322.15 604,-322.15 604,-300.15 554,-300.15"/> |
| <text text-anchor="start" x="557" y="-308.35" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="436,-278.15 436,-300.15 554,-300.15 554,-278.15 436,-278.15"/> |
| <polygon fill="none" stroke="black" points="436,-278.15 436,-300.15 554,-300.15 554,-278.15 436,-278.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="441" y="-295.149"/> |
| <text text-anchor="start" x="456" y="-286.35" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text> |
| <polygon fill="none" stroke="black" points="554,-278.15 554,-300.15 604,-300.15 604,-278.15 554,-278.15"/> |
| <text text-anchor="start" x="557" y="-286.35" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="436,-256.15 436,-278.15 554,-278.15 554,-256.15 436,-256.15"/> |
| <polygon fill="none" stroke="black" points="436,-256.15 436,-278.15 554,-278.15 554,-256.15 436,-256.15"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="441" y="-273.149"/> |
| <text text-anchor="start" x="456" y="-264.35" font-family="Helvetica,sans-Serif" font-size="11.00">role_cv_id</text> |
| <polygon fill="none" stroke="black" points="554,-256.15 554,-278.15 604,-278.15 604,-256.15 554,-256.15"/> |
| <text text-anchor="start" x="557" y="-264.35" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="436,-238.15 436,-256.15 486,-256.15 486,-238.15 436,-238.15"/> |
| <polygon fill="none" stroke="black" points="436,-238.15 436,-256.15 486,-256.15 486,-238.15 436,-238.15"/> |
| <text text-anchor="start" x="439" y="-244.35" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="486,-238.15 486,-256.15 554,-256.15 554,-238.15 486,-238.15"/> |
| <polygon fill="none" stroke="black" points="486,-238.15 486,-256.15 554,-256.15 554,-238.15 486,-238.15"/> |
| <text text-anchor="start" x="518" y="-244.35" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="554,-238.15 554,-256.15 604,-256.15 604,-238.15 554,-238.15"/> |
| <polygon fill="none" stroke="black" points="554,-238.15 554,-256.15 604,-256.15 604,-238.15 554,-238.15"/> |
| <text text-anchor="start" x="585" y="-244.35" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="435,-237.15 435,-367.15 605,-367.15 605,-237.15 435,-237.15"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_group_roles->m_client --> |
| <g id="edge9" class="edge"> |
| <title>m_group_roles:w->m_client:e</title> |
| <path fill="none" stroke="black" d="M420.85,-315.14C354.19,-358.59 477.42,-742.15 386.5,-742.15"/> |
| <polygon fill="black" stroke="black" points="427.3,-313.32 435.98,-314.61 431.15,-312.24 435,-311.15 435,-311.15 435,-311.15 431.15,-312.24 434.02,-307.68 427.3,-313.32 427.3,-313.32"/> |
| <ellipse fill="none" stroke="black" cx="424.22" cy="-314.19" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_group_roles->m_code_value --> |
| <g id="edge11" class="edge"> |
| <title>m_group_roles:w->m_code_value:e</title> |
| <path fill="none" stroke="black" d="M420.36,-265.42C362.93,-249.56 455.66,-128.42 393,-78.15 320.54,-20.03 253.21,-16.19 184,-78.15 124.69,-131.24 224.1,-434.15 144.5,-434.15"/> |
| <polygon fill="black" stroke="black" points="427.05,-266.21 434.58,-270.72 431.03,-266.68 435,-267.15 435,-267.15 435,-267.15 431.03,-266.68 435.42,-263.57 427.05,-266.21 427.05,-266.21"/> |
| <ellipse fill="none" stroke="black" cx="423.88" cy="-265.84" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_group_roles->m_group --> |
| <g id="edge10" class="edge"> |
| <title>m_group_roles:w->m_group:e</title> |
| <path fill="none" stroke="black" d="M420.34,-289.15C402.71,-289.15 393.57,-289.15 370.5,-289.15"/> |
| <polygon fill="black" stroke="black" points="427,-289.15 435,-292.75 431,-289.15 435,-289.15 435,-289.15 435,-289.15 431,-289.15 435,-285.55 427,-289.15 427,-289.15"/> |
| <ellipse fill="none" stroke="black" cx="423.8" cy="-289.15" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |