docs/database/public.subject_progress.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: public.subject_progress Pages: 1 -->
<svg width="780pt" height="682pt"
 viewBox="0.00 0.00 780.00 682.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 678)">
<title>public.subject_progress</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-678 776,-678 776,4 -4,4"/>
<!-- public.subject_progress -->
<g id="node1" class="node">
<title>public.subject_progress</title>
<polygon fill="#efefef" stroke="transparent" points="396,-592.5 396,-627.5 726,-627.5 726,-592.5 396,-592.5"/>
<polygon fill="none" stroke="#000000" points="396,-592.5 396,-627.5 726,-627.5 726,-592.5 396,-592.5"/>
<text text-anchor="start" x="402.6962" y="-605.3" font-family="Arial Bold" font-size="18.00" fill="#000000">public.subject_progress</text>
<text text-anchor="start" x="591.7358" y="-605.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="625.9406" y="-605.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="396,-562.5 396,-592.5 726,-592.5 726,-562.5 396,-562.5"/>
<text text-anchor="start" x="403" y="-573.9" font-family="Arial" font-size="14.00" fill="#000000">completed_at </text>
<text text-anchor="start" x="490.9172" y="-573.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="396,-532.5 396,-562.5 726,-562.5 726,-532.5 396,-532.5"/>
<text text-anchor="start" x="403" y="-543.9" font-family="Arial" font-size="14.00" fill="#000000">subject_id </text>
<text text-anchor="start" x="469.9074" y="-543.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="396,-502.5 396,-532.5 726,-532.5 726,-502.5 396,-502.5"/>
<text text-anchor="start" x="403" y="-513.9" font-family="Arial" font-size="14.00" fill="#000000">intervention_id </text>
<text text-anchor="start" x="497.913" y="-513.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="396,-472.5 396,-502.5 726,-502.5 726,-472.5 396,-472.5"/>
<text text-anchor="start" x="403" y="-483.9" font-family="Arial" font-size="14.00" fill="#000000">task_id </text>
<text text-anchor="start" x="451.2356" y="-483.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="396,-442.5 396,-472.5 726,-472.5 726,-442.5 396,-442.5"/>
<text text-anchor="start" x="403" y="-453.9" font-family="Arial" font-size="14.00" fill="#000000">result_type </text>
<text text-anchor="start" x="475.352" y="-453.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="396,-412.5 396,-442.5 726,-442.5 726,-412.5 396,-412.5"/>
<text text-anchor="start" x="403" y="-423.9" font-family="Arial" font-size="14.00" fill="#000000">result </text>
<text text-anchor="start" x="441.1136" y="-423.9" font-family="Arial" font-size="14.00" fill="#666666">[jsonb]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="394.5,-411.5 394.5,-629.5 727.5,-629.5 727.5,-411.5 394.5,-411.5"/>
</g>
<!-- public.study_subject -->
<g id="node2" class="node">
<title>public.study_subject</title>
<polygon fill="#efefef" stroke="transparent" points="409,-252.5 409,-287.5 712,-287.5 712,-252.5 409,-252.5"/>
<polygon fill="none" stroke="#000000" points="409,-252.5 409,-287.5 712,-287.5 712,-252.5 409,-252.5"/>
<text text-anchor="start" x="415.6935" y="-265.3" font-family="Arial Bold" font-size="18.00" fill="#000000">public.study_subject</text>
<text text-anchor="start" x="577.7385" y="-265.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="611.9433" y="-265.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="409,-222.5 409,-252.5 712,-252.5 712,-222.5 409,-222.5"/>
<text text-anchor="start" x="416" y="-233.9" font-family="Arial" font-size="14.00" fill="#000000">id    </text>
<text text-anchor="start" x="461.094" y="-233.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="409,-192.5 409,-222.5 712,-222.5 712,-192.5 409,-192.5"/>
<text text-anchor="start" x="416" y="-203.9" font-family="Arial" font-size="14.00" fill="#000000">study_id    </text>
<text text-anchor="start" x="502.3324" y="-203.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="409,-162.5 409,-192.5 712,-192.5 712,-162.5 409,-162.5"/>
<text text-anchor="start" x="416" y="-173.9" font-family="Arial" font-size="14.00" fill="#000000">user_id    </text>
<text text-anchor="start" x="496.1024" y="-173.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="409,-132.5 409,-162.5 712,-162.5 712,-132.5 409,-132.5"/>
<text text-anchor="start" x="416" y="-143.9" font-family="Arial" font-size="14.00" fill="#000000">started_at    </text>
<text text-anchor="start" x="512.4502" y="-143.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp with time zone]</text>
<polygon fill="none" stroke="#000000" points="409,-102.5 409,-132.5 712,-132.5 712,-102.5 409,-102.5"/>
<text text-anchor="start" x="416" y="-113.9" font-family="Arial" font-size="14.00" fill="#000000">selected_intervention_ids    </text>
<text text-anchor="start" x="608.1374" y="-113.9" font-family="Arial" font-size="14.00" fill="#666666">[text[]]</text>
<polygon fill="none" stroke="#000000" points="409,-72.5 409,-102.5 712,-102.5 712,-72.5 409,-72.5"/>
<text text-anchor="start" x="416" y="-83.9" font-family="Arial" font-size="14.00" fill="#000000">invite_code    </text>
<text text-anchor="start" x="521.0042" y="-83.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="409,-42.5 409,-72.5 712,-72.5 712,-42.5 409,-42.5"/>
<text text-anchor="start" x="416" y="-53.9" font-family="Arial" font-size="14.00" fill="#000000">is_deleted    </text>
<text text-anchor="start" x="514.0042" y="-53.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
</g>
<!-- public.subject_progress&#45;&gt;public.study_subject -->
<g id="edge1" class="edge">
<title>public.subject_progress:subject_id&#45;&gt;public.study_subject:id</title>
<path fill="none" stroke="#000000" d="M385.8294,-546.786C318.2396,-536.7831 344.9808,-424.1615 396,-367 490.1249,-261.5432 617.8751,-436.4568 712,-331 739.6713,-299.9973 753.5556,-237.5 712,-237.5"/>
<polygon fill="#000000" stroke="#000000" points="386.0245,-546.7996 395.6848,-551.989 391.0123,-547.1498 396,-547.5 396,-547.5 396,-547.5 391.0123,-547.1498 396.3152,-543.011 386.0245,-546.7996 386.0245,-546.7996"/>
<text text-anchor="start" x="6.5975" y="-557.5" font-family="Arial" font-size="10.00" fill="#000000">FOREIGN KEY (subject_id) REFERENCES study_subject(id) ON DELETE CASCADE</text>
</g>
</g>
</svg>