TABLE 'arktallennetunnus' ENTITY id: #1 coords: 2.000000, 2.000000 text (style COLNAME):'arktallennetunnus' ATTRIBUTE id: #2 coords: 4.000000, 2.000000 text (style KEYCOLNAME):'arktunnus' PLAIN CONNECTOR #1 -> #2 ATTRIBUTE id: #3 coords: 0.000000, 1.999985 text (style COLNAME):'otsikko' PLAIN CONNECTOR #1 -> #3 TABLE 'arktallenne' ENTITY id: #4 coords: 8.000000, 2.000000 text (style COLNAME):'arktallenne' ATTRIBUTE id: #5 coords: 10.000000, 2.000000 text (style COLNAME):'avoin' PLAIN CONNECTOR #4 -> #5 ATTRIBUTE id: #6 coords: 9.827090, 2.813475 text (style COLNAME):'alkupvm' PLAIN CONNECTOR #4 -> #6 RELATIONSHIP id: #7 coords: 11.669129, 11.743146 text (style COLNAME):'arktallennefmuoto-of' PLAIN CONNECTOR #4 -> #7 FILLED ARROW CONNECTOR #7 -> #119 ATTRIBUTE id: #8 coords: 8.618028, 3.902115 text (style COLNAME):'formaatti' PLAIN CONNECTOR #4 -> #8 RELATIONSHIP id: #9 coords: 4.895468, 11.994521 text (style COLNAME):'arktallennesistyyppi-of' PLAIN CONNECTOR #4 -> #9 FILLED ARROW CONNECTOR #9 -> #110 ATTRIBUTE id: #10 coords: 6.999992, 3.732046 text (style KEYCOLNAME):'tallenneid' PLAIN CONNECTOR #4 -> #10 ATTRIBUTE id: #11 coords: 6.381959, 3.175561 text (style COLNAME):'loppupvm' PLAIN CONNECTOR #4 -> #11 ATTRIBUTE id: #12 coords: 6.043702, 2.415810 text (style COLNAME):'kuvaus' PLAIN CONNECTOR #4 -> #12 ATTRIBUTE id: #13 coords: 6.043708, 1.584161 text (style COLNAME):'huom' PLAIN CONNECTOR #4 -> #13 RELATIONSHIP id: #14 coords: 4.190988, 1.412208 text (style COLNAME):'arktallennetunnus-of' PLAIN CONNECTOR #4 -> #14 FILLED ARROW CONNECTOR #14 -> #1 ATTRIBUTE id: #15 coords: 7.000017, 0.267939 text (style COLNAME):'otsikko' PLAIN CONNECTOR #4 -> #15 ATTRIBUTE id: #16 coords: 7.790965, 0.010954 text (style COLNAME):'julkaisija' PLAIN CONNECTOR #4 -> #16 RELATIONSHIP id: #17 coords: 8.309028, 1.048947 text (style COLNAME):'sijainti' PLAIN CONNECTOR #4 -> #17 FILLED ARROW CONNECTOR #17 -> #4 ATTRIBUTE id: #18 coords: 9.338280, 0.513727 text (style COLNAME):'kpl' PLAIN CONNECTOR #4 -> #18 RELATIONSHIP id: #19 coords: 5.913551, 13.593276 text (style COLNAME):'arktallennetarkoitus-of' PLAIN CONNECTOR #4 -> #19 FILLED ARROW CONNECTOR #19 -> #146 TABLE 'teostyyppi' ENTITY id: #20 coords: 14.000000, 2.000000 text (style COLNAME):'teostyyppi' ATTRIBUTE id: #21 coords: 16.000000, 2.000000 text (style COLNAME):'otsikko' PLAIN CONNECTOR #20 -> #21 ATTRIBUTE id: #22 coords: 12.999992, 3.732046 text (style KEYCOLNAME):'tyyppi' PLAIN CONNECTOR #20 -> #22 ATTRIBUTE id: #23 coords: 13.000017, 0.267939 text (style COLNAME):'prioriteetti' PLAIN CONNECTOR #20 -> #23 TABLE 'vlehtihakutulokset' RELATIONSHIP id: #24 coords: 11.000000, 14.000000 text (style COLNAME):'vlehtihakutulokset' PLAIN CONNECTOR #24 -> #84 PLAIN CONNECTOR #24 -> #74 ATTRIBUTE id: #26 coords: 18.999992, 3.732046 text (style COLNAME):'alkukohta' PLAIN CONNECTOR #24 -> #26 TABLE 'tuotantotekijat' WEAK ENTITY id: #28 coords: 26.000000, 2.000000 text (style COLNAME):'tuotantotekijat' WEAK RELATIONSHIP id: #29 coords: 30.000000, 11.000000 text (style COLNAME):'henkilo-of' PLAIN CONNECTOR #28 -> #29 FILLED ARROW CONNECTOR #29 -> #131 ATTRIBUTE id: #30 coords: 25.999993, 4.000000 text (style COLNAME):'huom' PLAIN CONNECTOR #28 -> #30 WEAK RELATIONSHIP id: #31 coords: 16.000000, 10.999993 text (style COLNAME):'tuotantotehtava-of' PLAIN CONNECTOR #28 -> #31 FILLED ARROW CONNECTOR #31 -> #115 WEAK RELATIONSHIP id: #32 coords: 29.000011, 7.000000 text (style COLNAME):'tuotanto-of' PLAIN CONNECTOR #28 -> #32 FILLED ARROW CONNECTOR #32 -> #98 TABLE 'vlehtihenkilot' RELATIONSHIP id: #33 coords: 20.000000, 17.000000 text (style COLNAME):'vlehtihenkilot' PLAIN CONNECTOR #33 -> #74 PLAIN CONNECTOR #33 -> #131 TABLE 'teostekijat' WEAK ENTITY id: #36 coords: 38.000000, 2.000000 text (style COLNAME):'teostekijat' WEAK RELATIONSHIP id: #37 coords: 36.000000, 11.000000 text (style COLNAME):'henkilo-of' PLAIN CONNECTOR #36 -> #37 FILLED ARROW CONNECTOR #37 -> #131 ATTRIBUTE id: #38 coords: 37.999993, 4.000000 text (style COLNAME):'huom' PLAIN CONNECTOR #36 -> #38 WEAK RELATIONSHIP id: #39 coords: 28.000000, 10.999993 text (style COLNAME):'teostehtava-of' PLAIN CONNECTOR #36 -> #39 FILLED ARROW CONNECTOR #39 -> #124 WEAK RELATIONSHIP id: #40 coords: 38.000011, 10.000000 text (style COLNAME):'teos-of' PLAIN CONNECTOR #36 -> #40 FILLED ARROW CONNECTOR #40 -> #141 TABLE 'kieli' ENTITY id: #41 coords: 2.000000, 8.000000 text (style COLNAME):'kieli' ATTRIBUTE id: #42 coords: 4.000000, 8.000000 text (style COLNAME):'nimi' PLAIN CONNECTOR #41 -> #42 ATTRIBUTE id: #43 coords: 0.999992, 9.732046 text (style KEYCOLNAME):'kielikoodi' PLAIN CONNECTOR #41 -> #43 ATTRIBUTE id: #44 coords: 1.000017, 6.267939 text (style COLNAME):'prioriteetti' PLAIN CONNECTOR #41 -> #44 TABLE 'tuotantotyyppi' ENTITY id: #45 coords: 8.000000, 8.000000 text (style COLNAME):'tuotantotyyppi' ATTRIBUTE id: #46 coords: 10.000000, 8.000000 text (style COLNAME):'otsikko' PLAIN CONNECTOR #45 -> #46 ATTRIBUTE id: #47 coords: 6.999992, 9.732046 text (style KEYCOLNAME):'tyyppi' PLAIN CONNECTOR #45 -> #47 ATTRIBUTE id: #48 coords: 7.000017, 6.267939 text (style COLNAME):'prioriteetti' PLAIN CONNECTOR #45 -> #48 TABLE 'arktallennetuotannot' RELATIONSHIP id: #49 coords: 20.000000, 8.000000 text (style COLNAME):'arktallennetuotannot' PLAIN CONNECTOR #49 -> #4 PLAIN CONNECTOR #49 -> #98 TABLE 'teosnimet' ENTITY id: #52 coords: 20.000000, 8.000000 text (style COLNAME):'teosnimet' ATTRIBUTE id: #53 coords: 22.000000, 8.000000 text (style COLNAME):'nimi' PLAIN CONNECTOR #52 -> #53 RELATIONSHIP id: #54 coords: 10.999996, 9.000000 text (style COLNAME):'kieli-of' PLAIN CONNECTOR #52 -> #54 FILLED ARROW CONNECTOR #54 -> #41 RELATIONSHIP id: #55 coords: 28.000000, 13.999993 text (style COLNAME):'teos-of' PLAIN CONNECTOR #52 -> #55 FILLED ARROW CONNECTOR #55 -> #141 ATTRIBUTE id: #56 coords: 20.000022, 6.000000 text (style KEYCOLNAME):'teosnimiid' PLAIN CONNECTOR #52 -> #56 TABLE 'ongelma' ENTITY id: #57 coords: 26.000000, 8.000000 text (style COLNAME):'ongelma' ATTRIBUTE id: #58 coords: 28.000000, 8.000000 text (style COLNAME):'selitys' PLAIN CONNECTOR #57 -> #58 ATTRIBUTE id: #59 coords: 26.618028, 9.902115 text (style COLNAME):'otsikko' PLAIN CONNECTOR #57 -> #59 ATTRIBUTE id: #60 coords: 24.381959, 9.175561 text (style COLNAME):'suljettu' PLAIN CONNECTOR #57 -> #60 ATTRIBUTE id: #61 coords: 24.381976, 6.824415 text (style KEYCOLNAME):'ongelmaid' PLAIN CONNECTOR #57 -> #61 ATTRIBUTE id: #62 coords: 26.618056, 6.097894 text (style COLNAME):'avattu' PLAIN CONNECTOR #57 -> #62 TABLE 'arktallenneteokset' RELATIONSHIP id: #63 coords: 23.000000, 11.000000 text (style COLNAME):'arktallenneteokset' PLAIN CONNECTOR #63 -> #4 PLAIN CONNECTOR #63 -> #141 TABLE 'aliteokset' RELATIONSHIP id: #66 coords: 38.000000, 20.000000 text (style COLNAME):'aliteokset' PLAIN CONNECTOR #66 -> #141 PLAIN CONNECTOR #66 -> #141 ATTRIBUTE id: #67 coords: 40.000000, 8.000000 text (style KEYCOLNAME):'huom' PLAIN CONNECTOR #66 -> #67 TABLE 'tuotantoteokset' RELATIONSHIP id: #70 coords: 35.000000, 17.000000 text (style COLNAME):'tuotantoteokset' PLAIN CONNECTOR #70 -> #98 PLAIN CONNECTOR #70 -> #141 ATTRIBUTE id: #71 coords: 4.000000, 14.000000 text (style KEYCOLNAME):'huom' PLAIN CONNECTOR #70 -> #71 TABLE 'vlehti' ENTITY id: #74 coords: 8.000000, 14.000000 text (style COLNAME):'vlehti' ATTRIBUTE id: #75 coords: 10.000000, 14.000000 text (style COLNAME):'sivunumero' PLAIN CONNECTOR #74 -> #75 ATTRIBUTE id: #76 coords: 9.532087, 15.285578 text (style COLNAME):'luokat' PLAIN CONNECTOR #74 -> #76 ATTRIBUTE id: #77 coords: 8.347290, 15.969617 text (style COLNAME):'teksti' PLAIN CONNECTOR #74 -> #77 ATTRIBUTE id: #78 coords: 6.999992, 15.732046 text (style COLNAME):'muutettu' PLAIN CONNECTOR #74 -> #78 ATTRIBUTE id: #79 coords: 6.120610, 14.684028 text (style KEYCOLNAME):'vlehtiid' PLAIN CONNECTOR #74 -> #79 ATTRIBUTE id: #80 coords: 6.120620, 13.315944 text (style COLNAME):'lehtiryhmaid' PLAIN CONNECTOR #74 -> #80 ATTRIBUTE id: #81 coords: 7.000017, 12.267939 text (style COLNAME):'originaaliteksti' PLAIN CONNECTOR #74 -> #81 ATTRIBUTE id: #82 coords: 8.347319, 12.030388 text (style COLNAME):'pvm' PLAIN CONNECTOR #74 -> #82 ATTRIBUTE id: #83 coords: 9.532106, 12.714445 text (style COLNAME):'tiedostonimi' PLAIN CONNECTOR #74 -> #83 TABLE 'vlehtihaku' ENTITY id: #84 coords: 14.000000, 14.000000 text (style COLNAME):'vlehtihaku' ATTRIBUTE id: #85 coords: 16.000000, 14.000000 text (style KEYCOLNAME):'hakuid' PLAIN CONNECTOR #84 -> #85 ATTRIBUTE id: #86 coords: 15.246976, 15.563666 text (style COLNAME):'maxvirhe' PLAIN CONNECTOR #84 -> #86 ATTRIBUTE id: #87 coords: 13.554950, 15.949854 text (style COLNAME):'minpvm' PLAIN CONNECTOR #84 -> #87 ATTRIBUTE id: #88 coords: 12.198057, 14.867756 text (style COLNAME):'hakuteksti' PLAIN CONNECTOR #84 -> #88 ATTRIBUTE id: #89 coords: 12.198070, 13.132217 text (style COLNAME):'valmis' PLAIN CONNECTOR #84 -> #89 ATTRIBUTE id: #90 coords: 13.554979, 12.050140 text (style COLNAME):'maxpvm' PLAIN CONNECTOR #84 -> #90 ATTRIBUTE id: #91 coords: 15.246999, 12.436353 text (style COLNAME):'hakuaika' PLAIN CONNECTOR #84 -> #91 TABLE 'arktallennehenkilot' RELATIONSHIP id: #92 coords: 20.000000, 11.000000 text (style COLNAME):'arktallennehenkilot' PLAIN CONNECTOR #92 -> #4 PLAIN CONNECTOR #92 -> #131 TABLE 'vlehtiteokset' RELATIONSHIP id: #95 coords: 23.000000, 17.000000 text (style COLNAME):'vlehtiteokset' PLAIN CONNECTOR #95 -> #74 PLAIN CONNECTOR #95 -> #141 TABLE 'tuotanto' ENTITY id: #98 coords: 32.000000, 14.000000 text (style COLNAME):'tuotanto' ATTRIBUTE id: #99 coords: 34.000000, 14.000000 text (style COLNAME):'nimi' PLAIN CONNECTOR #98 -> #99 ATTRIBUTE id: #100 coords: 33.246976, 15.563666 text (style COLNAME):'poistopvm' PLAIN CONNECTOR #98 -> #100 ATTRIBUTE id: #101 coords: 31.554950, 15.949854 text (style COLNAME):'tunnus' PLAIN CONNECTOR #98 -> #101 ATTRIBUTE id: #102 coords: 30.198057, 14.867756 text (style COLNAME):'huom' PLAIN CONNECTOR #98 -> #102 ATTRIBUTE id: #103 coords: 30.198070, 13.132217 text (style COLNAME):'ensiiltapvm' PLAIN CONNECTOR #98 -> #103 ATTRIBUTE id: #104 coords: 31.554979, 12.050140 text (style KEYCOLNAME):'tuotantoid' PLAIN CONNECTOR #98 -> #104 RELATIONSHIP id: #105 coords: 20.623500, 10.218176 text (style COLNAME):'tuotantotyyppi-of' PLAIN CONNECTOR #98 -> #105 FILLED ARROW CONNECTOR #105 -> #45 TABLE 'vlehtiluokka' ENTITY id: #106 coords: 38.000000, 14.000000 text (style COLNAME):'vlehtiluokka' ATTRIBUTE id: #107 coords: 40.000000, 14.000000 text (style COLNAME):'otsikko' PLAIN CONNECTOR #106 -> #107 ATTRIBUTE id: #108 coords: 36.999992, 15.732046 text (style KEYCOLNAME):'luokka' PLAIN CONNECTOR #106 -> #108 ATTRIBUTE id: #109 coords: 37.000017, 12.267939 text (style COLNAME):'prioriteetti' PLAIN CONNECTOR #106 -> #109 TABLE 'arktallennesistyyppi' ENTITY id: #110 coords: 2.000000, 20.000000 text (style COLNAME):'arktallennesistyyppi' ATTRIBUTE id: #111 coords: 4.000000, 20.000000 text (style KEYCOLNAME):'sistyyppi' PLAIN CONNECTOR #110 -> #111 ATTRIBUTE id: #112 coords: 1.999993, 22.000000 text (style COLNAME):'kuvaus' PLAIN CONNECTOR #110 -> #112 ATTRIBUTE id: #113 coords: 0.000000, 19.999985 text (style COLNAME):'prioriteetti' PLAIN CONNECTOR #110 -> #113 ATTRIBUTE id: #114 coords: 2.000022, 18.000000 text (style COLNAME):'otsikko' PLAIN CONNECTOR #110 -> #114 TABLE 'tuotantotehtava' ENTITY id: #115 coords: 8.000000, 20.000000 text (style COLNAME):'tuotantotehtava' ATTRIBUTE id: #116 coords: 10.000000, 20.000000 text (style COLNAME):'otsikko' PLAIN CONNECTOR #115 -> #116 ATTRIBUTE id: #117 coords: 6.999992, 21.732046 text (style KEYCOLNAME):'tehtava' PLAIN CONNECTOR #115 -> #117 ATTRIBUTE id: #118 coords: 7.000017, 18.267939 text (style COLNAME):'prioriteetti' PLAIN CONNECTOR #115 -> #118 TABLE 'arktallennefmuoto' ENTITY id: #119 coords: 14.000000, 20.000000 text (style COLNAME):'arktallennefmuoto' ATTRIBUTE id: #120 coords: 16.000000, 20.000000 text (style COLNAME):'otsikko' PLAIN CONNECTOR #119 -> #120 ATTRIBUTE id: #121 coords: 13.999993, 22.000000 text (style KEYCOLNAME):'fyysinenmuoto' PLAIN CONNECTOR #119 -> #121 ATTRIBUTE id: #122 coords: 12.000000, 19.999985 text (style COLNAME):'kuvaus' PLAIN CONNECTOR #119 -> #122 ATTRIBUTE id: #123 coords: 14.000022, 18.000000 text (style COLNAME):'prioriteetti' PLAIN CONNECTOR #119 -> #123 TABLE 'teostehtava' ENTITY id: #124 coords: 20.000000, 20.000000 text (style COLNAME):'teostehtava' ATTRIBUTE id: #125 coords: 22.000000, 20.000000 text (style COLNAME):'otsikko' PLAIN CONNECTOR #124 -> #125 ATTRIBUTE id: #126 coords: 18.999992, 21.732046 text (style KEYCOLNAME):'tehtava' PLAIN CONNECTOR #124 -> #126 ATTRIBUTE id: #127 coords: 19.000017, 18.267939 text (style COLNAME):'prioriteetti' PLAIN CONNECTOR #124 -> #127 TABLE 'vlehtiluokat' RELATIONSHIP id: #128 coords: 23.000000, 14.000000 text (style COLNAME):'vlehtiluokat' PLAIN CONNECTOR #128 -> #74 PLAIN CONNECTOR #128 -> #106 TABLE 'henkilo' ENTITY id: #131 coords: 32.000000, 20.000000 text (style COLNAME):'henkilo' ATTRIBUTE id: #132 coords: 34.000000, 20.000000 text (style KEYCOLNAME):'henkiloid' PLAIN CONNECTOR #131 -> #132 ATTRIBUTE id: #133 coords: 33.532087, 21.285578 text (style COLNAME):'kuollut' PLAIN CONNECTOR #131 -> #133 ATTRIBUTE id: #134 coords: 32.347290, 21.969617 text (style COLNAME):'sukupuoli' PLAIN CONNECTOR #131 -> #134 ATTRIBUTE id: #135 coords: 30.999992, 21.732046 text (style COLNAME):'etunimi' PLAIN CONNECTOR #131 -> #135 ATTRIBUTE id: #136 coords: 30.120610, 20.684028 text (style COLNAME):'huom' PLAIN CONNECTOR #131 -> #136 ATTRIBUTE id: #137 coords: 30.120620, 19.315944 text (style COLNAME):'sukunimi' PLAIN CONNECTOR #131 -> #137 RELATIONSHIP id: #138 coords: 16.500008, 13.133970 text (style COLNAME):'aidinkieli' PLAIN CONNECTOR #131 -> #138 FILLED ARROW CONNECTOR #138 -> #41 ATTRIBUTE id: #139 coords: 32.347319, 18.030388 text (style COLNAME):'syntynyt' PLAIN CONNECTOR #131 -> #139 ATTRIBUTE id: #140 coords: 33.532106, 18.714445 text (style COLNAME):'toinennimi' PLAIN CONNECTOR #131 -> #140 TABLE 'teos' ENTITY id: #141 coords: 38.000000, 20.000000 text (style COLNAME):'teos' ATTRIBUTE id: #142 coords: 40.000000, 20.000000 text (style COLNAME):'huom' PLAIN CONNECTOR #141 -> #142 ATTRIBUTE id: #143 coords: 37.999993, 22.000000 text (style COLNAME):'kantaesitys' PLAIN CONNECTOR #141 -> #143 RELATIONSHIP id: #144 coords: 25.000000, 10.999993 text (style COLNAME):'teostyyppi-of' PLAIN CONNECTOR #141 -> #144 FILLED ARROW CONNECTOR #144 -> #20 ATTRIBUTE id: #145 coords: 38.000022, 18.000000 text (style KEYCOLNAME):'teosid' PLAIN CONNECTOR #141 -> #145 TABLE 'arktallennetarkoitus' ENTITY id: #146 coords: 2.000000, 26.000000 text (style COLNAME):'arktallennetarkoitus' ATTRIBUTE id: #147 coords: 4.000000, 26.000000 text (style KEYCOLNAME):'tarkoitus' PLAIN CONNECTOR #146 -> #147 ATTRIBUTE id: #148 coords: 1.999993, 28.000000 text (style COLNAME):'kuvaus' PLAIN CONNECTOR #146 -> #148 ATTRIBUTE id: #149 coords: 0.000000, 25.999985 text (style COLNAME):'prioriteetti' PLAIN CONNECTOR #146 -> #149 ATTRIBUTE id: #150 coords: 2.000022, 24.000000 text (style COLNAME):'otsikko' PLAIN CONNECTOR #146 -> #150