doc/database/db_report.md

   1 Table report
   2 ===========
   3
   4
   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             | Reporting user                                               | mediumint unsigned | YES  |     | NULL                |                |
  13 | reporter-id     | Reporting contact                                            | int unsigned       | YES  |     | NULL                |                |
  14 | cid             | Reported contact                                             | int unsigned       | NO   |     | NULL                |                |
  15 | gsid            | Reported contact server                                      | int unsigned       | NO   |     | NULL                |                |
  16 | comment         | Report                                                       | text               | YES  |     | NULL                |                |
  17 | category-id     | Report category, one of Entity\Report::CATEGORY_*            | int unsigned       | NO   |     | 1                   |                |
  18 | forward         | Forward the report to the remote server                      | boolean            | YES  |     | NULL                |                |
  19 | public-remarks  | Remarks shared with the reporter                             | text               | YES  |     | NULL                |                |
  20 | private-remarks | Remarks shared with the moderation team                      | text               | YES  |     | NULL                |                |
  21 | last-editor-uid | Last editor user                                             | mediumint unsigned | YES  |     | NULL                |                |
  22 | assigned-uid    | Assigned moderator user                                      | mediumint unsigned | YES  |     | NULL                |                |
  23 | status          | Status of the report, one of Entity\Report::STATUS_*         | tinyint unsigned   | NO   |     | NULL                |                |
  24 | resolution      | Resolution of the report, one of Entity\Report::RESOLUTION_* | tinyint unsigned   | YES  |     | NULL                |                |
  25 | created         |                                                              | datetime(6)        | NO   |     | 0001-01-01 00:00:00 |                |
  26 | edited          | Last time the report has been edited                         | datetime(6)        | YES  |     | NULL                |                |
  27
  28 Indexes
  29 ------------
  30
  31 | Name              | Fields             |
  32 | ----------------- | ------------------ |
  33 | PRIMARY           | id                 |
  34 | uid               | uid                |
  35 | cid               | cid                |
  36 | reporter-id       | reporter-id        |
  37 | gsid              | gsid               |
  38 | assigned-uid      | assigned-uid       |
  39 | status-resolution | status, resolution |
  40 | created           | created            |
  41 | edited            | edited             |
  42
  43 Foreign Keys
  44 ------------
  45
  46 | Field | Target Table | Target Field |
  47 |-------|--------------|--------------|
  48 | uid | [user](help/database/db_user) | uid |
  49 | reporter-id | [contact](help/database/db_contact) | id |
  50 | cid | [contact](help/database/db_contact) | id |
  51 | gsid | [gserver](help/database/db_gserver) | id |
  52 | last-editor-uid | [user](help/database/db_user) | uid |
  53 | assigned-uid | [user](help/database/db_user) | uid |
  54
  55 Return to [database documentation](help/database)