doc/database/db_group_member.md

   1 Table group_member
   2 ===========
   3
   4 privacy groups, member info
   5
   6 Fields
   7 ------
   8
   9 | Field      | Description                                               | Type         | Null | Key | Default | Extra          |
  10 | ---------- | --------------------------------------------------------- | ------------ | ---- | --- | ------- | -------------- |
  11 | id         | sequential ID                                             | int unsigned | NO   | PRI | NULL    | auto_increment |
  12 | gid        | groups.id of the associated group                         | int unsigned | NO   |     | 0       |                |
  13 | contact-id | contact.id of the member assigned to the associated group | int unsigned | NO   |     | 0       |                |
  14
  15 Indexes
  16 ------------
  17
  18 | Name          | Fields                  |
  19 | ------------- | ----------------------- |
  20 | PRIMARY       | id                      |
  21 | contactid     | contact-id              |
  22 | gid_contactid | UNIQUE, gid, contact-id |
  23
  24 Foreign Keys
  25 ------------
  26
  27 | Field | Target Table | Target Field |
  28 |-------|--------------|--------------|
  29 | gid | [group](help/database/db_group) | id |
  30 | contact-id | [contact](help/database/db_contact) | id |
  31
  32 Return to [database documentation](help/database)