{"id":1277,"date":"2026-03-11T10:46:00","date_gmt":"2026-03-11T10:46:00","guid":{"rendered":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/?page_id=1277"},"modified":"2026-03-11T10:47:36","modified_gmt":"2026-03-11T10:47:36","slug":"andmebaasiskeem","status":"publish","type":"page","link":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/","title":{"rendered":"ANDMEBAASISKEEM"},"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-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/#Andmebaasi_skeem_%E2%80%93_vaike_konspekt\" >Andmebaasi skeem \u2013 v\u00e4ike konspekt<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/#Pohimoisted\" >P\u00f5him\u00f5isted<\/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\/andmebaasiskeem\/#Andmemudelid\" >Andmemudelid<\/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\/andmebaasiskeem\/#Votmed_andmebaasis\" >V\u00f5tmed andmebaasis<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Andmebaasi_skeem_%E2%80%93_vaike_konspekt\"><\/span>Andmebaasi skeem \u2013 v\u00e4ike konspekt<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p><strong>Andmebaasi skeem<\/strong> on diagramm, mis n\u00e4itab andmebaasi struktuuri.<br>Skeem kujutab tabelite, nende v\u00e4ljade (atribuutide) ja seoste vahelisi suhteid.<br>See aitab aru saada, kuidas andmed on andmebaasis organiseeritud ja kuidas tabelid omavahel seotud on.<\/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=\"Pohimoisted\"><\/span>P\u00f5him\u00f5isted<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Olem (Entity)<\/strong><br>Olem on objekt v\u00f5i tabel andmebaasis, mis kirjeldab mingit reaalse maailma objekti.<br>N\u00e4iteks: <strong>Klient, Auto, Mark, Rent_info<\/strong>.<\/p>\n\n\n\n<p><strong>Atribuut (Attribute)<\/strong><br>Atribuut on omadus, mis kirjeldab olemit.<br>N\u00e4iteks kliendi puhul: <strong>nimi, perekonnanimi, telefon, email<\/strong>.<\/p>\n\n\n\n<p><strong>Seos (Relationship)<\/strong><br>Seos n\u00e4itab, kuidas kaks tabelit on omavahel seotud.<br>N\u00e4iteks \u00fcks klient v\u00f5ib rentida mitu autot.<\/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=\"Andmemudelid\"><\/span>Andmemudelid<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Olemid\u2013seosed (Entity\u2013Relationship mudel)<\/strong><br>Mudelis n\u00e4idatakse tabelid ja nende vahelised seosed diagrammi kujul.<\/p>\n\n\n\n<p><strong>Olemid\u2013atribuutid\u2013seosed<\/strong><br>Lisaks tabelitele ja seostele n\u00e4idatakse ka k\u00f5ik v\u00e4ljad (atribuutid), mis tabelis asuvad.<\/p>\n\n\n\n<p><strong>Hierarhiline mudel<\/strong><br>Andmed on organiseeritud puustruktuurina, kus \u00fcks element on teise alamobjekt.<\/p>\n\n\n\n<p><strong>Relatsiooniline mudel<\/strong><br>K\u00f5ige levinum mudel, kus andmed salvestatakse tabelitesse ja tabelid on omavahel seotud v\u00f5tmete abil.<\/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=\"Votmed_andmebaasis\"><\/span>V\u00f5tmed andmebaasis<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Primary Key (PK)<\/strong><br>Unikaalne v\u00f5ti, mis identifitseerib iga tabeli rea.<\/p>\n\n\n\n<p><strong>Foreign Key (FK)<\/strong><br>V\u00f5ti, mis seob \u00fche tabeli teise tabeliga.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Minu skeem:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2026\/03\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png\"><img loading=\"lazy\" decoding=\"async\" width=\"577\" height=\"395\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2026\/03\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png\" alt=\"\" class=\"wp-image-1278\" srcset=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2026\/03\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png 577w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2026\/03\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F-300x205.png 300w, https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2026\/03\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F-150x103.png 150w\" sizes=\"auto, (max-width: 577px) 100vw, 577px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Andmebaasi skeem \u2013 v\u00e4ike konspekt Andmebaasi skeem on diagramm, mis n\u00e4itab andmebaasi struktuuri.Skeem kujutab tabelite, nende v\u00e4ljade (atribuutide) ja seoste vahelisi suhteid.See aitab aru saada, kuidas andmed on andmebaasis organiseeritud ja kuidas tabelid omavahel seotud on. P\u00f5him\u00f5isted Olem (Entity)Olem on objekt v\u00f5i tabel andmebaasis, mis kirjeldab mingit reaalse maailma objekti.N\u00e4iteks: Klient, Auto, Mark, Rent_info. Atribuut [&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-1277","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>ANDMEBAASISKEEM - Nikita Orlenko \/ Portfoolio<\/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:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ANDMEBAASISKEEM - Nikita Orlenko \/ Portfoolio\" \/>\n<meta property=\"og:description\" content=\"Andmebaasi skeem \u2013 v\u00e4ike konspekt Andmebaasi skeem on diagramm, mis n\u00e4itab andmebaasi struktuuri.Skeem kujutab tabelite, nende v\u00e4ljade (atribuutide) ja seoste vahelisi suhteid.See aitab aru saada, kuidas andmed on andmebaasis organiseeritud ja kuidas tabelid omavahel seotud on. P\u00f5him\u00f5isted Olem (Entity)Olem on objekt v\u00f5i tabel andmebaasis, mis kirjeldab mingit reaalse maailma objekti.N\u00e4iteks: Klient, Auto, Mark, Rent_info. Atribuut [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/\" \/>\n<meta property=\"og:site_name\" content=\"Nikita Orlenko \/ Portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-11T10:47:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2026\/03\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png\" \/>\n\t<meta property=\"og:image:width\" content=\"577\" \/>\n\t<meta property=\"og:image:height\" content=\"395\" \/>\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=\"2 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/andmebaasiskeem\\\/\",\"url\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/andmebaasiskeem\\\/\",\"name\":\"ANDMEBAASISKEEM - Nikita Orlenko \\\/ Portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/andmebaasiskeem\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/andmebaasiskeem\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png\",\"datePublished\":\"2026-03-11T10:46:00+00:00\",\"dateModified\":\"2026-03-11T10:47:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/andmebaasiskeem\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/andmebaasiskeem\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/andmebaasiskeem\\\/#primaryimage\",\"url\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png\",\"contentUrl\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/andmebaasiskeem\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ANDMEBAASISKEEM\"}]},{\"@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":"ANDMEBAASISKEEM - Nikita Orlenko \/ Portfoolio","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\/andmebaasiskeem\/","og_locale":"et_EE","og_type":"article","og_title":"ANDMEBAASISKEEM - Nikita Orlenko \/ Portfoolio","og_description":"Andmebaasi skeem \u2013 v\u00e4ike konspekt Andmebaasi skeem on diagramm, mis n\u00e4itab andmebaasi struktuuri.Skeem kujutab tabelite, nende v\u00e4ljade (atribuutide) ja seoste vahelisi suhteid.See aitab aru saada, kuidas andmed on andmebaasis organiseeritud ja kuidas tabelid omavahel seotud on. P\u00f5him\u00f5isted Olem (Entity)Olem on objekt v\u00f5i tabel andmebaasis, mis kirjeldab mingit reaalse maailma objekti.N\u00e4iteks: Klient, Auto, Mark, Rent_info. Atribuut [&hellip;]","og_url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/","og_site_name":"Nikita Orlenko \/ Portfoolio","article_modified_time":"2026-03-11T10:47:36+00:00","og_image":[{"width":577,"height":395,"url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2026\/03\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/","url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/","name":"ANDMEBAASISKEEM - Nikita Orlenko \/ Portfoolio","isPartOf":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/#primaryimage"},"image":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/#primaryimage"},"thumbnailUrl":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2026\/03\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png","datePublished":"2026-03-11T10:46:00+00:00","dateModified":"2026-03-11T10:47:36+00:00","breadcrumb":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/#primaryimage","url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2026\/03\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png","contentUrl":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-content\/uploads\/2026\/03\/83CC4AAD-1783-4D2A-A276-CBC7A628D04F.png"},{"@type":"BreadcrumbList","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/andmebaasiskeem\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/"},{"@type":"ListItem","position":2,"name":"ANDMEBAASISKEEM"}]},{"@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\/1277","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=1277"}],"version-history":[{"count":1,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/1277\/revisions"}],"predecessor-version":[{"id":1279,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/1277\/revisions\/1279"}],"wp:attachment":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/media?parent=1277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}