sample/postgres/public.comment_stars.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">
<!-- Generated by graphviz version 12.1.2 (20240928.0832)
 -->
<!-- Title: public.comment_stars Pages: 1 -->
<svg width="1044pt" height="1068pt"
 viewBox="0.00 0.00 1044.06 1068.00" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 1064)">
<title>public.comment_stars</title>
<polygon fill="white" stroke="none" points="-4,4 -4,-1064 1040.06,-1064 1040.06,4 -4,4"/>
<!-- public.comment_stars -->
<g id="node1" class="node">
<title>public.comment_stars</title>
<polygon fill="#efefef" stroke="none" points="454.04,-604.6 454.04,-640.2 750.99,-640.2 750.99,-604.6 454.04,-604.6"/>
<polygon fill="none" stroke="black" points="454.04,-604.6 454.04,-640.2 750.99,-640.2 750.99,-604.6 454.04,-604.6"/>
<text text-anchor="start" x="461.04" y="-618" font-family="Arial Bold" font-size="18.00">public.comment_stars</text>
<text text-anchor="start" x="619.5" y="-618" font-family="Arial" font-size="14.00">    </text>
<text text-anchor="start" x="650.62" y="-618" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="black" points="454.04,-573.8 454.04,-604.6 750.99,-604.6 750.99,-573.8 454.04,-573.8"/>
<text text-anchor="start" x="461.04" y="-586" font-family="Arial" font-size="14.00">id </text>
<text text-anchor="start" x="475.82" y="-586" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="black" points="454.04,-543 454.04,-573.8 750.99,-573.8 750.99,-543 454.04,-543"/>
<text text-anchor="start" x="461.04" y="-555.2" font-family="Arial" font-size="14.00">user_id </text>
<text text-anchor="start" x="510.84" y="-555.2" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="454.04,-512.2 454.04,-543 750.99,-543 750.99,-512.2 454.04,-512.2"/>
<text text-anchor="start" x="461.04" y="-524.4" font-family="Arial" font-size="14.00">comment_post_id </text>
<text text-anchor="start" x="575.43" y="-524.4" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="454.04,-481.4 454.04,-512.2 750.99,-512.2 750.99,-481.4 454.04,-481.4"/>
<text text-anchor="start" x="461.04" y="-493.6" font-family="Arial" font-size="14.00">comment_user_id </text>
<text text-anchor="start" x="576.2" y="-493.6" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="454.04,-450.6 454.04,-481.4 750.99,-481.4 750.99,-450.6 454.04,-450.6"/>
<text text-anchor="start" x="461.04" y="-462.8" font-family="Arial" font-size="14.00">created </text>
<text text-anchor="start" x="511.62" y="-462.8" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="black" points="454.04,-419.8 454.04,-450.6 750.99,-450.6 750.99,-419.8 454.04,-419.8"/>
<text text-anchor="start" x="461.04" y="-432" font-family="Arial" font-size="14.00">updated </text>
<text text-anchor="start" x="515.53" y="-432" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="black" stroke-width="3" points="452.54,-418.3 452.54,-641.7 752.49,-641.7 752.49,-418.3 452.54,-418.3"/>
</g>
<!-- public.comments -->
<g id="node3" class="node">
<title>public.comments</title>
<polygon fill="#efefef" stroke="none" points="290.53,-258.8 290.53,-294.4 552.5,-294.4 552.5,-258.8 290.53,-258.8"/>
<polygon fill="none" stroke="black" points="290.53,-258.8 290.53,-294.4 552.5,-294.4 552.5,-258.8 290.53,-258.8"/>
<text text-anchor="start" x="297.53" y="-272.2" font-family="Arial Bold" font-size="18.00">public.comments</text>
<text text-anchor="start" x="421.01" y="-272.2" font-family="Arial" font-size="14.00">    </text>
<text text-anchor="start" x="452.13" y="-272.2" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="black" points="290.53,-228 290.53,-258.8 552.5,-258.8 552.5,-228 290.53,-228"/>
<text text-anchor="start" x="297.53" y="-240.2" font-family="Arial" font-size="14.00">id </text>
<text text-anchor="start" x="312.32" y="-240.2" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="290.53,-197.2 290.53,-228 552.5,-228 552.5,-197.2 290.53,-197.2"/>
<text text-anchor="start" x="297.53" y="-209.4" font-family="Arial" font-size="14.00">post_id </text>
<text text-anchor="start" x="346.57" y="-209.4" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="290.53,-166.4 290.53,-197.2 552.5,-197.2 552.5,-166.4 290.53,-166.4"/>
<text text-anchor="start" x="297.53" y="-178.6" font-family="Arial" font-size="14.00">user_id </text>
<text text-anchor="start" x="347.34" y="-178.6" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="290.53,-135.6 290.53,-166.4 552.5,-166.4 552.5,-135.6 290.53,-135.6"/>
<text text-anchor="start" x="297.53" y="-147.8" font-family="Arial" font-size="14.00">comment </text>
<text text-anchor="start" x="358.99" y="-147.8" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="black" points="290.53,-104.8 290.53,-135.6 552.5,-135.6 552.5,-104.8 290.53,-104.8"/>
<text text-anchor="start" x="297.53" y="-117" font-family="Arial" font-size="14.00">post_id_desc </text>
<text text-anchor="start" x="383.93" y="-117" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="290.53,-74 290.53,-104.8 552.5,-104.8 552.5,-74 290.53,-74"/>
<text text-anchor="start" x="297.53" y="-86.2" font-family="Arial" font-size="14.00">created </text>
<text text-anchor="start" x="348.12" y="-86.2" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="black" points="290.53,-43.2 290.53,-74 552.5,-74 552.5,-43.2 290.53,-43.2"/>
<text text-anchor="start" x="297.53" y="-55.4" font-family="Arial" font-size="14.00">updated </text>
<text text-anchor="start" x="352.03" y="-55.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
</g>
<!-- public.comment_stars&#45;&gt;public.comments -->
<g id="edge2" class="edge">
<title>public.comment_stars:comment_post_id&#45;&gt;public.comments:post_id</title>
<path fill="none" stroke="black" d="M442.68,-526.74C387.91,-517 416.79,-426.51 454.04,-373.6 480.86,-335.5 525.65,-375.68 552.5,-337.6 584.51,-292.19 609.06,-212.6 553.5,-212.6"/>
<polygon fill="black" stroke="black" points="442.74,-526.75 452.33,-532.06 448.06,-527.19 452.37,-527.54 452.37,-527.54 452.37,-527.54 448.06,-527.19 453.08,-523.09 442.74,-526.75"/>
<text text-anchor="start" x="7" y="-537.6" font-family="Arial" font-size="10.00">FOREIGN KEY (comment_post_id, comment_user_id) REFERENCES comments(post_id, user_id)</text>
</g>
<!-- public.users -->
<g id="node4" class="node">
<title>public.users</title>
<polygon fill="#efefef" stroke="none" points="656.68,-243.4 656.68,-279 910.36,-279 910.36,-243.4 656.68,-243.4"/>
<polygon fill="none" stroke="black" points="656.68,-243.4 656.68,-279 910.36,-279 910.36,-243.4 656.68,-243.4"/>
<text text-anchor="start" x="678.03" y="-256.8" font-family="Arial Bold" font-size="18.00">public.users</text>
<text text-anchor="start" x="764.51" y="-256.8" font-family="Arial" font-size="14.00">    </text>
<text text-anchor="start" x="795.63" y="-256.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="black" points="656.68,-212.6 656.68,-243.4 910.36,-243.4 910.36,-212.6 656.68,-212.6"/>
<text text-anchor="start" x="663.68" y="-224.8" font-family="Arial" font-size="14.00">id </text>
<text text-anchor="start" x="678.46" y="-224.8" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="656.68,-181.8 656.68,-212.6 910.36,-212.6 910.36,-181.8 656.68,-181.8"/>
<text text-anchor="start" x="663.68" y="-194" font-family="Arial" font-size="14.00">username </text>
<text text-anchor="start" x="729.82" y="-194" font-family="Arial" font-size="14.00" fill="#666666">[varchar(50)]</text>
<polygon fill="none" stroke="black" points="656.68,-151 656.68,-181.8 910.36,-181.8 910.36,-151 656.68,-151"/>
<text text-anchor="start" x="663.68" y="-163.2" font-family="Arial" font-size="14.00">password </text>
<text text-anchor="start" x="727.48" y="-163.2" font-family="Arial" font-size="14.00" fill="#666666">[varchar(50)]</text>
<polygon fill="none" stroke="black" points="656.68,-120.2 656.68,-151 910.36,-151 910.36,-120.2 656.68,-120.2"/>
<text text-anchor="start" x="663.68" y="-132.4" font-family="Arial" font-size="14.00">email </text>
<text text-anchor="start" x="701.02" y="-132.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(355)]</text>
<polygon fill="none" stroke="black" points="656.68,-89.4 656.68,-120.2 910.36,-120.2 910.36,-89.4 656.68,-89.4"/>
<text text-anchor="start" x="663.68" y="-101.6" font-family="Arial" font-size="14.00">created </text>
<text text-anchor="start" x="714.26" y="-101.6" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="black" points="656.68,-58.6 656.68,-89.4 910.36,-89.4 910.36,-58.6 656.68,-58.6"/>
<text text-anchor="start" x="663.68" y="-70.8" font-family="Arial" font-size="14.00">updated </text>
<text text-anchor="start" x="718.17" y="-70.8" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
</g>
<!-- public.comment_stars&#45;&gt;public.users -->
<g id="edge3" class="edge">
<title>public.comment_stars:comment_user_id&#45;&gt;public.users:id</title>
<path fill="none" stroke="black" d="M762.35,-495.71C802.87,-486.22 777.17,-417.26 750.99,-373.6 726.45,-332.65 681.27,-363.12 656.68,-322.2 635.11,-286.31 613.81,-228 655.68,-228"/>
<polygon fill="black" stroke="black" points="762.27,-495.71 751.85,-492.29 756.97,-496.27 752.66,-496.73 752.66,-496.73 752.66,-496.73 756.97,-496.27 752.8,-501.24 762.27,-495.71"/>
<text text-anchor="start" x="758.99" y="-506.8" font-family="Arial" font-size="10.00">FOREIGN KEY (comment_user_id) REFERENCES users(id)</text>
</g>
<!-- public.logs -->
<g id="node2" class="node">
<title>public.logs</title>
<polygon fill="#efefef" stroke="none" points="477.63,-981.2 477.63,-1016.8 727.4,-1016.8 727.4,-981.2 477.63,-981.2"/>
<polygon fill="none" stroke="black" points="477.63,-981.2 477.63,-1016.8 727.4,-1016.8 727.4,-981.2 477.63,-981.2"/>
<text text-anchor="start" x="500.52" y="-994.6" font-family="Arial Bold" font-size="18.00">public.logs</text>
<text text-anchor="start" x="580.02" y="-994.6" font-family="Arial" font-size="14.00">    </text>
<text text-anchor="start" x="611.14" y="-994.6" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="black" points="477.63,-950.4 477.63,-981.2 727.4,-981.2 727.4,-950.4 477.63,-950.4"/>
<text text-anchor="start" x="484.63" y="-962.6" font-family="Arial" font-size="14.00">id </text>
<text text-anchor="start" x="499.42" y="-962.6" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="black" points="477.63,-919.6 477.63,-950.4 727.4,-950.4 727.4,-919.6 477.63,-919.6"/>
<text text-anchor="start" x="484.63" y="-931.8" font-family="Arial" font-size="14.00">user_id </text>
<text text-anchor="start" x="534.44" y="-931.8" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="477.63,-888.8 477.63,-919.6 727.4,-919.6 727.4,-888.8 477.63,-888.8"/>
<text text-anchor="start" x="484.63" y="-901" font-family="Arial" font-size="14.00">post_id </text>
<text text-anchor="start" x="533.66" y="-901" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="477.63,-858 477.63,-888.8 727.4,-888.8 727.4,-858 477.63,-858"/>
<text text-anchor="start" x="484.63" y="-870.2" font-family="Arial" font-size="14.00">comment_id </text>
<text text-anchor="start" x="564.77" y="-870.2" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="477.63,-827.2 477.63,-858 727.4,-858 727.4,-827.2 477.63,-827.2"/>
<text text-anchor="start" x="484.63" y="-839.4" font-family="Arial" font-size="14.00">comment_star_id </text>
<text text-anchor="start" x="595.9" y="-839.4" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="black" points="477.63,-796.4 477.63,-827.2 727.4,-827.2 727.4,-796.4 477.63,-796.4"/>
<text text-anchor="start" x="484.63" y="-808.6" font-family="Arial" font-size="14.00">payload </text>
<text text-anchor="start" x="537.56" y="-808.6" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="black" points="477.63,-765.6 477.63,-796.4 727.4,-796.4 727.4,-765.6 477.63,-765.6"/>
<text text-anchor="start" x="484.63" y="-777.8" font-family="Arial" font-size="14.00">created </text>
<text text-anchor="start" x="535.22" y="-777.8" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
</g>
<!-- public.logs&#45;&gt;public.comment_stars -->
<g id="edge1" class="edge">
<title>public.logs:comment_star_id&#45;&gt;public.comment_stars:id</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M738.74,-841.87C842.85,-827.01 861.57,-589.2 751.99,-589.2"/>
<polygon fill="black" stroke="black" points="738.71,-841.88 728.42,-838.09 733.39,-842.25 729.07,-842.55 729.07,-842.55 729.07,-842.55 733.39,-842.25 729.05,-847.07 738.71,-841.88"/>
<text text-anchor="start" x="735.4" y="-852.6" font-family="Arial" font-size="10.00">Additional Relation</text>
</g>
</g>
</svg>