{"id":171,"date":"2021-03-05T07:59:59","date_gmt":"2021-03-05T07:59:59","guid":{"rendered":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/?post_type=chapter&#038;p=171"},"modified":"2021-05-07T09:16:19","modified_gmt":"2021-05-07T09:16:19","slug":"sql-paringukeel-ja-tabeli-loomine","status":"publish","type":"chapter","link":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/chapter\/sql-paringukeel-ja-tabeli-loomine\/","title":{"raw":"SQL p\u00e4ringukeel ja tabeli loomine","rendered":"SQL p\u00e4ringukeel ja tabeli loomine"},"content":{"raw":"<p style=\"text-align: justify\">Selleks, et andmebaasidesse tabeleid luua, andmeid lisada, modifitseerida, kustutada ning vajalikke andmeid andmebaasist k\u00e4tte saada ehk <strong>p\u00e4rida<\/strong>, kasutatakse peamiselt p\u00e4ringukeelt SQL (ingl <em>Structured Query Language<\/em>). SQL on loodud IBM poolt aastal 1974.<\/p>\r\n\r\n<h2>SQL lause s\u00fcntaks tabeli loomiseks<\/h2>\r\n<p style=\"text-align: justify\">Tabeli loomise SQL lause \u00fcldkuju on j\u00e4rgnev:<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li style=\"text-align: left\"><strong><code><span style=\"color: #970000\">CREATE TABLE<\/span><\/code><\/strong><code> &lt;tabeli nimi&gt; ( ... )<span style=\"color: #ff0000\">;<\/span><\/code><\/li>\r\n<\/ul>\r\n<p style=\"text-align: justify\">Sulgudes oleva osa asemele tulevad komaga eraldatud veergude definitsioonid ning seej\u00e4rel tabeli \u00fcldised kitsendused. Tabeli kitsendusi me selles peat\u00fckis ei vaata, seega j\u00e4tame need esialgu SQL lausest v\u00e4lja.<\/p>\r\n<p style=\"text-align: justify\">Veeru definitsioon on j\u00e4rgneval kujul:<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li style=\"text-align: left\"><code>&lt;veeru nimi&gt;<\/code><strong><code> <span style=\"color: #000080\">&lt;veeru andmet\u00fc\u00fcp&gt;<\/span> <span style=\"color: #970000\">[vaikev\u00e4\u00e4rtused] [veeru kitsendused]<\/span><\/code><\/strong><\/li>\r\n<\/ul>\r\n<p style=\"text-align: justify\">Siin t\u00e4histavad nurksulud mittekohustuslikku osa.<\/p>\r\n<p style=\"text-align: justify\">Vaikev\u00e4\u00e4rtustest ning veeru kitsendustest r\u00e4\u00e4gime me hilisemates peat\u00fckkides t\u00e4psemalt, kuid siiski on kaks veeru kitsendust, mis v\u00f5iksid kohe alguses tuttavad olla. Esimeseks on <em>NOT NULL<\/em>, mis t\u00e4hendab, et antud veeru v\u00e4\u00e4rtus ei tohi kunagi t\u00fchi olla. Teiseks oluliseks kitsenduseks on <em>PRIMARY KEY<\/em>, mille abil saame me \u00f6elda, et antud veerg on primaarv\u00f5ti.<\/p>\r\n\r\n<h2>Loome SQL lause tabeli <em>Inimesed <\/em>jaoks<\/h2>\r\n<p style=\"text-align: justify\">Proovime n\u00fc\u00fcd koos koostada \u00fche tabeli loomise SQL lause.<\/p>\r\n<p style=\"text-align: justify\">Olgu \u00fclesandeks luua tabel <em>Inimesed<\/em>, mis peab peab sisaldama id-d, eesnime, perekonnanime ning s\u00fcnnip\u00e4eva. Kusjuures id peab olema primaarv\u00f5ti ning \u00fchegi tabelis oleva veeru v\u00e4\u00e4rtus ei tohi olla t\u00fchi.<\/p>\r\n<p style=\"text-align: justify\">Paneme k\u00f5igepealt paika lause kuju ilma veeru definitsioonideta.<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li><code><span style=\"color: #970000\"><strong>CREATE TABLE<\/strong><\/span> Inimesed ( ... )<span style=\"color: #ff0000\">;<\/span><\/code><\/li>\r\n<\/ul>\r\n<p style=\"text-align: justify\">N\u00fc\u00fcd koostame iga veeru definitsioonid.<\/p>\r\n<p style=\"text-align: justify\">Kuna veerg <em>id<\/em> peab olema primaarv\u00f5ti ning selle v\u00e4\u00e4rtus ei tohi kunagi t\u00fchi olla, kasutame kitsendusi PRIMARY KEY ning NOT NULL. Eelmises peat\u00fckis r\u00e4\u00e4kisime, et primaarv\u00f5tmete korral oleks alati otstarbekas kasutada andmet\u00fc\u00fcpi <em>serial.<\/em><\/p>\r\n<p style=\"text-align: justify\">Pannes k\u00f5ik kokku, saame veeru <em>id<\/em> jaoks j\u00e4rgneva veeru definitsiooni:<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li><code>id <\/code><strong><code><span style=\"color: #000080\">SERIAL<\/span> <span style=\"color: #970000\">PRIMARY KEY NOT NULL<\/span><\/code><\/strong><\/li>\r\n<\/ul>\r\n<p style=\"text-align: justify\">Veergudel <em>eesnimi<\/em> ning <em>perekonnanimi<\/em> on tekstilised v\u00e4\u00e4rtused.\u00a0 Ilmselt v\u00f5ime ka \u00f6elda, et nii ees- kui ka perekonnanime pikkus on maksimaalselt 50 t\u00e4hem\u00e4rki. Seega nende veergude andmet\u00fc\u00fcbina kasutame <em>varchar (50)<\/em>. Kuna \u00fclesande p\u00fcstituses on \u00f6eldud, et \u00fckski veerg ei tohi lubada t\u00fchja v\u00e4\u00e4rtust, lisame ka neile veeru definitsioonidele kitsenduse <em>NOT NULL.<\/em><\/p>\r\n<p style=\"text-align: justify\">Seega veergude <em>eesnimi<\/em> ja <em>perekonnanimi<\/em> jaoks saame me j\u00e4rgnevad definitsioonid:<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li><code>eesnimi <\/code><strong><code><span style=\"color: #000080\">VARCHAR (50)<\/span> <span style=\"color: #970000\">NOT NULL<\/span><\/code><\/strong><\/li>\r\n \t<li><code>perekonnanimi <span style=\"color: #000080\"><strong>VARCHAR (50)<\/strong><\/span> <span style=\"color: #970000\"><strong>NOT NULL<\/strong><\/span><\/code><\/li>\r\n<\/ul>\r\n<p style=\"text-align: justify\">Kuna veerg <em>s\u00fcnnip\u00e4ev<\/em> hoiab endas kuup\u00e4eva, tuleks andmet\u00fc\u00fcbina kasutada <em>date<\/em> andmet\u00fc\u00fcpi. Ka sellele veerule tuleb lisada kitsendus <em>NOT NULL<\/em>.<\/p>\r\n<p style=\"text-align: justify\">Seega veeru <em>s\u00fcnnip\u00e4ev<\/em> definitsiooniks saame:<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li><code>s\u00fcnnip\u00e4ev <span style=\"color: #000080\"><strong>DATE<\/strong><\/span> <span style=\"color: #970000\"><strong>NOT NULL<\/strong><\/span><\/code><\/li>\r\n<\/ul>\r\n<p style=\"text-align: justify\">Kui me n\u00fc\u00fcd k\u00f5ik eelneva kokku paneme, saame:<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li><strong><code><span style=\"color: #970000\">CREATE TABLE<\/span><\/code><\/strong><code> Inimesed (<\/code>\r\n<code>id <\/code><strong><code><span style=\"color: #000080\">SERIAL<\/span> <span style=\"color: #970000\">PRIMARY KEY NOT NULL<\/span><\/code><\/strong><code>,<\/code>\r\n<code>eesnimi <\/code><strong><code><span style=\"color: #000080\">VARCHAR (50)<\/span> <span style=\"color: #970000\">NOT NULL<\/span><\/code><\/strong><code>,<\/code>\r\n<code>perekonnanimi <span style=\"color: #000080\"><strong>VARCHAR (50)<\/strong><\/span> <span style=\"color: #970000\"><strong>NOT NULL<\/strong><\/span>,<\/code>\r\n<code>s\u00fcnnip\u00e4ev <span style=\"color: #000080\"><strong>DATE<\/strong><\/span> <span style=\"color: #970000\"><strong>NOT NULL<\/strong><\/span><\/code>\r\n<code>)<span style=\"color: #ff0000\">;<\/span><\/code><\/li>\r\n<\/ul>\r\n<h2>Tabelite loomine DBeaveris<\/h2>\r\n<p style=\"text-align: justify\">N\u00fc\u00fcd on l\u00f5puks k\u00e4tte j\u00f5udnud aeg, kui saame eelnevalt installitud tarkvara kasutama hakata. Kui teil ei ole vajalik tarkvara installitud v\u00f5i miski ei t\u00f6\u00f6ta, l\u00e4bige k\u00e4esoleva \u00f5piku <a href=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/chapter\/tarkvara-installimine\/\">teine peat\u00fckk<\/a>.<\/p>\r\nEt DBeaver ei muudaks meie SQL lausetes olevaid suurt\u00e4hti automaatselt v\u00e4iket\u00e4htedeks, peame me muutma \u00fchte s\u00e4tet. Selleks tuleks esmalt k\u00e4ivitada DBeaver ning seej\u00e4rel avada DBeaveri \u00fclal men\u00fc\u00fcs <em>Window<\/em> -&gt; <em>Preferences<\/em>.\r\n\r\n<img class=\"wp-image-1000 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/preferences_aken-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" \/>\r\n<p style=\"text-align: justify\">Seej\u00e4rel avaneb Preferences aken, kus liigu vasakul men\u00fc\u00fcs <em>Editors<\/em> -&gt; <em>SQL Editor<\/em> -&gt; <em>Code Editor<\/em> ning vaata, et valik <em>Convert keyword case<\/em> ei oleks valitud. Seej\u00e4rel klikka nupul <em>Apply and Close<\/em>.<\/p>\r\n<img class=\" wp-image-1001 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/conv_keyword_case-300x204.png\" alt=\"\" width=\"1024\" height=\"697\" \/>\r\n<p style=\"text-align: justify\">N\u00fc\u00fcd proovime lisada DBeaveris olevasse <em>public<\/em> andmebaasi tabeli <em>Inimesed<\/em>, mille loomise jaoks me \u00e4sja SQL lause moodustasime.<\/p>\r\n<p style=\"text-align: justify\">Selleks tuleb DBeaveris avada <em>Projects<\/em> men\u00fc\u00fc, kui see juba lahti pole (<em>Window<\/em> -&gt; <em>Projects<\/em>). Seej\u00e4rel tuleb avada SQL konsool, kuhu me saame sisestada SQL lauseid ning neid seej\u00e4rel k\u00e4ivitada. Selle avamiseks liigu \u00fclal men\u00fc\u00fcribal <em>SQL Editor<\/em> -&gt; <em>Open SQL console<\/em>.<\/p>\r\n<img class=\" wp-image-919 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/ava_SQL_console-300x225.png\" alt=\"\" width=\"1025\" height=\"769\" \/>\r\n<p style=\"text-align: justify\">N\u00fc\u00fcd lisame avanenud konsooli varasemalt koostatud SQL lause tabeli <em>Inimesed <\/em>loomiseks. Kontrolli, et SQL lauses ei esineks t\u00fchju ridu, vastasel juhul saad veateate. Seej\u00e4rel tuleb vajutada oran\u017ei <em>play<\/em>-nuppu (asukoht toodud v\u00e4lja alloleval pildil), et konsooli kirjutatud k\u00e4sk k\u00e4ivitataks.<\/p>\r\n<img class=\" wp-image-920 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/play_nupp-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" \/>\r\n<p style=\"text-align: justify\">P\u00e4rast seda peaks vasakul men\u00fc\u00fcs tabelite all olema n\u00e4htaval tabel <em>Inimesed<\/em>.<\/p>\r\n<p style=\"text-align: justify\"><span style=\"color: #ff0000\">NB!<\/span> Kui loodud tabel ei ole n\u00e4htaval, proovi andmebaasi vaadet v\u00e4rskendada. Selleks parem klikka andmebaasi <em>public<\/em> peal ning avanenud valikutest klikka <em>Refresh.\u00a0 <\/em><\/p>\r\n<img class=\" wp-image-921 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/refresh-300x224.png\" alt=\"\" width=\"1024\" height=\"764\" \/>\r\n<p style=\"text-align: justify\">Kui tabel <em>Inimesed<\/em> on n\u00e4htaval, siis topelt klikka sellel. N\u00fc\u00fcd peaks avanema vaade <em>Properties<\/em> tabeli <em>Inimesed <\/em>kohta k\u00e4iva informatsiooniga. Nagu n\u00e4ha, siis seal on olemas meie t\u00e4psustatud veerud ning nende andmet\u00fc\u00fcbid. Samuti on n\u00e4ha, et iga veeru korral on kitsendus <em>NOT NULL<\/em> valitud.<\/p>\r\n<img class=\" wp-image-1384 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/properties_vahekaart_tabelil_inimesed-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" \/>\r\n<p style=\"text-align: justify\">Hiljem, kui me hakkame tabelisse andmeid lisama, kajastuvad need <em>Data<\/em> vahelehe all. Iga sisestatud kirje ilmub seal eraldi reale. V\u00f5id ka praegu\u00a0<em>Data\u00a0<\/em>vahelehte uudistada, kuid kuna me pole veel tabelisse <em>Inimesed<\/em> andmeid sisestanud, pole seal \u00fchtegi kirjet n\u00e4ha.<\/p>\r\n<img class=\" wp-image-923 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/tabel_inimesed_data_vaheleht-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" \/>\r\n<p style=\"text-align: justify\">Paslik oleks praegusel hetkel tutvuda ka SQL lausega, mille abil on v\u00f5imalus andmebaasist tabeleid kustutada. Selleks on:<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li><code><span style=\"color: #970000\"><strong>DROP TABLE<\/strong><\/span> &lt;tabeli nimi&gt;;<\/code><\/li>\r\n<\/ul>\r\n<p style=\"text-align: justify\">Ehk siis juhul, kui teil edaspidistes \u00fclesannetes midagi sassi l\u00e4heb, on alati v\u00f5imalus tabel kustutada ning uuesti proovida.<\/p>\r\n\r\n<h2>Iseseisev \u00fclesanne<\/h2>\r\n<p style=\"text-align: justify\">Proovi n\u00fc\u00fcd ise DBeaveris lisada tabel <em>Toode<\/em>, millel on j\u00e4rgnevad veerud:<\/p>\r\n\r\n<ul style=\"text-align: justify\">\r\n \t<li><em>id<\/em>\r\n<ul>\r\n \t<li>andmet\u00fc\u00fcbiga <em>serial<\/em><\/li>\r\n \t<li>primaarv\u00f5ti<\/li>\r\n \t<li>ei luba t\u00fchjasid v\u00e4\u00e4rtusi<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li><em>nimi<\/em>\r\n<ul>\r\n \t<li>andmet\u00fc\u00fcbiga <em>varchar (100)<\/em><\/li>\r\n \t<li>ei luba t\u00fchjasid v\u00e4\u00e4rtusi<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li><em>hind<\/em>\r\n<ul>\r\n \t<li>andmet\u00fc\u00fcbiga <em>numeric<\/em><\/li>\r\n \t<li>ei luba t\u00fchjasid v\u00e4\u00e4rtusi<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>lisamiskuup\u00e4ev\r\n<ul>\r\n \t<li>andmet\u00fc\u00fcbiga <em>date<\/em><\/li>\r\n \t<li>ei luba t\u00fchjasid v\u00e4\u00e4rtusi<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>aegumiskuup\u00e4ev\r\n<ul>\r\n \t<li>andmet\u00fc\u00fcbiga <em>date<\/em><\/li>\r\n \t<li>ei luba t\u00fchjasid v\u00e4\u00e4rtusi<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p style=\"text-align: justify\">Selleks koosta esmalt korrektne SQL lause tabeli loomiseks (oma lahendust saab kontrollida alloleva vastuse abil). Kui SQL lause on korrektne, jooksuta seda DBeaveri SQL konsoolis. SQL konsoolile saab tagasi liikuda vajutades alloleval pildil n\u00e4idatud vahekaardile. Kui SQL konsooli vahekaart pole pildil n\u00e4idatud kohas n\u00e4htaval, saad selle uuesti avada (SQL Editor -&gt; Open SQL console).<\/p>\r\n<img class=\" wp-image-924 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/console_avamine_uuesti-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" \/>\r\n\r\n[h5p id=\"31\"]<code><span style=\"color: #ff0000\"><code><\/code><\/span><\/code>","rendered":"<p style=\"text-align: justify\">Selleks, et andmebaasidesse tabeleid luua, andmeid lisada, modifitseerida, kustutada ning vajalikke andmeid andmebaasist k\u00e4tte saada ehk <strong>p\u00e4rida<\/strong>, kasutatakse peamiselt p\u00e4ringukeelt SQL (ingl <em>Structured Query Language<\/em>). SQL on loodud IBM poolt aastal 1974.<\/p>\n<h2>SQL lause s\u00fcntaks tabeli loomiseks<\/h2>\n<p style=\"text-align: justify\">Tabeli loomise SQL lause \u00fcldkuju on j\u00e4rgnev:<\/p>\n<ul style=\"text-align: justify\">\n<li style=\"text-align: left\"><strong><code><span style=\"color: #970000\">CREATE TABLE<\/span><\/code><\/strong><code> &lt;tabeli nimi&gt; ( ... )<span style=\"color: #ff0000\">;<\/span><\/code><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Sulgudes oleva osa asemele tulevad komaga eraldatud veergude definitsioonid ning seej\u00e4rel tabeli \u00fcldised kitsendused. Tabeli kitsendusi me selles peat\u00fckis ei vaata, seega j\u00e4tame need esialgu SQL lausest v\u00e4lja.<\/p>\n<p style=\"text-align: justify\">Veeru definitsioon on j\u00e4rgneval kujul:<\/p>\n<ul style=\"text-align: justify\">\n<li style=\"text-align: left\"><code>&lt;veeru nimi&gt;<\/code><strong><code> <span style=\"color: #000080\">&lt;veeru andmet\u00fc\u00fcp&gt;<\/span> <span style=\"color: #970000\">[vaikev\u00e4\u00e4rtused] [veeru kitsendused]<\/span><\/code><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Siin t\u00e4histavad nurksulud mittekohustuslikku osa.<\/p>\n<p style=\"text-align: justify\">Vaikev\u00e4\u00e4rtustest ning veeru kitsendustest r\u00e4\u00e4gime me hilisemates peat\u00fckkides t\u00e4psemalt, kuid siiski on kaks veeru kitsendust, mis v\u00f5iksid kohe alguses tuttavad olla. Esimeseks on <em>NOT NULL<\/em>, mis t\u00e4hendab, et antud veeru v\u00e4\u00e4rtus ei tohi kunagi t\u00fchi olla. Teiseks oluliseks kitsenduseks on <em>PRIMARY KEY<\/em>, mille abil saame me \u00f6elda, et antud veerg on primaarv\u00f5ti.<\/p>\n<h2>Loome SQL lause tabeli <em>Inimesed <\/em>jaoks<\/h2>\n<p style=\"text-align: justify\">Proovime n\u00fc\u00fcd koos koostada \u00fche tabeli loomise SQL lause.<\/p>\n<p style=\"text-align: justify\">Olgu \u00fclesandeks luua tabel <em>Inimesed<\/em>, mis peab peab sisaldama id-d, eesnime, perekonnanime ning s\u00fcnnip\u00e4eva. Kusjuures id peab olema primaarv\u00f5ti ning \u00fchegi tabelis oleva veeru v\u00e4\u00e4rtus ei tohi olla t\u00fchi.<\/p>\n<p style=\"text-align: justify\">Paneme k\u00f5igepealt paika lause kuju ilma veeru definitsioonideta.<\/p>\n<ul style=\"text-align: justify\">\n<li><code><span style=\"color: #970000\"><strong>CREATE TABLE<\/strong><\/span> Inimesed ( ... )<span style=\"color: #ff0000\">;<\/span><\/code><\/li>\n<\/ul>\n<p style=\"text-align: justify\">N\u00fc\u00fcd koostame iga veeru definitsioonid.<\/p>\n<p style=\"text-align: justify\">Kuna veerg <em>id<\/em> peab olema primaarv\u00f5ti ning selle v\u00e4\u00e4rtus ei tohi kunagi t\u00fchi olla, kasutame kitsendusi PRIMARY KEY ning NOT NULL. Eelmises peat\u00fckis r\u00e4\u00e4kisime, et primaarv\u00f5tmete korral oleks alati otstarbekas kasutada andmet\u00fc\u00fcpi <em>serial.<\/em><\/p>\n<p style=\"text-align: justify\">Pannes k\u00f5ik kokku, saame veeru <em>id<\/em> jaoks j\u00e4rgneva veeru definitsiooni:<\/p>\n<ul style=\"text-align: justify\">\n<li><code>id <\/code><strong><code><span style=\"color: #000080\">SERIAL<\/span> <span style=\"color: #970000\">PRIMARY KEY NOT NULL<\/span><\/code><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Veergudel <em>eesnimi<\/em> ning <em>perekonnanimi<\/em> on tekstilised v\u00e4\u00e4rtused.\u00a0 Ilmselt v\u00f5ime ka \u00f6elda, et nii ees- kui ka perekonnanime pikkus on maksimaalselt 50 t\u00e4hem\u00e4rki. Seega nende veergude andmet\u00fc\u00fcbina kasutame <em>varchar (50)<\/em>. Kuna \u00fclesande p\u00fcstituses on \u00f6eldud, et \u00fckski veerg ei tohi lubada t\u00fchja v\u00e4\u00e4rtust, lisame ka neile veeru definitsioonidele kitsenduse <em>NOT NULL.<\/em><\/p>\n<p style=\"text-align: justify\">Seega veergude <em>eesnimi<\/em> ja <em>perekonnanimi<\/em> jaoks saame me j\u00e4rgnevad definitsioonid:<\/p>\n<ul style=\"text-align: justify\">\n<li><code>eesnimi <\/code><strong><code><span style=\"color: #000080\">VARCHAR (50)<\/span> <span style=\"color: #970000\">NOT NULL<\/span><\/code><\/strong><\/li>\n<li><code>perekonnanimi <span style=\"color: #000080\"><strong>VARCHAR (50)<\/strong><\/span> <span style=\"color: #970000\"><strong>NOT NULL<\/strong><\/span><\/code><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Kuna veerg <em>s\u00fcnnip\u00e4ev<\/em> hoiab endas kuup\u00e4eva, tuleks andmet\u00fc\u00fcbina kasutada <em>date<\/em> andmet\u00fc\u00fcpi. Ka sellele veerule tuleb lisada kitsendus <em>NOT NULL<\/em>.<\/p>\n<p style=\"text-align: justify\">Seega veeru <em>s\u00fcnnip\u00e4ev<\/em> definitsiooniks saame:<\/p>\n<ul style=\"text-align: justify\">\n<li><code>s\u00fcnnip\u00e4ev <span style=\"color: #000080\"><strong>DATE<\/strong><\/span> <span style=\"color: #970000\"><strong>NOT NULL<\/strong><\/span><\/code><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Kui me n\u00fc\u00fcd k\u00f5ik eelneva kokku paneme, saame:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><code><span style=\"color: #970000\">CREATE TABLE<\/span><\/code><\/strong><code> Inimesed (<\/code><br \/>\n<code>id <\/code><strong><code><span style=\"color: #000080\">SERIAL<\/span> <span style=\"color: #970000\">PRIMARY KEY NOT NULL<\/span><\/code><\/strong><code>,<\/code><br \/>\n<code>eesnimi <\/code><strong><code><span style=\"color: #000080\">VARCHAR (50)<\/span> <span style=\"color: #970000\">NOT NULL<\/span><\/code><\/strong><code>,<\/code><br \/>\n<code>perekonnanimi <span style=\"color: #000080\"><strong>VARCHAR (50)<\/strong><\/span> <span style=\"color: #970000\"><strong>NOT NULL<\/strong><\/span>,<\/code><br \/>\n<code>s\u00fcnnip\u00e4ev <span style=\"color: #000080\"><strong>DATE<\/strong><\/span> <span style=\"color: #970000\"><strong>NOT NULL<\/strong><\/span><\/code><br \/>\n<code>)<span style=\"color: #ff0000\">;<\/span><\/code><\/li>\n<\/ul>\n<h2>Tabelite loomine DBeaveris<\/h2>\n<p style=\"text-align: justify\">N\u00fc\u00fcd on l\u00f5puks k\u00e4tte j\u00f5udnud aeg, kui saame eelnevalt installitud tarkvara kasutama hakata. Kui teil ei ole vajalik tarkvara installitud v\u00f5i miski ei t\u00f6\u00f6ta, l\u00e4bige k\u00e4esoleva \u00f5piku <a href=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/chapter\/tarkvara-installimine\/\">teine peat\u00fckk<\/a>.<\/p>\n<p>Et DBeaver ei muudaks meie SQL lausetes olevaid suurt\u00e4hti automaatselt v\u00e4iket\u00e4htedeks, peame me muutma \u00fchte s\u00e4tet. Selleks tuleks esmalt k\u00e4ivitada DBeaver ning seej\u00e4rel avada DBeaveri \u00fclal men\u00fc\u00fcs <em>Window<\/em> -&gt; <em>Preferences<\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1000 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/preferences_aken-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" srcset=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/preferences_aken-300x225.png 300w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/preferences_aken-768x576.png 768w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/preferences_aken-65x49.png 65w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/preferences_aken-225x169.png 225w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/preferences_aken-350x263.png 350w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/preferences_aken.png 1022w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p style=\"text-align: justify\">Seej\u00e4rel avaneb Preferences aken, kus liigu vasakul men\u00fc\u00fcs <em>Editors<\/em> -&gt; <em>SQL Editor<\/em> -&gt; <em>Code Editor<\/em> ning vaata, et valik <em>Convert keyword case<\/em> ei oleks valitud. Seej\u00e4rel klikka nupul <em>Apply and Close<\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1001 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/conv_keyword_case-300x204.png\" alt=\"\" width=\"1024\" height=\"697\" srcset=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/conv_keyword_case-300x204.png 300w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/conv_keyword_case-768x522.png 768w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/conv_keyword_case-65x44.png 65w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/conv_keyword_case-225x153.png 225w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/conv_keyword_case-350x238.png 350w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/conv_keyword_case.png 807w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p style=\"text-align: justify\">N\u00fc\u00fcd proovime lisada DBeaveris olevasse <em>public<\/em> andmebaasi tabeli <em>Inimesed<\/em>, mille loomise jaoks me \u00e4sja SQL lause moodustasime.<\/p>\n<p style=\"text-align: justify\">Selleks tuleb DBeaveris avada <em>Projects<\/em> men\u00fc\u00fc, kui see juba lahti pole (<em>Window<\/em> -&gt; <em>Projects<\/em>). Seej\u00e4rel tuleb avada SQL konsool, kuhu me saame sisestada SQL lauseid ning neid seej\u00e4rel k\u00e4ivitada. Selle avamiseks liigu \u00fclal men\u00fc\u00fcribal <em>SQL Editor<\/em> -&gt; <em>Open SQL console<\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-919 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/ava_SQL_console-300x225.png\" alt=\"\" width=\"1025\" height=\"769\" srcset=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/ava_SQL_console-300x225.png 300w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/ava_SQL_console-768x575.png 768w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/ava_SQL_console-65x49.png 65w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/ava_SQL_console-225x169.png 225w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/ava_SQL_console-350x262.png 350w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/ava_SQL_console.png 1021w\" sizes=\"auto, (max-width: 1025px) 100vw, 1025px\" \/><\/p>\n<p style=\"text-align: justify\">N\u00fc\u00fcd lisame avanenud konsooli varasemalt koostatud SQL lause tabeli <em>Inimesed <\/em>loomiseks. Kontrolli, et SQL lauses ei esineks t\u00fchju ridu, vastasel juhul saad veateate. Seej\u00e4rel tuleb vajutada oran\u017ei <em>play<\/em>-nuppu (asukoht toodud v\u00e4lja alloleval pildil), et konsooli kirjutatud k\u00e4sk k\u00e4ivitataks.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-920 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/play_nupp-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" srcset=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/play_nupp-300x225.png 300w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/play_nupp-768x576.png 768w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/play_nupp-65x49.png 65w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/play_nupp-225x169.png 225w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/play_nupp-350x263.png 350w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/play_nupp.png 1024w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p style=\"text-align: justify\">P\u00e4rast seda peaks vasakul men\u00fc\u00fcs tabelite all olema n\u00e4htaval tabel <em>Inimesed<\/em>.<\/p>\n<p style=\"text-align: justify\"><span style=\"color: #ff0000\">NB!<\/span> Kui loodud tabel ei ole n\u00e4htaval, proovi andmebaasi vaadet v\u00e4rskendada. Selleks parem klikka andmebaasi <em>public<\/em> peal ning avanenud valikutest klikka <em>Refresh.\u00a0 <\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-921 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/refresh-300x224.png\" alt=\"\" width=\"1024\" height=\"764\" srcset=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/refresh-300x224.png 300w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/refresh-768x574.png 768w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/refresh-65x49.png 65w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/refresh-225x168.png 225w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/refresh-350x262.png 350w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/refresh.png 1022w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p style=\"text-align: justify\">Kui tabel <em>Inimesed<\/em> on n\u00e4htaval, siis topelt klikka sellel. N\u00fc\u00fcd peaks avanema vaade <em>Properties<\/em> tabeli <em>Inimesed <\/em>kohta k\u00e4iva informatsiooniga. Nagu n\u00e4ha, siis seal on olemas meie t\u00e4psustatud veerud ning nende andmet\u00fc\u00fcbid. Samuti on n\u00e4ha, et iga veeru korral on kitsendus <em>NOT NULL<\/em> valitud.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1384 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/properties_vahekaart_tabelil_inimesed-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" srcset=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/properties_vahekaart_tabelil_inimesed-300x225.png 300w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/properties_vahekaart_tabelil_inimesed-768x576.png 768w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/properties_vahekaart_tabelil_inimesed-65x49.png 65w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/properties_vahekaart_tabelil_inimesed-225x169.png 225w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/properties_vahekaart_tabelil_inimesed-350x263.png 350w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/properties_vahekaart_tabelil_inimesed.png 1024w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p style=\"text-align: justify\">Hiljem, kui me hakkame tabelisse andmeid lisama, kajastuvad need <em>Data<\/em> vahelehe all. Iga sisestatud kirje ilmub seal eraldi reale. V\u00f5id ka praegu\u00a0<em>Data\u00a0<\/em>vahelehte uudistada, kuid kuna me pole veel tabelisse <em>Inimesed<\/em> andmeid sisestanud, pole seal \u00fchtegi kirjet n\u00e4ha.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-923 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/tabel_inimesed_data_vaheleht-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" srcset=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/tabel_inimesed_data_vaheleht-300x225.png 300w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/tabel_inimesed_data_vaheleht-768x576.png 768w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/tabel_inimesed_data_vaheleht-65x49.png 65w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/tabel_inimesed_data_vaheleht-225x169.png 225w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/tabel_inimesed_data_vaheleht-350x263.png 350w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/tabel_inimesed_data_vaheleht.png 1024w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p style=\"text-align: justify\">Paslik oleks praegusel hetkel tutvuda ka SQL lausega, mille abil on v\u00f5imalus andmebaasist tabeleid kustutada. Selleks on:<\/p>\n<ul style=\"text-align: justify\">\n<li><code><span style=\"color: #970000\"><strong>DROP TABLE<\/strong><\/span> &lt;tabeli nimi&gt;;<\/code><\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ehk siis juhul, kui teil edaspidistes \u00fclesannetes midagi sassi l\u00e4heb, on alati v\u00f5imalus tabel kustutada ning uuesti proovida.<\/p>\n<h2>Iseseisev \u00fclesanne<\/h2>\n<p style=\"text-align: justify\">Proovi n\u00fc\u00fcd ise DBeaveris lisada tabel <em>Toode<\/em>, millel on j\u00e4rgnevad veerud:<\/p>\n<ul style=\"text-align: justify\">\n<li><em>id<\/em>\n<ul>\n<li>andmet\u00fc\u00fcbiga <em>serial<\/em><\/li>\n<li>primaarv\u00f5ti<\/li>\n<li>ei luba t\u00fchjasid v\u00e4\u00e4rtusi<\/li>\n<\/ul>\n<\/li>\n<li><em>nimi<\/em>\n<ul>\n<li>andmet\u00fc\u00fcbiga <em>varchar (100)<\/em><\/li>\n<li>ei luba t\u00fchjasid v\u00e4\u00e4rtusi<\/li>\n<\/ul>\n<\/li>\n<li><em>hind<\/em>\n<ul>\n<li>andmet\u00fc\u00fcbiga <em>numeric<\/em><\/li>\n<li>ei luba t\u00fchjasid v\u00e4\u00e4rtusi<\/li>\n<\/ul>\n<\/li>\n<li>lisamiskuup\u00e4ev\n<ul>\n<li>andmet\u00fc\u00fcbiga <em>date<\/em><\/li>\n<li>ei luba t\u00fchjasid v\u00e4\u00e4rtusi<\/li>\n<\/ul>\n<\/li>\n<li>aegumiskuup\u00e4ev\n<ul>\n<li>andmet\u00fc\u00fcbiga <em>date<\/em><\/li>\n<li>ei luba t\u00fchjasid v\u00e4\u00e4rtusi<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Selleks koosta esmalt korrektne SQL lause tabeli loomiseks (oma lahendust saab kontrollida alloleva vastuse abil). Kui SQL lause on korrektne, jooksuta seda DBeaveri SQL konsoolis. SQL konsoolile saab tagasi liikuda vajutades alloleval pildil n\u00e4idatud vahekaardile. Kui SQL konsooli vahekaart pole pildil n\u00e4idatud kohas n\u00e4htaval, saad selle uuesti avada (SQL Editor -&gt; Open SQL console).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-924 aligncenter\" src=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/console_avamine_uuesti-300x225.png\" alt=\"\" width=\"1024\" height=\"768\" srcset=\"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/console_avamine_uuesti-300x225.png 300w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/console_avamine_uuesti-768x576.png 768w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/console_avamine_uuesti-65x49.png 65w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/console_avamine_uuesti-225x169.png 225w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/console_avamine_uuesti-350x263.png 350w, https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-content\/uploads\/sites\/21\/2021\/03\/console_avamine_uuesti.png 1024w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<div id=\"h5p-31\">\n<div class=\"h5p-iframe-wrapper\"><iframe id=\"h5p-iframe-31\" class=\"h5p-iframe\" data-content-id=\"31\" style=\"height:1px\" src=\"about:blank\" frameBorder=\"0\" scrolling=\"no\" title=\"AT_5_vastus_1\"><\/iframe><\/div>\n<\/div>\n<p><code><span style=\"color: #ff0000\"><code><\/code><\/span><\/code><\/p>\n","protected":false},"author":33,"menu_order":5,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-171","chapter","type-chapter","status-publish","hentry"],"part":3,"_links":{"self":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapters\/171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/wp\/v2\/users\/33"}],"version-history":[{"count":59,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapters\/171\/revisions"}],"predecessor-version":[{"id":1386,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapters\/171\/revisions\/1386"}],"part":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/parts\/3"}],"metadata":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapters\/171\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/wp\/v2\/media?parent=171"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/pressbooks\/v2\/chapter-type?post=171"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/wp\/v2\/contributor?post=171"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/web.htk.tlu.ee\/digitaru\/lisamoodulid\/wp-json\/wp\/v2\/license?post=171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}