| <?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="514pt" height="318pt" |
| viewBox="0.00 0.00 514.00 318.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 314)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-314 510,-314 510,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> |
| <!-- notification_mapper --> |
| <g id="node1" class="node"> |
| <title>notification_mapper</title> |
| <g id="a_node1"><a xlink:href="../../tables/notification_mapper.html" xlink:title="notification_mapper" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="272,-136 272,-290 498,-290 498,-136 272,-136"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="274,-266 274,-288 496,-288 496,-266 274,-266"/> |
| <polygon fill="none" stroke="black" points="274,-266 274,-288 496,-288 496,-266 274,-266"/> |
| <text text-anchor="start" x="279" y="-275.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">notification_mapper</text> |
| <text text-anchor="start" x="461" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="274,-244 274,-266 430,-266 430,-244 274,-244"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-261"/> |
| <text text-anchor="start" x="294" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="430,-244 430,-266 496,-266 496,-244 430,-244"/> |
| <text text-anchor="start" x="433" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-222 274,-244 430,-244 430,-222 274,-222"/> |
| <polygon fill="none" stroke="black" points="274,-222 274,-244 430,-244 430,-222 274,-222"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-239"/> |
| <text text-anchor="start" x="294" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">notification_id</text> |
| <polygon fill="none" stroke="black" points="430,-222 430,-244 496,-244 496,-222 430,-222"/> |
| <text text-anchor="start" x="433" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-200 274,-222 430,-222 430,-200 274,-200"/> |
| <polygon fill="none" stroke="black" points="274,-200 274,-222 430,-222 430,-200 274,-200"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-217"/> |
| <text text-anchor="start" x="294" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">user_id</text> |
| <polygon fill="none" stroke="black" points="430,-200 430,-222 496,-222 496,-200 430,-200"/> |
| <text text-anchor="start" x="433" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274,-178 274,-200 430,-200 430,-178 274,-178"/> |
| <text text-anchor="start" x="294" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_read</text> |
| <polygon fill="none" stroke="black" points="430,-178 430,-200 496,-200 496,-178 430,-178"/> |
| <text text-anchor="start" x="433" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="274,-156 274,-178 430,-178 430,-156 274,-156"/> |
| <text text-anchor="start" x="294" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_at</text> |
| <polygon fill="none" stroke="black" points="430,-156 430,-178 496,-178 496,-156 430,-156"/> |
| <text text-anchor="start" x="433" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-138 274,-156 343,-156 343,-138 274,-138"/> |
| <polygon fill="none" stroke="black" points="274,-138 274,-156 343,-156 343,-138 274,-138"/> |
| <text text-anchor="start" x="277" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="343,-138 343,-156 430,-156 430,-138 343,-138"/> |
| <polygon fill="none" stroke="black" points="343,-138 343,-156 430,-156 430,-138 343,-138"/> |
| <text text-anchor="start" x="394" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="430,-138 430,-156 496,-156 496,-138 430,-138"/> |
| <polygon fill="none" stroke="black" points="430,-138 430,-156 496,-156 496,-138 430,-138"/> |
| <text text-anchor="start" x="477" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="273,-137 273,-289 497,-289 497,-137 273,-137"/> |
| </a> |
| </g> |
| </g> |
| <!-- notification_generator --> |
| <g id="node2" class="node"> |
| <title>notification_generator</title> |
| <g id="a_node2"><a xlink:href="../../tables/notification_generator.html" xlink:title="notification_generator" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="29.5,-226 29.5,-306 201.5,-306 201.5,-226 29.5,-226"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="29.5,-284 29.5,-306 201.5,-306 201.5,-284 29.5,-284"/> |
| <polygon fill="none" stroke="black" points="29.5,-284 29.5,-306 201.5,-306 201.5,-284 29.5,-284"/> |
| <text text-anchor="start" x="34.5" y="-293.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">notification_generator</text> |
| <text text-anchor="start" x="166.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="29.5,-262 29.5,-284 201.5,-284 201.5,-262 29.5,-262"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="34.5" y="-279"/> |
| <text text-anchor="start" x="49.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="29.5,-244 29.5,-262 201.5,-262 201.5,-244 29.5,-244"/> |
| <text text-anchor="start" x="32.5" y="-250.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="29.5,-226 29.5,-244 91.5,-244 91.5,-226 29.5,-226"/> |
| <polygon fill="none" stroke="black" points="29.5,-226 29.5,-244 91.5,-244 91.5,-226 29.5,-226"/> |
| <text text-anchor="start" x="32.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| <polygon fill="#ffffff" stroke="transparent" points="91.5,-226 91.5,-244 154.5,-244 154.5,-226 91.5,-226"/> |
| <polygon fill="none" stroke="black" points="91.5,-226 91.5,-244 154.5,-244 154.5,-226 91.5,-226"/> |
| <text text-anchor="start" x="118.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="154.5,-226 154.5,-244 201.5,-244 201.5,-226 154.5,-226"/> |
| <polygon fill="none" stroke="black" points="154.5,-226 154.5,-244 201.5,-244 201.5,-226 154.5,-226"/> |
| <text text-anchor="start" x="182.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- notification_mapper->notification_generator --> |
| <g id="edge1" class="edge"> |
| <title>notification_mapper:w->notification_generator:e</title> |
| <path fill="none" stroke="black" d="M258.58,-235.62C236.54,-244.52 232.9,-273 202.5,-273"/> |
| <polygon fill="black" stroke="black" points="265.13,-234.43 273.64,-236.54 269.06,-233.72 273,-233 273,-233 273,-233 269.06,-233.72 272.36,-229.46 265.13,-234.43 265.13,-234.43"/> |
| <ellipse fill="none" stroke="black" cx="261.98" cy="-235.01" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_appuser --> |
| <g id="node3" class="node"> |
| <title>m_appuser</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_appuser.html" xlink:title="m_appuser" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-205 223,-205 223,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-183 8.5,-205 223.5,-205 223.5,-183 8.5,-183"/> |
| <polygon fill="none" stroke="black" points="8.5,-183 8.5,-205 223.5,-205 223.5,-183 8.5,-183"/> |
| <text text-anchor="start" x="13.5" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text> |
| <text text-anchor="start" x="188.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-161 8.5,-183 223.5,-183 223.5,-161 8.5,-161"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-178"/> |
| <text text-anchor="start" x="28.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-139 8.5,-161 223.5,-161 223.5,-139 8.5,-139"/> |
| <polygon fill="none" stroke="black" points="8.5,-139 8.5,-161 223.5,-161 223.5,-139 8.5,-139"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-156"/> |
| <text text-anchor="start" x="28.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-117 8.5,-139 223.5,-139 223.5,-117 8.5,-117"/> |
| <polygon fill="none" stroke="black" points="8.5,-117 8.5,-139 223.5,-139 223.5,-117 8.5,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-134"/> |
| <text text-anchor="start" x="28.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-95 8.5,-117 223.5,-117 223.5,-95 8.5,-95"/> |
| <polygon fill="none" stroke="black" points="8.5,-95 8.5,-117 223.5,-117 223.5,-95 8.5,-95"/> |
| <text text-anchor="start" x="28.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-73 8.5,-95 223.5,-95 223.5,-73 8.5,-73"/> |
| <polygon fill="none" stroke="black" points="8.5,-73 8.5,-95 223.5,-95 223.5,-73 8.5,-73"/> |
| <text text-anchor="start" x="28.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text> |
| <polygon fill="none" stroke="black" points="8.5,-55 8.5,-73 223.5,-73 223.5,-55 8.5,-55"/> |
| <text text-anchor="start" x="11.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-37 8.5,-55 93.5,-55 93.5,-37 8.5,-37"/> |
| <polygon fill="none" stroke="black" points="8.5,-37 8.5,-55 93.5,-55 93.5,-37 8.5,-37"/> |
| <text text-anchor="start" x="11.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="93.5,-37 93.5,-55 163.5,-55 163.5,-37 93.5,-37"/> |
| <polygon fill="none" stroke="black" points="93.5,-37 93.5,-55 163.5,-55 163.5,-37 93.5,-37"/> |
| <text text-anchor="start" x="127.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="163.5,-37 163.5,-55 223.5,-55 223.5,-37 163.5,-37"/> |
| <polygon fill="none" stroke="black" points="163.5,-37 163.5,-55 223.5,-55 223.5,-37 163.5,-37"/> |
| <text text-anchor="start" x="198.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- notification_mapper->m_appuser --> |
| <g id="edge2" class="edge"> |
| <title>notification_mapper:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M259.08,-206.22C246.67,-195.8 246.11,-172 224.5,-172"/> |
| <polygon fill="black" stroke="black" points="265.43,-208.4 271.83,-214.4 269.22,-209.7 273,-211 273,-211 273,-211 269.22,-209.7 274.17,-207.6 265.43,-208.4 265.43,-208.4"/> |
| <ellipse fill="none" stroke="black" cx="262.41" cy="-207.36" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |