{"id":1109,"date":"2026-02-06T17:32:30","date_gmt":"2026-02-06T17:32:30","guid":{"rendered":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/?p=1109"},"modified":"2026-02-06T17:32:31","modified_gmt":"2026-02-06T17:32:31","slug":"week-4-database-schema-ready","status":"publish","type":"post","link":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/2026\/02\/06\/week-4-database-schema-ready\/","title":{"rendered":"WEEK 4: DATABASE SCHEMA READY"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"768\" src=\"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-content\/uploads\/sites\/243\/2026\/02\/IMG_4414-1-1024x768.jpg\" alt=\"\" class=\"wp-image-1117\" style=\"width:622px;height:auto\" srcset=\"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-content\/uploads\/sites\/243\/2026\/02\/IMG_4414-1-1024x768.jpg 1024w, https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-content\/uploads\/sites\/243\/2026\/02\/IMG_4414-1-300x225.jpg 300w, https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-content\/uploads\/sites\/243\/2026\/02\/IMG_4414-1-768x576.jpg 768w, https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-content\/uploads\/sites\/243\/2026\/02\/IMG_4414-1-1536x1152.jpg 1536w, https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-content\/uploads\/sites\/243\/2026\/02\/IMG_4414-1-2048x1536.jpg 2048w, https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-content\/uploads\/sites\/243\/2026\/02\/IMG_4414-1-280x210.jpg 280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>This week we focused on one of the first tasks in our backlog, the database schema! First, we created an ER diagram to organize the schema. Then, over a long team meeting, we went over each planned table and attribute to ensure they not only made sense, but were the most efficient solution. Going over the schema also solidified the workflow for parts of the application. Next, we are going to create the tables in our SQL Server instance in preparation for backend development.<\/p>\n\n\n\n<p>We also started discussing our plan for the FDR, a multi-volume paper due at the end of our project. We created a detailed outline for each volume, which includes all headings and subheadings. By starting our planning now, there will be less confusion when it comes time to start writing, and we can hit the ground running. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>This week we focused on one of the first tasks in our backlog, the database schema! First, we created an ER diagram to organize the schema. Then, over a long team meeting, we went over each planned table and attribute&hellip; <a href=\"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/2026\/02\/06\/week-4-database-schema-ready\/\" aria-label=\"Read \\\"WEEK 4: DATABASE SCHEMA READY\\\" class=\"read-more\">Read&nbsp;More<\/a><\/p>\n","protected":false},"author":939,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[12],"tags":[],"class_list":["post-1109","post","type-post","status-publish","format-standard","hentry","category-springsemester"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-json\/wp\/v2\/posts\/1109"}],"collection":[{"href":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-json\/wp\/v2\/users\/939"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-json\/wp\/v2\/comments?post=1109"}],"version-history":[{"count":4,"href":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-json\/wp\/v2\/posts\/1109\/revisions"}],"predecessor-version":[{"id":1119,"href":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-json\/wp\/v2\/posts\/1109\/revisions\/1119"}],"wp:attachment":[{"href":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-json\/wp\/v2\/media?parent=1109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-json\/wp\/v2\/categories?post=1109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ippd.ufl.edu\/blogs\/ay2526team20\/wp-json\/wp\/v2\/tags?post=1109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}