block

19 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
createdOn DATETIME 19 current_timestamp()
blockerId BIGINT 19 null
user.id block_blockerId_user_id_fk R
blockingId BIGINT 19 null
user.id block_blockingId_user_id_fk R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
block_blockerId_blockingId_unique_index Must be unique Asc/Asc blockerId + blockingId
block_blockerId_index Performance Asc blockerId
block_blockingId_index Performance Asc blockingId

Relationships

Close relationships within degrees of separation