doc/database/db_post-collection.md

   1 Table post-collection
   2 ===========
   3
   4 Collection of posts
   5
   6 Fields
   7 ------
   8
   9 | Field  | Description                                               | Type             | Null | Key | Default | Extra |
  10 | ------ | --------------------------------------------------------- | ---------------- | ---- | --- | ------- | ----- |
  11 | uri-id | Id of the item-uri table entry that contains the item uri | int unsigned     | NO   | PRI | NULL    |       |
  12 | type   | 0 - Featured                                              | tinyint unsigned | NO   | PRI | 0       |       |
  13
  14 Indexes
  15 ------------
  16
  17 | Name    | Fields       |
  18 | ------- | ------------ |
  19 | PRIMARY | uri-id, type |
  20 | type    | type         |
  21
  22 Foreign Keys
  23 ------------
  24
  25 | Field | Target Table | Target Field |
  26 |-------|--------------|--------------|
  27 | uri-id | [item-uri](help/database/db_item-uri) | id |
  28
  29 Return to [database documentation](help/database)