friends_and_foes

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id MEDIUMINT UNSIGNED 8 null
login.id friends_and_foes_user_login_id_fk R
subject_id MEDIUMINT UNSIGNED 8 null
login.id friends_and_foes_subject_login_id_fk R
status enum('FRIEND', 'FOE') 6 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc user_id + subject_id
friends_and_foes_subject_login_id_fk Performance Asc subject_id

Relationships

Close relationships within degrees of separation