doc/database/db_intro.md

   1 Table intro
   2 ===========
   3
   4 | Field      | Description      | Type             | Null | Key | Default             | Extra          |
   5 |------------|------------------|------------------|------|-----|---------------------|----------------|
   6 | id         | sequential ID    | int(10) unsigned | NO   | PRI | NULL                | auto_increment |
   7 | uid        |                  | int(10) unsigned | NO   |     | 0                   |                |
   8 | fid        |                  | int(11)          | NO   |     | 0                   |                |
   9 | contact-id |                  | int(11)          | NO   |     | 0                   |                |
  10 | knowyou    |                  | tinyint(1)       | NO   |     | 0                   |                |
  11 | duplex     |                  | tinyint(1)       | NO   |     | 0                   |                |
  12 | note       |                  | text             | NO   |     | NULL                |                |
  13 | hash       |                  | varchar(255)     | NO   |     |                     |                |
  14 | datetime   |                  | datetime         | NO   |     | 0001-01-01 00:00:00 |                |
  15 | blocked    |                  | tinyint(1)       | NO   |     | 1                   |                |
  16 | ignore     |                  | tinyint(1)       | NO   |     | 0                   |                |
  17
  18 Return to [database documentation](help/database)