|
V2 /
FriendsV2.Friends HistoryHide minor edits - Show changes to output Changed line 26 from:
* friend_date : When the friend link became active to:
* friend_date : When the friend link became active or changed state Added line 3:
!!Tenets Changed lines 10-11 from:
Table to:
!!Table schema Added lines 21-30:
* friend_rid : The source of the friends link. * friend_friendrid : the 'target' of the friends link. "This person is a friend of friend_rid..." * friend_requestkey : When a friend request is generated, this is the md5 key request used in the email link * friend_requestdate : When the friend request was generated * friend_date : When the friend link became active. * friend_status : OK, INACTIVE, PENDING ** OK - the link is enabled ** PENDING - Waiting for a pending invite to be acknowledged ** INACTIVE - A friends link has been disabled ('un-friended') Added lines 1-20:
'Friends' is a mechanism within CONGO to link one registrant to another. There are a couple basic tenets. * A friend link must be 'approved' before going active. A registrant cannot Friend another registrant and see their status until the target registrant approves it. * Friend links are one-way. If registrant A friends registrant B, B will be able to see A's status, but until B friends A, B's status will be hidden from A. * A registrant always has the option of 'un-friending' another registrant. * Friends lists may be maintained by administrators in order to facillitate groups / families / etc. Table structure mysql> describe reg_friends ; +-------------------+--------------+------+-----+---------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------------------+-----------------------------+ | friend_rid | int(8) | NO | PRI | NULL | | | friend_friendrid | int(8) | YES | | NULL | | | friend_requestkey | varchar(255) | YES | | NULL | | | frind_requestdate | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | friend_date | timestamp | NO | | 0000-00-00 00:00:00 | | +-------------------+--------------+------+-----+---------------------+-----------------------------+ |