(original) Attention, fan relationship database design

Mainly on the first three fields, and of course 4 fields

from_user_id to_user_id Mutual Powder Status both_status (Rel_type)
A b YES a focus on b,a become a fan of B (also need to add 1 in the statistics)
b A YES B concerned about a A a fan (also need to add 1 in the statistics, need to detect, a is not already concerned about B, if already concerned, then modify the status of two records is YES, to indicate the mutual powder)
A C NO
D A NO

Query a fan, with to_user_id, through the return of the Both_status, to determine whether a is a one-way, or two-way relationship
Query a two-way fan, to_user_id, status (YES)

Concern:
I am concerned about who: FROM_USER_ID is my id, query can

Fans:
This page shows my fans: people follow my
Use to_user_id, my ID, to query can

(original) Attention, fan relationship database design