In today's video, we'll take a break from all of the coding to look at how I've modeled out our entities in the database. I'll try to go over my thought process for each of the properties I've included in the FeedItem model.
Table users {
id int[pk]
fullName string
emailAddress string
profileImageUrl string
}
Table posts {
id int[pk]
text string
imageUrl string
userId int
}
Ref: posts.userId > users.id
Table feedItems {
id int
userId int
postId int
postOwnerId int
postCreatedAt timestamp
}
Ref: feedItems.userId > users.id
Ref: feedItems.postId > posts.id
Ref: feedItems.postOwnerId > users.id