Table contact-relation
Contact relations
Fields
| Field |
Description |
Type |
Null |
Key |
Default |
Extra |
| cid |
contact the related contact had interacted with |
int unsigned |
NO |
PRI |
0 |
|
| relation-cid |
related contact who had interacted with the contact |
int unsigned |
NO |
PRI |
0 |
|
| last-interaction |
Date of the last interaction by relation-cid on cid |
datetime |
NO |
|
0001-01-01 00:00:00 |
|
| follow-updated |
Date of the last update of the contact relationship |
datetime |
NO |
|
0001-01-01 00:00:00 |
|
| follows |
if true, relation-cid follows cid |
boolean |
NO |
|
0 |
|
| score |
score for interactions of cid on relation-cid |
smallint unsigned |
YES |
|
NULL |
|
| relation-score |
score for interactions of relation-cid on cid |
smallint unsigned |
YES |
|
NULL |
|
| thread-score |
score for interactions of cid on threads of relation-cid |
smallint unsigned |
YES |
|
NULL |
|
| relation-thread-score |
score for interactions of relation-cid on threads of cid |
smallint unsigned |
YES |
|
NULL |
|
| post-score |
score for the amount of posts from cid that can be seen by relation-cid |
smallint unsigned |
YES |
|
NULL |
|
Indexes
| Name |
Fields |
| PRIMARY |
cid, relation-cid |
| relation-cid |
relation-cid |
Foreign Keys
| Field |
Target Table |
Target Field |
| cid |
contact |
id |
| relation-cid |
contact |
id |
Return to database documentation
Lo, thar be cookies on this site to keep track of your login. By clicking 'okay', you are CONSENTING to this.