Personal blog written from scratch using Node.js, Bootstrap, and MySQL. https://jrtechs.net
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 

74 lines
8.4 KiB

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.0//EN" "http://www.w3.org/TR/2001/PR-SVG-20010719/DTD/svg10.dtd">
<svg width="21cm" height="13cm" viewBox="285 419 417 260" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g>
<rect style="fill: #ffffff" x="285" y="419" width="180" height="18"/>
<rect style="fill: none; fill-opacity:0; stroke-width: 2; stroke: #000000" x="285" y="419" width="180" height="18"/>
<text font-size="11.2" style="fill: #000000;text-anchor:middle;font-family:sans-serif;font-style:normal;font-weight:700" x="375" y="433">users</text>
<rect style="fill: #ffffff" x="285" y="437" width="180" height="68"/>
<rect style="fill: none; fill-opacity:0; stroke-width: 2; stroke: #000000" x="285" y="437" width="180" height="68"/>
<polygon style="fill: #000000" points="288,447 290,450 292,447 290,444 "/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="294" y="453">user_id</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="373.3" y="453">mediumint</text>
<line style="fill: none; fill-opacity:0; stroke-width: 1; stroke: #000000" x1="294" y1="454.6" x2="442.6" y2="454.6"/>
<ellipse style="fill: none; fill-opacity:0; stroke-width: 0.2; stroke: #000000" cx="290" cy="463" rx="2" ry="2"/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="294" y="469">user_name</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="373.3" y="469">varchar(60)</text>
<ellipse style="fill: none; fill-opacity:0; stroke-width: 0.2; stroke: #000000" cx="290" cy="479" rx="2" ry="2"/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="294" y="485">password</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="373.3" y="485">char(64)</text>
<ellipse style="fill: none; fill-opacity:0; stroke-width: 0.2; stroke: #000000" cx="290" cy="495" rx="2" ry="2"/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="294" y="501">salt</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="373.3" y="501">char(64)</text>
</g>
<g>
<rect style="fill: #ffffff" x="506" y="419" width="195.4" height="18"/>
<rect style="fill: none; fill-opacity:0; stroke-width: 2; stroke: #000000" x="506" y="419" width="195.4" height="18"/>
<text font-size="11.2" style="fill: #000000;text-anchor:middle;font-family:sans-serif;font-style:normal;font-weight:700" x="603.7" y="433">categories</text>
<rect style="fill: #ffffff" x="506" y="437" width="195.4" height="52"/>
<rect style="fill: none; fill-opacity:0; stroke-width: 2; stroke: #000000" x="506" y="437" width="195.4" height="52"/>
<polygon style="fill: #000000" points="509,447 511,450 513,447 511,444 "/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="515" y="453">category_id</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="609.7" y="453">mediumint</text>
<line style="fill: none; fill-opacity:0; stroke-width: 1; stroke: #000000" x1="515" y1="454.6" x2="679" y2="454.6"/>
<ellipse style="fill: none; fill-opacity:0; stroke-width: 0.2; stroke: #000000" cx="511" cy="463" rx="2" ry="2"/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="515" y="469">name</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="609.7" y="469">varchar(60)</text>
<ellipse style="fill: none; fill-opacity:0; stroke-width: 0.2; stroke: #000000" cx="511" cy="479" rx="2" ry="2"/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="515" y="485">url</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="609.7" y="485">varchar(60)</text>
</g>
<g>
<rect style="fill: #ffffff" x="325" y="561" width="203.1" height="18"/>
<rect style="fill: none; fill-opacity:0; stroke-width: 2; stroke: #000000" x="325" y="561" width="203.1" height="18"/>
<text font-size="11.2" style="fill: #000000;text-anchor:middle;font-family:sans-serif;font-style:normal;font-weight:700" x="426.55" y="575">posts</text>
<rect style="fill: #ffffff" x="325" y="579" width="203.1" height="100"/>
<rect style="fill: none; fill-opacity:0; stroke-width: 2; stroke: #000000" x="325" y="579" width="203.1" height="100"/>
<polygon style="fill: #000000" points="328,589 330,592 332,589 330,586 "/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="334" y="595">post_id</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="428.7" y="595">mediumint</text>
<line style="fill: none; fill-opacity:0; stroke-width: 1; stroke: #000000" x1="334" y1="596.6" x2="498" y2="596.6"/>
<ellipse style="fill: none; fill-opacity:0; stroke-width: 0.2; stroke: #000000" cx="330" cy="605" rx="2" ry="2"/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="334" y="611">category_id</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="428.7" y="611">mediumint</text>
<ellipse style="fill: none; fill-opacity:0; stroke-width: 0.2; stroke: #000000" cx="330" cy="621" rx="2" ry="2"/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="334" y="627">picture_url</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="428.7" y="627">varchar(100)</text>
<ellipse style="fill: none; fill-opacity:0; stroke-width: 0.2; stroke: #000000" cx="330" cy="637" rx="2" ry="2"/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="334" y="643">published</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="428.7" y="643">datetime</text>
<ellipse style="fill: none; fill-opacity:0; stroke-width: 0.2; stroke: #000000" cx="330" cy="653" rx="2" ry="2"/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="334" y="659">name</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="428.7" y="659">varchar(100)</text>
<ellipse style="fill: none; fill-opacity:0; stroke-width: 0.2; stroke: #000000" cx="330" cy="669" rx="2" ry="2"/>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="334" y="675">url</text>
<text font-size="12.8" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="428.7" y="675">varchar(100)</text>
</g>
<g>
<polyline style="fill: none; fill-opacity:0; stroke-width: 2; stroke: #000000" points="528.1,605 548.1,605 548.1,526 486,526 486,447 496.264,447 "/>
<polygon style="fill: #000000" points="503.764,447 493.764,452 496.264,447 493.764,442 "/>
<polygon style="fill: none; fill-opacity:0; stroke-width: 2; stroke: #000000" points="503.764,447 493.764,452 496.264,447 493.764,442 "/>
<text font-size="9.59961" style="fill: #000000;text-anchor:start;font-family:monospace;font-style:normal;font-weight:normal" x="532.1" y="601">1</text>
<text font-size="9.59961" style="fill: #000000;text-anchor:end;font-family:monospace;font-style:normal;font-weight:normal" x="502" y="443">n</text>
</g>
</svg>