sample/postgres/public.comments.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.comments Pages: 1 -->
<svg width="869pt" height="1130pt"
 viewBox="0.00 0.00 868.82 1129.60" 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 1125.6)">
<title>public.comments</title>
<polygon fill="white" stroke="none" points="-4,4 -4,-1125.6 864.82,-1125.6 864.82,4 -4,4"/>
<!-- public.comments -->
<g id="node1" class="node">
<title>public.comments</title>
<polygon fill="#efefef" stroke="none" points="237.28,-666.2 237.28,-701.8 499.24,-701.8 499.24,-666.2 237.28,-666.2"/>
<polygon fill="none" stroke="black" points="237.28,-666.2 237.28,-701.8 499.24,-701.8 499.24,-666.2 237.28,-666.2"/>
<text text-anchor="start" x="244.28" y="-679.6" font-family="Arial Bold" font-size="18.00">public.comments</text>
<text text-anchor="start" x="367.75" y="-679.6" font-family="Arial" font-size="14.00">    </text>
<text text-anchor="start" x="398.87" y="-679.6" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="black" points="237.28,-635.4 237.28,-666.2 499.24,-666.2 499.24,-635.4 237.28,-635.4"/>
<text text-anchor="start" x="244.28" y="-647.6" font-family="Arial" font-size="14.00">id </text>
<text text-anchor="start" x="259.06" y="-647.6" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="237.28,-604.6 237.28,-635.4 499.24,-635.4 499.24,-604.6 237.28,-604.6"/>
<text text-anchor="start" x="244.28" y="-616.8" font-family="Arial" font-size="14.00">post_id </text>
<text text-anchor="start" x="293.31" y="-616.8" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="237.28,-573.8 237.28,-604.6 499.24,-604.6 499.24,-573.8 237.28,-573.8"/>
<text text-anchor="start" x="244.28" y="-586" font-family="Arial" font-size="14.00">user_id </text>
<text text-anchor="start" x="294.08" y="-586" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="237.28,-543 237.28,-573.8 499.24,-573.8 499.24,-543 237.28,-543"/>
<text text-anchor="start" x="244.28" y="-555.2" font-family="Arial" font-size="14.00">comment </text>
<text text-anchor="start" x="305.74" y="-555.2" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="black" points="237.28,-512.2 237.28,-543 499.24,-543 499.24,-512.2 237.28,-512.2"/>
<text text-anchor="start" x="244.28" y="-524.4" font-family="Arial" font-size="14.00">post_id_desc </text>
<text text-anchor="start" x="330.67" y="-524.4" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="237.28,-481.4 237.28,-512.2 499.24,-512.2 499.24,-481.4 237.28,-481.4"/>
<text text-anchor="start" x="244.28" y="-493.6" font-family="Arial" font-size="14.00">created </text>
<text text-anchor="start" x="294.86" y="-493.6" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="black" points="237.28,-450.6 237.28,-481.4 499.24,-481.4 499.24,-450.6 237.28,-450.6"/>
<text text-anchor="start" x="244.28" y="-462.8" font-family="Arial" font-size="14.00">updated </text>
<text text-anchor="start" x="298.77" y="-462.8" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="black" stroke-width="3" points="235.78,-449.1 235.78,-703.3 500.74,-703.3 500.74,-449.1 235.78,-449.1"/>
</g>
<!-- public.posts -->
<g id="node3" class="node">
<title>public.posts</title>
<polygon fill="#efefef" stroke="none" points="62.42,-289.6 62.42,-325.2 316.1,-325.2 316.1,-289.6 62.42,-289.6"/>
<polygon fill="none" stroke="black" points="62.42,-289.6 62.42,-325.2 316.1,-325.2 316.1,-289.6 62.42,-289.6"/>
<text text-anchor="start" x="83.76" y="-303" font-family="Arial Bold" font-size="18.00">public.posts</text>
<text text-anchor="start" x="170.27" y="-303" font-family="Arial" font-size="14.00">    </text>
<text text-anchor="start" x="201.38" y="-303" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="black" points="62.42,-258.8 62.42,-289.6 316.1,-289.6 316.1,-258.8 62.42,-258.8"/>
<text text-anchor="start" x="69.42" y="-271" font-family="Arial" font-size="14.00">id </text>
<text text-anchor="start" x="84.2" y="-271" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="62.42,-228 62.42,-258.8 316.1,-258.8 316.1,-228 62.42,-228"/>
<text text-anchor="start" x="69.42" y="-240.2" font-family="Arial" font-size="14.00">user_id </text>
<text text-anchor="start" x="119.22" y="-240.2" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="62.42,-197.2 62.42,-228 316.1,-228 316.1,-197.2 62.42,-197.2"/>
<text text-anchor="start" x="69.42" y="-209.4" font-family="Arial" font-size="14.00">title </text>
<text text-anchor="start" x="95.09" y="-209.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="black" points="62.42,-166.4 62.42,-197.2 316.1,-197.2 316.1,-166.4 62.42,-166.4"/>
<text text-anchor="start" x="69.42" y="-178.6" font-family="Arial" font-size="14.00">body </text>
<text text-anchor="start" x="103.67" y="-178.6" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="black" points="62.42,-135.6 62.42,-166.4 316.1,-166.4 316.1,-135.6 62.42,-135.6"/>
<text text-anchor="start" x="69.42" y="-147.8" font-family="Arial" font-size="14.00">post_type </text>
<text text-anchor="start" x="134.02" y="-147.8" font-family="Arial" font-size="14.00" fill="#666666">[post_types]</text>
<polygon fill="none" stroke="black" points="62.42,-104.8 62.42,-135.6 316.1,-135.6 316.1,-104.8 62.42,-104.8"/>
<text text-anchor="start" x="69.42" y="-117" font-family="Arial" font-size="14.00">labels </text>
<text text-anchor="start" x="109.89" y="-117" font-family="Arial" font-size="14.00" fill="#666666">[varchar(50)[]]</text>
<polygon fill="none" stroke="black" points="62.42,-74 62.42,-104.8 316.1,-104.8 316.1,-74 62.42,-74"/>
<text text-anchor="start" x="69.42" y="-86.2" font-family="Arial" font-size="14.00">created </text>
<text text-anchor="start" x="120" y="-86.2" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="black" points="62.42,-43.2 62.42,-74 316.1,-74 316.1,-43.2 62.42,-43.2"/>
<text text-anchor="start" x="69.42" y="-55.4" font-family="Arial" font-size="14.00">updated </text>
<text text-anchor="start" x="123.91" y="-55.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
</g>
<!-- public.comments&#45;&gt;public.posts -->
<g id="edge2" class="edge">
<title>public.comments:post_id&#45;&gt;public.posts:id</title>
<path fill="none" stroke="black" d="M225.93,-619.42C143.88,-609.79 187.26,-481.83 237.28,-404.4 258.17,-372.05 295.11,-400.69 316.1,-368.4 338.92,-333.3 358.97,-274.2 317.1,-274.2"/>
<polygon fill="black" stroke="black" points="225.96,-619.42 235.69,-624.47 231.28,-619.72 235.61,-619.96 235.61,-619.96 235.61,-619.96 231.28,-619.72 236.19,-615.49 225.96,-619.42"/>
<text text-anchor="start" x="7" y="-630" font-family="Arial" font-size="10.00">FOREIGN KEY (post_id) REFERENCES posts(id)</text>
</g>
<!-- public.users -->
<g id="node5" class="node">
<title>public.users</title>
<polygon fill="#efefef" stroke="none" points="420.42,-258.8 420.42,-294.4 674.1,-294.4 674.1,-258.8 420.42,-258.8"/>
<polygon fill="none" stroke="black" points="420.42,-258.8 420.42,-294.4 674.1,-294.4 674.1,-258.8 420.42,-258.8"/>
<text text-anchor="start" x="441.77" y="-272.2" font-family="Arial Bold" font-size="18.00">public.users</text>
<text text-anchor="start" x="528.26" y="-272.2" font-family="Arial" font-size="14.00">    </text>
<text text-anchor="start" x="559.37" y="-272.2" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="black" points="420.42,-228 420.42,-258.8 674.1,-258.8 674.1,-228 420.42,-228"/>
<text text-anchor="start" x="427.42" y="-240.2" font-family="Arial" font-size="14.00">id </text>
<text text-anchor="start" x="442.2" y="-240.2" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="420.42,-197.2 420.42,-228 674.1,-228 674.1,-197.2 420.42,-197.2"/>
<text text-anchor="start" x="427.42" y="-209.4" font-family="Arial" font-size="14.00">username </text>
<text text-anchor="start" x="493.56" y="-209.4" font-family="Arial" font-size="14.00" fill="#666666">[varchar(50)]</text>
<polygon fill="none" stroke="black" points="420.42,-166.4 420.42,-197.2 674.1,-197.2 674.1,-166.4 420.42,-166.4"/>
<text text-anchor="start" x="427.42" y="-178.6" font-family="Arial" font-size="14.00">password </text>
<text text-anchor="start" x="491.22" y="-178.6" font-family="Arial" font-size="14.00" fill="#666666">[varchar(50)]</text>
<polygon fill="none" stroke="black" points="420.42,-135.6 420.42,-166.4 674.1,-166.4 674.1,-135.6 420.42,-135.6"/>
<text text-anchor="start" x="427.42" y="-147.8" font-family="Arial" font-size="14.00">email </text>
<text text-anchor="start" x="464.76" y="-147.8" font-family="Arial" font-size="14.00" fill="#666666">[varchar(355)]</text>
<polygon fill="none" stroke="black" points="420.42,-104.8 420.42,-135.6 674.1,-135.6 674.1,-104.8 420.42,-104.8"/>
<text text-anchor="start" x="427.42" y="-117" font-family="Arial" font-size="14.00">created </text>
<text text-anchor="start" x="478" y="-117" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="black" points="420.42,-74 420.42,-104.8 674.1,-104.8 674.1,-74 420.42,-74"/>
<text text-anchor="start" x="427.42" y="-86.2" font-family="Arial" font-size="14.00">updated </text>
<text text-anchor="start" x="481.91" y="-86.2" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
</g>
<!-- public.comments&#45;&gt;public.users -->
<g id="edge4" class="edge">
<title>public.comments:user_id&#45;&gt;public.users:id</title>
<path fill="none" stroke="black" d="M510.53,-588.55C578.06,-579.36 532.41,-475.49 499.24,-404.4 479.82,-362.79 439.94,-379.16 420.42,-337.6 402.61,-299.7 377.55,-243.4 419.42,-243.4"/>
<polygon fill="black" stroke="black" points="510.56,-588.54 500.29,-584.69 505.23,-588.88 500.91,-589.16 500.91,-589.16 500.91,-589.16 505.23,-588.88 500.86,-593.67 510.56,-588.54"/>
<text text-anchor="start" x="507.24" y="-599.2" font-family="Arial" font-size="10.00">FOREIGN KEY (user_id) REFERENCES users(id)</text>
</g>
<!-- public.logs -->
<g id="node2" class="node">
<title>public.logs</title>
<polygon fill="#efefef" stroke="none" points="54.37,-1042.8 54.37,-1078.4 304.14,-1078.4 304.14,-1042.8 54.37,-1042.8"/>
<polygon fill="none" stroke="black" points="54.37,-1042.8 54.37,-1078.4 304.14,-1078.4 304.14,-1042.8 54.37,-1042.8"/>
<text text-anchor="start" x="77.27" y="-1056.2" font-family="Arial Bold" font-size="18.00">public.logs</text>
<text text-anchor="start" x="156.76" y="-1056.2" font-family="Arial" font-size="14.00">    </text>
<text text-anchor="start" x="187.88" y="-1056.2" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="black" points="54.37,-1012 54.37,-1042.8 304.14,-1042.8 304.14,-1012 54.37,-1012"/>
<text text-anchor="start" x="61.37" y="-1024.2" font-family="Arial" font-size="14.00">id </text>
<text text-anchor="start" x="76.16" y="-1024.2" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="black" points="54.37,-981.2 54.37,-1012 304.14,-1012 304.14,-981.2 54.37,-981.2"/>
<text text-anchor="start" x="61.37" y="-993.4" font-family="Arial" font-size="14.00">user_id </text>
<text text-anchor="start" x="111.18" y="-993.4" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="54.37,-950.4 54.37,-981.2 304.14,-981.2 304.14,-950.4 54.37,-950.4"/>
<text text-anchor="start" x="61.37" y="-962.6" font-family="Arial" font-size="14.00">post_id </text>
<text text-anchor="start" x="110.41" y="-962.6" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="54.37,-919.6 54.37,-950.4 304.14,-950.4 304.14,-919.6 54.37,-919.6"/>
<text text-anchor="start" x="61.37" y="-931.8" font-family="Arial" font-size="14.00">comment_id </text>
<text text-anchor="start" x="141.52" y="-931.8" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="54.37,-888.8 54.37,-919.6 304.14,-919.6 304.14,-888.8 54.37,-888.8"/>
<text text-anchor="start" x="61.37" y="-901" font-family="Arial" font-size="14.00">comment_star_id </text>
<text text-anchor="start" x="172.64" y="-901" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="black" points="54.37,-858 54.37,-888.8 304.14,-888.8 304.14,-858 54.37,-858"/>
<text text-anchor="start" x="61.37" y="-870.2" font-family="Arial" font-size="14.00">payload </text>
<text text-anchor="start" x="114.3" y="-870.2" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="black" points="54.37,-827.2 54.37,-858 304.14,-858 304.14,-827.2 54.37,-827.2"/>
<text text-anchor="start" x="61.37" y="-839.4" font-family="Arial" font-size="14.00">created </text>
<text text-anchor="start" x="111.96" y="-839.4" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
</g>
<!-- public.logs&#45;&gt;public.comments -->
<g id="edge1" class="edge">
<title>public.logs:comment_id&#45;&gt;public.comments:id</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M315.27,-934.18C368.59,-924.88 336.86,-838.36 304.14,-784 286.74,-755.08 254.73,-776.89 237.28,-748 214.93,-711.03 193.07,-650.8 236.28,-650.8"/>
<polygon fill="black" stroke="black" points="315.45,-934.17 305.12,-930.49 310.13,-934.6 305.81,-934.95 305.81,-934.95 305.81,-934.95 310.13,-934.6 305.84,-939.46 315.45,-934.17"/>
<text text-anchor="start" x="312.14" y="-945" font-family="Arial" font-size="10.00">Additional Relation</text>
</g>
<!-- public.comment_stars -->
<g id="node4" class="node">
<title>public.comment_stars</title>
<polygon fill="#efefef" stroke="none" points="408.78,-1027.4 408.78,-1063 705.74,-1063 705.74,-1027.4 408.78,-1027.4"/>
<polygon fill="none" stroke="black" points="408.78,-1027.4 408.78,-1063 705.74,-1063 705.74,-1027.4 408.78,-1027.4"/>
<text text-anchor="start" x="415.78" y="-1040.8" font-family="Arial Bold" font-size="18.00">public.comment_stars</text>
<text text-anchor="start" x="574.25" y="-1040.8" font-family="Arial" font-size="14.00">    </text>
<text text-anchor="start" x="605.36" y="-1040.8" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="black" points="408.78,-996.6 408.78,-1027.4 705.74,-1027.4 705.74,-996.6 408.78,-996.6"/>
<text text-anchor="start" x="415.78" y="-1008.8" font-family="Arial" font-size="14.00">id </text>
<text text-anchor="start" x="430.57" y="-1008.8" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="black" points="408.78,-965.8 408.78,-996.6 705.74,-996.6 705.74,-965.8 408.78,-965.8"/>
<text text-anchor="start" x="415.78" y="-978" font-family="Arial" font-size="14.00">user_id </text>
<text text-anchor="start" x="465.59" y="-978" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="408.78,-935 408.78,-965.8 705.74,-965.8 705.74,-935 408.78,-935"/>
<text text-anchor="start" x="415.78" y="-947.2" font-family="Arial" font-size="14.00">comment_post_id </text>
<text text-anchor="start" x="530.17" y="-947.2" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="black" points="408.78,-904.2 408.78,-935 705.74,-935 705.74,-904.2 408.78,-904.2"/>
<text text-anchor="start" x="415.78" y="-916.4" font-family="Arial" font-size="14.00">comment_user_id </text>
<text text-anchor="start" x="530.95" y="-916.4" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="black" points="408.78,-873.4 408.78,-904.2 705.74,-904.2 705.74,-873.4 408.78,-873.4"/>
<text text-anchor="start" x="415.78" y="-885.6" font-family="Arial" font-size="14.00">created </text>
<text text-anchor="start" x="466.37" y="-885.6" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="black" points="408.78,-842.6 408.78,-873.4 705.74,-873.4 705.74,-842.6 408.78,-842.6"/>
<text text-anchor="start" x="415.78" y="-854.8" font-family="Arial" font-size="14.00">updated </text>
<text text-anchor="start" x="470.28" y="-854.8" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
</g>
<!-- public.comment_stars&#45;&gt;public.comments -->
<g id="edge3" class="edge">
<title>public.comment_stars:comment_post_id&#45;&gt;public.comments:post_id</title>
<path fill="none" stroke="black" d="M397.66,-949.59C344.4,-940.32 376.69,-854.13 408.78,-799.4 432.17,-759.51 475.83,-787.88 499.24,-748 528.05,-698.94 557.13,-620 500.24,-620"/>
<polygon fill="black" stroke="black" points="397.48,-949.57 407.09,-954.86 402.8,-950 407.11,-950.35 407.11,-950.35 407.11,-950.35 402.8,-950 407.81,-945.89 397.48,-949.57"/>
<text text-anchor="start" x="414.78" y="-960.4" font-family="Arial" font-size="10.00">FOREIGN KEY (comment_post_id, comment_user_id) REFERENCES comments(post_id, user_id)</text>
</g>
</g>
</svg>