flag

22 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 flag_postId_post_id_fk R
commentId BIGINT 19 √ NULL
comment.id flag_commentId_comment_id_fk R
userId BIGINT 19 √ NULL
user.id flag_userId_user_id_fk R
messageId BIGINT 19 √ NULL
message.id flag_messageId_message_id_fk R
otherReasonText VARCHAR 500 √ NULL
reporterId BIGINT 19 null
user.id flag_reporterId_user_id_fk R
reason VARCHAR 100 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
flag_commentId_index Performance Asc commentId
flag_commentId_reporterId_unique_index Must be unique Asc/Asc commentId + reporterId
flag_messageId_index Performance Asc messageId
flag_messageId_reporterId_unique_index Must be unique Asc/Asc messageId + reporterId
flag_postId_index Performance Asc postId
flag_postId_reporterId_unique_index Must be unique Asc/Asc postId + reporterId
flag_reporterId_index Performance Asc reporterId
flag_reporterId_userId_unique_index Must be unique Asc/Asc reporterId + userId
flag_userId_index Performance Asc userId

Relationships

Close relationships within degrees of separation