{"id":404,"date":"2014-11-01T11:36:12","date_gmt":"2014-11-01T15:36:12","guid":{"rendered":"http:\/\/blog.scad.edu\/ascarb21\/?p=404"},"modified":"2014-11-01T11:36:12","modified_gmt":"2014-11-01T15:36:12","slug":"db-design-for-troll-me-a-story","status":"publish","type":"post","link":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/2014\/11\/01\/db-design-for-troll-me-a-story\/","title":{"rendered":"DB design for Troll-Me-A-Story"},"content":{"rendered":"<div id=\"attachment_405\" style=\"width: 570px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-content\/uploads\/2014\/11\/tmasDBdesign.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-405\" class=\"size-large wp-image-405\" src=\"http:\/\/blog.scad.edu\/ascarb21\/files\/2014\/11\/tmasDBdesign-692x1024.png\" alt=\"Troll-Me-A-Story DB design\" width=\"560\" height=\"828\" srcset=\"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-content\/uploads\/2014\/11\/tmasDBdesign-692x1024.png 692w, https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-content\/uploads\/2014\/11\/tmasDBdesign-203x300.png 203w, https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-content\/uploads\/2014\/11\/tmasDBdesign-768x1136.png 768w, https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-content\/uploads\/2014\/11\/tmasDBdesign.png 910w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/a><p id=\"caption-attachment-405\" class=\"wp-caption-text\">Troll-Me-A-Story DB design<\/p><\/div>\n<p>So here is the database design for the MySQL database of the project. I had to rework it from the original design which was one large table. What is diagrammed above is the various tables and their relationships to one another. I reached out to my coworker at work who is one of the top eight in the US that knows DB design inside and out. He was able to help me understand how to design DB much better.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So here is the database design for the MySQL database of the project. I had to rework it from the original design which was one large table. What is diagrammed above is the various tables and their relationships to one&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/2014\/11\/01\/db-design-for-troll-me-a-story\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,17],"tags":[],"class_list":["post-404","post","type-post","status-publish","format-standard","hentry","category-continued","category-design-continued","category-prototype-continued"],"_links":{"self":[{"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/posts\/404","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/comments?post=404"}],"version-history":[{"count":0,"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/posts\/404\/revisions"}],"wp:attachment":[{"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/media?parent=404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/categories?post=404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itgm-thesis.aliciascarborough.com\/blog\/wp-json\/wp\/v2\/tags?post=404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}