Table diaspora-contact
Diaspora compatible contacts - used in the Diaspora implementation
Fields
Field | Description | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|---|
uri-id | Id of the item-uri table entry that contains the contact URL | int unsigned | NO | PRI | NULL | |
addr | varchar(255) | YES | NULL | |||
alias | varchar(255) | YES | NULL | |||
nick | varchar(255) | YES | NULL | |||
name | varchar(255) | YES | NULL | |||
given-name | varchar(255) | YES | NULL | |||
family-name | varchar(255) | YES | NULL | |||
photo | varchar(255) | YES | NULL | |||
photo-medium | varchar(255) | YES | NULL | |||
photo-small | varchar(255) | YES | NULL | |||
batch | varchar(255) | YES | NULL | |||
notify | varchar(255) | YES | NULL | |||
poll | varchar(255) | YES | NULL | |||
subscribe | varchar(255) | YES | NULL | |||
searchable | boolean | YES | NULL | |||
pubkey | text | YES | NULL | |||
gsid | Global Server ID | int unsigned | YES | NULL | ||
created | datetime | NO | 0001-01-01 00:00:00 | |||
updated | datetime | NO | 0001-01-01 00:00:00 | |||
interacting_count | Number of contacts this contact interacts with | int unsigned | YES | 0 | ||
interacted_count | Number of contacts that interacted with this contact | int unsigned | YES | 0 | ||
post_count | Number of posts and comments | int unsigned | YES | 0 |
Indexes
Name | Fields |
---|---|
PRIMARY | uri-id |
addr | UNIQUE, addr |
alias | alias |
gsid | gsid |
Foreign Keys
Field | Target Table | Target Field |
---|---|---|
uri-id | item-uri | id |
gsid | gserver | id |
Return to database documentation
This website is tracked using the Matomo analytics tool. If you do not want that your visits are logged in this way you can set a cookie to prevent Matomo / Piwik from tracking further visits of the site (opt-out).