TABLE 'arktallennetunnus' BOX id: #122 coords: 1.000000, 1.000000 size: 3.500000, 0.500000 text (style TABNAME):'arktallennetunnus' BOX id: #1 coords: 1.000000, 1.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'arktunnus'text (style TYPENAME):' (varchar)' BOX id: #2 coords: 1.000000, 2.000000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (varchar)' TABLE 'arktallenne' BOX id: #123 coords: 6.250000, 1.000000 size: 3.500000, 0.500000 text (style TABNAME):'arktallenne' BOX id: #3 coords: 6.250000, 1.500000 size: 3.500000, 0.500000 text (style COLNAME):'avoin'text (style TYPENAME):' (char)' BOX id: #4 coords: 6.250000, 2.000000 size: 3.500000, 0.500000 text (style COLNAME):'alkupvm'text (style TYPENAME):' (date)' BOX id: #5 coords: 6.250000, 2.500000 size: 3.500000, 0.500000 text (style COLNAME):'fyysinenmuoto'text (style TYPENAME):' (varchar)' BOX id: #6 coords: 6.250000, 3.000000 size: 3.500000, 0.500000 text (style COLNAME):'formaatti'text (style TYPENAME):' (varchar)' BOX id: #7 coords: 6.250000, 3.500000 size: 3.500000, 0.500000 text (style COLNAME):'sistyyppi'text (style TYPENAME):' (varchar)' BOX id: #8 coords: 6.250000, 4.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tallenneid'text (style TYPENAME):' (int)' BOX id: #9 coords: 6.250000, 4.500000 size: 3.500000, 0.500000 text (style COLNAME):'loppupvm'text (style TYPENAME):' (date)' BOX id: #10 coords: 6.250000, 5.000000 size: 3.500000, 0.500000 text (style COLNAME):'kuvaus'text (style TYPENAME):' (text)' BOX id: #11 coords: 6.250000, 5.500000 size: 3.500000, 0.500000 text (style COLNAME):'huom'text (style TYPENAME):' (text)' BOX id: #12 coords: 6.250000, 6.000000 size: 3.500000, 0.500000 text (style COLNAME):'arktunnus'text (style TYPENAME):' (varchar)' BOX id: #13 coords: 6.250000, 6.500000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (varchar)' BOX id: #14 coords: 6.250000, 7.000000 size: 3.500000, 0.500000 text (style COLNAME):'julkaisija'text (style TYPENAME):' (varchar)' BOX id: #15 coords: 6.250000, 7.500000 size: 3.500000, 0.500000 text (style COLNAME):'sijainti'text (style TYPENAME):' (int)' BOX id: #16 coords: 6.250000, 8.000000 size: 3.500000, 0.500000 text (style COLNAME):'kpl'text (style TYPENAME):' (int)' BOX id: #17 coords: 6.250000, 8.500000 size: 3.500000, 0.500000 text (style COLNAME):'tarkoitus'text (style TYPENAME):' (varchar)' ARROW (FILLED) #12 -> #1 (coords 9.750000, 6.250000 -> 1.000000, 1.750000) ARROW (FILLED) #15 -> #8 (coords 9.750000, 7.750000 -> 6.250000, 4.250000) ARROW (FILLED) #7 -> #89 (coords 9.750000, 3.750000 -> 6.250000, 29.250000) ARROW (FILLED) #5 -> #97 (coords 9.750000, 2.750000 -> 16.750000, 29.750000) ARROW (FILLED) #17 -> #118 (coords 9.750000, 8.750000 -> 1.000000, 38.750000) TABLE 'teostyyppi' BOX id: #124 coords: 11.500000, 1.000000 size: 3.500000, 0.500000 text (style TABNAME):'teostyyppi' BOX id: #18 coords: 11.500000, 1.500000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (varchar)' BOX id: #19 coords: 11.500000, 2.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tyyppi'text (style TYPENAME):' (varchar)' BOX id: #20 coords: 11.500000, 2.500000 size: 3.500000, 0.500000 text (style COLNAME):'prioriteetti'text (style TYPENAME):' (int)' TABLE 'vlehtihakutulokset' BOX id: #125 coords: 16.750000, 1.000000 size: 3.500000, 0.500000 text (style TABNAME):'vlehtihakutulokset' BOX id: #21 coords: 16.750000, 1.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'hakuid'text (style TYPENAME):' (int)' BOX id: #22 coords: 16.750000, 2.000000 size: 3.500000, 0.500000 text (style COLNAME):'alkukohta'text (style TYPENAME):' (int)' BOX id: #23 coords: 16.750000, 2.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'vlehtiid'text (style TYPENAME):' (int)' ARROW (FILLED) #21 -> #68 (coords 20.250000, 1.750000 -> 1.000000, 24.250000) ARROW (FILLED) #23 -> #63 (coords 20.250000, 2.750000 -> 16.750000, 20.250000) TABLE 'tuotantotekijat' BOX id: #126 coords: 1.000000, 10.000000 size: 3.500000, 0.500000 text (style TABNAME):'tuotantotekijat' BOX id: #24 coords: 1.000000, 10.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'henkiloid'text (style TYPENAME):' (int)' BOX id: #25 coords: 1.000000, 11.000000 size: 3.500000, 0.500000 text (style COLNAME):'huom'text (style TYPENAME):' (text)' BOX id: #26 coords: 1.000000, 11.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tehtava'text (style TYPENAME):' (varchar)' BOX id: #27 coords: 1.000000, 12.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tuotantoid'text (style TYPENAME):' (int)' ARROW (FILLED) #26 -> #94 (coords 4.500000, 11.750000 -> 11.500000, 29.750000) ARROW (FILLED) #24 -> #105 (coords 4.500000, 10.750000 -> 11.500000, 32.750000) ARROW (FILLED) #27 -> #84 (coords 4.500000, 12.250000 -> 16.750000, 26.750000) TABLE 'vlehtihenkilot' BOX id: #127 coords: 6.250000, 10.000000 size: 3.500000, 0.500000 text (style TABNAME):'vlehtihenkilot' BOX id: #28 coords: 6.250000, 10.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'henkiloid'text (style TYPENAME):' (int)' BOX id: #29 coords: 6.250000, 11.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'vlehtiid'text (style TYPENAME):' (int)' ARROW (FILLED) #29 -> #63 (coords 9.750000, 11.250000 -> 16.750000, 20.250000) ARROW (FILLED) #28 -> #105 (coords 9.750000, 10.750000 -> 11.500000, 32.750000) TABLE 'teostekijat' BOX id: #128 coords: 11.500000, 10.000000 size: 3.500000, 0.500000 text (style TABNAME):'teostekijat' BOX id: #30 coords: 11.500000, 10.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'henkiloid'text (style TYPENAME):' (int)' BOX id: #31 coords: 11.500000, 11.000000 size: 3.500000, 0.500000 text (style COLNAME):'huom'text (style TYPENAME):' (text)' BOX id: #32 coords: 11.500000, 11.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tehtava'text (style TYPENAME):' (varchar)' BOX id: #33 coords: 11.500000, 12.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'teosid'text (style TYPENAME):' (int)' ARROW (FILLED) #32 -> #101 (coords 15.000000, 11.750000 -> 1.000000, 33.250000) ARROW (FILLED) #33 -> #117 (coords 15.000000, 12.250000 -> 16.750000, 34.250000) ARROW (FILLED) #30 -> #105 (coords 15.000000, 10.750000 -> 11.500000, 32.750000) TABLE 'kieli' BOX id: #129 coords: 16.750000, 10.000000 size: 3.500000, 0.500000 text (style TABNAME):'kieli' BOX id: #34 coords: 16.750000, 10.500000 size: 3.500000, 0.500000 text (style COLNAME):'nimi'text (style TYPENAME):' (varchar)' BOX id: #35 coords: 16.750000, 11.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'kielikoodi'text (style TYPENAME):' (char)' BOX id: #36 coords: 16.750000, 11.500000 size: 3.500000, 0.500000 text (style COLNAME):'prioriteetti'text (style TYPENAME):' (int)' TABLE 'tuotantotyyppi' BOX id: #130 coords: 1.000000, 13.500000 size: 3.500000, 0.500000 text (style TABNAME):'tuotantotyyppi' BOX id: #37 coords: 1.000000, 14.000000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (varchar)' BOX id: #38 coords: 1.000000, 14.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tyyppi'text (style TYPENAME):' (varchar)' BOX id: #39 coords: 1.000000, 15.000000 size: 3.500000, 0.500000 text (style COLNAME):'prioriteetti'text (style TYPENAME):' (int)' TABLE 'arktallennetuotannot' BOX id: #131 coords: 6.250000, 13.500000 size: 3.500000, 0.500000 text (style TABNAME):'arktallennetuotannot' BOX id: #40 coords: 6.250000, 14.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tallenneid'text (style TYPENAME):' (int)' BOX id: #41 coords: 6.250000, 14.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tuotantoid'text (style TYPENAME):' (int)' ARROW (FILLED) #40 -> #8 (coords 9.750000, 14.250000 -> 6.250000, 4.250000) ARROW (FILLED) #41 -> #84 (coords 9.750000, 14.750000 -> 16.750000, 26.750000) TABLE 'teosnimet' BOX id: #132 coords: 11.500000, 13.500000 size: 3.500000, 0.500000 text (style TABNAME):'teosnimet' BOX id: #42 coords: 11.500000, 14.000000 size: 3.500000, 0.500000 text (style COLNAME):'nimi'text (style TYPENAME):' (varchar)' BOX id: #43 coords: 11.500000, 14.500000 size: 3.500000, 0.500000 text (style COLNAME):'kielikoodi'text (style TYPENAME):' (char)' BOX id: #44 coords: 11.500000, 15.000000 size: 3.500000, 0.500000 text (style COLNAME):'teosid'text (style TYPENAME):' (int)' BOX id: #45 coords: 11.500000, 15.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'teosnimiid'text (style TYPENAME):' (int)' ARROW (FILLED) #43 -> #35 (coords 15.000000, 14.750000 -> 16.750000, 11.250000) ARROW (FILLED) #44 -> #117 (coords 15.000000, 15.250000 -> 16.750000, 34.250000) TABLE 'ongelma' BOX id: #133 coords: 16.750000, 13.500000 size: 3.500000, 0.500000 text (style TABNAME):'ongelma' BOX id: #46 coords: 16.750000, 14.000000 size: 3.500000, 0.500000 text (style COLNAME):'selitys'text (style TYPENAME):' (text)' BOX id: #47 coords: 16.750000, 14.500000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (tinytext)' BOX id: #48 coords: 16.750000, 15.000000 size: 3.500000, 0.500000 text (style COLNAME):'suljettu'text (style TYPENAME):' (date)' BOX id: #49 coords: 16.750000, 15.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'ongelmaid'text (style TYPENAME):' (int)' BOX id: #50 coords: 16.750000, 16.000000 size: 3.500000, 0.500000 text (style COLNAME):'avattu'text (style TYPENAME):' (date)' TABLE 'arktallenneteokset' BOX id: #134 coords: 1.000000, 17.500000 size: 3.500000, 0.500000 text (style TABNAME):'arktallenneteokset' BOX id: #51 coords: 1.000000, 18.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tallenneid'text (style TYPENAME):' (int)' BOX id: #52 coords: 1.000000, 18.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'teosid'text (style TYPENAME):' (int)' ARROW (FILLED) #51 -> #8 (coords 4.500000, 18.250000 -> 6.250000, 4.250000) ARROW (FILLED) #52 -> #117 (coords 4.500000, 18.750000 -> 16.750000, 34.250000) TABLE 'aliteokset' BOX id: #135 coords: 6.250000, 17.500000 size: 3.500000, 0.500000 text (style TABNAME):'aliteokset' BOX id: #53 coords: 6.250000, 18.000000 size: 3.500000, 0.500000 text (style COLNAME):'huom'text (style TYPENAME):' (text)' BOX id: #54 coords: 6.250000, 18.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'aliteosid'text (style TYPENAME):' (int)' BOX id: #55 coords: 6.250000, 19.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'teosid'text (style TYPENAME):' (int)' ARROW (FILLED) #55 -> #117 (coords 9.750000, 19.250000 -> 16.750000, 34.250000) ARROW (FILLED) #54 -> #117 (coords 9.750000, 18.750000 -> 16.750000, 34.250000) TABLE 'tuotantoteokset' BOX id: #136 coords: 11.500000, 17.500000 size: 3.500000, 0.500000 text (style TABNAME):'tuotantoteokset' BOX id: #56 coords: 11.500000, 18.000000 size: 3.500000, 0.500000 text (style COLNAME):'huom'text (style TYPENAME):' (tinytext)' BOX id: #57 coords: 11.500000, 18.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'teosid'text (style TYPENAME):' (int)' BOX id: #58 coords: 11.500000, 19.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tuotantoid'text (style TYPENAME):' (int)' ARROW (FILLED) #58 -> #84 (coords 15.000000, 19.250000 -> 16.750000, 26.750000) ARROW (FILLED) #57 -> #117 (coords 15.000000, 18.750000 -> 16.750000, 34.250000) TABLE 'vlehti' BOX id: #137 coords: 16.750000, 17.500000 size: 3.500000, 0.500000 text (style TABNAME):'vlehti' BOX id: #59 coords: 16.750000, 18.000000 size: 3.500000, 0.500000 text (style COLNAME):'sivunumero'text (style TYPENAME):' (int)' BOX id: #60 coords: 16.750000, 18.500000 size: 3.500000, 0.500000 text (style COLNAME):'luokat'text (style TYPENAME):' (set)' BOX id: #61 coords: 16.750000, 19.000000 size: 3.500000, 0.500000 text (style COLNAME):'teksti'text (style TYPENAME):' (text)' BOX id: #62 coords: 16.750000, 19.500000 size: 3.500000, 0.500000 text (style COLNAME):'muutettu'text (style TYPENAME):' (timestamp)' BOX id: #63 coords: 16.750000, 20.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'vlehtiid'text (style TYPENAME):' (int)' BOX id: #64 coords: 16.750000, 20.500000 size: 3.500000, 0.500000 text (style COLNAME):'lehtiryhmaid'text (style TYPENAME):' (int)' BOX id: #65 coords: 16.750000, 21.000000 size: 3.500000, 0.500000 text (style COLNAME):'originaaliteksti'text (style TYPENAME):' (text)' BOX id: #66 coords: 16.750000, 21.500000 size: 3.500000, 0.500000 text (style COLNAME):'pvm'text (style TYPENAME):' (date)' BOX id: #67 coords: 16.750000, 22.000000 size: 3.500000, 0.500000 text (style COLNAME):'tiedostonimi'text (style TYPENAME):' (varchar)' TABLE 'vlehtihaku' BOX id: #138 coords: 1.000000, 23.500000 size: 3.500000, 0.500000 text (style TABNAME):'vlehtihaku' BOX id: #68 coords: 1.000000, 24.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'hakuid'text (style TYPENAME):' (int)' BOX id: #69 coords: 1.000000, 24.500000 size: 3.500000, 0.500000 text (style COLNAME):'maxvirhe'text (style TYPENAME):' (int)' BOX id: #70 coords: 1.000000, 25.000000 size: 3.500000, 0.500000 text (style COLNAME):'minpvm'text (style TYPENAME):' (date)' BOX id: #71 coords: 1.000000, 25.500000 size: 3.500000, 0.500000 text (style COLNAME):'hakuteksti'text (style TYPENAME):' (varchar)' BOX id: #72 coords: 1.000000, 26.000000 size: 3.500000, 0.500000 text (style COLNAME):'valmis'text (style TYPENAME):' (char)' BOX id: #73 coords: 1.000000, 26.500000 size: 3.500000, 0.500000 text (style COLNAME):'maxpvm'text (style TYPENAME):' (date)' BOX id: #74 coords: 1.000000, 27.000000 size: 3.500000, 0.500000 text (style COLNAME):'hakuaika'text (style TYPENAME):' (timestamp)' TABLE 'arktallennehenkilot' BOX id: #139 coords: 6.250000, 23.500000 size: 3.500000, 0.500000 text (style TABNAME):'arktallennehenkilot' BOX id: #75 coords: 6.250000, 24.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'henkiloid'text (style TYPENAME):' (int)' BOX id: #76 coords: 6.250000, 24.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tallenneid'text (style TYPENAME):' (int)' ARROW (FILLED) #76 -> #8 (coords 9.750000, 24.750000 -> 6.250000, 4.250000) ARROW (FILLED) #75 -> #105 (coords 9.750000, 24.250000 -> 11.500000, 32.750000) TABLE 'vlehtiteokset' BOX id: #140 coords: 11.500000, 23.500000 size: 3.500000, 0.500000 text (style TABNAME):'vlehtiteokset' BOX id: #77 coords: 11.500000, 24.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'teosid'text (style TYPENAME):' (int)' BOX id: #78 coords: 11.500000, 24.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'vlehtiid'text (style TYPENAME):' (int)' ARROW (FILLED) #78 -> #63 (coords 15.000000, 24.750000 -> 16.750000, 20.250000) ARROW (FILLED) #77 -> #117 (coords 15.000000, 24.250000 -> 16.750000, 34.250000) TABLE 'tuotanto' BOX id: #141 coords: 16.750000, 23.500000 size: 3.500000, 0.500000 text (style TABNAME):'tuotanto' BOX id: #79 coords: 16.750000, 24.000000 size: 3.500000, 0.500000 text (style COLNAME):'nimi'text (style TYPENAME):' (varchar)' BOX id: #80 coords: 16.750000, 24.500000 size: 3.500000, 0.500000 text (style COLNAME):'poistopvm'text (style TYPENAME):' (date)' BOX id: #81 coords: 16.750000, 25.000000 size: 3.500000, 0.500000 text (style COLNAME):'tunnus'text (style TYPENAME):' (varchar)' BOX id: #82 coords: 16.750000, 25.500000 size: 3.500000, 0.500000 text (style COLNAME):'huom'text (style TYPENAME):' (text)' BOX id: #83 coords: 16.750000, 26.000000 size: 3.500000, 0.500000 text (style COLNAME):'ensiiltapvm'text (style TYPENAME):' (date)' BOX id: #84 coords: 16.750000, 26.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tuotantoid'text (style TYPENAME):' (int)' BOX id: #85 coords: 16.750000, 27.000000 size: 3.500000, 0.500000 text (style COLNAME):'tyyppi'text (style TYPENAME):' (varchar)' ARROW (FILLED) #85 -> #38 (coords 20.250000, 27.250000 -> 1.000000, 14.750000) TABLE 'vlehtiluokka' BOX id: #142 coords: 1.000000, 28.500000 size: 3.500000, 0.500000 text (style TABNAME):'vlehtiluokka' BOX id: #86 coords: 1.000000, 29.000000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (varchar)' BOX id: #87 coords: 1.000000, 29.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'luokka'text (style TYPENAME):' (varchar)' BOX id: #88 coords: 1.000000, 30.000000 size: 3.500000, 0.500000 text (style COLNAME):'prioriteetti'text (style TYPENAME):' (int)' TABLE 'arktallennesistyyppi' BOX id: #143 coords: 6.250000, 28.500000 size: 3.500000, 0.500000 text (style TABNAME):'arktallennesistyyppi' BOX id: #89 coords: 6.250000, 29.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'sistyyppi'text (style TYPENAME):' (varchar)' BOX id: #90 coords: 6.250000, 29.500000 size: 3.500000, 0.500000 text (style COLNAME):'kuvaus'text (style TYPENAME):' (varchar)' BOX id: #91 coords: 6.250000, 30.000000 size: 3.500000, 0.500000 text (style COLNAME):'prioriteetti'text (style TYPENAME):' (int)' BOX id: #92 coords: 6.250000, 30.500000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (varchar)' TABLE 'tuotantotehtava' BOX id: #144 coords: 11.500000, 28.500000 size: 3.500000, 0.500000 text (style TABNAME):'tuotantotehtava' BOX id: #93 coords: 11.500000, 29.000000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (varchar)' BOX id: #94 coords: 11.500000, 29.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tehtava'text (style TYPENAME):' (varchar)' BOX id: #95 coords: 11.500000, 30.000000 size: 3.500000, 0.500000 text (style COLNAME):'prioriteetti'text (style TYPENAME):' (int)' TABLE 'arktallennefmuoto' BOX id: #145 coords: 16.750000, 28.500000 size: 3.500000, 0.500000 text (style TABNAME):'arktallennefmuoto' BOX id: #96 coords: 16.750000, 29.000000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (varchar)' BOX id: #97 coords: 16.750000, 29.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'fyysinenmuoto'text (style TYPENAME):' (varchar)' BOX id: #98 coords: 16.750000, 30.000000 size: 3.500000, 0.500000 text (style COLNAME):'kuvaus'text (style TYPENAME):' (varchar)' BOX id: #99 coords: 16.750000, 30.500000 size: 3.500000, 0.500000 text (style COLNAME):'prioriteetti'text (style TYPENAME):' (int)' TABLE 'teostehtava' BOX id: #146 coords: 1.000000, 32.000000 size: 3.500000, 0.500000 text (style TABNAME):'teostehtava' BOX id: #100 coords: 1.000000, 32.500000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (varchar)' BOX id: #101 coords: 1.000000, 33.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tehtava'text (style TYPENAME):' (varchar)' BOX id: #102 coords: 1.000000, 33.500000 size: 3.500000, 0.500000 text (style COLNAME):'prioriteetti'text (style TYPENAME):' (int)' TABLE 'vlehtiluokat' BOX id: #147 coords: 6.250000, 32.000000 size: 3.500000, 0.500000 text (style TABNAME):'vlehtiluokat' BOX id: #103 coords: 6.250000, 32.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'luokka'text (style TYPENAME):' (varchar)' BOX id: #104 coords: 6.250000, 33.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'vlehtiid'text (style TYPENAME):' (int)' ARROW (FILLED) #104 -> #63 (coords 9.750000, 33.250000 -> 16.750000, 20.250000) ARROW (FILLED) #103 -> #87 (coords 9.750000, 32.750000 -> 1.000000, 29.750000) TABLE 'henkilo' BOX id: #148 coords: 11.500000, 32.000000 size: 3.500000, 0.500000 text (style TABNAME):'henkilo' BOX id: #105 coords: 11.500000, 32.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'henkiloid'text (style TYPENAME):' (int)' BOX id: #106 coords: 11.500000, 33.000000 size: 3.500000, 0.500000 text (style COLNAME):'kuollut'text (style TYPENAME):' (date)' BOX id: #107 coords: 11.500000, 33.500000 size: 3.500000, 0.500000 text (style COLNAME):'sukupuoli'text (style TYPENAME):' (enum)' BOX id: #108 coords: 11.500000, 34.000000 size: 3.500000, 0.500000 text (style COLNAME):'etunimi'text (style TYPENAME):' (varchar)' BOX id: #109 coords: 11.500000, 34.500000 size: 3.500000, 0.500000 text (style COLNAME):'huom'text (style TYPENAME):' (text)' BOX id: #110 coords: 11.500000, 35.000000 size: 3.500000, 0.500000 text (style COLNAME):'sukunimi'text (style TYPENAME):' (varchar)' BOX id: #111 coords: 11.500000, 35.500000 size: 3.500000, 0.500000 text (style COLNAME):'aidinkieli'text (style TYPENAME):' (char)' BOX id: #112 coords: 11.500000, 36.000000 size: 3.500000, 0.500000 text (style COLNAME):'syntynyt'text (style TYPENAME):' (date)' BOX id: #113 coords: 11.500000, 36.500000 size: 3.500000, 0.500000 text (style COLNAME):'toinennimi'text (style TYPENAME):' (varchar)' ARROW (FILLED) #111 -> #35 (coords 15.000000, 35.750000 -> 16.750000, 11.250000) TABLE 'teos' BOX id: #149 coords: 16.750000, 32.000000 size: 3.500000, 0.500000 text (style TABNAME):'teos' BOX id: #114 coords: 16.750000, 32.500000 size: 3.500000, 0.500000 text (style COLNAME):'huom'text (style TYPENAME):' (text)' BOX id: #115 coords: 16.750000, 33.000000 size: 3.500000, 0.500000 text (style COLNAME):'kantaesitys'text (style TYPENAME):' (date)' BOX id: #116 coords: 16.750000, 33.500000 size: 3.500000, 0.500000 text (style COLNAME):'tyyppi'text (style TYPENAME):' (varchar)' BOX id: #117 coords: 16.750000, 34.000000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'teosid'text (style TYPENAME):' (int)' ARROW (FILLED) #116 -> #19 (coords 20.250000, 33.750000 -> 11.500000, 2.250000) TABLE 'arktallennetarkoitus' BOX id: #150 coords: 1.000000, 38.000000 size: 3.500000, 0.500000 text (style TABNAME):'arktallennetarkoitus' BOX id: #118 coords: 1.000000, 38.500000 size: 3.500000, 0.500000 text (style KEYCOLNAME):'tarkoitus'text (style TYPENAME):' (varchar)' BOX id: #119 coords: 1.000000, 39.000000 size: 3.500000, 0.500000 text (style COLNAME):'kuvaus'text (style TYPENAME):' (varchar)' BOX id: #120 coords: 1.000000, 39.500000 size: 3.500000, 0.500000 text (style COLNAME):'prioriteetti'text (style TYPENAME):' (int)' BOX id: #121 coords: 1.000000, 40.000000 size: 3.500000, 0.500000 text (style COLNAME):'otsikko'text (style TYPENAME):' (varchar)'