Documentation/EHI_Export/docs/diagrams/tables/esign_signatures.1degree.svg

   1 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
   2 <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
   3  "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
   4 <!-- Generated by graphviz version 2.40.1 (20161225.0304)
   5  -->
   6 <!-- Title: oneDegreeRelationshipsDiagram Pages: 1 -->
   7 <svg width="446pt" height="333pt"
   8  viewBox="0.00 0.00 446.00 332.70" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
   9 <g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 328.7)">
  10 <title>oneDegreeRelationshipsDiagram</title>
  11 <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-328.7 442,-328.7 442,4 -4,4"/>
  12 <text text-anchor="middle" x="72.4936" y="-7.3" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">Generated by SchemaSpy</text>
  13 <!-- esign_signatures -->
  14 <g id="node1" class="node">
  15 <title>esign_signatures</title>
  16 <g id="a_node1"><a xlink:href="../../tables/esign_signatures.html" xlink:title="esign_signatures" target="_top">
  17 <polygon fill="#ffffff" stroke="transparent" points="224,-76.7 224,-320.7 430,-320.7 430,-76.7 224,-76.7"/>
  18 <polygon fill="#f5f5f5" stroke="transparent" points="226,-295.7 226,-318.7 428,-318.7 428,-295.7 226,-295.7"/>
  19 <polygon fill="none" stroke="#000000" points="226,-295.7 226,-318.7 428,-318.7 428,-295.7 226,-295.7"/>
  20 <text text-anchor="start" x="231" y="-304.3" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">esign_signatures</text>
  21 <text text-anchor="start" x="393.0437" y="-303.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
  22 <polygon fill="none" stroke="#000000" points="226,-273.7 226,-295.7 361,-295.7 361,-273.7 226,-273.7"/>
  23 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="231" y="-290.7"/>
  24 <text text-anchor="start" x="246" y="-280.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
  25 <polygon fill="none" stroke="#000000" points="361,-273.7 361,-295.7 428,-295.7 428,-273.7 361,-273.7"/>
  26 <text text-anchor="start" x="364" y="-281.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">int[10]</text>
  27 <polygon fill="#ffffff" stroke="transparent" points="226,-251.7 226,-273.7 361,-273.7 361,-251.7 226,-251.7"/>
  28 <polygon fill="none" stroke="#000000" points="226,-251.7 226,-273.7 361,-273.7 361,-251.7 226,-251.7"/>
  29 <text text-anchor="start" x="246" y="-258.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">tid</text>
  30 <polygon fill="none" stroke="#000000" points="361,-251.7 361,-273.7 428,-273.7 428,-251.7 361,-251.7"/>
  31 <text text-anchor="start" x="364" y="-259.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">int[10]</text>
  32 <polygon fill="#ffffff" stroke="transparent" points="226,-229.7 226,-251.7 361,-251.7 361,-229.7 226,-229.7"/>
  33 <polygon fill="none" stroke="#000000" points="226,-229.7 226,-251.7 361,-251.7 361,-229.7 226,-229.7"/>
  34 <text text-anchor="start" x="246" y="-236.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">table</text>
  35 <polygon fill="none" stroke="#000000" points="361,-229.7 361,-251.7 428,-251.7 428,-229.7 361,-229.7"/>
  36 <text text-anchor="start" x="363.9365" y="-237.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[255]</text>
  37 <polygon fill="none" stroke="#000000" points="226,-207.7 226,-229.7 361,-229.7 361,-207.7 226,-207.7"/>
  38 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="231" y="-224.7"/>
  39 <text text-anchor="start" x="246" y="-214.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">uid</text>
  40 <polygon fill="none" stroke="#000000" points="361,-207.7 361,-229.7 428,-229.7 428,-207.7 361,-207.7"/>
  41 <text text-anchor="start" x="364" y="-215.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">int[10]</text>
  42 <polygon fill="none" stroke="#000000" points="226,-185.7 226,-207.7 361,-207.7 361,-185.7 226,-185.7"/>
  43 <text text-anchor="start" x="246" y="-192.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">datetime</text>
  44 <polygon fill="none" stroke="#000000" points="361,-185.7 361,-207.7 428,-207.7 428,-185.7 361,-185.7"/>
  45 <text text-anchor="start" x="364" y="-193.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">datetime[19]</text>
  46 <polygon fill="none" stroke="#000000" points="226,-163.7 226,-185.7 361,-185.7 361,-163.7 226,-163.7"/>
  47 <text text-anchor="start" x="246" y="-170.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">is_lock</text>
  48 <polygon fill="none" stroke="#000000" points="361,-163.7 361,-185.7 428,-185.7 428,-163.7 361,-163.7"/>
  49 <text text-anchor="start" x="364" y="-171.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">bit[1]</text>
  50 <polygon fill="none" stroke="#000000" points="226,-141.7 226,-163.7 361,-163.7 361,-141.7 226,-141.7"/>
  51 <text text-anchor="start" x="246" y="-148.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">amendment</text>
  52 <polygon fill="none" stroke="#000000" points="361,-141.7 361,-163.7 428,-163.7 428,-141.7 361,-141.7"/>
  53 <text text-anchor="start" x="364" y="-149.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">text[65535]</text>
  54 <polygon fill="none" stroke="#000000" points="226,-119.7 226,-141.7 361,-141.7 361,-119.7 226,-119.7"/>
  55 <text text-anchor="start" x="246" y="-126.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">hash</text>
  56 <polygon fill="none" stroke="#000000" points="361,-119.7 361,-141.7 428,-141.7 428,-119.7 361,-119.7"/>
  57 <text text-anchor="start" x="363.9365" y="-127.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[255]</text>
  58 <polygon fill="none" stroke="#000000" points="226,-97.7 226,-119.7 361,-119.7 361,-97.7 226,-97.7"/>
  59 <text text-anchor="start" x="246" y="-104.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">signature_hash</text>
  60 <polygon fill="none" stroke="#000000" points="361,-97.7 361,-119.7 428,-119.7 428,-97.7 361,-97.7"/>
  61 <text text-anchor="start" x="363.9365" y="-105.4" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">varchar[255]</text>
  62 <polygon fill="#ffffff" stroke="transparent" points="226,-78.7 226,-97.7 298,-97.7 298,-78.7 226,-78.7"/>
  63 <polygon fill="none" stroke="#000000" points="226,-78.7 226,-97.7 298,-97.7 298,-78.7 226,-78.7"/>
  64 <text text-anchor="start" x="229" y="-84.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 1</text>
  65 <polygon fill="#ffffff" stroke="transparent" points="298,-78.7 298,-97.7 361,-97.7 361,-78.7 298,-78.7"/>
  66 <polygon fill="none" stroke="#000000" points="298,-78.7 298,-97.7 361,-97.7 361,-78.7 298,-78.7"/>
  67 <text text-anchor="start" x="351.8862" y="-84.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
  68 <polygon fill="#ffffff" stroke="transparent" points="361,-78.7 361,-97.7 428,-97.7 428,-78.7 361,-78.7"/>
  69 <polygon fill="none" stroke="#000000" points="361,-78.7 361,-97.7 428,-97.7 428,-78.7 361,-78.7"/>
  70 <text text-anchor="start" x="409.4053" y="-84.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">0 &gt;</text>
  71 <polygon fill="none" stroke="#000000" stroke-width="2" points="225,-77.7 225,-319.7 429,-319.7 429,-77.7 225,-77.7"/>
  72 </a>
  73 </g>
  74 </g>
  75 <!-- users -->
  76 <g id="node2" class="node">
  77 <title>users</title>
  78 <g id="a_node2"><a xlink:href="../../tables/users.html" xlink:title="users" target="_top">
  79 <polygon fill="#ffffff" stroke="transparent" points="8,-38.2 8,-253.2 175,-253.2 175,-38.2 8,-38.2"/>
  80 <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-229.7 8.5,-252.7 175.5,-252.7 175.5,-229.7 8.5,-229.7"/>
  81 <polygon fill="none" stroke="#000000" points="8.5,-229.7 8.5,-252.7 175.5,-252.7 175.5,-229.7 8.5,-229.7"/>
  82 <text text-anchor="start" x="13.5" y="-238.3" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00" fill="#000000">users</text>
  83 <text text-anchor="start" x="140.5437" y="-237.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">[table]</text>
  84 <polygon fill="none" stroke="#000000" points="8.5,-207.7 8.5,-229.7 175.5,-229.7 175.5,-207.7 8.5,-207.7"/>
  85 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-224.7"/>
  86 <text text-anchor="start" x="28.5" y="-214.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">id</text>
  87 <polygon fill="#ffffff" stroke="transparent" points="8.5,-185.7 8.5,-207.7 175.5,-207.7 175.5,-185.7 8.5,-185.7"/>
  88 <polygon fill="none" stroke="#000000" points="8.5,-185.7 8.5,-207.7 175.5,-207.7 175.5,-185.7 8.5,-185.7"/>
  89 <text text-anchor="start" x="28.5" y="-192.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">uuid</text>
  90 <polygon fill="none" stroke="#000000" points="8.5,-163.7 8.5,-185.7 175.5,-185.7 175.5,-163.7 8.5,-163.7"/>
  91 <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-180.7"/>
  92 <text text-anchor="start" x="28.5" y="-170.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">username</text>
  93 <polygon fill="none" stroke="#000000" points="8.5,-141.7 8.5,-163.7 175.5,-163.7 175.5,-141.7 8.5,-141.7"/>
  94 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-158.7"/>
  95 <text text-anchor="start" x="28.5" y="-148.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">facility_id</text>
  96 <polygon fill="#ffffff" stroke="transparent" points="8.5,-119.7 8.5,-141.7 175.5,-141.7 175.5,-119.7 8.5,-119.7"/>
  97 <polygon fill="none" stroke="#000000" points="8.5,-119.7 8.5,-141.7 175.5,-141.7 175.5,-119.7 8.5,-119.7"/>
  98 <text text-anchor="start" x="28.5" y="-126.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">google_signin_email</text>
  99 <polygon fill="#ffffff" stroke="transparent" points="8.5,-97.7 8.5,-119.7 175.5,-119.7 175.5,-97.7 8.5,-97.7"/>
 100 <polygon fill="none" stroke="#000000" points="8.5,-97.7 8.5,-119.7 175.5,-119.7 175.5,-97.7 8.5,-97.7"/>
 101 <text text-anchor="start" x="28.5" y="-104.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">abook_type</text>
 102 <polygon fill="none" stroke="#000000" points="8.5,-75.7 8.5,-97.7 175.5,-97.7 175.5,-75.7 8.5,-75.7"/>
 103 <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-92.7"/>
 104 <text text-anchor="start" x="28.5" y="-82.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">billing_facility_id</text>
 105 <polygon fill="none" stroke="#000000" points="8.5,-56.7 8.5,-75.7 175.5,-75.7 175.5,-56.7 8.5,-56.7"/>
 106 <text text-anchor="start" x="11.5" y="-62.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">...</text>
 107 <polygon fill="#ffffff" stroke="transparent" points="8.5,-37.7 8.5,-56.7 82.5,-56.7 82.5,-37.7 8.5,-37.7"/>
 108 <polygon fill="none" stroke="#000000" points="8.5,-37.7 8.5,-56.7 82.5,-56.7 82.5,-37.7 8.5,-37.7"/>
 109 <text text-anchor="start" x="11.5" y="-43.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">&lt; 2</text>
 110 <polygon fill="#ffffff" stroke="transparent" points="82.5,-37.7 82.5,-56.7 121.5,-56.7 121.5,-37.7 82.5,-37.7"/>
 111 <polygon fill="none" stroke="#000000" points="82.5,-37.7 82.5,-56.7 121.5,-56.7 121.5,-37.7 82.5,-37.7"/>
 112 <text text-anchor="start" x="112.3862" y="-43.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000"> &#160;</text>
 113 <polygon fill="#ffffff" stroke="transparent" points="121.5,-37.7 121.5,-56.7 175.5,-56.7 175.5,-37.7 121.5,-37.7"/>
 114 <polygon fill="none" stroke="#000000" points="121.5,-37.7 121.5,-56.7 175.5,-56.7 175.5,-37.7 121.5,-37.7"/>
 115 <text text-anchor="start" x="150.7904" y="-43.8" font-family="Helvetica,sans-Serif" font-size="11.00" fill="#000000">61 &gt;</text>
 116 </a>
 117 </g>
 118 </g>
 119 <!-- esign_signatures&#45;&gt;users -->
 120 <g id="edge1" class="edge">
 121 <title>esign_signatures:w&#45;&gt;users:e</title>
 122 <path fill="none" stroke="#000000" d="M211.4203,-218.7C199.5435,-218.7 192.158,-218.7 175.5,-218.7"/>
 123 <polygon fill="#000000" stroke="#000000" points="218,-218.7001 226,-222.3 222,-218.7 226,-218.7 226,-218.7 226,-218.7 222,-218.7 226,-215.1 218,-218.7001 218,-218.7001"/>
 124 <ellipse fill="none" stroke="#000000" cx="214.8" cy="-218.7001" rx="3.2" ry="3.2"/>
 125 </g>
 126 </g>
 127 </svg>