{"id":925,"date":"2025-10-27T15:36:28","date_gmt":"2025-10-27T15:36:28","guid":{"rendered":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/?page_id=925"},"modified":"2025-11-13T12:51:15","modified_gmt":"2025-11-13T12:51:15","slug":"votmed","status":"publish","type":"page","link":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/","title":{"rendered":"V\u00f5tmed"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Andmebaaside_votmed\" >Andmebaaside v\u00f5tmed<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Primary_Key_esmane_voti\" >Primary Key (esmane v\u00f5ti)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Foreign_Key_valine_voti\" >Foreign Key (v\u00e4line v\u00f5ti)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Unique_Key_unikaalne_voti\" >Unique Key (unikaalne v\u00f5ti<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Simple_Key_lihtne_voti\" >Simple Key (lihtne v\u00f5ti)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Composite_Key_koostatud_voti\" >Composite Key (koostatud v\u00f5ti)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Compound_Key_koostatudkomponeeritud_voti\" >Compound Key (koostatud\/komponeeritud v\u00f5ti)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Superkey_ulevoti\" >Superkey (\u00fclev\u00f5ti)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Candidate_Key_kandidaatvoti\" >Candidate Key (kandidaatv\u00f5ti)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Alternate_Key_alternatiivvoti\" >Alternate Key (alternatiivv\u00f5ti)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#Allikad\" >Allikad<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Andmebaaside_votmed\"><\/span>Andmebaaside v\u00f5tmed<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>V\u00f5tmed on andmebaasi struktuuri oluline osa. Need aitavad <strong>unikaalselt tuvastada kirjeid<\/strong>, <strong>luua seoseid tabelite vahel<\/strong> ja <strong>s\u00e4ilitada andmete terviklikkust<\/strong>.<br>Vaatleme peamisi v\u00f5tmete t\u00fc\u00fcpe:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Primary_Key_esmane_voti\"><\/span>Primary Key (esmane v\u00f5ti)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Primary key on iga kirje <strong>unikaalne identifikaator<\/strong> tabelis.<br>\u00dches tabelis v\u00f5ib olla ainult \u00fcks esmav\u00f5ti.<br>See <strong>ei tohi sisaldada NULL-v\u00e4\u00e4rtust<\/strong> ja peab olema unikaalne.<\/p>\n\n\n\n<p><strong>N\u00e4ide (tabel \u201e\u00dcli\u00f5pilased\u201c):<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"200\" height=\"70\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F3E50A28-33D2-42AE-B329-081CAAADA235.png\" alt=\"\" class=\"wp-image-959\" style=\"width:366px;height:auto\" srcset=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F3E50A28-33D2-42AE-B329-081CAAADA235.png 200w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F3E50A28-33D2-42AE-B329-081CAAADA235-150x53.png 150w\" sizes=\"auto, (max-width: 200px) 100vw, 200px\" \/><\/figure>\n\n\n\n<p>Tabelite loomise kood:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Uliopilased (\nID_uliopilane INT PRIMARY KEY,\nNimi TEXT,\nGrupp TEXT\n);\n\nINSERT INTO Uliopilased (ID_uliopilane, Nimi, Grupp)\nVALUES (1, 'Eldar', 'A1'),\n(2, 'Nikita', 'B1');\n\nSELECT * FROM Uliopilased;<\/code><\/pre>\n\n\n\n<p>Siin on <code>ID_\u00fcli\u00f5pilane<\/code> <strong>Primary Key<\/strong>.<\/p>\n\n\n\n<p>Erinevus: Primary key on tabeli <strong>peamine unikaalne identifikaator<\/strong>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Foreign_Key_valine_voti\"><\/span>Foreign Key (v\u00e4line v\u00f5ti)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Foreign key on <strong>viide teise tabeli esmav\u00f5tmele<\/strong>.<br>See loob tabelite vahel <strong>seoseid<\/strong> (n\u00e4iteks \u00fcli\u00f5pilaste ja nende hinnete vahel).<\/p>\n\n\n\n<p><strong>N\u00e4ide:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"216\" height=\"62\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/28F1EE9F-C520-4AE2-944A-95B85D29C196.png\" alt=\"\" class=\"wp-image-961\" style=\"width:418px;height:auto\" srcset=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/28F1EE9F-C520-4AE2-944A-95B85D29C196.png 216w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/28F1EE9F-C520-4AE2-944A-95B85D29C196-150x43.png 150w\" sizes=\"auto, (max-width: 216px) 100vw, 216px\" \/><\/figure>\n\n\n\n<p>Tabelite loomise kood:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Hinded (\nID_hinne INT PRIMARY KEY,\nHinne INT,\nID_uliopilane INT,\nFOREIGN KEY (ID_uliopilane) REFERENCES Uliopilased(ID_uliopilane)\n);\n\nINSERT INTO Hinded (ID_hinne, Hinne, ID_uliopilane)\nVALUES (1, 5, 1),\n(2, 4, 2);\n\nSELECT * FROM Hinded;;\n<\/code><\/pre>\n\n\n\n<p>Siin on <code>ID_\u00fcli\u00f5pilane<\/code> <strong>Foreign Key<\/strong>, mis viitab tabeli \u201e\u00dcli\u00f5pilased\u201c <code>ID_\u00fcli\u00f5pilane<\/code>-le.<\/p>\n\n\n\n<p>Erinevus: Foreign key loob tabelite vahel <strong>seose<\/strong>, erinevalt Primary Key-st, mis tuvastab kirje ainult <strong>\u00fches tabelis<\/strong>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Unique_Key_unikaalne_voti\"><\/span>Unique Key (unikaalne v\u00f5ti<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Unique key tagab, et v\u00e4\u00e4rtus veerus oleks unikaalne, kuid erinevalt Primary Key-st v\u00f5ib <strong>tabelis olla mitu unikaalset v\u00f5tit<\/strong>.<br>See v\u00f5ib sisaldada NULL-v\u00e4\u00e4rtusi.<\/p>\n\n\n\n<p><strong>N\u00e4ide:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"215\" height=\"58\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/4C1FFC2B-47D9-434D-AA28-3815FE687D66.png\" alt=\"\" class=\"wp-image-962\" style=\"width:411px;height:auto\" srcset=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/4C1FFC2B-47D9-434D-AA28-3815FE687D66.png 215w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/4C1FFC2B-47D9-434D-AA28-3815FE687D66-150x40.png 150w\" sizes=\"auto, (max-width: 215px) 100vw, 215px\" \/><\/figure>\n\n\n\n<p>Tabelite loomise kood:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Kontaktid (\nID INT PRIMARY KEY,\nEmail VARCHAR(100) UNIQUE,\nTelefon VARCHAR(20)\n);\n\nINSERT INTO Kontaktid (ID, Email, Telefon)\nVALUES (1, 'khabib@mail.com', '555111'),\n(2, 'nikitos@mail.com', '555222');\n\nSELECT * FROM Kontaktid;<\/code><\/pre>\n\n\n\n<p>Siin v\u00f5ib <code>Email<\/code> olla <strong>Unique Key<\/strong>, et e-posti aadressid ei korduks.<\/p>\n\n\n\n<p>Erinevus: Unique Key v\u00f5ib sisaldada NULL-v\u00e4\u00e4rtusi ja ei pruugi olla tabeli peamine v\u00f5ti.\\<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Simple_Key_lihtne_voti\"><\/span>Simple Key (lihtne v\u00f5ti)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Lihtne v\u00f5ti koosneb <strong>ainult \u00fchest veerust<\/strong>, mis suudab unikaalselt tuvastada kirje.<\/p>\n\n\n\n<p><strong>N\u00e4ide:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"204\" height=\"65\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/178CA316-1D04-443A-BACE-DC84BB100B33.png\" alt=\"\" class=\"wp-image-972\" style=\"width:449px;height:auto\" srcset=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/178CA316-1D04-443A-BACE-DC84BB100B33.png 204w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/178CA316-1D04-443A-BACE-DC84BB100B33-150x48.png 150w\" sizes=\"auto, (max-width: 204px) 100vw, 204px\" \/><\/figure>\n\n\n\n<p>Tabelite loomise kood:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Uliopilased_Simple (\nID_uliopilane INT PRIMARY KEY,\nNimi VARCHAR(50),\nGrupp VARCHAR(10)\n);\n\nINSERT INTO Uliopilased_Simple (ID_uliopilane, Nimi, Grupp)\nVALUES (\n1, 'Nikita', 'C2'),\n(2, 'Eldar', 'A1'\n);\n\nSELECT * FROM Uliopilased_Simple;<\/code><\/pre>\n\n\n\n<p>Erinevus: Kui v\u00f5ti koosneb ainult \u00fchest atribuudist, on see lihtne. Kui mitmest, on see <strong>koostatud v\u00f5ti (composite\/compound)<\/strong>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Composite_Key_koostatud_voti\"><\/span>Composite Key (koostatud v\u00f5ti)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Composite key koosneb <strong>kahest v\u00f5i enamast veerust<\/strong>, mis koos tagavad kirje unikaalsuse.<\/p>\n\n\n\n<p><strong>N\u00e4ide (hinnete tabel):<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"214\" height=\"60\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/6699C69D-3B60-4DE1-BF3F-259416B00EE7.png\" alt=\"\" class=\"wp-image-963\" style=\"width:410px;height:auto\" srcset=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/6699C69D-3B60-4DE1-BF3F-259416B00EE7.png 214w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/6699C69D-3B60-4DE1-BF3F-259416B00EE7-150x42.png 150w\" sizes=\"auto, (max-width: 214px) 100vw, 214px\" \/><\/figure>\n\n\n\n<p>Tabelite loomise kood:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Hinded2 (\nID_aine INT,\nID_uliopilane INT,\nHinne INT,\nPRIMARY KEY (ID_aine, ID_uliopilane)\n);\n\nINSERT INTO Hinded2 (ID_aine, ID_uliopilane, Hinne)\nVALUES\n(1, 1, 5),\n(1, 2, 4);\n\nSELECT * FROM Hinded2;\n<\/code><\/pre>\n\n\n\n<p>Unikaalsus tekib <strong>ID_aine + ID_\u00fcli\u00f5pilane<\/strong> kombinatsioonist.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Compound_Key_koostatudkomponeeritud_voti\"><\/span>Compound Key (koostatud\/komponeeritud v\u00f5ti)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Compound key sarnaneb composite key-ga \u2014 see koosneb mitmest veerust, kuid mitte k\u00f5ik veerud ei pruugi olla iseseisvalt unikaalsed.<br>M\u00f5nikord peetakse m\u00f5lemaid termineid s\u00fcnon\u00fc\u00fcmideks.<\/p>\n\n\n\n<p><strong>N\u00e4ide:<\/strong> <\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"246\" height=\"64\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/DFFBF2FA-9B26-403F-A04E-5EE709C500F8.png\" alt=\"\" class=\"wp-image-969\" style=\"width:407px;height:auto\" srcset=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/DFFBF2FA-9B26-403F-A04E-5EE709C500F8.png 246w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/DFFBF2FA-9B26-403F-A04E-5EE709C500F8-150x39.png 150w\" sizes=\"auto, (max-width: 246px) 100vw, 246px\" \/><\/figure>\n\n\n\n<p>Tabelite loomise kood:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Inimesed_Compound (\nNimi VARCHAR(50),\nPerekonnanimi VARCHAR(50),\nSunnikuupaev DATE,\nPRIMARY KEY (Nimi, Perekonnanimi, Sunnikuupaev)\n);\n\nINSERT INTO Inimesed_Compound (Nimi, Perekonnanimi, Sunnikuupaev)\nVALUES (\n'Nikita', 'Orlenko', '2008-10-10'),\n('Eldar', 'Petrov', '2002-08-10'\n);\n\nSELECT * FROM Inimesed_Compound;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Superkey_ulevoti\"><\/span>Superkey (\u00fclev\u00f5ti)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Superkey on <strong>k\u00f5ikide atribuutide kombinatsioon<\/strong>, mis suudab unikaalselt tuvastada kirje.<br>Iga Primary Key on Superkey, kuid iga Superkey ei ole Primary Key.<\/p>\n\n\n\n<p><strong>N\u00e4ide:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"212\" height=\"64\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F0A003FF-D9DA-46F7-9BC5-9902158A0193.png\" alt=\"\" class=\"wp-image-964\" style=\"width:474px;height:auto\" srcset=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F0A003FF-D9DA-46F7-9BC5-9902158A0193.png 212w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F0A003FF-D9DA-46F7-9BC5-9902158A0193-150x45.png 150w\" sizes=\"auto, (max-width: 212px) 100vw, 212px\" \/><\/figure>\n\n\n\n<p>Tabelite loomise kood:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Inimesed (\nID INT PRIMARY KEY,\nEmail VARCHAR(100) UNIQUE,\nTelefon VARCHAR(20) UNIQUE\n);\n\nINSERT INTO Inimesed (ID, Email, Telefon)\nVALUES(\n1, 'nikitos@mail.com', '555111'),\n(2, 'eldar@mail.com', '555222'\n);\n\nSELECT * FROM Inimesed;<\/code><\/pre>\n\n\n\n<p>ID, Email, Telefon \u2014 k\u00f5ik need on Superkey, kuna iga v\u00e4li eraldi tagab kirje unikaalsuse.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Candidate_Key_kandidaatvoti\"><\/span>Candidate Key (kandidaatv\u00f5ti)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Candidate key on <strong>potentsiaalne v\u00f5ti<\/strong>, mis v\u00f5ib saada Primary Key-ks.<br>K\u00f5igist kandidaatv\u00f5tmetest valitakse <strong>\u00fcks<\/strong>, mis saab Primary Key-ks.<\/p>\n\n\n\n<p><strong>N\u00e4ide:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"218\" height=\"47\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/364F5C01-D14C-4994-A753-3F5657FBD01D.png\" alt=\"\" class=\"wp-image-965\" style=\"width:455px;height:auto\" srcset=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/364F5C01-D14C-4994-A753-3F5657FBD01D.png 218w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/364F5C01-D14C-4994-A753-3F5657FBD01D-150x32.png 150w\" sizes=\"auto, (max-width: 218px) 100vw, 218px\" \/><\/figure>\n\n\n\n<p>Tabelite loomise kood:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Kandidaadid (\nID INT PRIMARY KEY,\nEmail VARCHAR(100) UNIQUE,\nTelefon VARCHAR(20) UNIQUE\n);\n\nINSERT INTO Kandidaadid (ID, Email, Telefon)\nVALUES (\n1, 'nikitos@mail.com', '555111'\n);\nSELECT * FROM Kandidaadid\n<\/code><\/pre>\n\n\n\n<p>Kandidaatv\u00f5tmed: ID, Email, Telefon<br>Valitud Primary Key: ID<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Alternate_Key_alternatiivvoti\"><\/span>Alternate Key (alternatiivv\u00f5ti)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Alternate key on <strong>kandidaatv\u00f5ti<\/strong>, mida <strong>ei valitud esmase v\u00f5tmena<\/strong>.<\/p>\n\n\n\n<p><strong>N\u00e4ide:<\/strong><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"237\" height=\"54\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/6912BC5F-7BA0-43FA-B1C7-DD3CFAE7E6CE.png\" alt=\"\" class=\"wp-image-966\" style=\"width:509px;height:auto\" srcset=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/6912BC5F-7BA0-43FA-B1C7-DD3CFAE7E6CE.png 237w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/6912BC5F-7BA0-43FA-B1C7-DD3CFAE7E6CE-150x34.png 150w\" sizes=\"auto, (max-width: 237px) 100vw, 237px\" \/><\/figure>\n\n\n\n<p>Tabelite loomise kood:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Alternatiivsed (\nID INT PRIMARY KEY,\nEmail VARCHAR(100) UNIQUE,\nTelefon VARCHAR(20) UNIQUE\n);\n\nINSERT INTO Alternatiivsed (ID, Email, Telefon)\nVALUES (\n1, 'nikitos@mail.com', '555111')\n\n\nSELECT * FROM Alternatiivsed;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Allikad\"><\/span>Allikad<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tunnimaterjalid teemal \u201eAndmebaasid\u201c<\/li>\n\n\n\n<li>\u00d5pik: Andmebaasid ja SQL<\/li>\n\n\n\n<li><a href=\"https:\/\/www.geeksforgeeks.org\/types-of-keys-in-database\">https:\/\/www.geeksforgeeks.org\/types-of-keys-in-database<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/\">https:\/\/www.w3schools.com\/sql\/<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/chat.openai.com\/\">https:\/\/chat.openai.com\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Andmebaaside v\u00f5tmed V\u00f5tmed on andmebaasi struktuuri oluline osa. Need aitavad unikaalselt tuvastada kirjeid, luua seoseid tabelite vahel ja s\u00e4ilitada andmete terviklikkust.Vaatleme peamisi v\u00f5tmete t\u00fc\u00fcpe: Primary Key (esmane v\u00f5ti) Primary key on iga kirje unikaalne identifikaator tabelis.\u00dches tabelis v\u00f5ib olla ainult \u00fcks esmav\u00f5ti.See ei tohi sisaldada NULL-v\u00e4\u00e4rtust ja peab olema unikaalne. N\u00e4ide (tabel \u201e\u00dcli\u00f5pilased\u201c): Tabelite loomise [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-925","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>V\u00f5tmed - Nikita Orlenko \/ Portfoolio<\/title>\n<meta name=\"description\" content=\"V\u00f5tmed on andmebaasi struktuuri oluline osa. Need aitavad unikaalselt tuvastada kirjeid, luua seoseid tabelite vahel\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"V\u00f5tmed - Nikita Orlenko \/ Portfoolio\" \/>\n<meta property=\"og:description\" content=\"V\u00f5tmed on andmebaasi struktuuri oluline osa. Need aitavad unikaalselt tuvastada kirjeid, luua seoseid tabelite vahel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/\" \/>\n<meta property=\"og:site_name\" content=\"Nikita Orlenko \/ Portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T12:51:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F3E50A28-33D2-42AE-B329-081CAAADA235.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"70\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/votmed\\\/\",\"url\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/votmed\\\/\",\"name\":\"V\u00f5tmed - Nikita Orlenko \\\/ Portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/votmed\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/votmed\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/F3E50A28-33D2-42AE-B329-081CAAADA235.png\",\"datePublished\":\"2025-10-27T15:36:28+00:00\",\"dateModified\":\"2025-11-13T12:51:15+00:00\",\"description\":\"V\u00f5tmed on andmebaasi struktuuri oluline osa. Need aitavad unikaalselt tuvastada kirjeid, luua seoseid tabelite vahel\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/votmed\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/votmed\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/votmed\\\/#primaryimage\",\"url\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/F3E50A28-33D2-42AE-B329-081CAAADA235.png\",\"contentUrl\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/F3E50A28-33D2-42AE-B329-081CAAADA235.png\",\"width\":200,\"height\":70},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/votmed\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"V\u00f5tmed\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/#website\",\"url\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/\",\"name\":\"Nikita Orlenko \\\/ Portfoolio\",\"description\":\"Saate kontakt minuga\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"V\u00f5tmed - Nikita Orlenko \/ Portfoolio","description":"V\u00f5tmed on andmebaasi struktuuri oluline osa. Need aitavad unikaalselt tuvastada kirjeid, luua seoseid tabelite vahel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/","og_locale":"et_EE","og_type":"article","og_title":"V\u00f5tmed - Nikita Orlenko \/ Portfoolio","og_description":"V\u00f5tmed on andmebaasi struktuuri oluline osa. Need aitavad unikaalselt tuvastada kirjeid, luua seoseid tabelite vahel","og_url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/","og_site_name":"Nikita Orlenko \/ Portfoolio","article_modified_time":"2025-11-13T12:51:15+00:00","og_image":[{"width":200,"height":70,"url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F3E50A28-33D2-42AE-B329-081CAAADA235.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/","url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/","name":"V\u00f5tmed - Nikita Orlenko \/ Portfoolio","isPartOf":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#primaryimage"},"image":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#primaryimage"},"thumbnailUrl":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F3E50A28-33D2-42AE-B329-081CAAADA235.png","datePublished":"2025-10-27T15:36:28+00:00","dateModified":"2025-11-13T12:51:15+00:00","description":"V\u00f5tmed on andmebaasi struktuuri oluline osa. Need aitavad unikaalselt tuvastada kirjeid, luua seoseid tabelite vahel","breadcrumb":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#primaryimage","url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F3E50A28-33D2-42AE-B329-081CAAADA235.png","contentUrl":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2025\/11\/F3E50A28-33D2-42AE-B329-081CAAADA235.png","width":200,"height":70},{"@type":"BreadcrumbList","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/votmed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/"},{"@type":"ListItem","position":2,"name":"V\u00f5tmed"}]},{"@type":"WebSite","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/#website","url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/","name":"Nikita Orlenko \/ Portfoolio","description":"Saate kontakt minuga","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/925","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/comments?post=925"}],"version-history":[{"count":6,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/925\/revisions"}],"predecessor-version":[{"id":973,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/925\/revisions\/973"}],"wp:attachment":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/media?parent=925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}