doc/database/db_post-question.md

   1 Table post-question
   2 ===========
   3
   4 Question
   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 | uri-id   | Id of the item-uri table entry that contains the item uri | int unsigned | NO   |     | NULL                |                |
  13 | multiple | Multiple choice                                           | boolean      | NO   |     | 0                   |                |
  14 | voters   | Number of voters for this question                        | int unsigned | YES  |     | NULL                |                |
  15 | end-time | Question end time                                         | datetime     | YES  |     | 0001-01-01 00:00:00 |                |
  16
  17 Indexes
  18 ------------
  19
  20 | Name    | Fields         |
  21 | ------- | -------------- |
  22 | PRIMARY | id             |
  23 | uri-id  | UNIQUE, uri-id |
  24
  25 Foreign Keys
  26 ------------
  27
  28 | Field | Target Table | Target Field |
  29 |-------|--------------|--------------|
  30 | uri-id | [item-uri](help/database/db_item-uri) | id |
  31
  32 Return to [database documentation](help/database)