dbdoc/codes.plan_type.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: codes.plan_type Pages: 1 -->
<svg width="766pt" height="1132pt"
 viewBox="0.00 0.00 765.76 1132.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 1128)">
<title>codes.plan_type</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-1128 761.7554,-1128 761.7554,4 -4,4"/>
<!-- codes.plan_type -->
<g id="node1" class="node">
<title>codes.plan_type</title>
<polygon fill="#efefef" stroke="transparent" points="325,-345.5 325,-380.5 600,-380.5 600,-345.5 325,-345.5"/>
<polygon fill="none" stroke="#000000" points="325,-345.5 325,-380.5 600,-380.5 600,-345.5 325,-345.5"/>
<text text-anchor="start" x="333.1888" y="-358.3" font-family="Arial Bold" font-size="18.00" fill="#000000">codes.plan_type</text>
<text text-anchor="start" x="464.2432" y="-358.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="498.448" y="-358.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="325,-315.5 325,-345.5 600,-345.5 600,-315.5 325,-315.5"/>
<text text-anchor="start" x="332" y="-326.9" font-family="Arial" font-size="14.00" fill="#000000">value </text>
<text text-anchor="start" x="369.345" y="-326.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar]</text>
<polygon fill="none" stroke="#000000" points="325,-285.5 325,-315.5 600,-315.5 600,-285.5 325,-285.5"/>
<text text-anchor="start" x="332" y="-296.9" font-family="Arial" font-size="14.00" fill="#000000">short_name </text>
<text text-anchor="start" x="409.798" y="-296.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar]</text>
<polygon fill="none" stroke="#000000" points="325,-255.5 325,-285.5 600,-285.5 600,-255.5 325,-255.5"/>
<text text-anchor="start" x="332" y="-266.9" font-family="Arial" font-size="14.00" fill="#000000">name </text>
<text text-anchor="start" x="370.899" y="-266.9" font-family="Arial" font-size="14.00" fill="#666666">[jsonb]</text>
<polygon fill="none" stroke="#000000" points="325,-225.5 325,-255.5 600,-255.5 600,-225.5 325,-225.5"/>
<text text-anchor="start" x="332" y="-236.9" font-family="Arial" font-size="14.00" fill="#000000">description </text>
<text text-anchor="start" x="403.568" y="-236.9" font-family="Arial" font-size="14.00" fill="#666666">[jsonb]</text>
<polygon fill="none" stroke="#000000" points="325,-195.5 325,-225.5 600,-225.5 600,-195.5 325,-195.5"/>
<text text-anchor="start" x="332" y="-206.9" font-family="Arial" font-size="14.00" fill="#000000">status </text>
<text text-anchor="start" x="373.237" y="-206.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar]</text>
<polygon fill="none" stroke="#000000" points="325,-165.5 325,-195.5 600,-195.5 600,-165.5 325,-165.5"/>
<text text-anchor="start" x="332" y="-176.9" font-family="Arial" font-size="14.00" fill="#000000">level </text>
<text text-anchor="start" x="364.669" y="-176.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="#000000" points="325,-135.5 325,-165.5 600,-165.5 600,-135.5 325,-135.5"/>
<text text-anchor="start" x="332" y="-146.9" font-family="Arial" font-size="14.00" fill="#000000">parent_id </text>
<text text-anchor="start" x="394.244" y="-146.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="325,-105.5 325,-135.5 600,-135.5 600,-105.5 325,-105.5"/>
<text text-anchor="start" x="332" y="-116.9" font-family="Arial" font-size="14.00" fill="#000000">id </text>
<text text-anchor="start" x="346.7798" y="-116.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="325,-75.5 325,-105.5 600,-105.5 600,-75.5 325,-75.5"/>
<text text-anchor="start" x="332" y="-86.9" font-family="Arial" font-size="14.00" fill="#000000">created_at </text>
<text text-anchor="start" x="402.028" y="-86.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="#000000" points="325,-45.5 325,-75.5 600,-75.5 600,-45.5 325,-45.5"/>
<text text-anchor="start" x="331.8093" y="-56.9" font-family="Arial" font-size="14.00" fill="#000000">modified_at </text>
<text text-anchor="start" x="408.0505" y="-56.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="323,-44.5 323,-382.5 601,-382.5 601,-44.5 323,-44.5"/>
</g>
<!-- codes.plan_type&#45;&gt;codes.plan_type -->
<g id="edge1" class="edge">
<title>codes.plan_type:parent_id&#45;&gt;codes.plan_type:id</title>
<path fill="none" stroke="#000000" d="M464.2168,-175.7999C471.9799,-355.1575 471.5743,-717 463,-717 454.2593,-717 454.0075,-312.6761 462.2446,-135.6381"/>
<polygon fill="#000000" stroke="#000000" points="464.2058,-175.5547 468.2509,-165.3621 463.9806,-170.5597 463.7554,-165.5648 463.7554,-165.5648 463.7554,-165.5648 463.9806,-170.5597 459.26,-165.7675 464.2058,-175.5547 464.2058,-175.5547"/>
<text text-anchor="start" x="470.4609" y="-175.5648" font-family="Arial" font-size="10.00" fill="#000000">FOREIGN KEY (parent_id) REFERENCES codes.plan_type(id)</text>
</g>
<!-- hame.plan -->
<g id="node2" class="node">
<title>hame.plan</title>
<polygon fill="#efefef" stroke="transparent" points="309,-1045.5 309,-1080.5 617,-1080.5 617,-1045.5 309,-1045.5"/>
<polygon fill="none" stroke="#000000" points="309,-1045.5 309,-1080.5 617,-1080.5 617,-1045.5 309,-1045.5"/>
<text text-anchor="start" x="357.2031" y="-1058.3" font-family="Arial Bold" font-size="18.00" fill="#000000">hame.plan</text>
<text text-anchor="start" x="441.2289" y="-1058.3" font-family="Arial" font-size="14.00" fill="#000000">    </text>
<text text-anchor="start" x="475.4337" y="-1058.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="309,-1015.5 309,-1045.5 617,-1045.5 617,-1015.5 309,-1015.5"/>
<text text-anchor="start" x="316" y="-1026.9" font-family="Arial" font-size="14.00" fill="#000000">name    </text>
<text text-anchor="start" x="385.2132" y="-1026.9" font-family="Arial" font-size="14.00" fill="#666666">[jsonb]</text>
<polygon fill="none" stroke="#000000" points="309,-985.5 309,-1015.5 617,-1015.5 617,-985.5 309,-985.5"/>
<text text-anchor="start" x="316" y="-996.9" font-family="Arial" font-size="14.00" fill="#000000">id    </text>
<text text-anchor="start" x="361.094" y="-996.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="309,-955.5 309,-985.5 617,-985.5 617,-955.5 309,-955.5"/>
<text text-anchor="start" x="316" y="-966.9" font-family="Arial" font-size="14.00" fill="#000000">created_at    </text>
<text text-anchor="start" x="416.3422" y="-966.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="#000000" points="309,-925.5 309,-955.5 617,-955.5 617,-925.5 309,-925.5"/>
<text text-anchor="start" x="316" y="-936.9" font-family="Arial" font-size="14.00" fill="#000000">modified_at    </text>
<text text-anchor="start" x="422.5554" y="-936.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="#000000" points="309,-895.5 309,-925.5 617,-925.5 617,-895.5 309,-895.5"/>
<text text-anchor="start" x="316" y="-906.9" font-family="Arial" font-size="14.00" fill="#000000">exported_at    </text>
<text text-anchor="start" x="424.1248" y="-906.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="#000000" points="309,-865.5 309,-895.5 617,-895.5 617,-865.5 309,-865.5"/>
<text text-anchor="start" x="316" y="-876.9" font-family="Arial" font-size="14.00" fill="#000000">geom    </text>
<text text-anchor="start" x="385.2132" y="-876.9" font-family="Arial" font-size="14.00" fill="#666666">[geometry(MultiPolygon,3067)]</text>
<polygon fill="none" stroke="#000000" points="309,-835.5 309,-865.5 617,-865.5 617,-835.5 309,-835.5"/>
<text text-anchor="start" x="316" y="-846.9" font-family="Arial" font-size="14.00" fill="#000000">lifecycle_status_id    </text>
<text text-anchor="start" x="463.7812" y="-846.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="309,-805.5 309,-835.5 617,-835.5 617,-805.5 309,-805.5"/>
<text text-anchor="start" x="316" y="-816.9" font-family="Arial" font-size="14.00" fill="#000000">organisation_id    </text>
<text text-anchor="start" x="445.1192" y="-816.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="309,-775.5 309,-805.5 617,-805.5 617,-775.5 309,-775.5"/>
<text text-anchor="start" x="316" y="-786.9" font-family="Arial" font-size="14.00" fill="#000000">plan_regulation_group_id    </text>
<text text-anchor="start" x="508.1472" y="-786.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="309,-745.5 309,-775.5 617,-775.5 617,-745.5 309,-745.5"/>
<text text-anchor="start" x="316" y="-756.9" font-family="Arial" font-size="14.00" fill="#000000">plan_type_id    </text>
<text text-anchor="start" x="429.5694" y="-756.9" font-family="Arial" font-size="14.00" fill="#666666">[uuid]</text>
<polygon fill="none" stroke="#000000" points="309,-715.5 309,-745.5 617,-745.5 617,-715.5 309,-715.5"/>
<text text-anchor="start" x="316" y="-726.9" font-family="Arial" font-size="14.00" fill="#000000">permanent_plan_identifier    </text>
<text text-anchor="start" x="512.0238" y="-726.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar]</text>
<polygon fill="none" stroke="#000000" points="309,-685.5 309,-715.5 617,-715.5 617,-685.5 309,-685.5"/>
<text text-anchor="start" x="316" y="-696.9" font-family="Arial" font-size="14.00" fill="#000000">producers_plan_identifier    </text>
<text text-anchor="start" x="507.3506" y="-696.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar]</text>
<polygon fill="none" stroke="#000000" points="309,-655.5 309,-685.5 617,-685.5 617,-655.5 309,-655.5"/>
<text text-anchor="start" x="316" y="-666.9" font-family="Arial" font-size="14.00" fill="#000000">description    </text>
<text text-anchor="start" x="417.8822" y="-666.9" font-family="Arial" font-size="14.00" fill="#666666">[jsonb]</text>
<polygon fill="none" stroke="#000000" points="309,-625.5 309,-655.5 617,-655.5 617,-625.5 309,-625.5"/>
<text text-anchor="start" x="316" y="-636.9" font-family="Arial" font-size="14.00" fill="#000000">scale    </text>
<text text-anchor="start" x="382.8766" y="-636.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="#000000" points="309,-595.5 309,-625.5 617,-625.5 617,-595.5 309,-595.5"/>
<text text-anchor="start" x="316" y="-606.9" font-family="Arial" font-size="14.00" fill="#000000">matter_management_identifier    </text>
<text text-anchor="start" x="540.0196" y="-606.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar]</text>
<polygon fill="none" stroke="#000000" points="309,-565.5 309,-595.5 617,-595.5 617,-565.5 309,-565.5"/>
<text text-anchor="start" x="316" y="-576.9" font-family="Arial" font-size="14.00" fill="#000000">record_number    </text>
<text text-anchor="start" x="445.108" y="-576.9" font-family="Arial" font-size="14.00" fill="#666666">[varchar]</text>
<polygon fill="none" stroke="#000000" points="309,-535.5 309,-565.5 617,-565.5 617,-535.5 309,-535.5"/>
<text text-anchor="start" x="315.5912" y="-546.9" font-family="Arial" font-size="14.00" fill="#000000">validated_at    </text>
<text text-anchor="start" x="425.2686" y="-546.9" font-family="Arial" font-size="14.00" fill="#666666">[timestamp without time zone]</text>
<polygon fill="none" stroke="#000000" points="309,-505.5 309,-535.5 617,-535.5 617,-505.5 309,-505.5"/>
<text text-anchor="start" x="316" y="-516.9" font-family="Arial" font-size="14.00" fill="#000000">validation_errors    </text>
<text text-anchor="start" x="453.6578" y="-516.9" font-family="Arial" font-size="14.00" fill="#666666">[jsonb]</text>
</g>
<!-- hame.plan&#45;&gt;codes.plan_type -->
<g id="edge2" class="edge">
<title>hame.plan:plan_type_id&#45;&gt;codes.plan_type:id</title>
<path fill="none" stroke="#000000" d="M298.9362,-758.3482C245.3951,-733.9722 267.6105,-509.8254 309,-463 395.3076,-365.3572 513.6924,-524.6428 600,-427 690.217,-324.9344 736.2222,-120.5 600,-120.5"/>
<polygon fill="#000000" stroke="#000000" points="299.221,-758.409 308.0591,-764.9005 304.1105,-759.4545 309,-760.5 309,-760.5 309,-760.5 304.1105,-759.4545 309.9409,-756.0995 299.221,-758.409 299.221,-758.409"/>
<text text-anchor="start" x="7.2015" y="-770.5" font-family="Arial" font-size="10.00" fill="#000000">FOREIGN KEY (plan_type_id) REFERENCES codes.plan_type(id)</text>
</g>
</g>
</svg>