{"id":1668,"date":"2025-10-26T12:08:20","date_gmt":"2025-10-26T12:08:20","guid":{"rendered":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/?page_id=1668"},"modified":"2025-10-30T11:47:37","modified_gmt":"2025-10-30T11:47:37","slug":"administreerimise-konspekt","status":"publish","type":"page","link":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/","title":{"rendered":"Administreerimise konspekt"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">Administreerimise konspekt<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Andmebaasi v\u00f5tmete liigid (Database Keys)<\/h2>\n\n\n\n<div class=\"wp-block-group is-nowrap is-layout-flex wp-container-core-group-is-layout-6c531013 wp-block-group-is-layout-flex\">\n<ul class=\"wp-block-list\">\n<li>Primary key<\/li>\n\n\n\n<li>Foreign key<\/li>\n\n\n\n<li>Unique key<\/li>\n\n\n\n<li>Simple key<\/li>\n\n\n\n<li>Composite key<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Compound key<\/li>\n\n\n\n<li>Superkey<\/li>\n\n\n\n<li>Candidate key<\/li>\n\n\n\n<li>Alternate key<\/li>\n<\/ul>\n<\/div>\n\n\n\n<p><strong>V\u00f5tmed<\/strong><em><strong> <\/strong>on komponendid, mis tagavad andmete terviklikkuse, unikaalsuse ja t\u00f5husa ligip\u00e4\u00e4su neile. Neid kasutatakse laialdaselt tabeli ridade ainulaadseks tuvastamiseks.<br>Samuti kasutatakse v\u00f5tmeid seoste loomiseks erinevate veergude ja tabelite vahel relatsiooniandmebaasis.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Primary key<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Primary key <\/strong>on unikaalne v\u00f5ti, mis t\u00e4hendab, et see suudab \u00fcheselt tuvastada iga kirje tabelis. <\/li>\n\n\n\n<li>Selle v\u00e4\u00e4rtused peavad olema ainulaadsed ning need ei tohi korduda.<\/li>\n\n\n\n<li><strong>Primaarv\u00f5ti ei tohi olla NULL,<\/strong> sest see peab andma kehtiva ja unikaalse identifikaatori iga kirje jaoks.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"500\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11.png\" alt=\"\" class=\"wp-image-1674\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11.png 1000w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11-300x150.png 300w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11-768x384.png 768w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11-150x75.png 150w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate table employees (\n    id int primary key,\n    name varchar(100),\n    position varchar(50)\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"220\" height=\"120\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/1338C9F0-8919-4ED0-AC54-7F5D29B7C10E.png\" alt=\"\" class=\"wp-image-1734\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/1338C9F0-8919-4ED0-AC54-7F5D29B7C10E.png 220w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/1338C9F0-8919-4ED0-AC54-7F5D29B7C10E-150x82.png 150w\" sizes=\"auto, (max-width: 220px) 100vw, 220px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Foreign key<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Foreign<\/strong> <strong>key<\/strong> on \u00fche tabeli komponent, mis viitab teise tabeli primaarv\u00f5tmele.<\/li>\n\n\n\n<li>V\u00f5\u00f5rv\u00f5ti \u00fches tabelis osutab primaarv\u00f5tmele teises tabelis, <strong>luues nende vahel seose<\/strong>.<\/li>\n\n\n\n<li>See aitab \u00fchendada kahte v\u00f5i enamat tabelit, v\u00f5imaldades nendevahelisi seoseid.<strong> See on oluline andmete terviklikkuse s\u00e4ilitamiseks ja liigsete andmete v\u00e4ltimiseks.<\/strong><\/li>\n\n\n\n<li>V\u00f5\u00f5rv\u00f5tmed toimivad ristviidetena tabelite vahel.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"500\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11.png\" alt=\"\" class=\"wp-image-1674\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11.png 1000w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11-300x150.png 300w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11-768x384.png 768w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11-150x75.png 150w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate table departments (\n    id int primary key,\n    name varchar(100)\n);\n\ncreate table employees (\n    id int primary key,\n    name varchar(100),\n    department_id int,\n    foreign key (department_id) references departments(id)\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"219\" height=\"210\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/064923AB-D6F8-4EE6-9EAF-F7B1F87C4DB6.png\" alt=\"\" class=\"wp-image-1736\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/064923AB-D6F8-4EE6-9EAF-F7B1F87C4DB6.png 219w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/064923AB-D6F8-4EE6-9EAF-F7B1F87C4DB6-150x144.png 150w\" sizes=\"auto, (max-width: 219px) 100vw, 219px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Unique key<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Unique key<\/strong> v\u00f5ivad sisaldada <strong>\u00fchte NULL-v\u00e4\u00e4rtust<\/strong>. <\/li>\n\n\n\n<li>Tabelis v\u00f5ib olla<strong> rohkem kui \u00fcks unique key.<\/strong><\/li>\n\n\n\n<li><strong>Unique key<\/strong> saab uuendada v\u00f5i kustutada ning see ei m\u00f5juta tabeli terviklikkuse piiranguid.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"500\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-13.png\" alt=\"\" class=\"wp-image-1678\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-13.png 1000w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-13-300x150.png 300w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-13-768x384.png 768w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-13-150x75.png 150w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate table users (\n    id int primary key,\n    username varchar(50) UNIQUE,\n    email varchar(100) UNIQUE\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"236\" height=\"116\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/189E982B-70F0-4B21-80C6-1C29D8D81480.png\" alt=\"\" class=\"wp-image-1737\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/189E982B-70F0-4B21-80C6-1C29D8D81480.png 236w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/189E982B-70F0-4B21-80C6-1C29D8D81480-150x74.png 150w\" sizes=\"auto, (max-width: 236px) 100vw, 236px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Simple key<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Simple key<\/strong> koosneb <strong>ainult \u00fchest veerust<\/strong> (atribuudist). <\/li>\n\n\n\n<li><strong>Simple key <\/strong>on lihtsam m\u00e4\u00e4ratleda ja hallata \u2014 <strong>piisab vaid \u00fchest v\u00e4ljast.<\/strong><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate table customers (\n    customer_id int primary key,\n    name varchar(100),\n    email varchar(100)\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"283\" height=\"115\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/4DAD1038-2D2D-4E61-A082-8C88C7A94ABD.png\" alt=\"\" class=\"wp-image-1738\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/4DAD1038-2D2D-4E61-A082-8C88C7A94ABD.png 283w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/4DAD1038-2D2D-4E61-A082-8C88C7A94ABD-150x61.png 150w\" sizes=\"auto, (max-width: 283px) 100vw, 283px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Composite key<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>See toimib primaarv\u00f5tmena<\/strong>, kui tabelis puudub primaarv\u00f5ti.<\/li>\n\n\n\n<li><strong>Kahe v\u00f5i enama atribuudi <\/strong>abil moodustatakse liitv\u00f5ti.<\/li>\n\n\n\n<li>Erinevad atribuudi kombinatsioonid v\u00f5ivad tagada erineva t\u00e4psuse ridade unikaalse tuvastamise osas.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"268\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-18.png\" alt=\"\" class=\"wp-image-1683\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-18.png 700w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-18-300x115.png 300w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-18-150x57.png 150w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate table order_items (\n    order_id int,\n    product_id int,\n    quantity int,\n    primary key (order_id, product_id)\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"207\" height=\"116\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/2E0B84D3-2BE1-423D-81F5-6CEFC935385C.png\" alt=\"\" class=\"wp-image-1739\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/2E0B84D3-2BE1-423D-81F5-6CEFC935385C.png 207w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/2E0B84D3-2BE1-423D-81F5-6CEFC935385C-150x84.png 150w\" sizes=\"auto, (max-width: 207px) 100vw, 207px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Compound key<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Compound key on eriline t\u00fc\u00fcpi composite key,<\/strong> mida kasutatakse tabeli primaarv\u00f5tmena.<\/li>\n\n\n\n<li>K\u00f5ik liitv\u00f5tmed on composite key, kuid mitte k\u00f5ik \u00fchendv\u00f5tmed ei ole liitv\u00f5tmed.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate table order_items (\n    order_id int,\n    product_id int,\n    quantity int,\n    primary key (order_id, product_id)\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"213\" height=\"123\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/107C5CBA-D977-48E1-A796-78DAA899F458.png\" alt=\"\" class=\"wp-image-1740\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/107C5CBA-D977-48E1-A796-78DAA899F458.png 213w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/107C5CBA-D977-48E1-A796-78DAA899F458-150x87.png 150w\" sizes=\"auto, (max-width: 213px) 100vw, 213px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Superkey<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Superkey<\/strong> on \u00fcks v\u00f5i mitu v\u00e4lja, mis \u00fcheskoos v\u00f5imaldavad \u00fcheselt tuvastada ridu tabelis. <strong>See v\u00f5ib sisaldada NULL-v\u00e4\u00e4rtusi ridades<\/strong>.<\/li>\n\n\n\n<li><strong>Superkey <\/strong>v\u00f5ib sisaldada ka lisaattribuute, mis ei ole vajalikud unikaalsuse tagamiseks.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"500\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-14.png\" alt=\"\" class=\"wp-image-1679\" style=\"width:1200px;height:auto\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-14.png 1000w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-14-300x150.png 300w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-14-768x384.png 768w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-14-150x75.png 150w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate table employees (\n    emp_id int,\n    email varchar(100),\n    phone varchar(20),\n    name varchar(100)\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"345\" height=\"119\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/79E12404-05D7-43A3-9729-526893A1D523.png\" alt=\"\" class=\"wp-image-1741\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/79E12404-05D7-43A3-9729-526893A1D523.png 345w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/79E12404-05D7-43A3-9729-526893A1D523-300x103.png 300w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/79E12404-05D7-43A3-9729-526893A1D523-150x52.png 150w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Candidate key<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Candidate key on minimaalne superv\u00f5ti<\/strong>, mis t\u00e4hendab, et see suudab \u00fcheselt tuvastada kirje, kuid ei sisalda liigseid atribuute.<\/li>\n\n\n\n<li>See on superv\u00f5ti ilma korduvate andmeteta, mida nimetatakse potentsiaalv\u00f5tiks.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"500\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-15.png\" alt=\"\" class=\"wp-image-1680\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-15.png 1000w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-15-300x150.png 300w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-15-768x384.png 768w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-15-150x75.png 150w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate table users (\n    id int primary key,\n    username varchar(50) UNIQUE,\n    email varchar(100) UNIQUE\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"228\" height=\"114\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/43D75766-951B-4F88-AA84-BC9D6B26DACC.png\" alt=\"\" class=\"wp-image-1742\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/43D75766-951B-4F88-AA84-BC9D6B26DACC.png 228w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/43D75766-951B-4F88-AA84-BC9D6B26DACC-150x75.png 150w\" sizes=\"auto, (max-width: 228px) 100vw, 228px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Alternate key<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Alternate key <\/strong>on mis tahes potentsiaalv\u00f5ti tabelis, mida ei ole valitud primaarv\u00f5tmeks. Teisis\u00f5nu, k\u00f5ik v\u00f5tmed, mida ei ole m\u00e4\u00e4ratud primaarv\u00f5tmeks, loetakse alternatiivv\u00f5tmeteks.<\/li>\n\n\n\n<li><strong>Alternate key nimetatakse ka teisesev\u00f5tmeks<\/strong>, kuna see suudab \u00fcheselt tuvastada kirjeid tabelis samamoodi nagu primaarv\u00f5ti.<\/li>\n\n\n\n<li>Alternate key v\u00f5ib koosneda \u00fchest v\u00f5i mitmest veerust (v\u00e4ljast), mis v\u00f5imaldavad kirjet \u00fcheselt tuvastada, kuid see ei ole primaarv\u00f5ti.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"500\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-16.png\" alt=\"\" class=\"wp-image-1681\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-16.png 1000w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-16-300x150.png 300w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-16-768x384.png 768w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-16-150x75.png 150w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncreate table employees (\n    emp_id int primary key,\n    email varchar(100) UNIQUE\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"193\" height=\"103\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/C3756E61-8A70-462D-89BE-85ADA5C881C3.png\" alt=\"\" class=\"wp-image-1743\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/C3756E61-8A70-462D-89BE-85ADA5C881C3.png 193w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/C3756E61-8A70-462D-89BE-85ADA5C881C3-150x80.png 150w\" sizes=\"auto, (max-width: 193px) 100vw, 193px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Kasutatud allikad<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.geeksforgeeks.org\/dbms\/types-of-keys-in-relational-model-candidate-super-primary-alternate-and-foreign\/\">https:\/\/www.geeksforgeeks.org\/dbms\/types-of-keys-in-relational-model-candidate-super-primary-alternate-and-foreign\/<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.geeksforgeeks.org\/dbms\/unique-key-in-dbms\/\">https:\/\/www.geeksforgeeks.org\/dbms\/unique-key-in-dbms\/<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/database.guide\/compound-keys-explained\/\">https:\/\/database.guide\/compound-keys-explained\/<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Administreerimise konspekt Andmebaasi v\u00f5tmete liigid (Database Keys) V\u00f5tmed on komponendid, mis tagavad andmete terviklikkuse, unikaalsuse ja t\u00f5husa ligip\u00e4\u00e4su neile. Neid [&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-1668","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>Administreerimise konspekt - Oleksandra Ryshniak Portfolio<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Administreerimise konspekt - Oleksandra Ryshniak Portfolio\" \/>\n<meta property=\"og:description\" content=\"Administreerimise konspekt Andmebaasi v\u00f5tmete liigid (Database Keys) V\u00f5tmed on komponendid, mis tagavad andmete terviklikkuse, unikaalsuse ja t\u00f5husa ligip\u00e4\u00e4su neile. Neid [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/\" \/>\n<meta property=\"og:site_name\" content=\"Oleksandra Ryshniak Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-30T11:47:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\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=\"3 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/administreerimise-konspekt\\\/\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/administreerimise-konspekt\\\/\",\"name\":\"Administreerimise konspekt - Oleksandra Ryshniak Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/administreerimise-konspekt\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/administreerimise-konspekt\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/image-11.png\",\"datePublished\":\"2025-10-26T12:08:20+00:00\",\"dateModified\":\"2025-10-30T11:47:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/administreerimise-konspekt\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/administreerimise-konspekt\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/administreerimise-konspekt\\\/#primaryimage\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/image-11.png\",\"contentUrl\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/image-11.png\",\"width\":1000,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/administreerimise-konspekt\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Administreerimise konspekt\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/#website\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/\",\"name\":\"Oleksandra Ryshniak Portfolio\",\"description\":\"\u041f\u0440\u043e\u0441\u0442\u043e \u0435\u0449\u0435 \u043e\u0434\u0438\u043d WordPress \u0441\u0430\u0439\u0442\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/?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":"Administreerimise konspekt - Oleksandra Ryshniak Portfolio","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:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/","og_locale":"et_EE","og_type":"article","og_title":"Administreerimise konspekt - Oleksandra Ryshniak Portfolio","og_description":"Administreerimise konspekt Andmebaasi v\u00f5tmete liigid (Database Keys) V\u00f5tmed on komponendid, mis tagavad andmete terviklikkuse, unikaalsuse ja t\u00f5husa ligip\u00e4\u00e4su neile. Neid [&hellip;]","og_url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/","og_site_name":"Oleksandra Ryshniak Portfolio","article_modified_time":"2025-10-30T11:47:37+00:00","og_image":[{"width":1000,"height":500,"url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/","name":"Administreerimise konspekt - Oleksandra Ryshniak Portfolio","isPartOf":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/#primaryimage"},"image":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/#primaryimage"},"thumbnailUrl":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11.png","datePublished":"2025-10-26T12:08:20+00:00","dateModified":"2025-10-30T11:47:37+00:00","breadcrumb":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/#primaryimage","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11.png","contentUrl":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/10\/image-11.png","width":1000,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/administreerimise-konspekt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/"},{"@type":"ListItem","position":2,"name":"Administreerimise konspekt"}]},{"@type":"WebSite","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/#website","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/","name":"Oleksandra Ryshniak Portfolio","description":"\u041f\u0440\u043e\u0441\u0442\u043e \u0435\u0449\u0435 \u043e\u0434\u0438\u043d WordPress \u0441\u0430\u0439\u0442","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/1668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/comments?post=1668"}],"version-history":[{"count":8,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/1668\/revisions"}],"predecessor-version":[{"id":1744,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/1668\/revisions\/1744"}],"wp:attachment":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/media?parent=1668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}