4 | Field |Description | Type | Null | Key | Default | Extra |
5 |--------------|------------------------------------|------------------|------|-----|---------------------|----------------|
6 | id | sequential ID | int(10) unsigned | NO | PRI | NULL | auto_increment |
7 | name | Name that this contact is known by | varchar(255) | NO | | | |
8 | nick | Nick- and user name of the contact | varchar(255) | NO | | | |
9 | url | Link to the contacts profile page | varchar(255) | NO | | | |
10 | nurl | | varchar(255) | NO | MUL | | |
11 | photo | Link to the profile photo | varchar(255) | NO | | | |
12 | connect | | varchar(255) | NO | | | |
13 | created | | datetime | NO | | 0000-00-00 00:00:00 | |
14 | updated | | datetime | YES | MUL | 0000-00-00 00:00:00 | |
15 | last_contact | | datetime | YES | | 0000-00-00 00:00:00 | |
16 | last_failure | | datetime | YES | | 0000-00-00 00:00:00 | |
17 | location | | varchar(255) | NO | | | |
18 | about | | text | NO | | NULL | |
19 | keywords | puplic keywords (interests) | text | NO | | NULL | |
20 | gender | | varchar(32) | NO | | | |
21 | birthday | | varchar(32) | NO | | 0000-00-00 | |
22 | community | 1 if contact is forum account | tinyint(1) | NO | | 0 | |
23 | hide | 1 = should be hidden from search | tinyint(1) | NO | | 0 | |
24 | nsfw | 1 = contact posts nsfw content | tinyint(1) | NO | | 0 | |
25 | network | social network protocol | varchar(255) | NO | | | |
26 | addr | | varchar(255) | NO | | | |
27 | notify | | text | NO | | | |
28 | alias | | varchar(255) | NO | | | |
29 | generation | | tinyint(3) | NO | | 0 | |
30 | server_url | baseurl of the contacts server | varchar(255) | NO | | | |
32 Return to [database documentation](help/database)