doc/db/schema.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.40.1 (20161225.0304)
 -->
<!-- Title: app Pages: 1 -->
<svg width="2721pt" height="609pt"
 viewBox="0.00 0.00 2720.50 609.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 605)">
<title>app</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-605 2716.5,-605 2716.5,4 -4,4"/>
<!-- public._prisma_migrations -->
<g id="node1" class="node">
<title>public._prisma_migrations</title>
<polygon fill="#efefef" stroke="transparent" points="43,-402.5 43,-437.5 393,-437.5 393,-402.5 43,-402.5"/>
<polygon fill="none" stroke="#000000" points="43,-402.5 43,-437.5 393,-437.5 393,-402.5 43,-402.5"/>
<text text-anchor="start" x="49.7098" y="-415.3" font-family="Arial Bold" font-size="18.00" fill="#000000">public._prisma_migrations</text>
<text text-anchor="start" x="258.7222" y="-415.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="292.927" y="-415.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="43,-372.5 43,-402.5 393,-402.5 393,-372.5 43,-372.5"/>
<text text-anchor="start" x="50" y="-383.9" font-family="Arial" font-size="14.00" fill="#000000">id    </text>
<text text-anchor="start" x="95.094" y="-383.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(36)]</text>
<polygon fill="none" stroke="#000000" points="43,-342.5 43,-372.5 393,-372.5 393,-342.5 43,-342.5"/>
<text text-anchor="start" x="50" y="-353.9" font-family="Arial" font-size="14.00" fill="#000000">checksum    </text>
<text text-anchor="start" x="147.2132" y="-353.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(64)]</text>
<polygon fill="none" stroke="#000000" points="43,-312.5 43,-342.5 393,-342.5 393,-312.5 43,-312.5"/>
<text text-anchor="start" x="50" y="-323.9" font-family="Arial" font-size="14.00" fill="#000000">finished_at    </text>
<text text-anchor="start" x="151.8948" y="-323.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="43,-282.5 43,-312.5 393,-312.5 393,-282.5 43,-282.5"/>
<text text-anchor="start" x="50" y="-293.9" font-family="Arial" font-size="14.00" fill="#000000">migration_name    </text>
<text text-anchor="start" x="184.5512" y="-293.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar(255)]</text>
<polygon fill="none" stroke="#000000" points="43,-252.5 43,-282.5 393,-282.5 393,-252.5 43,-252.5"/>
<text text-anchor="start" x="50" y="-263.9" font-family="Arial" font-size="14.00" fill="#000000">logs    </text>
<text text-anchor="start" x="109.8766" y="-263.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="43,-222.5 43,-252.5 393,-252.5 393,-222.5 43,-222.5"/>
<text text-anchor="start" x="50" y="-233.9" font-family="Arial" font-size="14.00" fill="#000000">rolled_back_at    </text>
<text text-anchor="start" x="175.23" y="-233.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="43,-192.5 43,-222.5 393,-222.5 393,-192.5 43,-192.5"/>
<text text-anchor="start" x="50" y="-203.9" font-family="Arial" font-size="14.00" fill="#000000">started_at    </text>
<text text-anchor="start" x="146.4502" y="-203.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="43,-162.5 43,-192.5 393,-192.5 393,-162.5 43,-162.5"/>
<text text-anchor="start" x="50" y="-173.9" font-family="Arial" font-size="14.00" fill="#000000">applied_steps_count    </text>
<text text-anchor="start" x="212.5904" y="-173.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
</g>
<!-- public.UploadedImage -->
<g id="node2" class="node">
<title>public.UploadedImage</title>
<polygon fill="#efefef" stroke="transparent" points="497,-327.5 497,-362.5 817,-362.5 817,-327.5 497,-327.5"/>
<polygon fill="none" stroke="#000000" points="497,-327.5 497,-362.5 817,-362.5 817,-327.5 497,-327.5"/>
<text text-anchor="start" x="503.6921" y="-340.3" font-family="Arial Bold" font-size="18.00" fill="#000000">public.UploadedImage</text>
<text text-anchor="start" x="682.7399" y="-340.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="716.9447" y="-340.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="497,-297.5 497,-327.5 817,-327.5 817,-297.5 497,-297.5"/>
<text text-anchor="start" x="504" y="-308.9" font-family="Arial" font-size="14.00" fill="#000000">id    </text>
<text text-anchor="start" x="549.094" y="-308.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="497,-267.5 497,-297.5 817,-297.5 817,-267.5 497,-267.5"/>
<text text-anchor="start" x="504" y="-278.9" font-family="Arial" font-size="14.00" fill="#000000">path    </text>
<text text-anchor="start" x="565.4432" y="-278.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="497,-237.5 497,-267.5 817,-267.5 817,-237.5 497,-237.5"/>
<text text-anchor="start" x="504" y="-248.9" font-family="Arial" font-size="14.00" fill="#000000">createdAt    </text>
<text text-anchor="start" x="598.1136" y="-248.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp(3) without time zone]</text>
</g>
<!-- graphile_worker.migrations -->
<g id="node3" class="node">
<title>graphile_worker.migrations</title>
<polygon fill="#efefef" stroke="transparent" points="922,-312.5 922,-347.5 1279,-347.5 1279,-312.5 922,-312.5"/>
<polygon fill="none" stroke="#000000" points="922,-312.5 922,-347.5 1279,-347.5 1279,-312.5 922,-312.5"/>
<text text-anchor="start" x="928.7106" y="-325.3" font-family="Arial Bold" font-size="18.00" fill="#000000">graphile_worker.migrations</text>
<text text-anchor="start" x="1144.7214" y="-325.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="1178.9262" y="-325.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="922,-282.5 922,-312.5 1279,-312.5 1279,-282.5 922,-282.5"/>
<text text-anchor="start" x="929" y="-293.9" font-family="Arial" font-size="14.00" fill="#000000">id    </text>
<text text-anchor="start" x="974.094" y="-293.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="#000000" points="922,-252.5 922,-282.5 1279,-282.5 1279,-252.5 922,-252.5"/>
<text text-anchor="start" x="929" y="-263.9" font-family="Arial" font-size="14.00" fill="#000000">ts    </text>
<text text-anchor="start" x="974.0954" y="-263.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
</g>
<!-- graphile_worker.job_queues -->
<g id="node4" class="node">
<title>graphile_worker.job_queues</title>
<polygon fill="#efefef" stroke="transparent" points="1383,-342.5 1383,-377.5 1750,-377.5 1750,-342.5 1383,-342.5"/>
<polygon fill="none" stroke="#000000" points="1383,-342.5 1383,-377.5 1750,-377.5 1750,-342.5 1383,-342.5"/>
<text text-anchor="start" x="1389.6886" y="-355.3" font-family="Arial Bold" font-size="18.00" fill="#000000">graphile_worker.job_queues</text>
<text text-anchor="start" x="1615.7434" y="-355.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="1649.9482" y="-355.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="1383,-312.5 1383,-342.5 1750,-342.5 1750,-312.5 1383,-312.5"/>
<text text-anchor="start" x="1390" y="-323.9" font-family="Arial" font-size="14.00" fill="#000000">queue_name    </text>
<text text-anchor="start" x="1505.9088" y="-323.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="1383,-282.5 1383,-312.5 1750,-312.5 1750,-282.5 1383,-282.5"/>
<text text-anchor="start" x="1390" y="-293.9" font-family="Arial" font-size="14.00" fill="#000000">job_count    </text>
<text text-anchor="start" x="1484.8976" y="-293.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="#000000" points="1383,-252.5 1383,-282.5 1750,-282.5 1750,-252.5 1383,-252.5"/>
<text text-anchor="start" x="1390" y="-263.9" font-family="Arial" font-size="14.00" fill="#000000">locked_at    </text>
<text text-anchor="start" x="1484.115" y="-263.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="1383,-222.5 1383,-252.5 1750,-252.5 1750,-222.5 1383,-222.5"/>
<text text-anchor="start" x="1390" y="-233.9" font-family="Arial" font-size="14.00" fill="#000000">locked_by    </text>
<text text-anchor="start" x="1487.2244" y="-233.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
</g>
<!-- graphile_worker.jobs -->
<g id="node5" class="node">
<title>graphile_worker.jobs</title>
<polygon fill="#efefef" stroke="transparent" points="1854,-522.5 1854,-557.5 2161,-557.5 2161,-522.5 1854,-522.5"/>
<polygon fill="none" stroke="#000000" points="1854,-522.5 1854,-557.5 2161,-557.5 2161,-522.5 1854,-522.5"/>
<text text-anchor="start" x="1860.7072" y="-535.3" font-family="Arial Bold" font-size="18.00" fill="#000000">graphile_worker.jobs</text>
<text text-anchor="start" x="2026.7248" y="-535.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="2060.9296" y="-535.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="1854,-492.5 1854,-522.5 2161,-522.5 2161,-492.5 1854,-492.5"/>
<text text-anchor="start" x="1861" y="-503.9" font-family="Arial" font-size="14.00" fill="#000000">id    </text>
<text text-anchor="start" x="1906.094" y="-503.9" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="#000000" points="1854,-462.5 1854,-492.5 2161,-492.5 2161,-462.5 1854,-462.5"/>
<text text-anchor="start" x="1861" y="-473.9" font-family="Arial" font-size="14.00" fill="#000000">queue_name    </text>
<text text-anchor="start" x="1976.9088" y="-473.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="1854,-432.5 1854,-462.5 2161,-462.5 2161,-432.5 1854,-432.5"/>
<text text-anchor="start" x="1861" y="-443.9" font-family="Arial" font-size="14.00" fill="#000000">task_identifier    </text>
<text text-anchor="start" x="1981.5526" y="-443.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="1854,-402.5 1854,-432.5 2161,-432.5 2161,-402.5 1854,-402.5"/>
<text text-anchor="start" x="1861" y="-413.9" font-family="Arial" font-size="14.00" fill="#000000">payload    </text>
<text text-anchor="start" x="1944.2244" y="-413.9" font-family="Arial" font-size="14.00" fill="#666666">[json]</text>
<polygon fill="none" stroke="#000000" points="1854,-372.5 1854,-402.5 2161,-402.5 2161,-372.5 1854,-372.5"/>
<text text-anchor="start" x="1861" y="-383.9" font-family="Arial" font-size="14.00" fill="#000000">priority    </text>
<text text-anchor="start" x="1937.195" y="-383.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="#000000" points="1854,-342.5 1854,-372.5 2161,-372.5 2161,-342.5 1854,-342.5"/>
<text text-anchor="start" x="1861" y="-353.9" font-family="Arial" font-size="14.00" fill="#000000">run_at    </text>
<text text-anchor="start" x="1934.8864" y="-353.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="1854,-312.5 1854,-342.5 2161,-342.5 2161,-312.5 1854,-312.5"/>
<text text-anchor="start" x="1861" y="-323.9" font-family="Arial" font-size="14.00" fill="#000000">attempts    </text>
<text text-anchor="start" x="1948.885" y="-323.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="#000000" points="1854,-282.5 1854,-312.5 2161,-312.5 2161,-282.5 1854,-282.5"/>
<text text-anchor="start" x="1861" y="-293.9" font-family="Arial" font-size="14.00" fill="#000000">max_attempts    </text>
<text text-anchor="start" x="1983.1108" y="-293.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="#000000" points="1854,-252.5 1854,-282.5 2161,-282.5 2161,-252.5 1854,-252.5"/>
<text text-anchor="start" x="1861" y="-263.9" font-family="Arial" font-size="14.00" fill="#000000">last_error    </text>
<text text-anchor="start" x="1954.3142" y="-263.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="1854,-222.5 1854,-252.5 2161,-252.5 2161,-222.5 1854,-222.5"/>
<text text-anchor="start" x="1861" y="-233.9" font-family="Arial" font-size="14.00" fill="#000000">created_at    </text>
<text text-anchor="start" x="1961.3422" y="-233.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="1854,-192.5 1854,-222.5 2161,-222.5 2161,-192.5 1854,-192.5"/>
<text text-anchor="start" x="1861" y="-203.9" font-family="Arial" font-size="14.00" fill="#000000">updated_at    </text>
<text text-anchor="start" x="1965.2468" y="-203.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="1854,-162.5 1854,-192.5 2161,-192.5 2161,-162.5 1854,-162.5"/>
<text text-anchor="start" x="1861" y="-173.9" font-family="Arial" font-size="14.00" fill="#000000">key    </text>
<text text-anchor="start" x="1916.9874" y="-173.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="1854,-132.5 1854,-162.5 2161,-162.5 2161,-132.5 1854,-132.5"/>
<text text-anchor="start" x="1861" y="-143.9" font-family="Arial" font-size="14.00" fill="#000000">locked_at    </text>
<text text-anchor="start" x="1955.115" y="-143.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="1854,-102.5 1854,-132.5 2161,-132.5 2161,-102.5 1854,-102.5"/>
<text text-anchor="start" x="1861" y="-113.9" font-family="Arial" font-size="14.00" fill="#000000">locked_by    </text>
<text text-anchor="start" x="1958.2244" y="-113.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="1854,-72.5 1854,-102.5 2161,-102.5 2161,-72.5 1854,-72.5"/>
<text text-anchor="start" x="1861" y="-83.9" font-family="Arial" font-size="14.00" fill="#000000">revision    </text>
<text text-anchor="start" x="1943.4264" y="-83.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="#000000" points="1854,-42.5 1854,-72.5 2161,-72.5 2161,-42.5 1854,-42.5"/>
<text text-anchor="start" x="1861" y="-53.9" font-family="Arial" font-size="14.00" fill="#000000">flags    </text>
<text text-anchor="start" x="1924.7672" y="-53.9" font-family="Arial" font-size="14.00" fill="#666666">[jsonb]</text>
</g>
<!-- graphile_worker.known_crontabs -->
<g id="node6" class="node">
<title>graphile_worker.known_crontabs</title>
<polygon fill="#efefef" stroke="transparent" points="2265,-327.5 2265,-362.5 2670,-362.5 2670,-327.5 2265,-327.5"/>
<polygon fill="none" stroke="#000000" points="2265,-327.5 2265,-362.5 2670,-362.5 2670,-327.5 2265,-327.5"/>
<text text-anchor="start" x="2271.6914" y="-340.3" font-family="Arial Bold" font-size="18.00" fill="#000000">graphile_worker.known_crontabs</text>
<text text-anchor="start" x="2535.7406" y="-340.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="2569.9454" y="-340.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="2265,-297.5 2265,-327.5 2670,-327.5 2670,-297.5 2265,-297.5"/>
<text text-anchor="start" x="2272" y="-308.9" font-family="Arial" font-size="14.00" fill="#000000">identifier    </text>
<text text-anchor="start" x="2359.0968" y="-308.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="2265,-267.5 2265,-297.5 2670,-297.5 2670,-267.5 2265,-267.5"/>
<text text-anchor="start" x="2272" y="-278.9" font-family="Arial" font-size="14.00" fill="#000000">known_since    </text>
<text text-anchor="start" x="2387.1136" y="-278.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="2265,-237.5 2265,-267.5 2670,-267.5 2670,-237.5 2265,-237.5"/>
<text text-anchor="start" x="2272" y="-248.9" font-family="Arial" font-size="14.00" fill="#000000">last_execution    </text>
<text text-anchor="start" x="2395.6774" y="-248.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
</g>
</g>
</svg>