erd.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 2.43.0 (0)
 -->
<!-- Title: %3 Pages: 1 -->
<svg width="1265pt" height="637pt"
 viewBox="0.00 0.00 1265.00 637.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 633)">
<title>%3</title>
<polygon fill="white" stroke="transparent" points="-4,4 -4,-633 1261,-633 1261,4 -4,4"/>
<!-- alembic_version -->
<g id="node1" class="node">
<title>alembic_version</title>
<polygon fill="none" stroke="black" points="30,-128 30,-156 242,-156 242,-128 30,-128"/>
<text text-anchor="start" x="63.5" y="-139.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="16.00">alembic_version</text>
<polygon fill="none" stroke="black" points="30,-103 30,-128 242,-128 242,-103 30,-103"/>
<text text-anchor="start" x="35" y="-112.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">version_num</text>
<text text-anchor="start" x="125" y="-112.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(32)]</text>
</g>
<!-- commands -->
<g id="node2" class="node">
<title>commands</title>
<polygon fill="none" stroke="black" points="353,-597 353,-625 547,-625 547,-597 353,-597"/>
<text text-anchor="start" x="401.5" y="-608.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="16.00">commands</text>
<polygon fill="none" stroke="black" points="353,-572 353,-597 547,-597 547,-572 353,-572"/>
<text text-anchor="start" x="358" y="-581.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">id</text>
<text text-anchor="start" x="371" y="-581.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="353,-547 353,-572 547,-572 547,-547 353,-547"/>
<text text-anchor="start" x="358" y="-556.8" font-family="Helvetica,sans-Serif" font-size="14.00">date</text>
<text text-anchor="start" x="389" y="-556.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [DATETIME]</text>
<polygon fill="none" stroke="black" points="353,-522 353,-547 547,-547 547,-522 353,-522"/>
<text text-anchor="start" x="358" y="-531.8" font-family="Helvetica,sans-Serif" font-size="14.00">user_login</text>
<text text-anchor="start" x="430" y="-531.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(30)]</text>
<polygon fill="none" stroke="black" points="353,-497 353,-522 547,-522 547,-497 353,-497"/>
<text text-anchor="start" x="358" y="-506.8" font-family="Helvetica,sans-Serif" font-size="14.00">project_id</text>
<text text-anchor="start" x="425" y="-506.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="353,-472 353,-497 547,-497 547,-472 353,-472"/>
<text text-anchor="start" x="358" y="-481.8" font-family="Helvetica,sans-Serif" font-size="14.00">document_id</text>
<text text-anchor="start" x="448" y="-481.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="353,-447 353,-472 547,-472 547,-447 353,-447"/>
<text text-anchor="start" x="358" y="-456.8" font-family="Helvetica,sans-Serif" font-size="14.00">payload</text>
<text text-anchor="start" x="413" y="-456.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [TEXT]</text>
</g>
<!-- users -->
<g id="node3" class="node">
<title>users</title>
<polygon fill="none" stroke="black" points="8,-532 8,-560 264,-560 264,-532 8,-532"/>
<text text-anchor="start" x="111" y="-543.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="16.00">users</text>
<polygon fill="none" stroke="black" points="8,-507 8,-532 264,-532 264,-507 8,-507"/>
<text text-anchor="start" x="13" y="-516.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">login</text>
<text text-anchor="start" x="47" y="-516.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(30)]</text>
<polygon fill="none" stroke="black" points="8,-482 8,-507 264,-507 264,-482 8,-482"/>
<text text-anchor="start" x="13" y="-491.8" font-family="Helvetica,sans-Serif" font-size="14.00">created</text>
<text text-anchor="start" x="65" y="-491.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [DATETIME]</text>
<polygon fill="none" stroke="black" points="8,-457 8,-482 264,-482 264,-457 8,-457"/>
<text text-anchor="start" x="13" y="-466.8" font-family="Helvetica,sans-Serif" font-size="14.00">hashed_password</text>
<text text-anchor="start" x="138" y="-466.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(120)]</text>
<polygon fill="none" stroke="black" points="8,-432 8,-457 264,-457 264,-432 8,-432"/>
<text text-anchor="start" x="13" y="-441.8" font-family="Helvetica,sans-Serif" font-size="14.00">password_set_date</text>
<text text-anchor="start" x="146" y="-441.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [DATETIME]</text>
<polygon fill="none" stroke="black" points="8,-407 8,-432 264,-432 264,-407 8,-407"/>
<text text-anchor="start" x="13" y="-416.8" font-family="Helvetica,sans-Serif" font-size="14.00">language</text>
<text text-anchor="start" x="78" y="-416.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(10)]</text>
<polygon fill="none" stroke="black" points="8,-382 8,-407 264,-407 264,-382 8,-382"/>
<text text-anchor="start" x="13" y="-391.8" font-family="Helvetica,sans-Serif" font-size="14.00">email</text>
<text text-anchor="start" x="51" y="-391.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(256)]</text>
<polygon fill="none" stroke="black" points="8,-357 8,-382 264,-382 264,-357 8,-357"/>
<text text-anchor="start" x="13" y="-366.8" font-family="Helvetica,sans-Serif" font-size="14.00">email_sent</text>
<text text-anchor="start" x="88" y="-366.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [DATETIME]</text>
</g>
<!-- users&#45;&#45;commands -->
<g id="edge1" class="edge">
<title>users&#45;&#45;commands</title>
<path fill="none" stroke="#7f7f7f" stroke-dasharray="5,2" d="M272.03,-492.33C296.41,-498.34 321.48,-504.53 344.8,-510.28"/>
<text text-anchor="start" x="303.8" y="-499.08" font-family="Times,serif" font-size="14.00">{0,1}</text>
<text text-anchor="start" x="272.03" y="-481.13" font-family="Times,serif" font-size="14.00">0..N</text>
</g>
<!-- project_members -->
<g id="node9" class="node">
<title>project_members</title>
<polygon fill="none" stroke="black" points="353,-392 353,-420 547,-420 547,-392 353,-392"/>
<text text-anchor="start" x="372" y="-403.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="16.00">project_members</text>
<polygon fill="none" stroke="black" points="353,-367 353,-392 547,-392 547,-367 353,-367"/>
<text text-anchor="start" x="358" y="-376.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">project_id</text>
<text text-anchor="start" x="425" y="-376.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="353,-342 353,-367 547,-367 547,-342 353,-342"/>
<text text-anchor="start" x="358" y="-351.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">user_login</text>
<text text-anchor="start" x="430" y="-351.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(30)]</text>
<polygon fill="none" stroke="black" points="353,-317 353,-342 547,-342 547,-317 353,-317"/>
<text text-anchor="start" x="358" y="-326.8" font-family="Helvetica,sans-Serif" font-size="14.00">privileges</text>
<text text-anchor="start" x="426" y="-326.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(11)]</text>
</g>
<!-- users&#45;&#45;project_members -->
<g id="edge8" class="edge">
<title>users&#45;&#45;project_members</title>
<path fill="none" stroke="#7f7f7f" stroke-dasharray="5,2" d="M272.03,-420.05C296.41,-413.02 321.48,-405.79 344.8,-399.06"/>
<text text-anchor="start" x="303.8" y="-387.86" font-family="Times,serif" font-size="14.00">{0,1}</text>
<text text-anchor="start" x="272.03" y="-408.85" font-family="Times,serif" font-size="14.00">0..N</text>
</g>
<!-- projects -->
<g id="node4" class="node">
<title>projects</title>
<polygon fill="none" stroke="black" points="51,-283 51,-311 222,-311 222,-283 51,-283"/>
<text text-anchor="start" x="99.5" y="-294.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="16.00">projects</text>
<polygon fill="none" stroke="black" points="51,-258 51,-283 222,-283 222,-258 51,-258"/>
<text text-anchor="start" x="56" y="-267.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">id</text>
<text text-anchor="start" x="69" y="-267.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="51,-233 51,-258 222,-258 222,-233 51,-233"/>
<text text-anchor="start" x="56" y="-242.8" font-family="Helvetica,sans-Serif" font-size="14.00">name</text>
<text text-anchor="start" x="96" y="-242.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(200)]</text>
<polygon fill="none" stroke="black" points="51,-208 51,-233 222,-233 222,-208 51,-208"/>
<text text-anchor="start" x="56" y="-217.8" font-family="Helvetica,sans-Serif" font-size="14.00">description</text>
<text text-anchor="start" x="134" y="-217.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [TEXT]</text>
<polygon fill="none" stroke="black" points="51,-183 51,-208 222,-208 222,-183 51,-183"/>
<text text-anchor="start" x="56" y="-192.8" font-family="Helvetica,sans-Serif" font-size="14.00">created</text>
<text text-anchor="start" x="108" y="-192.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [DATETIME]</text>
</g>
<!-- projects&#45;&#45;commands -->
<g id="edge2" class="edge">
<title>projects&#45;&#45;commands</title>
<path fill="none" stroke="#7f7f7f" stroke-dasharray="5,2" d="M229.57,-309.32C244.28,-320.58 258.93,-332.68 272,-345 309.23,-380.09 310.46,-396.26 345,-434 347.65,-436.89 350.35,-439.81 353.1,-442.73"/>
<text text-anchor="start" x="312.1" y="-431.53" font-family="Times,serif" font-size="14.00">{0,1}</text>
<text text-anchor="start" x="229.57" y="-298.12" font-family="Times,serif" font-size="14.00">0..N</text>
</g>
<!-- documents -->
<g id="node5" class="node">
<title>documents</title>
<polygon fill="none" stroke="black" points="354,-263 354,-291 546,-291 546,-263 354,-263"/>
<text text-anchor="start" x="400" y="-274.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="16.00">documents</text>
<polygon fill="none" stroke="black" points="354,-238 354,-263 546,-263 546,-238 354,-238"/>
<text text-anchor="start" x="359" y="-247.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">id</text>
<text text-anchor="start" x="372" y="-247.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="354,-213 354,-238 546,-238 546,-213 354,-213"/>
<text text-anchor="start" x="359" y="-222.8" font-family="Helvetica,sans-Serif" font-size="14.00">name</text>
<text text-anchor="start" x="399" y="-222.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(200)]</text>
<polygon fill="none" stroke="black" points="354,-188 354,-213 546,-213 546,-188 354,-188"/>
<text text-anchor="start" x="359" y="-197.8" font-family="Helvetica,sans-Serif" font-size="14.00">description</text>
<text text-anchor="start" x="437" y="-197.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [TEXT]</text>
<polygon fill="none" stroke="black" points="354,-163 354,-188 546,-188 546,-163 354,-163"/>
<text text-anchor="start" x="359" y="-172.8" font-family="Helvetica,sans-Serif" font-size="14.00">filename</text>
<text text-anchor="start" x="420" y="-172.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(200)]</text>
<polygon fill="none" stroke="black" points="354,-138 354,-163 546,-163 546,-138 354,-138"/>
<text text-anchor="start" x="359" y="-147.8" font-family="Helvetica,sans-Serif" font-size="14.00">created</text>
<text text-anchor="start" x="411" y="-147.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [DATETIME]</text>
<polygon fill="none" stroke="black" points="354,-113 354,-138 546,-138 546,-113 354,-113"/>
<text text-anchor="start" x="359" y="-122.8" font-family="Helvetica,sans-Serif" font-size="14.00">project_id</text>
<text text-anchor="start" x="426" y="-122.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="354,-88 354,-113 546,-113 546,-88 354,-88"/>
<text text-anchor="start" x="359" y="-97.8" font-family="Helvetica,sans-Serif" font-size="14.00">contents</text>
<text text-anchor="start" x="420" y="-97.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [TEXT]</text>
</g>
<!-- projects&#45;&#45;documents -->
<g id="edge3" class="edge">
<title>projects&#45;&#45;documents</title>
<path fill="none" stroke="#7f7f7f" stroke-dasharray="5,2" d="M229.77,-230.05C266.32,-223.37 308.45,-215.68 345.95,-208.83"/>
<text text-anchor="start" x="304.95" y="-197.63" font-family="Times,serif" font-size="14.00">{0,1}</text>
<text text-anchor="start" x="229.77" y="-218.85" font-family="Times,serif" font-size="14.00">0..N</text>
</g>
<!-- tags -->
<g id="node8" class="node">
<title>tags</title>
<polygon fill="none" stroke="black" points="599.5,-104 599.5,-132 762.5,-132 762.5,-104 599.5,-104"/>
<text text-anchor="start" x="661" y="-115.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="16.00">tags</text>
<polygon fill="none" stroke="black" points="599.5,-79 599.5,-104 762.5,-104 762.5,-79 599.5,-79"/>
<text text-anchor="start" x="604.5" y="-88.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">id</text>
<text text-anchor="start" x="617.5" y="-88.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="599.5,-54 599.5,-79 762.5,-79 762.5,-54 599.5,-54"/>
<text text-anchor="start" x="604.5" y="-63.8" font-family="Helvetica,sans-Serif" font-size="14.00">project_id</text>
<text text-anchor="start" x="671.5" y="-63.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="599.5,-29 599.5,-54 762.5,-54 762.5,-29 599.5,-29"/>
<text text-anchor="start" x="604.5" y="-38.8" font-family="Helvetica,sans-Serif" font-size="14.00">path</text>
<text text-anchor="start" x="636.5" y="-38.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [VARCHAR(200)]</text>
<polygon fill="none" stroke="black" points="599.5,-4 599.5,-29 762.5,-29 762.5,-4 599.5,-4"/>
<text text-anchor="start" x="604.5" y="-13.8" font-family="Helvetica,sans-Serif" font-size="14.00">description</text>
<text text-anchor="start" x="682.5" y="-13.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [TEXT]</text>
</g>
<!-- projects&#45;&#45;tags -->
<g id="edge7" class="edge">
<title>projects&#45;&#45;tags</title>
<path fill="none" stroke="#7f7f7f" stroke-dasharray="5,2" d="M229.65,-200.74C244.5,-191.51 259.19,-181.17 272,-170 312.14,-135.01 297.48,-99.03 345,-75 421.19,-36.46 520.18,-39.87 590.66,-49.77"/>
<text text-anchor="start" x="549.66" y="-38.57" font-family="Times,serif" font-size="14.00">{0,1}</text>
<text text-anchor="start" x="229.65" y="-189.54" font-family="Times,serif" font-size="14.00">0..N</text>
</g>
<!-- projects&#45;&#45;project_members -->
<g id="edge9" class="edge">
<title>projects&#45;&#45;project_members</title>
<path fill="none" stroke="#7f7f7f" stroke-dasharray="5,2" d="M229.77,-283.27C265.96,-297.43 307.62,-313.72 344.84,-328.27"/>
<text text-anchor="start" x="303.84" y="-317.07" font-family="Times,serif" font-size="14.00">{0,1}</text>
<text text-anchor="start" x="229.77" y="-272.07" font-family="Times,serif" font-size="14.00">0..N</text>
</g>
<!-- highlights -->
<g id="node7" class="node">
<title>highlights</title>
<polygon fill="none" stroke="black" points="814.5,-234 814.5,-262 991.5,-262 991.5,-234 814.5,-234"/>
<text text-anchor="start" x="858" y="-245.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="16.00">highlights</text>
<polygon fill="none" stroke="black" points="814.5,-209 814.5,-234 991.5,-234 991.5,-209 814.5,-209"/>
<text text-anchor="start" x="819.5" y="-218.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">id</text>
<text text-anchor="start" x="832.5" y="-218.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="814.5,-184 814.5,-209 991.5,-209 991.5,-184 814.5,-184"/>
<text text-anchor="start" x="819.5" y="-193.8" font-family="Helvetica,sans-Serif" font-size="14.00">document_id</text>
<text text-anchor="start" x="909.5" y="-193.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="814.5,-159 814.5,-184 991.5,-184 991.5,-159 814.5,-159"/>
<text text-anchor="start" x="819.5" y="-168.8" font-family="Helvetica,sans-Serif" font-size="14.00">start_offset</text>
<text text-anchor="start" x="898.5" y="-168.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="814.5,-134 814.5,-159 991.5,-159 991.5,-134 814.5,-134"/>
<text text-anchor="start" x="819.5" y="-143.8" font-family="Helvetica,sans-Serif" font-size="14.00">end_offset</text>
<text text-anchor="start" x="892.5" y="-143.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="814.5,-109 814.5,-134 991.5,-134 991.5,-109 814.5,-109"/>
<text text-anchor="start" x="819.5" y="-118.8" font-family="Helvetica,sans-Serif" font-size="14.00">snippet</text>
<text text-anchor="start" x="871.5" y="-118.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [TEXT]</text>
</g>
<!-- documents&#45;&#45;highlights -->
<g id="edge6" class="edge">
<title>documents&#45;&#45;highlights</title>
<path fill="none" stroke="#7f7f7f" stroke-dasharray="5,2" d="M554.07,-189.08C629.78,-188.41 731.9,-187.51 805.81,-186.85"/>
<text text-anchor="start" x="764.81" y="-175.65" font-family="Times,serif" font-size="14.00">{0,1}</text>
<text text-anchor="start" x="554.07" y="-177.88" font-family="Times,serif" font-size="14.00">0..N</text>
</g>
<!-- highlight_tags -->
<g id="node6" class="node">
<title>highlight_tags</title>
<polygon fill="none" stroke="black" points="1080.5,-104 1080.5,-132 1249.5,-132 1249.5,-104 1080.5,-104"/>
<text text-anchor="start" x="1101.5" y="-115.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="16.00">highlight_tags</text>
<polygon fill="none" stroke="black" points="1080.5,-79 1080.5,-104 1249.5,-104 1249.5,-79 1080.5,-79"/>
<text text-anchor="start" x="1085.5" y="-88.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">highlight_id</text>
<text text-anchor="start" x="1167.5" y="-88.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
<polygon fill="none" stroke="black" points="1080.5,-54 1080.5,-79 1249.5,-79 1249.5,-54 1080.5,-54"/>
<text text-anchor="start" x="1085.5" y="-63.8" font-family="Helvetica,sans-Serif" text-decoration="underline" font-size="14.00">tag_id</text>
<text text-anchor="start" x="1128.5" y="-63.8" font-family="Helvetica,sans-Serif" font-size="14.00"> [INTEGER]</text>
</g>
<!-- highlights&#45;&#45;highlight_tags -->
<g id="edge4" class="edge">
<title>highlights&#45;&#45;highlight_tags</title>
<path fill="none" stroke="#7f7f7f" stroke-dasharray="5,2" d="M999.21,-151.77C1022.95,-143.27 1048.34,-134.19 1071.89,-125.77"/>
<text text-anchor="start" x="1030.89" y="-114.57" font-family="Times,serif" font-size="14.00">{0,1}</text>
<text text-anchor="start" x="999.21" y="-140.57" font-family="Times,serif" font-size="14.00">0..N</text>
</g>
<!-- tags&#45;&#45;highlight_tags -->
<g id="edge5" class="edge">
<title>tags&#45;&#45;highlight_tags</title>
<path fill="none" stroke="#7f7f7f" stroke-dasharray="5,2" d="M770.19,-72.6C855.83,-77.04 984.97,-83.74 1071.66,-88.24"/>
<text text-anchor="start" x="1030.66" y="-77.04" font-family="Times,serif" font-size="14.00">{0,1}</text>
<text text-anchor="start" x="770.19" y="-61.4" font-family="Times,serif" font-size="14.00">0..N</text>
</g>
</g>
</svg>