{"id":790,"date":"2025-05-10T08:17:00","date_gmt":"2025-05-10T08:17:00","guid":{"rendered":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790"},"modified":"2025-05-13T06:48:33","modified_gmt":"2025-05-13T06:48:33","slug":"db-keys","status":"publish","type":"page","link":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790","title":{"rendered":"Andmebaasiv\u00f5tmed"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\ud83d\udd11 \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0442\u0438\u043f\u044b \u043a\u043b\u044e\u0447\u0435\u0439<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u041a\u043b\u044e\u0447 (\u043d\u0430 \u0430\u043d\u0433\u043b.)<\/th><th>\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043d\u0430 \u0440\u0443\u0441\u0441\u043a\u043e\u043c<\/th><th>\u041f\u0440\u043e\u0441\u0442\u043e\u0435 \u043e\u0431\u044a\u044f\u0441\u043d\u0435\u043d\u0438\u0435 \u2014 \u0437\u0430\u0447\u0435\u043c \u043e\u043d \u043d\u0443\u0436\u0435\u043d<\/th><\/tr><\/thead><tbody><tr><td><strong>Primary Key<\/strong><\/td><td>\u041f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u0439 \u043a\u043b\u044e\u0447<\/td><td>\u042d\u0442\u043e <strong>\u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440<\/strong> \u0437\u0430\u043f\u0438\u0441\u0438. \u041e\u043d <strong>\u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u0435\u043d<\/strong> \u0438 <strong>\u0443\u043d\u0438\u043a\u0430\u043b\u0435\u043d<\/strong>. \u0411\u0435\u0437 \u043d\u0435\u0433\u043e \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u043f\u043e\u0440\u044f\u0434\u043a\u0430 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435.<\/td><\/tr><tr><td><strong>Foreign Key<\/strong><\/td><td>\u0412\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447<\/td><td>\u0421\u0432\u044f\u0437\u044b\u0432\u0430\u0435\u0442 \u043e\u0434\u043d\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0441 \u0434\u0440\u0443\u0433\u043e\u0439. \u041f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 SQL \u043f\u043e\u043d\u044f\u0442\u044c, <strong>\u0433\u0434\u0435 \u0441\u0432\u044f\u0437\u044c \u043c\u0435\u0436\u0434\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438<\/strong>, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0441\u0442\u0443\u0434\u0435\u043d\u0442 \u0438 \u0435\u0433\u043e \u043a\u0443\u0440\u0441\u044b.<\/td><\/tr><tr><td><strong>Unique Key<\/strong><\/td><td>\u0423\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0439 \u043a\u043b\u044e\u0447<\/td><td>\u0413\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u0443\u0435\u0442, \u0447\u0442\u043e \u0432 \u044d\u0442\u043e\u043c \u043f\u043e\u043b\u0435 <strong>\u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u043f\u043e\u0432\u0442\u043e\u0440\u043e\u0432<\/strong>, \u043d\u043e <strong>\u044d\u0442\u043e \u043d\u0435 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u043a\u043b\u044e\u0447<\/strong>. \u0423\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u2014 \u0434\u0430, \u0433\u043b\u0430\u0432\u043d\u043e\u0441\u0442\u044c \u2014 \u043d\u0435\u0442.<\/td><\/tr><tr><td><strong>Simple Key<\/strong><\/td><td>\u041f\u0440\u043e\u0441\u0442\u043e\u0439 \u043a\u043b\u044e\u0447<\/td><td>\u041a\u043b\u044e\u0447 \u0438\u0437 <strong>\u043e\u0434\u043d\u043e\u0433\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u0430<\/strong>. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, <code>OpilaseID<\/code> \u2014 \u044d\u0442\u043e \u043f\u0440\u043e\u0441\u0442\u043e\u0439 \u043a\u043b\u044e\u0447, \u043f\u043e\u0442\u043e\u043c\u0443 \u0447\u0442\u043e \u043e\u043d \u043e\u0434\u0438\u043d.<\/td><\/tr><tr><td><strong>Composite Key<\/strong><\/td><td>\u0421\u043e\u0441\u0442\u0430\u0432\u043d\u043e\u0439 \u043a\u043b\u044e\u0447<\/td><td>\u041a\u043b\u044e\u0447 \u0438\u0437 <strong>\u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u043f\u043e\u043b\u0435\u0439<\/strong>, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0432\u043c\u0435\u0441\u0442\u0435 \u0434\u0430\u044e\u0442 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, <code>StudentID + CourseCode<\/code>.<\/td><\/tr><tr><td><strong>Compound Key<\/strong><\/td><td>\u041a\u043e\u043c\u0431\u0438\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 \u043a\u043b\u044e\u0447<\/td><td>\u0422\u043e \u0436\u0435 \u0441\u0430\u043c\u043e\u0435, \u0447\u0442\u043e \u0438 \u0441\u043e\u0441\u0442\u0430\u0432\u043d\u043e\u0439, \u043d\u043e \u043f\u043e\u0434\u0447\u0435\u0440\u043a\u0438\u0432\u0430\u0435\u0442, \u0447\u0442\u043e \u043f\u043e\u043b\u044f \u043c\u043e\u0433\u0443\u0442 \u0431\u044b\u0442\u044c <strong>\u0440\u0430\u0437\u043d\u043e\u0433\u043e \u0442\u0438\u043f\u0430<\/strong> \u0438\u043b\u0438 \u0441\u043c\u044b\u0441\u043b\u0430.<\/td><\/tr><tr><td><strong>Superkey<\/strong><\/td><td>\u0421\u0443\u043f\u0435\u0440\u043a\u043b\u044e\u0447<\/td><td>\u041b\u044e\u0431\u0430\u044f <strong>\u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u044f \u043f\u043e\u043b\u0435\u0439, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0434\u0435\u043b\u0430\u0435\u0442 \u0437\u0430\u043f\u0438\u0441\u044c \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u043e\u0439<\/strong>, \u0434\u0430\u0436\u0435 \u0435\u0441\u043b\u0438 \u043b\u0438\u0448\u043d\u044f\u044f. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, <code>ID + Email<\/code>.<\/td><\/tr><tr><td><strong>Candidate Key<\/strong><\/td><td>\u041a\u0430\u043d\u0434\u0438\u0434\u0430\u0442 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u043a\u043b\u044e\u0447<\/td><td>\u041b\u044e\u0431\u043e\u0435 \u043f\u043e\u043b\u0435 (\u0438\u043b\u0438 \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u044f), \u043a\u043e\u0442\u043e\u0440\u043e\u0435 <strong>\u043c\u043e\u0433\u043b\u043e \u0431\u044b \u0431\u044b\u0442\u044c Primary Key<\/strong>. SQL \u00ab\u0432\u044b\u0431\u0438\u0440\u0430\u0435\u0442\u00bb \u043e\u0434\u0438\u043d \u0438\u0437 \u043d\u0438\u0445.<\/td><\/tr><tr><td><strong>Alternate Key<\/strong><\/td><td>\u0410\u043b\u044c\u0442\u0435\u0440\u043d\u0430\u0442\u0438\u0432\u043d\u044b\u0439 \u043a\u043b\u044e\u0447<\/td><td>\u0422\u0435 <strong>candidate key, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0435 \u0432\u044b\u0431\u0440\u0430\u043d\u044b \u043a\u0430\u043a \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0439<\/strong>. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, <code>Isikukood<\/code>, \u0435\u0441\u043b\u0438 Primary \u2014 <code>OpilaseID<\/code>.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udca1 \u041f\u0440\u0438\u043c\u0435\u0440\u044b \u0438\u0437 \u0436\u0438\u0437\u043d\u0438<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>Primary Key<\/code> \u2014 \u043a\u0430\u043a <strong>ID-\u043f\u0430\u0441\u043f\u043e\u0440\u0442<\/strong>: \u0443 \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u0447\u0435\u043b\u043e\u0432\u0435\u043a\u0430 \u043e\u0434\u0438\u043d, \u0438 \u043e\u043d \u0443\u043d\u0438\u043a\u0430\u043b\u0435\u043d.<\/li>\n\n\n\n<li><code>Foreign Key<\/code> \u2014 \u043a\u0430\u043a <strong>\u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u0440\u043e\u0434\u0438\u0442\u0435\u043b\u044f \u0432 \u0448\u043a\u043e\u043b\u0435<\/strong>: \u0443\u0447\u0435\u043d\u0438\u043a \u0441\u0432\u044f\u0437\u0430\u043d \u0441 \u0440\u043e\u0434\u0438\u0442\u0435\u043b\u0435\u043c.<\/li>\n\n\n\n<li><code>Unique Key<\/code> \u2014 \u043a\u0430\u043a <strong>\u043d\u043e\u043c\u0435\u0440 \u0442\u0435\u043b\u0435\u0444\u043e\u043d\u0430<\/strong>: \u0443 \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u0441\u0432\u043e\u0439, \u043d\u043e \u043e\u043d \u043d\u0435 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u0442 \u0442\u0435\u0431\u044f \u043f\u043e\u043b\u043d\u043e\u0441\u0442\u044c\u044e.<\/li>\n\n\n\n<li><code>Composite Key<\/code> \u2014 \u043a\u0430\u043a <strong>\u0424\u0418\u041e + \u0434\u0430\u0442\u0430 \u0440\u043e\u0436\u0434\u0435\u043d\u0438\u044f<\/strong>: \u0432\u043c\u0435\u0441\u0442\u0435 \u0442\u043e\u0447\u043d\u043e \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b, \u043f\u043e \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u2014 \u043d\u0435\u0442.<\/li>\n\n\n\n<li><code>Superkey<\/code> \u2014 \u043a\u0430\u043a <strong>ID + \u043d\u043e\u043c\u0435\u0440 \u043e\u0431\u0443\u0432\u0438 + \u0440\u043e\u0441\u0442<\/strong>: \u0434\u0435\u043b\u0430\u0435\u0442 \u0442\u0435\u0431\u044f \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u043c, \u043d\u043e \u043d\u0435 \u043d\u0443\u0436\u043d\u043e \u0441\u0442\u043e\u043b\u044c\u043a\u043e.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u0412\u043e\u0437\u044c\u043c\u0435\u043c \u043f\u0440\u0438\u043c\u0435\u0440 \u0411\u0414 \u0448\u043a\u043e\u043b\u0430<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE DATABASE KoolAndmebaas;\nuse KoolAndmebaas\nCREATE TABLE Opilased (\n    OpilaseID INT PRIMARY KEY,    -- PRIMARY KEY: \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0439 \u043a\u043b\u044e\u0447\n    Eesnimi NVARCHAR(50),\n    Perenimi NVARCHAR(50),\n    Isikukood CHAR(11) UNIQUE,   -- UNIQUE KEY: \u043a\u0430\u0436\u0434\u044b\u0439 \u0443\u0447\u0435\u043d\u0438\u043a \u0438\u043c\u0435\u0435\u0442 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0439 ID-\u043a\u043e\u0434\n    Email NVARCHAR(100),\n    Telefon NVARCHAR(15),\n    CONSTRAINT UQ_Email_Telefon UNIQUE (Email, Telefon)  -- COMPOUND KEY: \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438 email \u0438 \u0442\u0435\u043b\u0435\u0444\u043e\u043d\u0430\n);\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nINSERT INTO Opilased (OpilaseID, Eesnimi, Perenimi, Isikukood, Email, Telefon)\nVALUES \n(3, &#039;Anna&#039;, &#039;Ivanova&#039;, &#039;12345678901&#039;, &#039;anna@kool.ee&#039;, &#039;5551111&#039;),\n(2, &#039;Mati&#039;, &#039;Tamm&#039;, &#039;98765432100&#039;, &#039;mati@kool.ee&#039;, &#039;5552222&#039;);\n\nSELECT * FROM Opilased\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"388\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-141912-1024x388.png\" alt=\"\" class=\"wp-image-795\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-141912-1024x388.png 1024w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-141912-300x114.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-141912-768x291.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-141912-150x57.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-141912-600x228.png 600w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-141912.png 1403w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- \u0422\u0430\u0431\u043b\u0438\u0446\u0430 \u0443\u0447\u0438\u0442\u0435\u043b\u0435\u0439 \u0441 UNIQUE KEY\nCREATE TABLE Opetajad (\n    OpetajaID INT PRIMARY KEY,\n    Email NVARCHAR(100) UNIQUE  -- UNIQUE: email \u0434\u043e\u043b\u0436\u0435\u043d \u0431\u044b\u0442\u044c \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u043c\n);\n\n\nINSERT INTO Opetajad (OpetajaID, Email)\nVALUES \n(1, &#039;opetaja.liisa@kool.ee&#039;),\n(2, &#039;opetaja.jaanus@kool.ee&#039;);\n\nSELECT * FROM Opetajad\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1022\" height=\"532\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142150.png\" alt=\"\" class=\"wp-image-796\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142150.png 1022w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142150-300x156.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142150-768x400.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142150-150x78.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142150-600x312.png 600w\" sizes=\"auto, (max-width: 1022px) 100vw, 1022px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- \u0422\u0430\u0431\u043b\u0438\u0446\u0430 \u0440\u0435\u0433\u0438\u0441\u0442\u0440\u0430\u0446\u0438\u0439 \u0441 COMPOSITE KEY \u0438 FOREIGN KEY\nCREATE TABLE Registreerimised (\n    OpilaseID INT,\n    KursuseKood NVARCHAR(10),\n    RegistreerimiseKuup\u00e4ev DATE,\n    PRIMARY KEY (OpilaseID, KursuseKood),  -- COMPOSITE KEY: \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u0430\u044f \u043f\u0430\u0440\u0430\n    FOREIGN KEY (OpilaseID) REFERENCES Opilased(OpilaseID)   -- FOREIGN KEY: \u0441\u0432\u044f\u0437\u044c \u0441 \u0443\u0447\u0435\u043d\u0438\u043a\u0430\u043c\u0438\n);\n\nINSERT INTO Registreerimised (OpilaseID, KursuseKood, RegistreerimiseKuup\u00e4ev)\nVALUES \n(3, &#039;MAT101&#039;, &#039;2024-09-01&#039;),\n(2, &#039;BIO102&#039;, &#039;2024-09-03&#039;);\n\nSELECT * FROM Registreerimised\nSELECT * FROM Opilased\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"656\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142548-1024x656.png\" alt=\"\" class=\"wp-image-797\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142548-1024x656.png 1024w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142548-300x192.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142548-768x492.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142548-150x96.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142548-600x385.png 600w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142548.png 1228w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- \u0422\u0430\u0431\u043b\u0438\u0446\u0430 \u043e\u0446\u0435\u043d\u043e\u043a \u0441 COMPOSITE KEY\nCREATE TABLE Hindamised (\n    OpilaseID INT,\n    KursuseKood NVARCHAR(10),\n    Hinne INT,\n    PRIMARY KEY (OpilaseID, KursuseKood)\n);\n\nINSERT INTO Hindamised (OpilaseID, KursuseKood, Hinne)\nVALUES \n(2, &#039;MAT101&#039;, 5),\n(3, &#039;BIO102&#039;, 4);\n\nSELECT * FROM Registreerimised\nSELECT * FROM Opilased\nSELECT * FROM Hindamised\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"891\" height=\"767\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142752.png\" alt=\"\" class=\"wp-image-798\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142752.png 891w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142752-300x258.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142752-768x661.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142752-150x129.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-142752-600x516.png 600w\" sizes=\"auto, (max-width: 891px) 100vw, 891px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- \u0422\u0430\u0431\u043b\u0438\u0446\u0430 \u0441 COMPOUND UNIQUE KEY\nCREATE TABLE Kontaktid (\n    Email NVARCHAR(100),\n    Telefon NVARCHAR(20),\n    CONSTRAINT UQ_Kontakt UNIQUE (Email, Telefon)\n);\n\nINSERT INTO Kontaktid (Email, Telefon)\nVALUES \n(&#039;anna@kool.ee&#039;, &#039;5551111&#039;),\n(&#039;mati@kool.ee&#039;, &#039;5552222&#039;);\n\nSELECT * FROM Kontaktid\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"818\" height=\"568\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143102.png\" alt=\"\" class=\"wp-image-799\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143102.png 818w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143102-300x208.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143102-768x533.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143102-150x104.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143102-600x417.png 600w\" sizes=\"auto, (max-width: 818px) 100vw, 818px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- \u0422\u0430\u0431\u043b\u0438\u0446\u0430 \u0441 SUPERKEY (PRIMARY KEY \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 &quot;\u043b\u0438\u0448\u043d\u0438\u0435&quot; \u043f\u043e\u043b\u044f) \u043f\u043e\u043b\u0435 Email \u0437\u0434\u0435\u0441\u044c \u043b\u0438\u0448\u043d\u0435\u0435, \u043f\u043e\u0442\u043e\u043c\u0443 \u0447\u0442\u043e OpilaseID \u0443\u0436\u0435 \u0438 \u0442\u0430\u043a \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0439. \/\/ \u0442\u0435\u0441\u0442\u043e\u0432\u0430\u044f \u0434\u043b\u044f SUPERKEY\nCREATE TABLE Proov (\n    OpilaseID INT,\n    Email NVARCHAR(100),\n    PRIMARY KEY (OpilaseID, Email)\n);\n\nINSERT INTO Proov (OpilaseID, Email)\nVALUES \n(2, &#039;anna@kool.ee&#039;),\n(3, &#039;mati@kool.ee&#039;);\n\nSELECT * FROM Proov\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"891\" height=\"550\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143357.png\" alt=\"\" class=\"wp-image-801\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143357.png 891w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143357-300x185.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143357-768x474.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143357-150x93.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143357-600x370.png 600w\" sizes=\"auto, (max-width: 891px) 100vw, 891px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE Opilased2 (\n    ID INT,\n    Isikukood CHAR(11),\n    Email NVARCHAR(100),\n    CONSTRAINT PK_Opilased2 PRIMARY KEY (ID),-- PRIMARY KEY\n    CONSTRAINT UQ_Isikukood UNIQUE (Isikukood), -- ALTERNATE KEY\n    CONSTRAINT UQ_Email UNIQUE (Email) -- ALTERNATE KEY\n);\n\nINSERT INTO Opilased2 (ID, Isikukood, Email)\nVALUES \n(2, &#039;11111111111&#039;, &#039;liis@kool.ee&#039;),\n(3, &#039;22222222222&#039;, &#039;jaan@kool.ee&#039;);\n\nSELECT * FROM Opilased2\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"952\" height=\"618\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143546.png\" alt=\"\" class=\"wp-image-803\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143546.png 952w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143546-300x195.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143546-768x499.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143546-150x97.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143546-600x389.png 600w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM Opilased;\nSELECT * FROM Opetajad;\nSELECT * FROM Registreerimised;\nSELECT * FROM Hindamised;\nSELECT * FROM Kontaktid;\nSELECT * FROM Proov;\nSELECT * FROM Opilased2;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"895\" height=\"777\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143829.png\" alt=\"\" class=\"wp-image-805\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143829.png 895w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143829-300x260.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143829-768x667.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143829-150x130.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-143829-600x521.png 600w\" sizes=\"auto, (max-width: 895px) 100vw, 895px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u0422\u0430\u0431\u043b\u0438\u0446\u0430<\/th><th>\u041a\u043b\u044e\u0447\u0438<\/th><th>\u0427\u0442\u043e \u043e\u043d\u0438 \u0434\u0435\u043b\u0430\u044e\u0442<\/th><\/tr><\/thead><tbody><tr><td><code>Opilased<\/code><\/td><td><code>PRIMARY KEY (OpilaseID)<\/code><\/td><td>\u0423\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0439 ID \u0443\u0447\u0435\u043d\u0438\u043a\u0430<\/td><\/tr><tr><td><\/td><td><code>UNIQUE (Isikukood)<\/code><\/td><td>\u0413\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u0443\u0435\u0442, \u0447\u0442\u043e ID-\u043a\u043e\u0434 \u0443\u043d\u0438\u043a\u0430\u043b\u0435\u043d<\/td><\/tr><tr><td><\/td><td><code>UNIQUE (Email, Telefon)<\/code><\/td><td>\u0423\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u0430\u044f \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u044f \u2014 \u043d\u0438 \u043e\u0434\u0438\u043d \u0443\u0447\u0435\u043d\u0438\u043a \u043d\u0435 \u043c\u043e\u0436\u0435\u0442 \u043f\u043e\u0432\u0442\u043e\u0440\u0438\u0442\u044c\u0441\u044f \u043f\u043e \u044d\u0442\u0438\u043c 2 \u043f\u043e\u043b\u044f\u043c<\/td><\/tr><tr><td><code>Opetajad<\/code><\/td><td><code>PRIMARY KEY (OpetajaID)<\/code><\/td><td>ID \u0443\u0447\u0438\u0442\u0435\u043b\u044f<\/td><\/tr><tr><td><\/td><td><code>UNIQUE (Email)<\/code><\/td><td>\u0423 \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u0443\u0447\u0438\u0442\u0435\u043b\u044f \u0441\u0432\u043e\u0439 email<\/td><\/tr><tr><td><code>Registreerimised<\/code><\/td><td><code>PRIMARY KEY (OpilaseID, KursuseKood)<\/code><\/td><td>\u041e\u0434\u0438\u043d \u0443\u0447\u0435\u043d\u0438\u043a \u043d\u0435 \u043c\u043e\u0436\u0435\u0442 \u0434\u0432\u0430\u0436\u0434\u044b \u0437\u0430\u043f\u0438\u0441\u0430\u0442\u044c\u0441\u044f \u043d\u0430 \u043e\u0434\u0438\u043d \u043a\u0443\u0440\u0441<\/td><\/tr><tr><td><\/td><td><code>FOREIGN KEY (OpilaseID)<\/code> \u2192 <code>Opilased.OpilaseID<\/code><\/td><td>\u0421\u0432\u044f\u0437\u044c \u0441 \u0443\u0447\u0435\u043d\u0438\u043a\u0430\u043c\u0438<\/td><\/tr><tr><td><code>Hindamised<\/code><\/td><td><code>PRIMARY KEY (OpilaseID, KursuseKood)<\/code><\/td><td>\u041a\u0430\u0436\u0434\u043e\u043c\u0443 \u0443\u0447\u0435\u043d\u0438\u043a\u0443 \u043f\u043e \u043a\u0443\u0440\u0441\u0443 \u2014 \u043e\u0434\u043d\u0430 \u043e\u0446\u0435\u043d\u043a\u0430<\/td><\/tr><tr><td><code>Kontaktid<\/code><\/td><td><code>UNIQUE (Email, Telefon)<\/code><\/td><td>\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u044f \u0434\u043e\u043b\u0436\u043d\u0430 \u0431\u044b\u0442\u044c \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u043e\u0439<\/td><\/tr><tr><td><code>Proov<\/code><\/td><td><code>PRIMARY KEY (OpilaseID, Email)<\/code><\/td><td>SUPERKEY: \u0434\u0435\u043b\u0430\u0435\u0442 \u0441\u0442\u0440\u043e\u043a\u0443 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u043e\u0439, \u043d\u043e Email \u043b\u0438\u0448\u043d\u0438\u0439<\/td><\/tr><tr><td><code>Opilased2<\/code><\/td><td><code>PRIMARY KEY (ID)<\/code><\/td><td>\u041e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u043a\u043b\u044e\u0447<\/td><\/tr><tr><td><\/td><td><code>UNIQUE (Isikukood)<\/code> \u0438 <code>UNIQUE (Email)<\/code><\/td><td>Alternate Keys \u2014 \u0442\u043e\u0436\u0435 \u043c\u043e\u0433\u043b\u0438 \u0431\u044b \u0431\u044b\u0442\u044c Primary<br><br><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0440\u0430\u0431\u043e\u0442\u044b \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0439<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 UNIQUE\nINSERT INTO Opilased (OpilaseID, Eesnimi, Perenimi, Isikukood, Email, Telefon)\nVALUES (5, &#039;Test&#039;, &#039;Test&#039;, &#039;12345678901&#039;, &#039;another@kool.ee&#039;, &#039;9999999&#039;);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"260\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-144113-1024x260.png\" alt=\"\" class=\"wp-image-806\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-144113-1024x260.png 1024w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-144113-300x76.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-144113-768x195.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-144113-150x38.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-144113-1536x390.png 1536w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-144113-600x152.png 600w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2025-05-10-144113.png 1587w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442 \u043e\u0448\u0438\u0431\u043a\u0443, \u043f\u043e\u0442\u043e\u043c\u0443 \u0447\u0442\u043e <code>Isikukood = '12345678901'<\/code> \u0443\u0436\u0435 \u0435\u0441\u0442\u044c<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0418\u0442\u043e\u0433<\/h2>\n\n\n\n<p>\u0412\u0441\u0435 \u043a\u043b\u044e\u0447\u0438 \u0431\u044b\u043b\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u044b \u0438 \u043f\u0440\u043e\u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u044b. \u0422\u0430\u0431\u043b\u0438\u0446\u0430 \u0441\u0432\u044f\u0437\u0430\u043d\u0430(Registreemised &#8211; Opilased), \u0434\u0430\u043d\u043d\u044b\u0435 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u044b, \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0442. \u041f\u043e\u043d\u044f\u0442\u0438\u0435 PRIMARY KEY, FOREIGN KEY, UNIQUE, COMPOSITE, SUPERKEY \u0438 \u0434\u0440\u0443\u0433\u0438\u0435 \u043e\u0442\u0440\u0430\u0431\u043e\u0442\u0430\u043d\u044b \u043d\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0435.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0438<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>w3schools: https:\/\/www.w3schools.com\/sql\/sql_primarykey.asp<\/li>\n\n\n\n<li>Habr: https:\/\/habr.com\/ru\/companies\/oleg-bunin\/articles\/348172\/<\/li>\n\n\n\n<li>\u041f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 \u0438 \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447: 9 \u0432\u0430\u0436\u043d\u044b\u0445 \u043e\u0442\u043b\u0438\u0447\u0438\u0439: https:\/\/www.astera.com\/ru\/type\/blog\/primary-key-vs-foreign-key\/<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud83d\udd11 \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0442\u0438\u043f\u044b \u043a\u043b\u044e\u0447\u0435\u0439 \u041a\u043b\u044e\u0447 (\u043d\u0430 \u0430\u043d\u0433\u043b.) \u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043d\u0430 \u0440\u0443\u0441\u0441\u043a\u043e\u043c \u041f\u0440\u043e\u0441\u0442\u043e\u0435 \u043e\u0431\u044a\u044f\u0441\u043d\u0435\u043d\u0438\u0435 \u2014 \u0437\u0430\u0447\u0435\u043c \u043e\u043d \u043d\u0443\u0436\u0435\u043d Primary Key \u041f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 \u042d\u0442\u043e \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0437\u0430\u043f\u0438\u0441\u0438. \u041e\u043d \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u0435\u043d \u0438 \u0443\u043d\u0438\u043a\u0430\u043b\u0435\u043d. \u0411\u0435\u0437 \u043d\u0435\u0433\u043e \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u043f\u043e\u0440\u044f\u0434\u043a\u0430 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435. Foreign Key \u0412\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447 \u0421\u0432\u044f\u0437\u044b\u0432\u0430\u0435\u0442 \u043e\u0434\u043d\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0441 \u0434\u0440\u0443\u0433\u043e\u0439. \u041f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 SQL \u043f\u043e\u043d\u044f\u0442\u044c, \u0433\u0434\u0435 \u0441\u0432\u044f\u0437\u044c \u043c\u0435\u0436\u0434\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0441\u0442\u0443\u0434\u0435\u043d\u0442 \u0438 \u0435\u0433\u043e &#8230; <a title=\"Andmebaasiv\u00f5tmed\" class=\"read-more\" href=\"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790\" aria-label=\"Read more about Andmebaasiv\u00f5tmed\">Read more<\/a><\/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-790","page","type-page","status-publish"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Andmebaasiv\u00f5tmed - Gleb Dranitsyn \/ 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:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Andmebaasiv\u00f5tmed - Gleb Dranitsyn \/ Portfolio\" \/>\n<meta property=\"og:description\" content=\"\ud83d\udd11 \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0442\u0438\u043f\u044b \u043a\u043b\u044e\u0447\u0435\u0439 \u041a\u043b\u044e\u0447 (\u043d\u0430 \u0430\u043d\u0433\u043b.) \u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043d\u0430 \u0440\u0443\u0441\u0441\u043a\u043e\u043c \u041f\u0440\u043e\u0441\u0442\u043e\u0435 \u043e\u0431\u044a\u044f\u0441\u043d\u0435\u043d\u0438\u0435 \u2014 \u0437\u0430\u0447\u0435\u043c \u043e\u043d \u043d\u0443\u0436\u0435\u043d Primary Key \u041f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 \u042d\u0442\u043e \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0437\u0430\u043f\u0438\u0441\u0438. \u041e\u043d \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u0435\u043d \u0438 \u0443\u043d\u0438\u043a\u0430\u043b\u0435\u043d. \u0411\u0435\u0437 \u043d\u0435\u0433\u043e \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u043f\u043e\u0440\u044f\u0434\u043a\u0430 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435. Foreign Key \u0412\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447 \u0421\u0432\u044f\u0437\u044b\u0432\u0430\u0435\u0442 \u043e\u0434\u043d\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0441 \u0434\u0440\u0443\u0433\u043e\u0439. \u041f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 SQL \u043f\u043e\u043d\u044f\u0442\u044c, \u0433\u0434\u0435 \u0441\u0432\u044f\u0437\u044c \u043c\u0435\u0436\u0434\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0441\u0442\u0443\u0434\u0435\u043d\u0442 \u0438 \u0435\u0433\u043e ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790\" \/>\n<meta property=\"og:site_name\" content=\"Gleb Dranitsyn \/ Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-13T06:48:33+00:00\" \/>\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:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=790\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=790\",\"name\":\"Andmebaasiv\u00f5tmed - Gleb Dranitsyn \\\/ Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#website\"},\"datePublished\":\"2025-05-10T08:17:00+00:00\",\"dateModified\":\"2025-05-13T06:48:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=790#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=790\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=790#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Andmebaasiv\u00f5tmed\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/\",\"name\":\"Gleb Dranitsyn \\\/ Portfolio\",\"description\":\"Tarkvara aarendaja\",\"publisher\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#organization\",\"name\":\"Gleb Dranitsyn \\\/ Portfolio\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-cropped-logo1.jpg\",\"contentUrl\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-cropped-logo1.jpg\",\"width\":400,\"height\":171,\"caption\":\"Gleb Dranitsyn \\\/ Portfolio\"},\"image\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Andmebaasiv\u00f5tmed - Gleb Dranitsyn \/ 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:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790","og_locale":"et_EE","og_type":"article","og_title":"Andmebaasiv\u00f5tmed - Gleb Dranitsyn \/ Portfolio","og_description":"\ud83d\udd11 \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0442\u0438\u043f\u044b \u043a\u043b\u044e\u0447\u0435\u0439 \u041a\u043b\u044e\u0447 (\u043d\u0430 \u0430\u043d\u0433\u043b.) \u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043d\u0430 \u0440\u0443\u0441\u0441\u043a\u043e\u043c \u041f\u0440\u043e\u0441\u0442\u043e\u0435 \u043e\u0431\u044a\u044f\u0441\u043d\u0435\u043d\u0438\u0435 \u2014 \u0437\u0430\u0447\u0435\u043c \u043e\u043d \u043d\u0443\u0436\u0435\u043d Primary Key \u041f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 \u042d\u0442\u043e \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0437\u0430\u043f\u0438\u0441\u0438. \u041e\u043d \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u0435\u043d \u0438 \u0443\u043d\u0438\u043a\u0430\u043b\u0435\u043d. \u0411\u0435\u0437 \u043d\u0435\u0433\u043e \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u043f\u043e\u0440\u044f\u0434\u043a\u0430 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435. Foreign Key \u0412\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447 \u0421\u0432\u044f\u0437\u044b\u0432\u0430\u0435\u0442 \u043e\u0434\u043d\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0441 \u0434\u0440\u0443\u0433\u043e\u0439. \u041f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 SQL \u043f\u043e\u043d\u044f\u0442\u044c, \u0433\u0434\u0435 \u0441\u0432\u044f\u0437\u044c \u043c\u0435\u0436\u0434\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0441\u0442\u0443\u0434\u0435\u043d\u0442 \u0438 \u0435\u0433\u043e ... Read more","og_url":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790","og_site_name":"Gleb Dranitsyn \/ Portfolio","article_modified_time":"2025-05-13T06:48:33+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790","name":"Andmebaasiv\u00f5tmed - Gleb Dranitsyn \/ Portfolio","isPartOf":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#website"},"datePublished":"2025-05-10T08:17:00+00:00","dateModified":"2025-05-13T06:48:33+00:00","breadcrumb":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=790#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/glebdranitson24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"Andmebaasiv\u00f5tmed"}]},{"@type":"WebSite","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#website","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/","name":"Gleb Dranitsyn \/ Portfolio","description":"Tarkvara aarendaja","publisher":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/glebdranitson24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":"Organization","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#organization","name":"Gleb Dranitsyn \/ Portfolio","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/","logo":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#\/schema\/logo\/image\/","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/cropped-cropped-logo1.jpg","contentUrl":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/cropped-cropped-logo1.jpg","width":400,"height":171,"caption":"Gleb Dranitsyn \/ Portfolio"},"image":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=790"}],"version-history":[{"count":8,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/790\/revisions"}],"predecessor-version":[{"id":814,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/790\/revisions\/814"}],"wp:attachment":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}