post

306 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
comment.postId comment_postId_post_id_fk R
disableNotification.postId disableNotification_postId_post_id_fk R
flag.postId flag_postId_post_id_fk R
highlight.postId highlight_postId_post_id_fk R
likedPost.postId likedPost_postId_post_id_fk R
post.sharedPostId post_sharedPostId_post_id_fk R
savedPost.postId savedPost_postId_post_id_fk R
tip.postId tip_postId_post_id_fk R
createdOn DATETIME 19 current_timestamp()
modifiedOn DATETIME 19 current_timestamp()
creatorId BIGINT 19 null
user.id post_creatorId_user_id_fk R
sharedPostId BIGINT 19 √ NULL
post.id post_sharedPostId_post_id_fk R
likeCount INT 10 0
shareCount INT 10 0
caption VARCHAR 255 null
isCommentingEnabled BOOLEAN 3 null
isDeleted BOOLEAN 3 0
commentCount INT 10 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
post_caption_index Performance Asc caption
post_creatorId_index Performance Asc creatorId
post_sharedPostId_index Performance Asc sharedPostId

Relationships

Close relationships within degrees of separation