{"id":1564,"date":"2025-03-14T12:29:14","date_gmt":"2025-03-14T12:29:14","guid":{"rendered":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564"},"modified":"2025-03-28T11:44:37","modified_gmt":"2025-03-28T11:44:37","slug":"mobiilirakendus-projekteerimine","status":"publish","type":"page","link":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564","title":{"rendered":"Mobiilirakendus projekteerimine"},"content":{"rendered":"\n<p><strong>USE case Skeem:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"581\" src=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3-1024x581.png\" alt=\"\" class=\"wp-image-1593\" srcset=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3-1024x581.png 1024w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3-300x170.png 300w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3-768x436.png 768w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3-624x354.png 624w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3.png 1327w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Kommentaarid:<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Administraator:<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Avab toodete valiku liidese<\/strong> \u2013 v\u00f5imaldab sirvida ja hallata tooteid s\u00fcsteemis.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Kasutaja:<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Valib soovitud funktsioonid<\/strong> \u2013 kasutaja saab otsustada, mida ta rakenduses teha soovib.<\/li>\n<\/ul>\n\n\n\n<p><strong>PROTOT\u00dc\u00dcPI Skeemid:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"1024\" src=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem1-768x1024.jpg\" alt=\"\" class=\"wp-image-1571\" srcset=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem1-768x1024.jpg 768w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem1-225x300.jpg 225w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem1-624x832.jpg 624w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem1-300x400.jpg 300w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem1.jpg 960w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem2.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"1024\" src=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem2-768x1024.jpg\" alt=\"\" class=\"wp-image-1572\" srcset=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem2-768x1024.jpg 768w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem2-225x300.jpg 225w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem2-624x832.jpg 624w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem2-300x400.jpg 300w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/skeem2.jpg 960w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Kirjeldus:<\/strong><\/p>\n\n\n\n<p>Tahaksin teha oma rakenduse, kus saab skaneerida v\u00f6\u00f6tkoode ja vaadata, kus see toode on odavam. Seal on v\u00f5imalus lisada tooteid lemmikute hulka. Administraator saab lisada v\u00f5i kustutada poode, et kui \u00fches poes sellist toodet pole, siis ei ole vaja seda poodi n\u00e4idata.<\/p>\n\n\n\n<p><strong>Tegevusskeem:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-13.png\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"772\" src=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-13.png\" alt=\"\" class=\"wp-image-1646\" srcset=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-13.png 800w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-13-300x290.png 300w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-13-768x741.png 768w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-13-624x602.png 624w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/figure>\n\n\n\n<p><strong>SQL Skeem ja kood (v\u00f5ib muutuda):<\/strong><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-8.png\"><img loading=\"lazy\" decoding=\"async\" width=\"760\" height=\"476\" src=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-8.png\" alt=\"\" class=\"wp-image-1630\" srcset=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-8.png 760w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-8-300x188.png 300w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-8-624x391.png 624w\" sizes=\"auto, (max-width: 760px) 100vw, 760px\" \/><\/a><\/figure>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"create database testst\ngo \n\nuse testst\ngo\n\nCREATE TABLE Users (\n    user_id INT IDENTITY(1,1) PRIMARY KEY,\n    username VARCHAR(50) NOT NULL UNIQUE,\n    password_hash NVARCHAR(MAX) NOT NULL,\n    role VARCHAR(10) NOT NULL CHECK (role IN ('admin', 'client'))\n);\n\nCREATE TABLE Products (\n    product_id INT IDENTITY(1,1) PRIMARY KEY,\n    name VARCHAR(100) NOT NULL,\n    description TEXT,\n    barcode VARCHAR(50) UNIQUE NOT NULL\n);\n\nCREATE TABLE Prices (\n    price_id INT IDENTITY(1,1) PRIMARY KEY,\n    product_id INT NOT NULL,\n    price DECIMAL(10,2) NOT NULL,\n    store VARCHAR(100) NOT NULL,\n    last_updated DATETIME DEFAULT GETDATE(),\n    FOREIGN KEY (product_id) REFERENCES Products(product_id) ON DELETE CASCADE\n);\n\nCREATE TABLE Favorites (\n    favorite_id INT IDENTITY(1,1) PRIMARY KEY,\n    user_id INT NOT NULL,\n    product_id INT NOT NULL,\n    added_on DATETIME DEFAULT GETDATE(),\n    FOREIGN KEY (user_id) REFERENCES Users(user_id) ON DELETE CASCADE,\n    FOREIGN KEY (product_id) REFERENCES Products(product_id) ON DELETE CASCADE\n);\n\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">create<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">database<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">testst<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">go<\/span><span style=\"color: #D8DEE9FF\"> <\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">use<\/span><span style=\"color: #D8DEE9FF\"> testst<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">go<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Users<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    user_id <\/span><span style=\"color: #81A1C1\">INT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">IDENTITY<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">,<\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #81A1C1\">PRIMARY KEY<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    username <\/span><span style=\"color: #81A1C1\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">50<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #81A1C1\">NOT NULL<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">UNIQUE<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    password_hash <\/span><span style=\"color: #81A1C1\">NVARCHAR<\/span><span style=\"color: #D8DEE9FF\">(MAX) <\/span><span style=\"color: #81A1C1\">NOT NULL<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">role<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">10<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #81A1C1\">NOT NULL<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">CHECK<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #81A1C1\">role<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">IN<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">admin<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">client<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">))<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Products<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    product_id <\/span><span style=\"color: #81A1C1\">INT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">IDENTITY<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">,<\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #81A1C1\">PRIMARY KEY<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">name<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #81A1C1\">NOT NULL<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">description<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TEXT<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    barcode <\/span><span style=\"color: #81A1C1\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">50<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #81A1C1\">UNIQUE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">NOT NULL<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Prices<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    price_id <\/span><span style=\"color: #81A1C1\">INT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">IDENTITY<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">,<\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #81A1C1\">PRIMARY KEY<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    product_id <\/span><span style=\"color: #81A1C1\">INT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">NOT NULL<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    price <\/span><span style=\"color: #81A1C1\">DECIMAL<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">10<\/span><span style=\"color: #D8DEE9FF\">,<\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #81A1C1\">NOT NULL<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    store <\/span><span style=\"color: #81A1C1\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #81A1C1\">NOT NULL<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    last_updated <\/span><span style=\"color: #81A1C1\">DATETIME<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">DEFAULT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">GETDATE<\/span><span style=\"color: #D8DEE9FF\">(),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">FOREIGN KEY<\/span><span style=\"color: #D8DEE9FF\"> (product_id) <\/span><span style=\"color: #81A1C1\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> Products(product_id) <\/span><span style=\"color: #81A1C1\">ON DELETE CASCADE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Favorites<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    favorite_id <\/span><span style=\"color: #81A1C1\">INT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">IDENTITY<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">,<\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #81A1C1\">PRIMARY KEY<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    user_id <\/span><span style=\"color: #81A1C1\">INT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">NOT NULL<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    product_id <\/span><span style=\"color: #81A1C1\">INT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">NOT NULL<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    added_on <\/span><span style=\"color: #81A1C1\">DATETIME<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">DEFAULT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">GETDATE<\/span><span style=\"color: #D8DEE9FF\">(),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">FOREIGN KEY<\/span><span style=\"color: #D8DEE9FF\"> (user_id) <\/span><span style=\"color: #81A1C1\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> Users(user_id) <\/span><span style=\"color: #81A1C1\">ON DELETE CASCADE<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">FOREIGN KEY<\/span><span style=\"color: #D8DEE9FF\"> (product_id) <\/span><span style=\"color: #81A1C1\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> Products(product_id) <\/span><span style=\"color: #81A1C1\">ON DELETE CASCADE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<p>&nbsp;<strong>UML skeem (oma valik)<\/strong>:<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"963\" height=\"669\" src=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-11.png\" alt=\"\" class=\"wp-image-1637\" srcset=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-11.png 963w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-11-300x208.png 300w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-11-768x534.png 768w, https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-11-624x433.png 624w\" sizes=\"auto, (max-width: 963px) 100vw, 963px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>USE case Skeem: Kommentaarid: Administraator: Kasutaja: PROTOT\u00dc\u00dcPI Skeemid: Kirjeldus: Tahaksin teha oma rakenduse, kus saab skaneerida v\u00f6\u00f6tkoode ja vaadata, kus see toode on odavam. Seal on v\u00f5imalus lisada tooteid lemmikute hulka. Administraator saab lisada v\u00f5i kustutada poode, et kui \u00fches poes sellist toodet pole, siis ei ole vaja seda poodi n\u00e4idata. Tegevusskeem: SQL Skeem ja [&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-1564","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Mobiilirakendus projekteerimine - Kirill Sats &otilde;pimapp | 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:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mobiilirakendus projekteerimine - Kirill Sats &otilde;pimapp | portfoolio\" \/>\n<meta property=\"og:description\" content=\"USE case Skeem: Kommentaarid: Administraator: Kasutaja: PROTOT\u00dc\u00dcPI Skeemid: Kirjeldus: Tahaksin teha oma rakenduse, kus saab skaneerida v\u00f6\u00f6tkoode ja vaadata, kus see toode on odavam. Seal on v\u00f5imalus lisada tooteid lemmikute hulka. Administraator saab lisada v\u00f5i kustutada poode, et kui \u00fches poes sellist toodet pole, siis ei ole vaja seda poodi n\u00e4idata. Tegevusskeem: SQL Skeem ja [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564\" \/>\n<meta property=\"og:site_name\" content=\"Kirill Sats &otilde;pimapp | portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-28T11:44:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1327\" \/>\n\t<meta property=\"og:image:height\" content=\"753\" \/>\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:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=1564\",\"url\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=1564\",\"name\":\"Mobiilirakendus projekteerimine - Kirill Sats &otilde;pimapp | portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=1564#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=1564#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/pilt-3-1024x581.png\",\"datePublished\":\"2025-03-14T12:29:14+00:00\",\"dateModified\":\"2025-03-28T11:44:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=1564#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=1564\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=1564#primaryimage\",\"url\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/pilt-3.png\",\"contentUrl\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/pilt-3.png\",\"width\":1327,\"height\":753},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=1564#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mobiilirakendus projekteerimine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/\",\"name\":\"Kirill Sats &otilde;pimapp | portfoolio\",\"description\":\"Noorem Tarkvaarendaja eriala\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kirillsats23.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":"Mobiilirakendus projekteerimine - Kirill Sats &otilde;pimapp | 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:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564","og_locale":"et_EE","og_type":"article","og_title":"Mobiilirakendus projekteerimine - Kirill Sats &otilde;pimapp | portfoolio","og_description":"USE case Skeem: Kommentaarid: Administraator: Kasutaja: PROTOT\u00dc\u00dcPI Skeemid: Kirjeldus: Tahaksin teha oma rakenduse, kus saab skaneerida v\u00f6\u00f6tkoode ja vaadata, kus see toode on odavam. Seal on v\u00f5imalus lisada tooteid lemmikute hulka. Administraator saab lisada v\u00f5i kustutada poode, et kui \u00fches poes sellist toodet pole, siis ei ole vaja seda poodi n\u00e4idata. Tegevusskeem: SQL Skeem ja [&hellip;]","og_url":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564","og_site_name":"Kirill Sats &otilde;pimapp | portfoolio","article_modified_time":"2025-03-28T11:44:37+00:00","og_image":[{"width":1327,"height":753,"url":"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3.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:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564","url":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564","name":"Mobiilirakendus projekteerimine - Kirill Sats &otilde;pimapp | portfoolio","isPartOf":{"@id":"https:\/\/kirillsats23.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564#primaryimage"},"image":{"@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564#primaryimage"},"thumbnailUrl":"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3-1024x581.png","datePublished":"2025-03-14T12:29:14+00:00","dateModified":"2025-03-28T11:44:37+00:00","breadcrumb":{"@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564#primaryimage","url":"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3.png","contentUrl":"https:\/\/kirillsats23.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/pilt-3.png","width":1327,"height":753},{"@type":"BreadcrumbList","@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=1564#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kirillsats23.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"Mobiilirakendus projekteerimine"}]},{"@type":"WebSite","@id":"https:\/\/kirillsats23.thkit.ee\/wp\/#website","url":"https:\/\/kirillsats23.thkit.ee\/wp\/","name":"Kirill Sats &otilde;pimapp | portfoolio","description":"Noorem Tarkvaarendaja eriala","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kirillsats23.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/1564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1564"}],"version-history":[{"count":26,"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/1564\/revisions"}],"predecessor-version":[{"id":1647,"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/1564\/revisions\/1647"}],"wp:attachment":[{"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}