| <?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="626pt" height="485pt" |
| viewBox="0.00 0.00 626.00 485.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 481)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-481 622,-481 622,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_provisioning_criteria_definition --> |
| <g id="node1" class="node"> |
| <title>m_provisioning_criteria_definition</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_provisioning_criteria_definition.html" xlink:title="m_provisioning_criteria_definition" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="293,-125 293,-345 610,-345 610,-125 293,-125"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="295.5,-321 295.5,-343 608.5,-343 608.5,-321 295.5,-321"/> |
| <polygon fill="none" stroke="black" points="295.5,-321 295.5,-343 608.5,-343 608.5,-321 295.5,-321"/> |
| <text text-anchor="start" x="300.5" y="-330.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_provisioning_criteria_definition</text> |
| <text text-anchor="start" x="573.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="295.5,-299 295.5,-321 544.5,-321 544.5,-299 295.5,-299"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-316"/> |
| <text text-anchor="start" x="315.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="544.5,-299 544.5,-321 608.5,-321 608.5,-299 544.5,-299"/> |
| <text text-anchor="start" x="547.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-277 295.5,-299 544.5,-299 544.5,-277 295.5,-277"/> |
| <polygon fill="none" stroke="black" points="295.5,-277 295.5,-299 544.5,-299 544.5,-277 295.5,-277"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-294"/> |
| <text text-anchor="start" x="315.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">criteria_id</text> |
| <polygon fill="none" stroke="black" points="544.5,-277 544.5,-299 608.5,-299 608.5,-277 544.5,-277"/> |
| <text text-anchor="start" x="547.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-255 295.5,-277 544.5,-277 544.5,-255 295.5,-255"/> |
| <polygon fill="none" stroke="black" points="295.5,-255 295.5,-277 544.5,-277 544.5,-255 295.5,-255"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-272"/> |
| <text text-anchor="start" x="315.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">category_id</text> |
| <polygon fill="none" stroke="black" points="544.5,-255 544.5,-277 608.5,-277 608.5,-255 544.5,-255"/> |
| <text text-anchor="start" x="547.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="295.5,-233 295.5,-255 544.5,-255 544.5,-233 295.5,-233"/> |
| <text text-anchor="start" x="315.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">min_age</text> |
| <polygon fill="none" stroke="black" points="544.5,-233 544.5,-255 608.5,-255 608.5,-233 544.5,-233"/> |
| <text text-anchor="start" x="547.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="295.5,-211 295.5,-233 544.5,-233 544.5,-211 295.5,-211"/> |
| <text text-anchor="start" x="315.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">max_age</text> |
| <polygon fill="none" stroke="black" points="544.5,-211 544.5,-233 608.5,-233 608.5,-211 544.5,-211"/> |
| <text text-anchor="start" x="547.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="295.5,-189 295.5,-211 544.5,-211 544.5,-189 295.5,-189"/> |
| <text text-anchor="start" x="315.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">provision_percentage</text> |
| <polygon fill="none" stroke="black" points="544.5,-189 544.5,-211 608.5,-211 608.5,-189 544.5,-189"/> |
| <text text-anchor="start" x="547.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[5,2]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-167 295.5,-189 544.5,-189 544.5,-167 295.5,-167"/> |
| <polygon fill="none" stroke="black" points="295.5,-167 295.5,-189 544.5,-189 544.5,-167 295.5,-167"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-184"/> |
| <text text-anchor="start" x="315.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">liability_account</text> |
| <polygon fill="none" stroke="black" points="544.5,-167 544.5,-189 608.5,-189 608.5,-167 544.5,-167"/> |
| <text text-anchor="start" x="547.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-145 295.5,-167 544.5,-167 544.5,-145 295.5,-145"/> |
| <polygon fill="none" stroke="black" points="295.5,-145 295.5,-167 544.5,-167 544.5,-145 295.5,-145"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-162"/> |
| <text text-anchor="start" x="315.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">expense_account</text> |
| <polygon fill="none" stroke="black" points="544.5,-145 544.5,-167 608.5,-167 608.5,-145 544.5,-145"/> |
| <text text-anchor="start" x="547.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-127 295.5,-145 411.5,-145 411.5,-127 295.5,-127"/> |
| <polygon fill="none" stroke="black" points="295.5,-127 295.5,-145 411.5,-145 411.5,-127 295.5,-127"/> |
| <text text-anchor="start" x="298.5" y="-133.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 4</text> |
| <polygon fill="#ffffff" stroke="transparent" points="411.5,-127 411.5,-145 544.5,-145 544.5,-127 411.5,-127"/> |
| <polygon fill="none" stroke="black" points="411.5,-127 411.5,-145 544.5,-145 544.5,-127 411.5,-127"/> |
| <text text-anchor="start" x="508.5" y="-133.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="544.5,-127 544.5,-145 608.5,-145 608.5,-127 544.5,-127"/> |
| <polygon fill="none" stroke="black" points="544.5,-127 544.5,-145 608.5,-145 608.5,-127 544.5,-127"/> |
| <text text-anchor="start" x="589.5" y="-133.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="294,-126 294,-344 609,-344 609,-126 294,-126"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_provision_category --> |
| <g id="node2" class="node"> |
| <title>m_provision_category</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_provision_category.html" xlink:title="m_provision_category" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="42.5,-204 42.5,-306 209.5,-306 209.5,-204 42.5,-204"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="43,-284 43,-306 210,-306 210,-284 43,-284"/> |
| <polygon fill="none" stroke="black" points="43,-284 43,-306 210,-306 210,-284 43,-284"/> |
| <text text-anchor="start" x="48" y="-293.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_provision_category</text> |
| <text text-anchor="start" x="175" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="43,-262 43,-284 210,-284 210,-262 43,-262"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="48" y="-279"/> |
| <text text-anchor="start" x="63" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="43,-240 43,-262 210,-262 210,-240 43,-240"/> |
| <polygon fill="none" stroke="black" points="43,-240 43,-262 210,-262 210,-240 43,-240"/> |
| <text text-anchor="start" x="63" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">category_name</text> |
| <polygon fill="none" stroke="black" points="43,-222 43,-240 210,-240 210,-222 43,-222"/> |
| <text text-anchor="start" x="46" y="-228.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="43,-204 43,-222 102,-222 102,-204 43,-204"/> |
| <polygon fill="none" stroke="black" points="43,-204 43,-222 102,-222 102,-204 43,-204"/> |
| <text text-anchor="start" x="46" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| <polygon fill="#ffffff" stroke="transparent" points="102,-204 102,-222 164,-222 164,-204 102,-204"/> |
| <polygon fill="none" stroke="black" points="102,-204 102,-222 164,-222 164,-204 102,-204"/> |
| <text text-anchor="start" x="128" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="164,-204 164,-222 210,-222 210,-204 164,-204"/> |
| <polygon fill="none" stroke="black" points="164,-204 164,-222 210,-222 210,-204 164,-204"/> |
| <text text-anchor="start" x="191" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_provisioning_criteria_definition->m_provision_category --> |
| <g id="edge1" class="edge"> |
| <title>m_provisioning_criteria_definition:w->m_provision_category:e</title> |
| <path fill="none" stroke="black" d="M279.95,-266.4C254.06,-267.88 242.86,-273 211,-273"/> |
| <polygon fill="black" stroke="black" points="286.5,-266.22 294.6,-269.6 290.5,-266.11 294.5,-266 294.5,-266 294.5,-266 290.5,-266.11 294.4,-262.4 286.5,-266.22 286.5,-266.22"/> |
| <ellipse fill="none" stroke="black" cx="283.3" cy="-266.31" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_provisioning_criteria --> |
| <g id="node3" class="node"> |
| <title>m_provisioning_criteria</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_provisioning_criteria.html" xlink:title="m_provisioning_criteria" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="37,-327 37,-473 215,-473 215,-327 37,-327"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="37,-451 37,-473 215,-473 215,-451 37,-451"/> |
| <polygon fill="none" stroke="black" points="37,-451 37,-473 215,-473 215,-451 37,-451"/> |
| <text text-anchor="start" x="42" y="-460.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_provisioning_criteria</text> |
| <text text-anchor="start" x="180" y="-459.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="37,-429 37,-451 215,-451 215,-429 37,-429"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="42" y="-446"/> |
| <text text-anchor="start" x="57" y="-437.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="37,-407 37,-429 215,-429 215,-407 37,-407"/> |
| <polygon fill="none" stroke="black" points="37,-407 37,-429 215,-429 215,-407 37,-407"/> |
| <text text-anchor="start" x="57" y="-415.2" font-family="Helvetica,sans-Serif" font-size="11.00">criteria_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="37,-385 37,-407 215,-407 215,-385 37,-385"/> |
| <polygon fill="none" stroke="black" points="37,-385 37,-407 215,-407 215,-385 37,-385"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="42" y="-402"/> |
| <text text-anchor="start" x="57" y="-393.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="37,-363 37,-385 215,-385 215,-363 37,-363"/> |
| <polygon fill="none" stroke="black" points="37,-363 37,-385 215,-385 215,-363 37,-363"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="42" y="-380"/> |
| <text text-anchor="start" x="57" y="-371.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text> |
| <polygon fill="none" stroke="black" points="37,-345 37,-363 215,-363 215,-345 37,-345"/> |
| <text text-anchor="start" x="40" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="37,-327 37,-345 106,-345 106,-327 37,-327"/> |
| <polygon fill="none" stroke="black" points="37,-327 37,-345 106,-345 106,-327 37,-327"/> |
| <text text-anchor="start" x="40" y="-333.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="106,-327 106,-345 169,-345 169,-327 106,-327"/> |
| <polygon fill="none" stroke="black" points="106,-327 106,-345 169,-345 169,-327 106,-327"/> |
| <text text-anchor="start" x="133" y="-333.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="169,-327 169,-345 215,-345 215,-327 169,-327"/> |
| <polygon fill="none" stroke="black" points="169,-327 169,-345 215,-345 215,-327 169,-327"/> |
| <text text-anchor="start" x="196" y="-333.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_provisioning_criteria_definition->m_provisioning_criteria --> |
| <g id="edge2" class="edge"> |
| <title>m_provisioning_criteria_definition:w->m_provisioning_criteria:e</title> |
| <path fill="none" stroke="black" d="M280.25,-290.27C228.32,-309.17 286.54,-440 216,-440"/> |
| <polygon fill="black" stroke="black" points="286.6,-289.26 295.07,-291.56 290.55,-288.63 294.5,-288 294.5,-288 294.5,-288 290.55,-288.63 293.93,-284.44 286.6,-289.26 286.6,-289.26"/> |
| <ellipse fill="none" stroke="black" cx="283.44" cy="-289.76" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- acc_gl_account --> |
| <g id="node4" class="node"> |
| <title>acc_gl_account</title> |
| <g id="a_node4"><a xlink:href="../../tables/acc_gl_account.html" xlink:title="acc_gl_account" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-183 244,-183 244,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-161 8,-183 244,-183 244,-161 8,-161"/> |
| <polygon fill="none" stroke="black" points="8,-161 8,-183 244,-183 244,-161 8,-161"/> |
| <text text-anchor="start" x="13" y="-170.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_gl_account</text> |
| <text text-anchor="start" x="209" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-139 8,-161 244,-161 244,-139 8,-139"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-156"/> |
| <text text-anchor="start" x="28" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-117 8,-139 244,-139 244,-117 8,-117"/> |
| <polygon fill="none" stroke="black" points="8,-117 8,-139 244,-139 244,-117 8,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-134"/> |
| <text text-anchor="start" x="28" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-95 8,-117 244,-117 244,-95 8,-95"/> |
| <polygon fill="none" stroke="black" points="8,-95 8,-117 244,-117 244,-95 8,-95"/> |
| <text text-anchor="start" x="28" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">gl_code</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-73 8,-95 244,-95 244,-73 8,-73"/> |
| <polygon fill="none" stroke="black" points="8,-73 8,-95 244,-95 244,-73 8,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-90"/> |
| <text text-anchor="start" x="28" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">tag_id</text> |
| <polygon fill="none" stroke="black" points="8,-55 8,-73 244,-73 244,-55 8,-55"/> |
| <text text-anchor="start" x="11" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-55 103,-55 103,-37 8,-37"/> |
| <polygon fill="none" stroke="black" points="8,-37 8,-55 103,-55 103,-37 8,-37"/> |
| <text text-anchor="start" x="11" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="103,-37 103,-55 179,-55 179,-37 103,-37"/> |
| <polygon fill="none" stroke="black" points="103,-37 103,-55 179,-55 179,-37 103,-37"/> |
| <text text-anchor="start" x="143" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="179,-37 179,-55 244,-55 244,-37 179,-37"/> |
| <polygon fill="none" stroke="black" points="179,-37 179,-55 244,-55 244,-37 179,-37"/> |
| <text text-anchor="start" x="219" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">14 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_provisioning_criteria_definition->acc_gl_account --> |
| <g id="edge3" class="edge"> |
| <title>m_provisioning_criteria_definition:w->acc_gl_account:e</title> |
| <path fill="none" stroke="black" d="M279.8,-154.95C268.39,-153.24 261.27,-150 245,-150"/> |
| <polygon fill="black" stroke="black" points="286.52,-155.43 294.24,-159.59 290.51,-155.72 294.5,-156 294.5,-156 294.5,-156 290.51,-155.72 294.76,-152.41 286.52,-155.43 286.52,-155.43"/> |
| <ellipse fill="none" stroke="black" cx="283.33" cy="-155.21" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_provisioning_criteria_definition->acc_gl_account --> |
| <g id="edge4" class="edge"> |
| <title>m_provisioning_criteria_definition:w->acc_gl_account:e</title> |
| <path fill="none" stroke="black" d="M280.39,-174.11C268.27,-166.41 264.35,-150 245,-150"/> |
| <polygon fill="black" stroke="black" points="286.79,-175.87 293.54,-181.47 290.64,-176.94 294.5,-178 294.5,-178 294.5,-178 290.64,-176.94 295.46,-174.53 286.79,-175.87 286.79,-175.87"/> |
| <ellipse fill="none" stroke="black" cx="283.7" cy="-175.02" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
