{"id":801,"date":"2023-02-16T11:07:20","date_gmt":"2023-02-16T09:07:20","guid":{"rendered":"https:\/\/aleksrogovskii.wordpress.com\/?p=801"},"modified":"2023-02-16T11:07:20","modified_gmt":"2023-02-16T09:07:20","slug":"sql-ulesanded-ab-aviafirma","status":"publish","type":"post","link":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/","title":{"rendered":"SQL \u00fclesanded: AB Aviafirma"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nCREATE TABLE Company(\nID_comp int PRIMARY KEY AUTO_INCREMENT,\nname char(10)\n);\nCREATE TABLE Trip (\ntrip_no int primary key auto_increment,\nID_comp int,\nFOREIGN KEY (ID_comp) REFERENCES company(ID_comp),\nplane char(10),\ntown_from char(25),\ntown_to char(25),\ntime_out datetime,\ntime_in datetime\n)\n<\/pre><\/div>\n\n\n<p>Nelja tabeli loomine<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nCREATE TABLE Passenger(\nID_psg int PRIMARY key AUTO_INCREMENT,\nname char(20)\n);\nCREATE TABLE Pass_in_trip(\ntrip_no int,\nFOREIGN KEY (trip_no) REFERENCES Trip(trip_no),\ndate_ datetime,\nID_psg int,\nFOREIGN KEY (ID_psg) REFERENCES Passenger(ID_psg),\nplace char(10),\nprimary key (trip_no, date_, ID_psg)\n);\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nINSERT INTO passenger(name) VALUES (&quot;Dmitri&quot;);\nINSERT INTO passenger(name) VALUES (&quot;Darja&quot;);\nINSERT INTO passenger(name) VALUES (&quot;Aleksander&quot;);\nINSERT INTO passenger(name) VALUES (&quot;Nikita&quot;);\nINSERT INTO passenger(name) VALUES (&quot;Josef&quot;);\n<\/pre><\/div>\n\n\n<p>Lisasin nimekirjed passengeri nimekirjadesse<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nINSERT INTO Company(name) VALUES (&quot;AirGo&quot;);\nINSERT INTO Company(name) VALUES (&quot;BalticAir&quot;);\nINSERT INTO Company(name) VALUES (&quot;SwedenPlanes&quot;);\nINSERT INTO Company(name) VALUES (&quot;PlaneGo&quot;);\nINSERT INTO Company(name) VALUES (&quot;EuropaAirLines&quot;);\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nINSERT INTO trip(plane, town_from, town_to, time_out, time_in) VALUES (&quot;Douglas B-18 Bolo&quot;, &quot;Tallinn&quot;, &quot;Berlin&quot;,  &quot;2023-3-13 10:30:00&quot;, &quot;2023-3-13 14:30:00&quot;);\nINSERT INTO trip(plane, town_from, town_to, time_out, time_in) VALUES (&quot;F-35&quot;, &quot;Washington&quot;, &quot;Baghdad&quot;,  &quot;2023-3-13 17:30:00&quot;, &quot;2023-3-13 23:00:00&quot;);\nINSERT INTO trip(plane, town_from, town_to, time_out, time_in) VALUES (&quot;Airbus 535&quot;, &quot;Moscow&quot;, &quot;Pekin&quot;,  &quot;2023-3-20 8:10:00&quot;, &quot;2023-3-20 16:00:00&quot;);\nINSERT INTO trip(plane, town_from, town_to, time_out, time_in) VALUES (&quot;Boeing 777&quot;, &quot;Stockholm&quot;, &quot;Berlin&quot;,  &quot;2023-4-2 5:30:00&quot;, &quot;2023-4-2 8:45:00&quot;);\nINSERT INTO trip(plane, town_from, town_to, time_out, time_in) VALUES (&quot;Ilju\u0161in Il-76&quot;, &quot;Magadan&quot;, &quot;Tokio&quot;,  &quot;2023-5-5 12:10:00&quot;, &quot;2023-5-5 16:00:00&quot;);\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nINSERT INTO pass_in_trip(place, date_,trip_no, ID_psg) VALUES (&quot;35F&quot;, &quot;2023-5-5 12:10:00&quot;, 2, 2);\nINSERT INTO pass_in_trip(place, date_,trip_no, ID_psg) VALUES (&quot;1F&quot;, &quot;2023-03-13 10:30:00&quot;, 1, 1);\nINSERT INTO pass_in_trip(place, date_,trip_no, ID_psg) VALUES (&quot;5F&quot;, &quot;2023-03-20 08:10:00&quot;, 3, 3);\nINSERT INTO pass_in_trip(place, date_,trip_no, ID_psg) VALUES (&quot;6F&quot;, &quot;2023-04-02 05:30:00&quot;, 4, 4);\nINSERT INTO pass_in_trip(place, date_,trip_no, ID_psg) VALUES (&quot;44B&quot;, &quot;2023-05-05 12:10:00&quot;, 5, 5);\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Nelja tabeli loomine Lisasin nimekirjed passengeri nimekirjadesse<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-801","post","type-post","status-publish","format-standard","hentry","category-andme-baasid"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL \u00fclesanded: AB Aviafirma - Aleksander Rogovski 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:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL \u00fclesanded: AB Aviafirma - Aleksander Rogovski portfoolio\" \/>\n<meta property=\"og:description\" content=\"Nelja tabeli loomine Lisasin nimekirjed passengeri nimekirjadesse\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/\" \/>\n<meta property=\"og:site_name\" content=\"Aleksander Rogovski portfoolio\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-16T09:07:20+00:00\" \/>\n<meta name=\"author\" content=\"aleksanderrogovski\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"aleksanderrogovski\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/blog\\\/2023\\\/02\\\/16\\\/sql-ulesanded-ab-aviafirma\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/blog\\\/2023\\\/02\\\/16\\\/sql-ulesanded-ab-aviafirma\\\/\"},\"author\":{\"name\":\"aleksanderrogovski\",\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/48bdc680aabc2f8304817e7c25ced88d\"},\"headline\":\"SQL \u00fclesanded: AB Aviafirma\",\"datePublished\":\"2023-02-16T09:07:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/blog\\\/2023\\\/02\\\/16\\\/sql-ulesanded-ab-aviafirma\\\/\"},\"wordCount\":11,\"commentCount\":0,\"articleSection\":[\"Andme baasid\"],\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/blog\\\/2023\\\/02\\\/16\\\/sql-ulesanded-ab-aviafirma\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/blog\\\/2023\\\/02\\\/16\\\/sql-ulesanded-ab-aviafirma\\\/\",\"url\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/blog\\\/2023\\\/02\\\/16\\\/sql-ulesanded-ab-aviafirma\\\/\",\"name\":\"SQL \u00fclesanded: AB Aviafirma - Aleksander Rogovski portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/#website\"},\"datePublished\":\"2023-02-16T09:07:20+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/48bdc680aabc2f8304817e7c25ced88d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/blog\\\/2023\\\/02\\\/16\\\/sql-ulesanded-ab-aviafirma\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/blog\\\/2023\\\/02\\\/16\\\/sql-ulesanded-ab-aviafirma\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/blog\\\/2023\\\/02\\\/16\\\/sql-ulesanded-ab-aviafirma\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL \u00fclesanded: AB Aviafirma\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/\",\"name\":\"Aleksander Rogovski portfoolio\",\"description\":\"Noorem tarkvaraarendaja\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/48bdc680aabc2f8304817e7c25ced88d\",\"name\":\"aleksanderrogovski\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/39b6653814e8a7036a20701db337b6ab9ea066ece5b8e52871e18d411b422522?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/39b6653814e8a7036a20701db337b6ab9ea066ece5b8e52871e18d411b422522?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/39b6653814e8a7036a20701db337b6ab9ea066ece5b8e52871e18d411b422522?s=96&d=mm&r=g\",\"caption\":\"aleksanderrogovski\"},\"url\":\"https:\\\/\\\/aleksanderrogovski22.thkit.ee\\\/wp\\\/blog\\\/author\\\/aleksanderrogovski\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL \u00fclesanded: AB Aviafirma - Aleksander Rogovski 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:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/","og_locale":"et_EE","og_type":"article","og_title":"SQL \u00fclesanded: AB Aviafirma - Aleksander Rogovski portfoolio","og_description":"Nelja tabeli loomine Lisasin nimekirjed passengeri nimekirjadesse","og_url":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/","og_site_name":"Aleksander Rogovski portfoolio","article_published_time":"2023-02-16T09:07:20+00:00","author":"aleksanderrogovski","twitter_card":"summary_large_image","twitter_misc":{"Written by":"aleksanderrogovski","Est. reading time":"2 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/#article","isPartOf":{"@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/"},"author":{"name":"aleksanderrogovski","@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/#\/schema\/person\/48bdc680aabc2f8304817e7c25ced88d"},"headline":"SQL \u00fclesanded: AB Aviafirma","datePublished":"2023-02-16T09:07:20+00:00","mainEntityOfPage":{"@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/"},"wordCount":11,"commentCount":0,"articleSection":["Andme baasid"],"inLanguage":"et","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/","url":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/","name":"SQL \u00fclesanded: AB Aviafirma - Aleksander Rogovski portfoolio","isPartOf":{"@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/#website"},"datePublished":"2023-02-16T09:07:20+00:00","author":{"@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/#\/schema\/person\/48bdc680aabc2f8304817e7c25ced88d"},"breadcrumb":{"@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/2023\/02\/16\/sql-ulesanded-ab-aviafirma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"SQL \u00fclesanded: AB Aviafirma"}]},{"@type":"WebSite","@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/#website","url":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/","name":"Aleksander Rogovski portfoolio","description":"Noorem tarkvaraarendaja","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":"Person","@id":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/#\/schema\/person\/48bdc680aabc2f8304817e7c25ced88d","name":"aleksanderrogovski","image":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/secure.gravatar.com\/avatar\/39b6653814e8a7036a20701db337b6ab9ea066ece5b8e52871e18d411b422522?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/39b6653814e8a7036a20701db337b6ab9ea066ece5b8e52871e18d411b422522?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/39b6653814e8a7036a20701db337b6ab9ea066ece5b8e52871e18d411b422522?s=96&d=mm&r=g","caption":"aleksanderrogovski"},"url":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/blog\/author\/aleksanderrogovski\/"}]}},"_links":{"self":[{"href":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/wp-json\/wp\/v2\/posts\/801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=801"}],"version-history":[{"count":0,"href":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/wp-json\/wp\/v2\/posts\/801\/revisions"}],"wp:attachment":[{"href":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/wp-json\/wp\/v2\/categories?post=801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aleksanderrogovski22.thkit.ee\/wp\/wp-json\/wp\/v2\/tags?post=801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}