backend/databasemodel/dbdoc/kooste.lipas_pisteet.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: kooste.lipas_pisteet Pages: 1 -->
<svg width="369pt" height="1605pt"
 viewBox="0.00 0.00 369.00 1605.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 1601)">
<title>kooste.lipas_pisteet</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-1601 365,-1601 365,4 -4,4"/>
<!-- kooste.lipas_pisteet -->
<g id="node1" class="node">
<title>kooste.lipas_pisteet</title>
<polygon fill="#efefef" stroke="transparent" points="46.5,-1515.5 46.5,-1550.5 315.5,-1550.5 315.5,-1515.5 46.5,-1515.5"/>
<polygon fill="none" stroke="#000000" points="46.5,-1515.5 46.5,-1550.5 315.5,-1550.5 315.5,-1515.5 46.5,-1515.5"/>
<text text-anchor="start" x="53.3495" y="-1528.3" font-family="Arial Bold" font-size="18.00" fill="#000000">kooste.lipas_pisteet</text>
<text text-anchor="start" x="211.3967" y="-1528.3" font-family="Arial" font-size="14.00" fill="#000000"> </text>
<text text-anchor="start" x="215.2873" y="-1528.3" font-family="Arial" font-size="14.00" fill="#666666">[BASE TABLE]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1485.5 46.5,-1515.5 315.5,-1515.5 315.5,-1485.5 46.5,-1485.5"/>
<text text-anchor="start" x="53.5" y="-1496.9" font-family="Arial" font-size="14.00" fill="#000000">sportsPlaceId </text>
<text text-anchor="start" x="142.1886" y="-1496.9" font-family="Arial" font-size="14.00" fill="#666666">[bigint]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1455.5 46.5,-1485.5 315.5,-1485.5 315.5,-1455.5 46.5,-1455.5"/>
<text text-anchor="start" x="53.5" y="-1466.9" font-family="Arial" font-size="14.00" fill="#000000">geom </text>
<text text-anchor="start" x="92.399" y="-1466.9" font-family="Arial" font-size="14.00" fill="#666666">[geometry(MultiPoint,4326)]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1425.5 46.5,-1455.5 315.5,-1455.5 315.5,-1425.5 46.5,-1425.5"/>
<text text-anchor="start" x="53.5" y="-1436.9" font-family="Arial" font-size="14.00" fill="#000000">name </text>
<text text-anchor="start" x="92.399" y="-1436.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1395.5 46.5,-1425.5 315.5,-1425.5 315.5,-1395.5 46.5,-1395.5"/>
<text text-anchor="start" x="53.5" y="-1406.9" font-family="Arial" font-size="14.00" fill="#000000">type_typeCode </text>
<text text-anchor="start" x="151.5392" y="-1406.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1365.5 46.5,-1395.5 315.5,-1395.5 315.5,-1365.5 46.5,-1365.5"/>
<text text-anchor="start" x="53.5" y="-1376.9" font-family="Arial" font-size="14.00" fill="#000000">type_name </text>
<text text-anchor="start" x="126.6374" y="-1376.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1335.5 46.5,-1365.5 315.5,-1365.5 315.5,-1335.5 46.5,-1335.5"/>
<text text-anchor="start" x="53.5" y="-1346.9" font-family="Arial" font-size="14.00" fill="#000000">tarmo_category </text>
<text text-anchor="start" x="154.6318" y="-1346.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1305.5 46.5,-1335.5 315.5,-1335.5 315.5,-1305.5 46.5,-1305.5"/>
<text text-anchor="start" x="53.5" y="-1316.9" font-family="Arial" font-size="14.00" fill="#000000">owner </text>
<text text-anchor="start" x="95.5056" y="-1316.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1275.5 46.5,-1305.5 315.5,-1305.5 315.5,-1275.5 46.5,-1275.5"/>
<text text-anchor="start" x="53.5" y="-1286.9" font-family="Arial" font-size="14.00" fill="#000000">admin </text>
<text text-anchor="start" x="95.5056" y="-1286.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1245.5 46.5,-1275.5 315.5,-1275.5 315.5,-1245.5 46.5,-1245.5"/>
<text text-anchor="start" x="53.5" y="-1256.9" font-family="Arial" font-size="14.00" fill="#000000">address </text>
<text text-anchor="start" x="107.1816" y="-1256.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1215.5 46.5,-1245.5 315.5,-1245.5 315.5,-1215.5 46.5,-1215.5"/>
<text text-anchor="start" x="53.5" y="-1226.9" font-family="Arial" font-size="14.00" fill="#000000">postalCode </text>
<text text-anchor="start" x="128.19" y="-1226.9" font-family="Arial" font-size="14.00" fill="#666666">[integer]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1185.5 46.5,-1215.5 315.5,-1215.5 315.5,-1185.5 46.5,-1185.5"/>
<text text-anchor="start" x="53.5" y="-1196.9" font-family="Arial" font-size="14.00" fill="#000000">postalOffice </text>
<text text-anchor="start" x="131.2966" y="-1196.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1155.5 46.5,-1185.5 315.5,-1185.5 315.5,-1155.5 46.5,-1155.5"/>
<text text-anchor="start" x="53.5" y="-1166.9" font-family="Arial" font-size="14.00" fill="#000000">cityName </text>
<text text-anchor="start" x="115.7202" y="-1166.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1125.5 46.5,-1155.5 315.5,-1155.5 315.5,-1125.5 46.5,-1125.5"/>
<text text-anchor="start" x="53.5" y="-1136.9" font-family="Arial" font-size="14.00" fill="#000000">email </text>
<text text-anchor="start" x="90.8296" y="-1136.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1095.5 46.5,-1125.5 315.5,-1125.5 315.5,-1095.5 46.5,-1095.5"/>
<text text-anchor="start" x="53.5" y="-1106.9" font-family="Arial" font-size="14.00" fill="#000000">phoneNumber </text>
<text text-anchor="start" x="146.0792" y="-1106.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1065.5 46.5,-1095.5 315.5,-1095.5 315.5,-1065.5 46.5,-1065.5"/>
<text text-anchor="start" x="53.5" y="-1076.9" font-family="Arial" font-size="14.00" fill="#000000">www </text>
<text text-anchor="start" x="87.7104" y="-1076.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1035.5 46.5,-1065.5 315.5,-1065.5 315.5,-1035.5 46.5,-1035.5"/>
<text text-anchor="start" x="53.5" y="-1046.9" font-family="Arial" font-size="14.00" fill="#000000">season </text>
<text text-anchor="start" x="102.521" y="-1046.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-1005.5 46.5,-1035.5 315.5,-1035.5 315.5,-1005.5 46.5,-1005.5"/>
<text text-anchor="start" x="53.5" y="-1016.9" font-family="Arial" font-size="14.00" fill="#000000">toilet </text>
<text text-anchor="start" x="86.9502" y="-1016.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-975.5 46.5,-1005.5 315.5,-1005.5 315.5,-975.5 46.5,-975.5"/>
<text text-anchor="start" x="53.5" y="-986.9" font-family="Arial" font-size="14.00" fill="#000000">shower </text>
<text text-anchor="start" x="102.5056" y="-986.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-945.5 46.5,-975.5 315.5,-975.5 315.5,-945.5 46.5,-945.5"/>
<text text-anchor="start" x="53.5" y="-956.9" font-family="Arial" font-size="14.00" fill="#000000">changingRooms </text>
<text text-anchor="start" x="158.5252" y="-956.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-915.5 46.5,-945.5 315.5,-945.5 315.5,-915.5 46.5,-915.5"/>
<text text-anchor="start" x="53.5" y="-926.9" font-family="Arial" font-size="14.00" fill="#000000">ligthing </text>
<text text-anchor="start" x="101.7314" y="-926.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-885.5 46.5,-915.5 315.5,-915.5 315.5,-885.5 46.5,-885.5"/>
<text text-anchor="start" x="53.5" y="-896.9" font-family="Arial" font-size="14.00" fill="#000000">restPlacesCount </text>
<text text-anchor="start" x="160.0778" y="-896.9" font-family="Arial" font-size="14.00" fill="#666666">[numeric]</text>
<polygon fill="none" stroke="#000000" points="46.5,-855.5 46.5,-885.5 315.5,-885.5 315.5,-855.5 46.5,-855.5"/>
<text text-anchor="start" x="53.5" y="-866.9" font-family="Arial" font-size="14.00" fill="#000000">skiTrackTraditional </text>
<text text-anchor="start" x="174.8296" y="-866.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-825.5 46.5,-855.5 315.5,-855.5 315.5,-825.5 46.5,-825.5"/>
<text text-anchor="start" x="53.5" y="-836.9" font-family="Arial" font-size="14.00" fill="#000000">skiTrackFreestyle </text>
<text text-anchor="start" x="167.0512" y="-836.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-795.5 46.5,-825.5 315.5,-825.5 315.5,-795.5 46.5,-795.5"/>
<text text-anchor="start" x="53.5" y="-806.9" font-family="Arial" font-size="14.00" fill="#000000">litRouteLengthKm </text>
<text text-anchor="start" x="168.6402" y="-806.9" font-family="Arial" font-size="14.00" fill="#666666">[numeric]</text>
<polygon fill="none" stroke="#000000" points="46.5,-765.5 46.5,-795.5 315.5,-795.5 315.5,-765.5 46.5,-765.5"/>
<text text-anchor="start" x="53.5" y="-776.9" font-family="Arial" font-size="14.00" fill="#000000">routeLengthKm </text>
<text text-anchor="start" x="153.0904" y="-776.9" font-family="Arial" font-size="14.00" fill="#666666">[numeric]</text>
<polygon fill="none" stroke="#000000" points="46.5,-735.5 46.5,-765.5 315.5,-765.5 315.5,-735.5 46.5,-735.5"/>
<text text-anchor="start" x="53.5" y="-746.9" font-family="Arial" font-size="14.00" fill="#000000">pier </text>
<text text-anchor="start" x="80.723" y="-746.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-705.5 46.5,-735.5 315.5,-735.5 315.5,-705.5 46.5,-705.5"/>
<text text-anchor="start" x="53.5" y="-716.9" font-family="Arial" font-size="14.00" fill="#000000">otherPlatforms </text>
<text text-anchor="start" x="148.4004" y="-716.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-675.5 46.5,-705.5 315.5,-705.5 315.5,-675.5 46.5,-675.5"/>
<text text-anchor="start" x="53.5" y="-686.9" font-family="Arial" font-size="14.00" fill="#000000">accessibilityInfo </text>
<text text-anchor="start" x="155.4018" y="-686.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-645.5 46.5,-675.5 315.5,-675.5 315.5,-645.5 46.5,-645.5"/>
<text text-anchor="start" x="53.5" y="-656.9" font-family="Arial" font-size="14.00" fill="#000000">kiosk </text>
<text text-anchor="start" x="89.2798" y="-656.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-615.5 46.5,-645.5 315.5,-645.5 315.5,-615.5 46.5,-615.5"/>
<text text-anchor="start" x="53.5" y="-626.9" font-family="Arial" font-size="14.00" fill="#000000">skiService </text>
<text text-anchor="start" x="121.1662" y="-626.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-585.5 46.5,-615.5 315.5,-615.5 315.5,-585.5 46.5,-585.5"/>
<text text-anchor="start" x="53.5" y="-596.9" font-family="Arial" font-size="14.00" fill="#000000">equipmentRental </text>
<text text-anchor="start" x="163.1956" y="-596.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-555.5 46.5,-585.5 315.5,-585.5 315.5,-555.5 46.5,-555.5"/>
<text text-anchor="start" x="53.5" y="-566.9" font-family="Arial" font-size="14.00" fill="#000000">sauna </text>
<text text-anchor="start" x="95.521" y="-566.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-525.5 46.5,-555.5 315.5,-555.5 315.5,-525.5 46.5,-525.5"/>
<text text-anchor="start" x="53.5" y="-536.9" font-family="Arial" font-size="14.00" fill="#000000">playground </text>
<text text-anchor="start" x="126.636" y="-536.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-495.5 46.5,-525.5 315.5,-525.5 315.5,-495.5 46.5,-495.5"/>
<text text-anchor="start" x="53.5" y="-506.9" font-family="Arial" font-size="14.00" fill="#000000">exerciseMachines </text>
<text text-anchor="start" x="169.4032" y="-506.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-465.5 46.5,-495.5 315.5,-495.5 315.5,-465.5 46.5,-465.5"/>
<text text-anchor="start" x="53.5" y="-476.9" font-family="Arial" font-size="14.00" fill="#000000">infoFi </text>
<text text-anchor="start" x="91.6122" y="-476.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-435.5 46.5,-465.5 315.5,-465.5 315.5,-435.5 46.5,-435.5"/>
<text text-anchor="start" x="53.5" y="-446.9" font-family="Arial" font-size="14.00" fill="#000000">trackLengthM </text>
<text text-anchor="start" x="142.1886" y="-446.9" font-family="Arial" font-size="14.00" fill="#666666">[numeric]</text>
<polygon fill="none" stroke="#000000" points="46.5,-405.5 46.5,-435.5 315.5,-435.5 315.5,-405.5 46.5,-405.5"/>
<text text-anchor="start" x="53.5" y="-416.9" font-family="Arial" font-size="14.00" fill="#000000">altitudeDifference </text>
<text text-anchor="start" x="166.3008" y="-416.9" font-family="Arial" font-size="14.00" fill="#666666">[numeric]</text>
<polygon fill="none" stroke="#000000" points="46.5,-375.5 46.5,-405.5 315.5,-405.5 315.5,-375.5 46.5,-375.5"/>
<text text-anchor="start" x="53.5" y="-386.9" font-family="Arial" font-size="14.00" fill="#000000">climbingWallWidthM </text>
<text text-anchor="start" x="183.3668" y="-386.9" font-family="Arial" font-size="14.00" fill="#666666">[numeric]</text>
<polygon fill="none" stroke="#000000" points="46.5,-345.5 46.5,-375.5 315.5,-375.5 315.5,-345.5 46.5,-345.5"/>
<text text-anchor="start" x="53.5" y="-356.9" font-family="Arial" font-size="14.00" fill="#000000">climbingWallHeightM </text>
<text text-anchor="start" x="188.0414" y="-356.9" font-family="Arial" font-size="14.00" fill="#666666">[numeric]</text>
<polygon fill="none" stroke="#000000" points="46.5,-315.5 46.5,-345.5 315.5,-345.5 315.5,-315.5 46.5,-315.5"/>
<text text-anchor="start" x="53.5" y="-326.9" font-family="Arial" font-size="14.00" fill="#000000">climbingRoutesCount </text>
<text text-anchor="start" x="190.4088" y="-326.9" font-family="Arial" font-size="14.00" fill="#666666">[numeric]</text>
<polygon fill="none" stroke="#000000" points="46.5,-285.5 46.5,-315.5 315.5,-315.5 315.5,-285.5 46.5,-285.5"/>
<text text-anchor="start" x="53.5" y="-296.9" font-family="Arial" font-size="14.00" fill="#000000">holesCount </text>
<text text-anchor="start" x="128.19" y="-296.9" font-family="Arial" font-size="14.00" fill="#666666">[numeric]</text>
<polygon fill="none" stroke="#000000" points="46.5,-255.5 46.5,-285.5 315.5,-285.5 315.5,-255.5 46.5,-255.5"/>
<text text-anchor="start" x="53.5" y="-266.9" font-family="Arial" font-size="14.00" fill="#000000">boatLaunchingSpot </text>
<text text-anchor="start" x="178.0062" y="-266.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-225.5 46.5,-255.5 315.5,-255.5 315.5,-225.5 46.5,-225.5"/>
<text text-anchor="start" x="53.5" y="-236.9" font-family="Arial" font-size="14.00" fill="#000000">iceClimbing </text>
<text text-anchor="start" x="129.7146" y="-236.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-195.5 46.5,-225.5 315.5,-225.5 315.5,-195.5 46.5,-195.5"/>
<text text-anchor="start" x="53.5" y="-206.9" font-family="Arial" font-size="14.00" fill="#000000">iceReduction </text>
<text text-anchor="start" x="138.2966" y="-206.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-165.5 46.5,-195.5 315.5,-195.5 315.5,-165.5 46.5,-165.5"/>
<text text-anchor="start" x="53.5" y="-176.9" font-family="Arial" font-size="14.00" fill="#000000">range </text>
<text text-anchor="start" x="93.1816" y="-176.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" points="46.5,-135.5 46.5,-165.5 315.5,-165.5 315.5,-135.5 46.5,-135.5"/>
<text text-anchor="start" x="53.5" y="-146.9" font-family="Arial" font-size="14.00" fill="#000000">trackType </text>
<text text-anchor="start" x="118.8422" y="-146.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-105.5 46.5,-135.5 315.5,-135.5 315.5,-105.5 46.5,-105.5"/>
<text text-anchor="start" x="53.5" y="-116.9" font-family="Arial" font-size="14.00" fill="#000000">additionalInfo </text>
<text text-anchor="start" x="140.643" y="-116.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-75.5 46.5,-105.5 315.5,-105.5 315.5,-75.5 46.5,-75.5"/>
<text text-anchor="start" x="53.5" y="-86.9" font-family="Arial" font-size="14.00" fill="#000000">images </text>
<text text-anchor="start" x="102.5056" y="-86.9" font-family="Arial" font-size="14.00" fill="#666666">[text]</text>
<polygon fill="none" stroke="#000000" points="46.5,-45.5 46.5,-75.5 315.5,-75.5 315.5,-45.5 46.5,-45.5"/>
<text text-anchor="start" x="53.5" y="-56.9" font-family="Arial" font-size="14.00" fill="#000000">deleted </text>
<text text-anchor="start" x="103.3008" y="-56.9" font-family="Arial" font-size="14.00" fill="#666666">[boolean]</text>
<polygon fill="none" stroke="#000000" stroke-width="3" points="44.5,-44.5 44.5,-1552.5 316.5,-1552.5 316.5,-44.5 44.5,-44.5"/>
</g>
</g>
</svg>