doc/database/db_contact-relation.md

   1 Table contact-relation
   2 ===========
   3
   4 Contact relations
   5
   6 Fields
   7 ------
   8
   9 | Field            | Description                                         | Type         | Null | Key | Default             | Extra |
  10 | ---------------- | --------------------------------------------------- | ------------ | ---- | --- | ------------------- | ----- |
  11 | cid              | contact the related contact had interacted with     | int unsigned | NO   | PRI | 0                   |       |
  12 | relation-cid     | related contact who had interacted with the contact | int unsigned | NO   | PRI | 0                   |       |
  13 | last-interaction | Date of the last interaction                        | datetime     | NO   |     | 0001-01-01 00:00:00 |       |
  14 | follow-updated   | Date of the last update of the contact relationship | datetime     | NO   |     | 0001-01-01 00:00:00 |       |
  15 | follows          |                                                     | boolean      | NO   |     | 0                   |       |
  16
  17 Indexes
  18 ------------
  19
  20 | Name         | Fields            |
  21 | ------------ | ----------------- |
  22 | PRIMARY      | cid, relation-cid |
  23 | relation-cid | relation-cid      |
  24
  25 Foreign Keys
  26 ------------
  27
  28 | Field | Target Table | Target Field |
  29 |-------|--------------|--------------|
  30 | cid | [contact](help/database/db_contact) | id |
  31 | relation-cid | [contact](help/database/db_contact) | id |
  32
  33 Return to [database documentation](help/database)