{"id":190,"date":"2020-04-28T08:03:07","date_gmt":"2020-04-28T05:03:07","guid":{"rendered":"http:\/\/blog.gunlerveisler.gen.tr\/?p=190"},"modified":"2020-09-21T05:06:27","modified_gmt":"2020-09-21T02:06:27","slug":"a-new-project-technical-sales-service-and-stock-tracking-system","status":"publish","type":"post","link":"https:\/\/aliyargunes.com.tr\/blog\/a-new-project-technical-sales-service-and-stock-tracking-system\/","title":{"rendered":"Some Sql Notes"},"content":{"rendered":"\n<p>In these quarentine days I&#8217;am getting some progress in sql. I nearly completed the database design, but still there is some standardization issues that I&#8217;am working on it. It be use by any small scale technology companies for storing and managing technical sales, stock tracking, client info and technical service records. Mysql forces me a lot because of its relational structure but it is fine, I&#8217;am learning and practicing lots of things, such as constraints, views, procedures, triggers and functions. The finishing can take one day more, I attached current enhanced entity-relationship diagram of it. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/aliyargunes.com.tr\/blog\/wp-content\/uploads\/2020\/04\/technicalServiceAndSalesLogDB.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"572\" src=\"https:\/\/aliyargunes.com.tr\/blog\/wp-content\/uploads\/2020\/04\/technicalServiceAndSalesLogDB-1024x572.png\" alt=\"\" class=\"wp-image-533\" srcset=\"https:\/\/aliyargunes.com.tr\/blog\/wp-content\/uploads\/2020\/04\/technicalServiceAndSalesLogDB-1024x572.png 1024w, https:\/\/aliyargunes.com.tr\/blog\/wp-content\/uploads\/2020\/04\/technicalServiceAndSalesLogDB-300x168.png 300w, https:\/\/aliyargunes.com.tr\/blog\/wp-content\/uploads\/2020\/04\/technicalServiceAndSalesLogDB-768x429.png 768w, https:\/\/aliyargunes.com.tr\/blog\/wp-content\/uploads\/2020\/04\/technicalServiceAndSalesLogDB-1536x858.png 1536w, https:\/\/aliyargunes.com.tr\/blog\/wp-content\/uploads\/2020\/04\/technicalServiceAndSalesLogDB-2048x1144.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>EER Diagram of The Database<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In these quarentine days I&#8217;am getting some progress in sql. I nearly completed the database design, but still there is some standardization issues that I&#8217;am working on it. It be use by any small scale technology companies for storing and &hellip; <a href=\"https:\/\/aliyargunes.com.tr\/blog\/a-new-project-technical-sales-service-and-stock-tracking-system\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,7],"tags":[24,43],"class_list":["post-190","post","type-post","status-publish","format-standard","hentry","category-projects","category-techlog","tag-database-design","tag-mysql"],"_links":{"self":[{"href":"https:\/\/aliyargunes.com.tr\/blog\/wp-json\/wp\/v2\/posts\/190"}],"collection":[{"href":"https:\/\/aliyargunes.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aliyargunes.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aliyargunes.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aliyargunes.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=190"}],"version-history":[{"count":5,"href":"https:\/\/aliyargunes.com.tr\/blog\/wp-json\/wp\/v2\/posts\/190\/revisions"}],"predecessor-version":[{"id":582,"href":"https:\/\/aliyargunes.com.tr\/blog\/wp-json\/wp\/v2\/posts\/190\/revisions\/582"}],"wp:attachment":[{"href":"https:\/\/aliyargunes.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aliyargunes.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aliyargunes.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}