img/example-distance-1-from-articles.svg

<?xml version="1.0" encoding="UTF-8" standalone="no"?><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" contentScriptType="application/ecmascript" contentStyleType="text/css" height="405px" preserveAspectRatio="none" style="width:928px;height:405px;" version="1.1" viewBox="0 0 928 405" width="928px" zoomAndPan="magnify"><defs><filter height="300%" id="f70r2hcguqn91" width="300%" x="-1" y="-1"><feGaussianBlur result="blurOut" stdDeviation="2.0"/><feColorMatrix in="blurOut" result="blurOut2" type="matrix" values="0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .4 0"/><feOffset dx="4.0" dy="4.0" in="blurOut2" result="blurOut3"/><feBlend in="SourceGraphic" in2="blurOut3" mode="normal"/></filter></defs><g><!--MD5=[79d8edbcc1568d03c30ea71d2d6556d3]
class articles--><rect fill="#F8F8F8" filter="url(#f70r2hcguqn91)" height="94.4141" id="articles" style="stroke: #383838; stroke-width: 1.5;" width="217" x="379" y="167"/><ellipse cx="460.25" cy="183" fill="#C2C2C2" rx="11" ry="11" style="stroke: #383838; stroke-width: 1.0;"/><path d="M459.0469,183.875 L460.5,183.875 L460.5,183.9844 C460.5,184.3906 460.5313,184.5469 460.6094,184.7031 C460.7656,184.9531 461.0469,185.1094 461.3438,185.1094 C461.5938,185.1094 461.8594,184.9688 462.0156,184.75 C462.1406,184.5938 462.1719,184.4375 462.1719,183.9844 L462.1719,182.0625 C462.1719,181.9063 462.1719,181.8594 462.1563,181.7031 C462.0938,181.2344 461.7813,180.9219 461.3281,180.9219 C461.0781,180.9219 460.8125,181.0625 460.6406,181.2813 C460.5313,181.4531 460.5,181.6094 460.5,182.0625 L460.5,182.1875 L459.0469,182.1875 L459.0469,179.7813 L463.0313,179.7813 L463.0313,180.6406 C463.0313,181.0469 463.0625,181.2188 463.1406,181.375 C463.3125,181.625 463.5938,181.7813 463.875,181.7813 C464.1406,181.7813 464.4063,181.6406 464.5781,181.4219 C464.6875,181.25 464.7188,181.1094 464.7188,180.6406 L464.7188,178.0938 L457.0938,178.0938 C456.6563,178.0938 456.5313,178.1094 456.375,178.2031 C456.125,178.3594 455.9688,178.6563 455.9688,178.9375 C455.9688,179.2188 456.1094,179.4688 456.3281,179.6406 C456.4844,179.75 456.6719,179.7813 457.0938,179.7813 L457.3438,179.7813 L457.3438,186.2969 L457.0938,186.2969 C456.6875,186.2969 456.5313,186.3125 456.375,186.4219 C456.125,186.5938 455.9688,186.8594 455.9688,187.1563 C455.9688,187.4219 456.1094,187.6719 456.3281,187.8281 C456.4688,187.9531 456.7031,188 457.0938,188 L465.0938,188 L465.0938,185.4219 C465.0938,184.9844 465.0625,184.8438 464.9844,184.6875 C464.8125,184.4375 464.5313,184.2813 464.25,184.2813 C463.9844,184.2813 463.7188,184.3906 463.5469,184.6406 C463.4375,184.7969 463.4063,184.9375 463.4063,185.4219 L463.4063,186.2969 L459.0469,186.2969 L459.0469,183.875 Z "/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="46" x="480.75" y="187.1543">articles</text><line style="stroke: #383838; stroke-width: 1.5;" x1="380" x2="595" y1="199" y2="199"/><ellipse cx="390" cy="210" fill="#000000" rx="3" ry="3" style="stroke: #000000; stroke-width: 1.0;"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="63" x="399" y="213.2104">id : integer</text><line style="stroke: #383838; stroke-width: 1.0;" x1="380" x2="595" y1="219.8047" y2="219.8047"/><ellipse cx="390" cy="230.8047" fill="#000000" rx="3" ry="3" style="stroke: #000000; stroke-width: 1.0;"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="96" x="399" y="234.0151">user_id : integer</text><line style="stroke: #383838; stroke-width: 1.0;" x1="380" x2="595" y1="240.6094" y2="240.6094"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="205" x="385" y="254.8198">index_user_id_on_articles (user_id)</text><!--MD5=[ffea0c25cc794db9280a5614eef8b091]
class comments--><rect fill="#F8F8F8" filter="url(#f70r2hcguqn91)" height="94.4141" id="comments" style="stroke: #383838; stroke-width: 1.5;" width="235" x="6" y="10.5"/><ellipse cx="87.25" cy="26.5" fill="#C2C2C2" rx="11" ry="11" style="stroke: #383838; stroke-width: 1.0;"/><path d="M86.0469,27.375 L87.5,27.375 L87.5,27.4844 C87.5,27.8906 87.5313,28.0469 87.6094,28.2031 C87.7656,28.4531 88.0469,28.6094 88.3438,28.6094 C88.5938,28.6094 88.8594,28.4688 89.0156,28.25 C89.1406,28.0938 89.1719,27.9375 89.1719,27.4844 L89.1719,25.5625 C89.1719,25.4063 89.1719,25.3594 89.1563,25.2031 C89.0938,24.7344 88.7813,24.4219 88.3281,24.4219 C88.0781,24.4219 87.8125,24.5625 87.6406,24.7813 C87.5313,24.9531 87.5,25.1094 87.5,25.5625 L87.5,25.6875 L86.0469,25.6875 L86.0469,23.2813 L90.0313,23.2813 L90.0313,24.1406 C90.0313,24.5469 90.0625,24.7188 90.1406,24.875 C90.3125,25.125 90.5938,25.2813 90.875,25.2813 C91.1406,25.2813 91.4063,25.1406 91.5781,24.9219 C91.6875,24.75 91.7188,24.6094 91.7188,24.1406 L91.7188,21.5938 L84.0938,21.5938 C83.6563,21.5938 83.5313,21.6094 83.375,21.7031 C83.125,21.8594 82.9688,22.1563 82.9688,22.4375 C82.9688,22.7188 83.1094,22.9688 83.3281,23.1406 C83.4844,23.25 83.6719,23.2813 84.0938,23.2813 L84.3438,23.2813 L84.3438,29.7969 L84.0938,29.7969 C83.6875,29.7969 83.5313,29.8125 83.375,29.9219 C83.125,30.0938 82.9688,30.3594 82.9688,30.6563 C82.9688,30.9219 83.1094,31.1719 83.3281,31.3281 C83.4688,31.4531 83.7031,31.5 84.0938,31.5 L92.0938,31.5 L92.0938,28.9219 C92.0938,28.4844 92.0625,28.3438 91.9844,28.1875 C91.8125,27.9375 91.5313,27.7813 91.25,27.7813 C90.9844,27.7813 90.7188,27.8906 90.5469,28.1406 C90.4375,28.2969 90.4063,28.4375 90.4063,28.9219 L90.4063,29.7969 L86.0469,29.7969 L86.0469,27.375 Z "/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="64" x="107.75" y="30.6543">comments</text><line style="stroke: #383838; stroke-width: 1.5;" x1="7" x2="240" y1="42.5" y2="42.5"/><ellipse cx="17" cy="53.5" fill="#000000" rx="3" ry="3" style="stroke: #000000; stroke-width: 1.0;"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="63" x="26" y="56.7104">id : integer</text><line style="stroke: #383838; stroke-width: 1.0;" x1="7" x2="240" y1="63.3047" y2="63.3047"/><ellipse cx="17" cy="74.3047" fill="#000000" rx="3" ry="3" style="stroke: #000000; stroke-width: 1.0;"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="105" x="26" y="77.5151">article_id : integer</text><line style="stroke: #383838; stroke-width: 1.0;" x1="7" x2="240" y1="84.1094" y2="84.1094"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="223" x="12" y="98.3198">index_article_id_on_articles (article_id)</text><!--MD5=[b71691ed90354d79c1e3bc54a90e3196]
class likes--><rect fill="#F8F8F8" filter="url(#f70r2hcguqn91)" height="99.2188" id="likes" style="stroke: #383838; stroke-width: 1.5;" width="359" x="558" y="8"/><ellipse cx="719.25" cy="24" fill="#C2C2C2" rx="11" ry="11" style="stroke: #383838; stroke-width: 1.0;"/><path d="M718.0469,24.875 L719.5,24.875 L719.5,24.9844 C719.5,25.3906 719.5313,25.5469 719.6094,25.7031 C719.7656,25.9531 720.0469,26.1094 720.3438,26.1094 C720.5938,26.1094 720.8594,25.9688 721.0156,25.75 C721.1406,25.5938 721.1719,25.4375 721.1719,24.9844 L721.1719,23.0625 C721.1719,22.9063 721.1719,22.8594 721.1563,22.7031 C721.0938,22.2344 720.7813,21.9219 720.3281,21.9219 C720.0781,21.9219 719.8125,22.0625 719.6406,22.2813 C719.5313,22.4531 719.5,22.6094 719.5,23.0625 L719.5,23.1875 L718.0469,23.1875 L718.0469,20.7813 L722.0313,20.7813 L722.0313,21.6406 C722.0313,22.0469 722.0625,22.2188 722.1406,22.375 C722.3125,22.625 722.5938,22.7813 722.875,22.7813 C723.1406,22.7813 723.4063,22.6406 723.5781,22.4219 C723.6875,22.25 723.7188,22.1094 723.7188,21.6406 L723.7188,19.0938 L716.0938,19.0938 C715.6563,19.0938 715.5313,19.1094 715.375,19.2031 C715.125,19.3594 714.9688,19.6563 714.9688,19.9375 C714.9688,20.2188 715.1094,20.4688 715.3281,20.6406 C715.4844,20.75 715.6719,20.7813 716.0938,20.7813 L716.3438,20.7813 L716.3438,27.2969 L716.0938,27.2969 C715.6875,27.2969 715.5313,27.3125 715.375,27.4219 C715.125,27.5938 714.9688,27.8594 714.9688,28.1563 C714.9688,28.4219 715.1094,28.6719 715.3281,28.8281 C715.4688,28.9531 715.7031,29 716.0938,29 L724.0938,29 L724.0938,26.4219 C724.0938,25.9844 724.0625,25.8438 723.9844,25.6875 C723.8125,25.4375 723.5313,25.2813 723.25,25.2813 C722.9844,25.2813 722.7188,25.3906 722.5469,25.6406 C722.4375,25.7969 722.4063,25.9375 722.4063,26.4219 L722.4063,27.2969 L718.0469,27.2969 L718.0469,24.875 Z "/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="28" x="739.75" y="28.1543">likes</text><line style="stroke: #383838; stroke-width: 1.5;" x1="559" x2="916" y1="40" y2="40"/><ellipse cx="569" cy="51" fill="#000000" rx="3" ry="3" style="stroke: #000000; stroke-width: 1.0;"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="105" x="578" y="54.2104">article_id : integer</text><ellipse cx="569" cy="63.8047" fill="#000000" rx="3" ry="3" style="stroke: #000000; stroke-width: 1.0;"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="96" x="578" y="67.0151">user_id : integer</text><line style="stroke: #383838; stroke-width: 1.0;" x1="559" x2="916" y1="73.6094" y2="73.6094"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="189" x="578" y="87.8198">index_user_id_on_likes (user_id)</text><rect fill="#808080" height="6" style="stroke: #595959; stroke-width: 1.0;" width="6" x="566" y="94.4141"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="333" x="578" y="100.6245">index_article_id_and_user_id_on_likes (article_id, user_id)</text><!--MD5=[b2d851ba367528962b4efddfd4662824]
class revisions--><rect fill="#F8F8F8" filter="url(#f70r2hcguqn91)" height="94.4141" id="revisions" style="stroke: #383838; stroke-width: 1.5;" width="246" x="276.5" y="10.5"/><ellipse cx="367.75" cy="26.5" fill="#C2C2C2" rx="11" ry="11" style="stroke: #383838; stroke-width: 1.0;"/><path d="M366.5469,27.375 L368,27.375 L368,27.4844 C368,27.8906 368.0313,28.0469 368.1094,28.2031 C368.2656,28.4531 368.5469,28.6094 368.8438,28.6094 C369.0938,28.6094 369.3594,28.4688 369.5156,28.25 C369.6406,28.0938 369.6719,27.9375 369.6719,27.4844 L369.6719,25.5625 C369.6719,25.4063 369.6719,25.3594 369.6563,25.2031 C369.5938,24.7344 369.2813,24.4219 368.8281,24.4219 C368.5781,24.4219 368.3125,24.5625 368.1406,24.7813 C368.0313,24.9531 368,25.1094 368,25.5625 L368,25.6875 L366.5469,25.6875 L366.5469,23.2813 L370.5313,23.2813 L370.5313,24.1406 C370.5313,24.5469 370.5625,24.7188 370.6406,24.875 C370.8125,25.125 371.0938,25.2813 371.375,25.2813 C371.6406,25.2813 371.9063,25.1406 372.0781,24.9219 C372.1875,24.75 372.2188,24.6094 372.2188,24.1406 L372.2188,21.5938 L364.5938,21.5938 C364.1563,21.5938 364.0313,21.6094 363.875,21.7031 C363.625,21.8594 363.4688,22.1563 363.4688,22.4375 C363.4688,22.7188 363.6094,22.9688 363.8281,23.1406 C363.9844,23.25 364.1719,23.2813 364.5938,23.2813 L364.8438,23.2813 L364.8438,29.7969 L364.5938,29.7969 C364.1875,29.7969 364.0313,29.8125 363.875,29.9219 C363.625,30.0938 363.4688,30.3594 363.4688,30.6563 C363.4688,30.9219 363.6094,31.1719 363.8281,31.3281 C363.9688,31.4531 364.2031,31.5 364.5938,31.5 L372.5938,31.5 L372.5938,28.9219 C372.5938,28.4844 372.5625,28.3438 372.4844,28.1875 C372.3125,27.9375 372.0313,27.7813 371.75,27.7813 C371.4844,27.7813 371.2188,27.8906 371.0469,28.1406 C370.9375,28.2969 370.9063,28.4375 370.9063,28.9219 L370.9063,29.7969 L366.5469,29.7969 L366.5469,27.375 Z "/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="55" x="388.25" y="30.6543">revisions</text><line style="stroke: #383838; stroke-width: 1.5;" x1="277.5" x2="521.5" y1="42.5" y2="42.5"/><ellipse cx="287.5" cy="53.5" fill="#000000" rx="3" ry="3" style="stroke: #000000; stroke-width: 1.0;"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="63" x="296.5" y="56.7104">id : integer</text><line style="stroke: #383838; stroke-width: 1.0;" x1="277.5" x2="521.5" y1="63.3047" y2="63.3047"/><ellipse cx="287.5" cy="74.3047" fill="#000000" rx="3" ry="3" style="stroke: #000000; stroke-width: 1.0;"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="105" x="296.5" y="77.5151">article_id : integer</text><line style="stroke: #383838; stroke-width: 1.0;" x1="277.5" x2="521.5" y1="84.1094" y2="84.1094"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="234" x="282.5" y="98.3198">index_article_id_on_revisions (article_id)</text><!--MD5=[8413f8248b2da7966d2de021109ec289]
class users--><rect fill="#F8F8F8" filter="url(#f70r2hcguqn91)" height="73.6094" id="users" style="stroke: #383838; stroke-width: 1.5;" width="89" x="546" y="321"/><ellipse cx="571.35" cy="337" fill="#C2C2C2" rx="11" ry="11" style="stroke: #383838; stroke-width: 1.0;"/><path d="M570.1469,337.875 L571.6,337.875 L571.6,337.9844 C571.6,338.3906 571.6313,338.5469 571.7094,338.7031 C571.8656,338.9531 572.1469,339.1094 572.4438,339.1094 C572.6938,339.1094 572.9594,338.9688 573.1156,338.75 C573.2406,338.5938 573.2719,338.4375 573.2719,337.9844 L573.2719,336.0625 C573.2719,335.9063 573.2719,335.8594 573.2563,335.7031 C573.1938,335.2344 572.8813,334.9219 572.4281,334.9219 C572.1781,334.9219 571.9125,335.0625 571.7406,335.2813 C571.6313,335.4531 571.6,335.6094 571.6,336.0625 L571.6,336.1875 L570.1469,336.1875 L570.1469,333.7813 L574.1313,333.7813 L574.1313,334.6406 C574.1313,335.0469 574.1625,335.2188 574.2406,335.375 C574.4125,335.625 574.6938,335.7813 574.975,335.7813 C575.2406,335.7813 575.5063,335.6406 575.6781,335.4219 C575.7875,335.25 575.8188,335.1094 575.8188,334.6406 L575.8188,332.0938 L568.1938,332.0938 C567.7563,332.0938 567.6313,332.1094 567.475,332.2031 C567.225,332.3594 567.0688,332.6563 567.0688,332.9375 C567.0688,333.2188 567.2094,333.4688 567.4281,333.6406 C567.5844,333.75 567.7719,333.7813 568.1938,333.7813 L568.4438,333.7813 L568.4438,340.2969 L568.1938,340.2969 C567.7875,340.2969 567.6313,340.3125 567.475,340.4219 C567.225,340.5938 567.0688,340.8594 567.0688,341.1563 C567.0688,341.4219 567.2094,341.6719 567.4281,341.8281 C567.5688,341.9531 567.8031,342 568.1938,342 L576.1938,342 L576.1938,339.4219 C576.1938,338.9844 576.1625,338.8438 576.0844,338.6875 C575.9125,338.4375 575.6313,338.2813 575.35,338.2813 C575.0844,338.2813 574.8188,338.3906 574.6469,338.6406 C574.5375,338.7969 574.5063,338.9375 574.5063,339.4219 L574.5063,340.2969 L570.1469,340.2969 L570.1469,337.875 Z "/><text fill="#000000" font-family="sans-serif" font-size="12" lengthAdjust="spacingAndGlyphs" textLength="34" x="587.65" y="341.1543">users</text><line style="stroke: #383838; stroke-width: 1.5;" x1="547" x2="634" y1="353" y2="353"/><ellipse cx="557" cy="364" fill="#000000" rx="3" ry="3" style="stroke: #000000; stroke-width: 1.0;"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="63" x="566" y="367.2104">id : integer</text><line style="stroke: #383838; stroke-width: 1.0;" x1="547" x2="634" y1="373.8047" y2="373.8047"/><text fill="#000000" font-family="sans-serif" font-size="11" lengthAdjust="spacingAndGlyphs" textLength="67" x="552" y="388.0151">name : text</text><!--MD5=[ecdc84a09e61f5b87dd8dadf07c1ea39]
reverse link articles to users--><path d="M525.932,267.984 C538.635,285.497 552.474,304.5758 564.07,320.5626 " fill="none" id="articles&lt;-users" style="stroke: #383838; stroke-width: 1.0;"/><line style="stroke: #383838; stroke-width: 1.0;" x1="525.6382" x2="514.4652" y1="267.5788" y2="261.103"/><line style="stroke: #383838; stroke-width: 1.0;" x1="525.6382" x2="527.4168" y1="267.5788" y2="261.103"/><line style="stroke: #383838; stroke-width: 1.0;" x1="525.6382" x2="520.941" y1="267.5788" y2="261.103"/><!--MD5=[90b56babdbe2f4ab8c94b1a17f365ddd]
reverse link comments to articles--><path d="M239.621,107.788 C284.298,126.751 335.098,148.313 379.027,166.959 " fill="none" id="comments&lt;-articles" style="stroke: #383838; stroke-width: 1.0;"/><line style="stroke: #383838; stroke-width: 1.0;" x1="239.5831" x2="229.0934" y1="107.7716" y2="104.646"/><line style="stroke: #383838; stroke-width: 1.0;" x1="239.5831" x2="235.3446" y1="107.7716" y2="104.646"/><line style="stroke: #383838; stroke-width: 1.0;" x1="239.5831" x2="232.219" y1="107.7716" y2="104.646"/><!--MD5=[7ab8a6299fe6b442d79d1fe586d3c28f]
reverse link likes to users--><path d="M710.015,114.311 C680.286,174.68 633.754,269.168 608.414,320.6243 " fill="none" id="likes&lt;-users" style="stroke: #383838; stroke-width: 1.0;"/><line style="stroke: #383838; stroke-width: 1.0;" x1="710.0196" x2="706.3786" y1="114.3004" y2="107.124"/><line style="stroke: #383838; stroke-width: 1.0;" x1="710.0196" x2="720.7314" y1="114.3004" y2="107.124"/><line style="stroke: #383838; stroke-width: 1.0;" x1="710.0196" x2="713.555" y1="114.3004" y2="107.124"/><!--MD5=[f0d4c0f9102afa637cc4f9edbe58e2fc]
reverse link likes to articles--><path d="M651.789,111.469 C622.612,129.501 590.256,149.497 562.027,166.942 " fill="none" id="likes&lt;-articles" style="stroke: #383838; stroke-width: 1.0;"/><line style="stroke: #383838; stroke-width: 1.0;" x1="651.937" x2="654.5358" y1="111.3792" y2="107.173"/><line style="stroke: #383838; stroke-width: 1.0;" x1="651.937" x2="662.9482" y1="111.3792" y2="107.173"/><line style="stroke: #383838; stroke-width: 1.0;" x1="651.937" x2="658.742" y1="111.3792" y2="107.173"/><!--MD5=[ab74b54eeecbe98acac434dc1c2be725]
reverse link revisions to articles--><path d="M429.905,111.882 C440.115,129.806 451.406,149.631 461.267,166.944 " fill="none" id="revisions&lt;-articles" style="stroke: #383838; stroke-width: 1.0;"/><line style="stroke: #383838; stroke-width: 1.0;" x1="429.8618" x2="418.9512" y1="111.8068" y2="104.855"/><line style="stroke: #383838; stroke-width: 1.0;" x1="429.8618" x2="432.8548" y1="111.8068" y2="104.855"/><line style="stroke: #383838; stroke-width: 1.0;" x1="429.8618" x2="425.903" y1="111.8068" y2="104.855"/></g></svg>