{"id":134,"date":"2025-06-02T10:58:43","date_gmt":"2025-06-02T10:58:43","guid":{"rendered":"https:\/\/darjamalkova23.thkit.ee\/wpp\/?page_id=134"},"modified":"2025-06-02T10:58:43","modified_gmt":"2025-06-02T10:58:43","slug":"andmebaasis-steemide-alused","status":"publish","type":"page","link":"https:\/\/darjamalkova23.thkit.ee\/wpp\/andmebaasis-steemide-alused\/","title":{"rendered":"Andmebaasis-steemide-alused"},"content":{"rendered":"\n<ol class=\"wp-block-list\">\n<li>teksti v\u00f5i s\u00fcmboolid &#8211; VARCHAR(50), CHAR(3), TEXT<br>N\u00e4ited: nimi, nimetus, telefoninumber, isikukood &#8211; VARCHAR(11)<\/li>\n\n\n\n<li>ARVULISED &#8211; int, bigint, smallint, decimal(5,2) -5 kokku, 2- peale komat<br>N\u00e4ited: vanus, palk, temperatuur, kaal, jne<\/li>\n\n\n\n<li>Kuup\u00e4eva &#8211; DATE, TIME, date\/time<br>4.Loogilised &#8211; bit, bool, boolean<\/li>\n<\/ol>\n\n\n\n<p>Piirangud<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Primary Key &#8211; ei anna v\u00f5imalust lisada topelt v\u00e4\u00e4rtused<\/li>\n\n\n\n<li>UNIQUE<\/li>\n\n\n\n<li>NOT NULL &#8211; ei lubada t\u00fchjad v\u00e4\u00e4rtused<\/li>\n\n\n\n<li>Foreign Key &#8211; saab kasutada ainult teise tabeli v\u00e4\u00e4rtused<\/li>\n\n\n\n<li>CHECK &#8211; saab sisestada ainult check m\u00e4\u00e4ratud v\u00e4\u00e4rtused<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Piirangud<\/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-134","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/pages\/134","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/comments?post=134"}],"version-history":[{"count":1,"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/pages\/134\/revisions"}],"predecessor-version":[{"id":135,"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/pages\/134\/revisions\/135"}],"wp:attachment":[{"href":"https:\/\/darjamalkova23.thkit.ee\/wpp\/wp-json\/wp\/v2\/media?parent=134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}