fan

402 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
createdOn DATETIME 19 current_timestamp()
followerId BIGINT 19 null
user.id fan_followerId_user_id_fk R
followingId BIGINT 19 null
user.id fan_followingId_user_id_fk R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fan_followerId_followingId_unique_index Must be unique Asc/Asc followerId + followingId
fan_followerId_index Performance Asc followerId
fan_followingId_index Performance Asc followingId

Relationships

Close relationships within degrees of separation