savedPost

26 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
createdOn DATETIME 19 current_timestamp()
postId BIGINT 19 null
post.id savedPost_postId_post_id_fk R
userId BIGINT 19 null
user.id savedPost_userId_user_id_fk R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
savedPost_postId_index Performance Asc postId
savedPost_postId_userId_unique_index Must be unique Asc/Asc postId + userId
savedPost_userId_index Performance Asc userId

Relationships

Close relationships within degrees of separation