[Database Design] Confirmation on database design for my website.

[Database Design] Confirmation on database design for my website.

[Database Design] Confirmation on database design for my website.

I am creating a database for a social networking website for “gamers”. There are users who can choose from multiple games and the games will have platforms (like PS, Xbox, Desktop) to choose from. Users can also leave a comment and rating on another users profile (Users allowed to leave multiple). The database design is shown below:

‚Äč

https://preview.redd.it/7s7miimyrvi61.png?width=739&format=png&auto=webp&s=de8192f5800a935a77351cccb775d9054a40b7f3

I also was thinking of adding a chat feature, am I right to assume that it will require another table? Although, that will be once I have achieved the current requirements.

Also, in terms of analytics (graphs showing specific info) would it be smart to add details into the User or Profile table and make graphs out of them?

Just want advice on this design as I want to get this to be 100% right before I start the coding process. Any help would be appreciated, thank you!

submitted by /u/Slayed7
[link] [comments]


Go to Source of this post
Author Of this post: /u/Slayed7
Title Of post: [Database Design] Confirmation on database design for my website.
Author Link: {authorlink}