{"id":552,"date":"2024-11-21T10:03:53","date_gmt":"2024-11-21T10:03:53","guid":{"rendered":"https:\/\/marilunatei24.thkit.ee\/wp\/?page_id=552"},"modified":"2025-04-17T14:17:03","modified_gmt":"2025-04-17T14:17:03","slug":"database-diagram","status":"publish","type":"page","link":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/","title":{"rendered":"Database Diagram"},"content":{"rendered":"\n

A Database Diagram is a visual representation that shows how the tables in a database are related to each other.<\/strong> It helps to better understand the structure of the database and the relationships between different tables. For example, you can see which tables are connected and how data flows between them. It is a useful tool for planning and maintaining a database.<\/p>\n\n\n\n\n \n \n \n \n \n \n \n \n
Database Schema Designs<\/th>\n Andmebaasiskeemi kujundid<\/th>\n \u042d\u043b\u0435\u043c\u0435\u043d\u0442\u044b \u0434\u0438\u0437\u0430\u0439\u043d\u0430 \u0441\u0445\u0435\u043c\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445<\/th>\n <\/tr>\n <\/thead>\n
Table<\/strong>
A rectangle representing a data table with rows and columns.<\/td>\n 		Tabel<\/strong>
Ristk\u00fclik, mis esindab andmetabelit koos ridade ja veergudega.<\/td>\n 		\u0422\u0430\u0431\u043b\u0438\u0446\u0430<\/strong>
\u041f\u0440\u044f\u043c\u043e\u0443\u0433\u043e\u043b\u044c\u043d\u0438\u043a, \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0441 \u0441\u0442\u0440\u043e\u043a\u0430\u043c\u0438 \u0438 \u0441\u0442\u043e\u043b\u0431\u0446\u0430\u043c\u0438.<\/td>\n <\/tr>\n
Key<\/strong>
Primary Key \/ Foreign Key<\/td>\n 		V\u00f5ti<\/strong>
Esmane v\u00f5ti \/ V\u00f5\u00f5rv\u00f5ti<\/td>\n 		\u041a\u043b\u044e\u0447<\/strong>
\u041f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 \/ \u0412\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447<\/td>\n <\/tr>\n
Field<\/strong>
An element inside a table that holds a specific data type.<\/td>\n 		V\u00e4li<\/strong>
Tabeli sees olev element, mis hoiab konkreetset andmet\u00fc\u00fcpi.<\/td>\n 		\u041f\u043e\u043b\u0435<\/strong>
\u042d\u043b\u0435\u043c\u0435\u043d\u0442 \u0432\u043d\u0443\u0442\u0440\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u044b\u0439 \u0442\u0438\u043f \u0434\u0430\u043d\u043d\u044b\u0445.<\/td>\n <\/tr>\n
Relationship<\/strong>
Shows how tables are connected to each other.<\/td>\n 		Seos<\/strong>
N\u00e4itab, kuidas tabelid on omavahel seotud.<\/td>\n 		\u0421\u0432\u044f\u0437\u044c<\/strong>
\u041f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442, \u043a\u0430\u043a \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0441\u0432\u044f\u0437\u0430\u043d\u044b \u043c\u0435\u0436\u0434\u0443 \u0441\u043e\u0431\u043e\u0439.<\/td>\n <\/tr>\n
Index<\/strong>
Shows additional symbols pointing to tables for faster searching.<\/td>\n 		Indeks<\/strong>
N\u00e4idatakse t\u00e4iendavate s\u00fcmbolitega, mis osutavad tabelitele kiirema otsingu v\u00f5imaldamiseks.<\/td>\n 		\u0418\u043d\u0434\u0435\u043a\u0441<\/strong>
\u041f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0441\u0438\u043c\u0432\u043e\u043b\u044b, \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u044e\u0449\u0438\u0435 \u043d\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0434\u043b\u044f \u0443\u0441\u043a\u043e\u0440\u0435\u043d\u0438\u044f \u043f\u043e\u0438\u0441\u043a\u0430.<\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n\n\n\n

How to add shapes on the Licidchart<\/a> website<\/strong>:<\/strong><\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

How to generate SQL code for creating a database using Lucidchart:<\/strong><\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Create a database using Microsoft SQL Server Management Studio<\/h3>\n\n\n\n\n \n \n \n \n \n \n \n \n \n
Vajuta<\/th>\n New Query<\/th>\n <\/tr>\n <\/thead>\n
Sisestage<\/td>\n \n CREATE DATABASE PRODUCTION_OF_WINDOW_BLINDS;\n <\/td>\n <\/tr>\n
Vajuta<\/td>\n Execute<\/td>\n <\/tr>\n
Sisestage<\/td>\n \n USE PRODUCTION_OF_WINDOW_BLINDS;\n <\/td>\n <\/tr>\n
Kopaeri<\/td>\n \n Lucidehart-iga genererritud kaod\n <\/td>\n <\/tr>\n
Select<\/td>\n \n K\u0101ik kaod peale “CREATE DATABASE PRODUCTION_OF_WINDOW_BLINDS;”\n <\/td>\n <\/tr>\n
Vajuta<\/td>\n Execute<\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Lucidchart tutorial video: Creating diagrams<\/h3>\n\n\n\n


Link 1<\/a>, 2<\/a><\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

A Database Diagram is a visual representation that shows how the tables in a database are related to each other. It helps to better understand the structure of the database and the relationships between different tables. For example, you can see which tables are connected and how data flows between them. It is a useful […]<\/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-552","page","type-page","status-publish","hentry"],"blocksy_meta":[],"yoast_head":"\nDatabase Diagram - Mari L Tei 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:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Diagram - Mari L Tei Portfolio\" \/>\n<meta property=\"og:description\" content=\"A Database Diagram is a visual representation that shows how the tables in a database are related to each other. It helps to better understand the structure of the database and the relationships between different tables. For example, you can see which tables are connected and how data flows between them. It is a useful […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/\" \/>\n<meta property=\"og:site_name\" content=\"Mari L Tei Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-17T14:17:03+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/database-diagram\\\/\",\"url\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/database-diagram\\\/\",\"name\":\"Database Diagram - Mari L Tei Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/database-diagram\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/database-diagram\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/Screenshot-2024-11-21-160124-1024x559.png\",\"datePublished\":\"2024-11-21T10:03:53+00:00\",\"dateModified\":\"2025-04-17T14:17:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/database-diagram\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/database-diagram\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/database-diagram\\\/#primaryimage\",\"url\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/Screenshot-2024-11-21-160124-1024x559.png\",\"contentUrl\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/Screenshot-2024-11-21-160124-1024x559.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/database-diagram\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Diagram\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Mari L Tei Portfolio\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/marilunatei24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Diagram - Mari L Tei 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:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/","og_locale":"en_US","og_type":"article","og_title":"Database Diagram - Mari L Tei Portfolio","og_description":"A Database Diagram is a visual representation that shows how the tables in a database are related to each other. It helps to better understand the structure of the database and the relationships between different tables. For example, you can see which tables are connected and how data flows between them. It is a useful […]","og_url":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/","og_site_name":"Mari L Tei Portfolio","article_modified_time":"2025-04-17T14:17:03+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/","url":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/","name":"Database Diagram - Mari L Tei Portfolio","isPartOf":{"@id":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/#primaryimage"},"image":{"@id":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/#primaryimage"},"thumbnailUrl":"https:\/\/marilunatei24.thkit.ee\/wp\/wp-content\/uploads\/2024\/11\/Screenshot-2024-11-21-160124-1024x559.png","datePublished":"2024-11-21T10:03:53+00:00","dateModified":"2025-04-17T14:17:03+00:00","breadcrumb":{"@id":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/#primaryimage","url":"https:\/\/marilunatei24.thkit.ee\/wp\/wp-content\/uploads\/2024\/11\/Screenshot-2024-11-21-160124-1024x559.png","contentUrl":"https:\/\/marilunatei24.thkit.ee\/wp\/wp-content\/uploads\/2024\/11\/Screenshot-2024-11-21-160124-1024x559.png"},{"@type":"BreadcrumbList","@id":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/database-diagram\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"Database Diagram"}]},{"@type":"WebSite","@id":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/","name":"Mari L Tei Portfolio","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=552"}],"version-history":[{"count":1,"href":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/552\/revisions"}],"predecessor-version":[{"id":1240,"href":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/552\/revisions\/1240"}],"wp:attachment":[{"href":"https:\/\/marilunatei24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}