4 Diaspora compatible contacts - used in the Diaspora implementation
9 | Field | Description | Type | Null | Key | Default | Extra |
10 | ----------------- | ------------------------------------------------------------ | ------------ | ---- | --- | ------------------- | ----- |
11 | uri-id | Id of the item-uri table entry that contains the contact URL | int unsigned | NO | PRI | NULL | |
12 | addr | | varchar(255) | YES | | NULL | |
13 | alias | | varchar(255) | YES | | NULL | |
14 | nick | | varchar(255) | YES | | NULL | |
15 | name | | varchar(255) | YES | | NULL | |
16 | given-name | | varchar(255) | YES | | NULL | |
17 | family-name | | varchar(255) | YES | | NULL | |
18 | photo | | varchar(255) | YES | | NULL | |
19 | photo-medium | | varchar(255) | YES | | NULL | |
20 | photo-small | | varchar(255) | YES | | NULL | |
21 | batch | | varchar(255) | YES | | NULL | |
22 | notify | | varchar(255) | YES | | NULL | |
23 | poll | | varchar(255) | YES | | NULL | |
24 | subscribe | | varchar(255) | YES | | NULL | |
25 | searchable | | boolean | YES | | NULL | |
26 | pubkey | | text | YES | | NULL | |
27 | gsid | Global Server ID | int unsigned | YES | | NULL | |
28 | created | | datetime | NO | | 0001-01-01 00:00:00 | |
29 | updated | | datetime | NO | | 0001-01-01 00:00:00 | |
30 | interacting_count | Number of contacts this contact interactes with | int unsigned | YES | | 0 | |
31 | interacted_count | Number of contacts that interacted with this contact | int unsigned | YES | | 0 | |
32 | post_count | Number of posts and comments | int unsigned | YES | | 0 | |
38 | ------- | ------------ |
40 | addr | UNIQUE, addr |
47 | Field | Target Table | Target Field |
48 |-------|--------------|--------------|
49 | uri-id | [item-uri](help/database/db_item-uri) | id |
50 | gsid | [gserver](help/database/db_gserver) | id |
52 Return to [database documentation](help/database)