Sprint 2 Logical View Class Diagrams - Fatima-Essa/Wits-Social-SDP GitHub Wiki

In the below class diagram it can be seen that for out User table we have allocated a unique userID per user which is stored as a record with the users username, email, full name, as well as a list of all users followed by the account and following the account. Furthermore, this Users table is then linked to 2 other tables via the userID.

The 2 tables being for bio, posts and profile pictures. The Bio table stored the default bio as well as links it to the user allowing for future implementation of changing the bio. The Posts table stored all the data required for a user post as well as its relevant interactions. It store the images uri, the caption, the amount of likes and all comments on a specific post.