doc/database/db_group.md

   1 Table group
   2 ===========
   3
   4 privacy groups, group 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 | uid     | Owner User id                              | mediumint unsigned | NO   |     | 0       |                |
  13 | visible | 1 indicates the member list is not private | boolean            | NO   |     | 0       |                |
  14 | deleted | 1 indicates the group has been deleted     | boolean            | NO   |     | 0       |                |
  15 | name    | human readable name of group               | varchar(255)       | NO   |     |         |                |
  16
  17 Indexes
  18 ------------
  19
  20 | Name    | Fields |
  21 | ------- | ------ |
  22 | PRIMARY | id     |
  23 | uid     | uid    |
  24
  25 Foreign Keys
  26 ------------
  27
  28 | Field | Target Table | Target Field |
  29 |-------|--------------|--------------|
  30 | uid | [user](help/database/db_user) | uid |
  31
  32 Return to [database documentation](help/database)