Instantly share code, notes, and snippets.
Created
August 28, 2022 16:47
-
Star
(0)
0
You must be signed in to star a gist -
Fork
(0)
0
You must be signed in to fork a gist
-
Save mnemnion/02d16e178b0dcbd2a3efe43533f8ea50 to your computer and use it in GitHub Desktop.
create-table statement rendered with Pikchr class-tags branch
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 718.33 315.792"> | |
<circle cx="5" cy="17" r="3.6" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<path d="M9,17L32,17" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> | |
<path d="M47,32L100,32A15 15 0 0 0 116 17A15 15 0 0 0 100 2L47,2A15 15 0 0 0 32 17A15 15 0 0 0 47 32Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="74" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">CREATE</text> | |
<path d="M167,56L199,56A15 15 0 0 0 214 41A15 15 0 0 0 199 26L167,26A15 15 0 0 0 152 41A15 15 0 0 0 167 56Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="183" y="41" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TEMP</text> | |
<path d="M167,94L259,94A15 15 0 0 0 274 79A15 15 0 0 0 259 64L167,64A15 15 0 0 0 152 79A15 15 0 0 0 167 94Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="213" y="79" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TEMPORARY</text> | |
<path d="M325,32L365,32A15 15 0 0 0 380 17A15 15 0 0 0 365 2L325,2A15 15 0 0 0 310 17A15 15 0 0 0 325 32Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="345" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TABLE</text> | |
<g > | |
<path d="M116,17L213,17" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="213,17 201,21 201,12" style="fill:rgb(0,0,0)"/> | |
</g> | |
<g > | |
<path d="M213,17L310,17" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="310,17 299,21 299,12" style="fill:rgb(0,0,0)"/> | |
</g> | |
<g > | |
<path d="M116,17 L 123,17 Q 131,17 131,29 Q 131,41 141,41 L 152,41" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="152,41 140,45 140,37" style="fill:rgb(0,0,0)"/> | |
</g> | |
<g > | |
<path d="M116,17 L 123,17 Q 131,17 131,32 L 131,64 Q 131,79 141,79 L 152,79" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="152,79 140,83 140,74" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M274,79 L 282,79 Q 289,79 289,64 L 289,32 Q 289,17 294,17 L 299,17" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<path d="M214,41 L 274,41 Q 289,41 289,33 L 289,26" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<g > | |
<path d="M380,17L416,17" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="416,17 404,21 404,12" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M431,32A15 15 0 0 0 446 17A15 15 0 0 0 431 2A15 15 0 0 0 416 17A15 15 0 0 0 431 32Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="431" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">IF</text> | |
<g > | |
<path d="M446,17L469,17" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="469,17 458,21 458,12" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M484,32L504,32A15 15 0 0 0 520 17A15 15 0 0 0 504 2L484,2A15 15 0 0 0 469 17A15 15 0 0 0 484 32Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="494" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NOT</text> | |
<g > | |
<path d="M520,17L543,17" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="543,17 531,21 531,12" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M558,32L602,32A15 15 0 0 0 617 17A15 15 0 0 0 602 2L558,2A15 15 0 0 0 543 17A15 15 0 0 0 558 32Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="580" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">EXISTS</text> | |
<g > | |
<path d="M380,17 L 387,17 Q 395,17 395,32 L 395,94 Q 395,109 380,109 L 228,109 L 213,109" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="213,109 224,105 224,113" style="fill:rgb(0,0,0)"/> | |
</g> | |
<g > | |
<path d="M617,17 L 625,17 Q 632,17 632,32 L 632,94 Q 632,109 617,109 L 558,109 L 543,109" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="543,109 554,105 554,113" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M543,109L310,109" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<g > | |
<path d="M310,109 L 20,109 Q 5,109 5,124 L 5,132 Q 5,147 17,147 L 28,147" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="28,147 17,151 17,142" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M43,162L140,162A15 15 0 0 0 155 147A15 15 0 0 0 140 132L43,132A15 15 0 0 0 28 147A15 15 0 0 0 43 162Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="92" y="147" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">schema-name</text> | |
<g > | |
<path d="M155,147L178,147" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="178,147 166,151 166,142" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M193,162A15 15 0 0 0 208 147A15 15 0 0 0 193 132A15 15 0 0 0 178 147A15 15 0 0 0 193 162Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="193" y="147" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">.</text> | |
<g > | |
<path d="M208,147L244,147" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="244,147 233,151 233,142" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M259,162L334,162A15 15 0 0 0 350 147A15 15 0 0 0 334 132L259,132A15 15 0 0 0 244 147A15 15 0 0 0 259 162Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="297" y="147" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-name</text> | |
<g > | |
<path d="M5,132 L 5,162 Q 5,177 20,177 L 77,177 L 92,177" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="92,177 80,181 80,173" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M92,177 L 205,177 Q 220,177 220,162 L 220,162 Q 220,147 227,147 L 235,147" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<g > | |
<path d="M350,147 L 357,147 Q 365,147 365,162 L 365,207 Q 365,222 350,222 L 208,222 L 193,222" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="193,222 205,218 205,227" style="fill:rgb(0,0,0)"/> | |
</g> | |
<g > | |
<path d="M193,222 L 20,222 Q 5,222 5,237 L 5,245 Q 5,260 17,260 L 28,260" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="28,260 17,265 17,256" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M43,275A15 15 0 0 0 59 260A15 15 0 0 0 43 245A15 15 0 0 0 28 260A15 15 0 0 0 43 275Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="43" y="260" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text> | |
<g > | |
<path d="M59,260L95,260" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="95,260 83,265 83,256" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M95,275L199,275L199,245L95,245Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="147" y="260" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-def</text> | |
<path d="M253,313L399,313L399,283L253,283Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="326" y="298" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-constraint</text> | |
<g > | |
<path d="M399,298L416,298" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="399,298 410,294 410,302" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M431,313A15 15 0 0 0 446 298A15 15 0 0 0 431 283A15 15 0 0 0 416 298A15 15 0 0 0 431 313Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="431" y="298" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text> | |
<path d="M503,275A15 15 0 0 0 518 260A15 15 0 0 0 503 245A15 15 0 0 0 488 260A15 15 0 0 0 503 275Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="503" y="260" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text> | |
<g > | |
<path d="M518,260L553,260" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="553,260 541,265 541,256" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M553,275L674,275L674,245L553,245Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="613" y="260" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-options</text> | |
<path d="M147,313A15 15 0 0 0 162 298A15 15 0 0 0 147 283A15 15 0 0 0 132 298A15 15 0 0 0 147 313Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="147" y="298" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text> | |
<g > | |
<path d="M199,260 L 207,260 Q 214,260 214,275 L 214,283 Q 214,298 199,298 L 177,298 L 162,298" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="162,298 174,294 174,302" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M132,298 L 87,298 Q 72,298 72,283 L 72,275 Q 72,260 77,260 L 83,260" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<g > | |
<path d="M199,260L235,260" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="235,260 224,265 224,256" style="fill:rgb(0,0,0)"/> | |
</g> | |
<g > | |
<path d="M235,260L488,260" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="488,260 476,265 476,256" style="fill:rgb(0,0,0)"/> | |
</g> | |
<g > | |
<path d="M446,260 L 458,260 Q 469,260 469,275 L 469,283 Q 469,298 458,298 L 446,298" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="446,298 458,294 458,302" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M253,298 L 246,298 Q 238,298 238,283 L 238,275 Q 238,260 250,260 L 261,260" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<g > | |
<path d="M518,260 L 526,260 Q 533,260 533,245 L 533,230 Q 533,215 548,215 L 598,215 L 613,215" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="613,215 602,219 602,211" style="fill:rgb(0,0,0)"/> | |
</g> | |
<g > | |
<path d="M613,215 L 659,215 Q 674,215 689,215 L 693,215 L 708,215" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="708,215 697,219 697,211" style="fill:rgb(0,0,0)"/> | |
</g> | |
<circle cx="712" cy="215" r="3.6" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<g > | |
<path d="M674,260 L 681,260 Q 689,260 689,245 L 689,230 Q 689,215 699,215 L 708,215" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="708,215 697,219 697,211" style="fill:rgb(0,0,0)"/> | |
</g> | |
<g > | |
<path d="M350,147L440,147" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="440,147 428,151 428,142" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M455,162L459,162A15 15 0 0 0 474 147A15 15 0 0 0 459 132L455,132A15 15 0 0 0 440 147A15 15 0 0 0 455 162Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="457" y="147" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">AS</text> | |
<g > | |
<path d="M474,147L497,147" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="497,147 485,151 485,142" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M497,162L601,162L601,132L497,132Z" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<text x="549" y="147" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">select-stmt</text> | |
<g > | |
<path d="M601,147L637,147" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
<polygon points="637,147 626,151 626,142" style="fill:rgb(0,0,0)"/> | |
</g> | |
<path d="M637,147 L 674,147 Q 689,147 689,162 L 689,200 Q 689,215 696,215 L 704,215" fill="none" style="stroke-width:2.16;stroke:rgb(0,0,0);" /> | |
</svg> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment