Skip to content

Instantly share code, notes, and snippets.

@marioa

marioa/sql-join-structure.png

Last active July 7, 2017 12:09
Show Gist options
  • Save marioa/688359820aae7092afc2a3e91cca3a95 to your computer and use it in GitHub Desktop.
Save marioa/688359820aae7092afc2a3e91cca3a95 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Questions
Display the source blob
Display the rendered blob
Raw
sql-join-structure.svg
<?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">
<svg width="100%" height="100%" viewBox="0 0 373 523" version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" xml:space="preserve" style="fill-rule:evenodd;clip-rule:evenodd;">
<g id="graph0" transform="matrix(1.33333,0,0,1.33333,5.33332,517.332)">
<rect x="-4" y="-388" width="279" height="392" style="fill:white;stroke:white;stroke-width:1px;"/>
<rect x="0" y="-252" width="102" height="96" style="fill:rgb(217,217,217);stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,25.652,-234)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">Person</text>
</g>
<path d="M0,-228L102,-228" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,2.152,-210)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">id</text>
</g>
<g transform="matrix(1,0,0,1,9.75002,0)">
<path d="M54,-204L54,-228" style="fill:none;stroke:black;stroke-width:1px;"/>
</g>
<g transform="matrix(1,0,0,1,65.105,-210)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">text</text>
</g>
<path d="M0,-204L102,-204" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,1.312,-186)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">personal</text>
</g>
<path d="M64,-180L64,-204" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,67.105,-186)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">text</text>
</g>
<path d="M0,-180L102,-180" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,2.609,-162)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">family</text>
</g>
<g transform="matrix(1,0,0,1,6.75002,0)">
<path d="M57,-156L57,-180" style="fill:none;stroke:black;stroke-width:1px;"/>
</g>
<g transform="matrix(1,0,0,1,66.105,-162)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">text</text>
</g>
<rect x="169" y="-120" width="103" height="120" style="fill:rgb(217,217,217);stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,195.102,-102)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">Survey</text>
</g>
<path d="M169,-96L272,-96" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,171.93,-78)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">taken</text>
</g>
<g transform="matrix(1,0,0,1,8.25002,0)">
<path d="M217,-72L217,-96" style="fill:none;stroke:black;stroke-width:1px;"/>
</g>
<g transform="matrix(1,0,0,1,250,-78)">
<g transform="matrix(1,0,0,1,-21.244,0)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:15.75px;">i</text>
</g>
<g transform="matrix(1,0,0,1,-18.69,0)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:13.5px;">nteger</text>
</g>
</g>
<path d="M169,-72L272,-72" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,172.289,-54)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">person</text>
</g>
<g transform="matrix(1,0,0,1,-3.75001,0)">
<path d="M229,-48L229,-72" style="fill:none;stroke:black;stroke-width:1px;"/>
</g>
<g transform="matrix(1,0,0,1,230.355,-54)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">text</text>
</g>
<path d="M169,-48L272,-48" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,172.48,-30)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">quant</text>
</g>
<path d="M225,-24L225,-48" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,229.855,-30)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">text</text>
</g>
<path d="M169,-24L272,-24" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,171.812,-6)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">reading</text>
</g>
<g transform="matrix(1,0,0,1,-6.00002,0)">
<path d="M231,0L231,-24" style="fill:none;stroke:black;stroke-width:1px;"/>
</g>
<g transform="matrix(1,0,0,1,229.41,-6)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">real</text>
</g>
<g id="edge6">
<path d="M102,-216C130,-216 110,-181 120,-156C137,-115 124,-68 159,-61" style="fill:none;stroke:black;stroke-width:1px;"/>
<path d="M159.398,-64.478L169,-60L158.701,-57.513L159.398,-64.478Z" style="fill-rule:nonzero;stroke:black;stroke-width:1px;"/>
</g>
<rect x="53" y="-384" width="85" height="96" style="fill:rgb(217,217,217);stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,81.215,-366)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">Site</text>
</g>
<path d="M53,-360L138,-360" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,55.988,-342)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">name</text>
</g>
<path d="M100,-336L100,-360" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,104.605,-342)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">text</text>
</g>
<path d="M53,-336L138,-336" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,59.051,-318)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">lat</text>
</g>
<g transform="matrix(1,0,0,1,9.00002,0)">
<path d="M91,-312L91,-336" style="fill:none;stroke:black;stroke-width:1px;"/>
</g>
<g transform="matrix(1,0,0,1,104.41,-318)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">real</text>
</g>
<path d="M53,-312L138,-312" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,59.875,-294)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">long</text>
</g>
<g transform="matrix(1,0,0,1,3.00001,0)">
<path d="M97,-288L97,-312" style="fill:none;stroke:black;stroke-width:1px;"/>
</g>
<g transform="matrix(1,0,0,1,104.41,-294)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">real</text>
</g>
<rect x="138" y="-252" width="99" height="96" style="fill:rgb(217,217,217);stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,187,-234)">
<g transform="matrix(1,0,0,1,-23.867,0)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">V</text>
</g>
<g transform="matrix(1,0,0,1,-13.484,0)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">isited</text>
</g>
</g>
<path d="M138,-228L237,-228" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,141.902,-210)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">id</text>
</g>
<path d="M182,-204L182,-228" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,184.539,-210)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">integer</text>
</g>
<path d="M138,-204L237,-204" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,142.051,-186)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">site</text>
</g>
<g transform="matrix(1,0,0,1,-3.75001,0)">
<path d="M186,-180L186,-204" style="fill:none;stroke:black;stroke-width:1px;"/>
</g>
<g transform="matrix(1,0,0,1,186.105,-186)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">text</text>
</g>
<path d="M138,-180L237,-180" style="fill:none;stroke:black;stroke-width:1px;"/>
<g transform="matrix(1,0,0,1,141.98,-162)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">dated</text>
</g>
<g transform="matrix(1,0,0,1,-9.75002,0)">
<path d="M192,-156L192,-180" style="fill:none;stroke:black;stroke-width:1px;"/>
</g>
<g transform="matrix(1,0,0,1,186.105,-162)">
<text x="0px" y="0px" style="font-family:'ArialMT', 'Arial', sans-serif;font-size:16px;">text</text>
</g>
<g id="edge2">
<path d="M138,-348C168,-348 119,-226 130,-198" style="fill:none;stroke:black;stroke-width:1px;"/>
<path d="M132.1,-200.8L138,-192L127.9,-195.2L132.1,-200.8Z" style="fill-rule:nonzero;stroke:black;stroke-width:1px;"/>
</g>
<g id="edge4">
<path d="M237,-216C263,-216 250,-178 237,-156C219,-126 186,-149 169,-120C163,-110 157,-96 160,-89" style="fill:none;stroke:black;stroke-width:1px;"/>
<path d="M161.958,-91.916L169,-84L158.559,-85.797L161.958,-91.916Z" style="fill-rule:nonzero;stroke:black;stroke-width:1px;"/>
</g>
</g>
</svg>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment