Checkpoint 1 Ready for Review

[jbrischke]

@pawaitemadisoncollege

Instead of a database design diagram I just typed in and linked the raw SQL to the diagram link. Its a start ill update the tables and add stuff to it as I go. It has been quite awhile since I last created my own data objects to use in a application so this is going to be fun to do.

[pawaitemadisoncollege]

@jbrischke

• [ ] Check it out! IntelliJ can produce those db diagrams for you: https://www.jetbrains.com/help/idea/creating-diagrams.html
• [ ] Project plan needs some detail yet for each week in the semester: https://github.com/jbrischke/RatingsAnonymous/blob/main/ProjectPlan.md.
• [ ] Screen design/wireframes are part of Checkpoint 1. Can you point me to those?

[jbrischke]

@pawaitemadisoncollege

Resubmission fixed those issues

[pawaitemadisoncollege]

• [ ] With the database design - will the user have an association to games and/or reports? The diagram doesn't represent this, if so.
• [ ] The link on the readme to Database Design would be better if it linked to the diagram - pictures may be easier for most folks to understand rather than the actual sql.
• [ ] Can you point me to the screen design, if there is one? Note that it is not meaningful to create this at this point if it doesn't already exist.

[jbrischke]

@pawaitemadisoncollege

Resubmission

Added the wireframes for future models that will be added once I finally figure out how to get the proper data back from my other tables. I updated the database diagram and I am probably going to go with something like shown unless yet again I realize I wrote the join wrong. I don't have any plans to ever update any information in the database table role, I prepopulated it with a few roleids and roletypes. I am trying to Pass a roles set to my page to render out the type and prepopulate a dropdown menu with 1, 2, 3 as options and based on the role_id submitted it then returns the type associated with that ID.

[pawaitemadisoncollege]

Looks good, thanks @jbrischke