PK userId
username
email
passwordHash
creationDate
role
PK profileId
bio
profilePictureUrl
lastActive
FK userId
PK postId
content
timestamp
PK commentId
text
FK postId
PK photoId
imageUrl
caption
UserId (FK)
FollowedUserId (FK)
PostId (FK)
by apexa
