doc/database/db_gcontact.md

   1 Table gcontact
   2 ==============
   3
   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   |     | 0001-01-01 00:00:00 |                |
  14 | updated      |                                    | datetime         | YES  | MUL | 0001-01-01 00:00:00 |                |
  15 | last_contact |                                    | datetime         | YES  |     | 0001-01-01 00:00:00 |                |
  16 | last_failure |                                    | datetime         | YES  |     | 0001-01-01 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   |     | 0001-01-01          |                |
  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   |     |                     |                |
  31
  32 Return to [database documentation](help/database)