{"id":1270,"date":"2026-03-11T12:31:40","date_gmt":"2026-03-11T10:31:40","guid":{"rendered":"https:\/\/mareklukk24.thkit.ee\/wp\/?page_id=1270"},"modified":"2026-03-11T14:46:44","modified_gmt":"2026-03-11T12:46:44","slug":"andmebaasiskeem","status":"publish","type":"page","link":"https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/","title":{"rendered":"ANDMEBAASISKEEM"},"content":{"rendered":"\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;69ee466f1bc19&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"69ee466f1bc19\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"988\" height=\"696\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4.png\" alt=\"\" class=\"wp-image-1271\" srcset=\"https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4.png 988w, https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4-300x211.png 300w, https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4-768x541.png 768w, https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4-150x106.png 150w, https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4-230x162.png 230w, https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4-350x247.png 350w, https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4-480x338.png 480w\" sizes=\"auto, (max-width: 988px) 100vw, 988px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p><strong>Andmebaasi skeemi kirjeldus<\/strong><\/p>\n\n\n\n<p>See andmebaas on loodud hobuste talli haldamiseks. Andmebaas sisaldab infot hobuste, nende omanike, t\u00f6\u00f6tajate, toidu, s\u00f6\u00f6tmise, tallide ja veterinaarsete visiitide kohta. K\u00f5ik andmed on jagatud eraldi tabelitesse, mis on omavahel seotud v\u00e4lisv\u00f5tmete (FK) kaudu.<\/p>\n\n\n\n<p><strong>Tabelite kirjeldus:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>amet<\/strong> \u2013 sisaldab t\u00f6\u00f6tajate ametikohti.<\/li>\n\n\n\n<li><strong>tootaja<\/strong> \u2013 sisaldab t\u00f6\u00f6tajate andmeid (nimi, amet, palk).<\/li>\n\n\n\n<li><strong>omanik<\/strong> \u2013 sisaldab hobuste omanike kontaktandmeid.<\/li>\n\n\n\n<li><strong>hobused<\/strong> \u2013 sisaldab hobuste p\u00f5hiandmeid (nimi, vanus, sugu, omanik, tall, toit).<\/li>\n\n\n\n<li><strong>toit<\/strong> \u2013 sisaldab infot hobuste toidu kohta.<\/li>\n\n\n\n<li><strong>toitumine<\/strong> \u2013 salvestab andmed hobuste s\u00f6\u00f6tmise kohta (millal, millise toiduga ja milline t\u00f6\u00f6taja s\u00f6\u00f6tis).<\/li>\n\n\n\n<li><strong>tall<\/strong> \u2013 sisaldab infot tallide kohta (asukohad ja mahutavus).<\/li>\n\n\n\n<li><strong>veternaar<\/strong> \u2013 sisaldab veterinaaride andmeid.<\/li>\n\n\n\n<li><strong>vetvisiit<\/strong> \u2013 salvestab veterinaaride visiidid, diagnoosi ja ravi.<\/li>\n<\/ul>\n\n\n\n<p><strong>Seosed:<\/strong><br>\u00dchel omanikul v\u00f5ib olla mitu hobust, \u00fches tallis v\u00f5ib olla mitu hobust. T\u00f6\u00f6tajad on seotud ametitega ning nad v\u00f5ivad teostada hobuste s\u00f6\u00f6tmist. Veterinaarid teevad hobustele visiite, mille kohta salvestatakse diagnoos ja ravi.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Andmebaasi skeemi kirjeldus See andmebaas on loodud hobuste talli haldamiseks. Andmebaas sisaldab infot hobuste, nende omanike, t\u00f6\u00f6tajate, toidu, s\u00f6\u00f6tmise, tallide ja veterinaarsete [&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-1270","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 - Marek Lukk 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:\/\/mareklukk24.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 - Marek Lukk portfoolio\" \/>\n<meta property=\"og:description\" content=\"Andmebaasi skeemi kirjeldus See andmebaas on loodud hobuste talli haldamiseks. Andmebaas sisaldab infot hobuste, nende omanike, t\u00f6\u00f6tajate, toidu, s\u00f6\u00f6tmise, tallide ja veterinaarsete [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/\" \/>\n<meta property=\"og:site_name\" content=\"Marek Lukk portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-11T12:46:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"988\" \/>\n\t<meta property=\"og:image:height\" content=\"696\" \/>\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=\"1 minut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/andmebaasiskeem\\\/\",\"url\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/andmebaasiskeem\\\/\",\"name\":\"ANDMEBAASISKEEM - Marek Lukk portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/andmebaasiskeem\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/andmebaasiskeem\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/D691195B-F196-4944-A3DC-177F7FDA87E4.png\",\"datePublished\":\"2026-03-11T10:31:40+00:00\",\"dateModified\":\"2026-03-11T12:46:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/andmebaasiskeem\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/andmebaasiskeem\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/andmebaasiskeem\\\/#primaryimage\",\"url\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/D691195B-F196-4944-A3DC-177F7FDA87E4.png\",\"contentUrl\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/D691195B-F196-4944-A3DC-177F7FDA87E4.png\",\"width\":988,\"height\":696},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/andmebaasiskeem\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ANDMEBAASISKEEM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/\",\"name\":\"Marek Lukk portfoolio\",\"description\":\"Noorem tarkvaraarendaja\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mareklukk24.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 - Marek Lukk 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:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/","og_locale":"et_EE","og_type":"article","og_title":"ANDMEBAASISKEEM - Marek Lukk portfoolio","og_description":"Andmebaasi skeemi kirjeldus See andmebaas on loodud hobuste talli haldamiseks. Andmebaas sisaldab infot hobuste, nende omanike, t\u00f6\u00f6tajate, toidu, s\u00f6\u00f6tmise, tallide ja veterinaarsete [&hellip;]","og_url":"https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/","og_site_name":"Marek Lukk portfoolio","article_modified_time":"2026-03-11T12:46:44+00:00","og_image":[{"width":988,"height":696,"url":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/","url":"https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/","name":"ANDMEBAASISKEEM - Marek Lukk portfoolio","isPartOf":{"@id":"https:\/\/mareklukk24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/#primaryimage"},"image":{"@id":"https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/#primaryimage"},"thumbnailUrl":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4.png","datePublished":"2026-03-11T10:31:40+00:00","dateModified":"2026-03-11T12:46:44+00:00","breadcrumb":{"@id":"https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/#primaryimage","url":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4.png","contentUrl":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-content\/uploads\/2026\/03\/D691195B-F196-4944-A3DC-177F7FDA87E4.png","width":988,"height":696},{"@type":"BreadcrumbList","@id":"https:\/\/mareklukk24.thkit.ee\/wp\/andmebaasiskeem\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mareklukk24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"ANDMEBAASISKEEM"}]},{"@type":"WebSite","@id":"https:\/\/mareklukk24.thkit.ee\/wp\/#website","url":"https:\/\/mareklukk24.thkit.ee\/wp\/","name":"Marek Lukk portfoolio","description":"Noorem tarkvaraarendaja","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mareklukk24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=1270"}],"version-history":[{"count":2,"href":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1270\/revisions"}],"predecessor-version":[{"id":1283,"href":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1270\/revisions\/1283"}],"wp:attachment":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=1270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}