doc/database/db_post-content.md

   1 Table post-content
   2 ===========
   3
   4 Content for all 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 | title           | item title                                                                                                                | varchar(255) | NO   |     |         |       |
  13 | content-warning |                                                                                                                           | varchar(255) | NO   |     |         |       |
  14 | body            | item body content                                                                                                         | mediumtext   | YES  |     | NULL    |       |
  15 | raw-body        | Body without embedded media links                                                                                         | mediumtext   | YES  |     | NULL    |       |
  16 | location        | text location where this item originated                                                                                  | varchar(255) | NO   |     |         |       |
  17 | coord           | longitude/latitude pair representing location where this item originated                                                  | varchar(255) | NO   |     |         |       |
  18 | language        | Language information about this post                                                                                      | text         | YES  |     | NULL    |       |
  19 | app             | application which generated this item                                                                                     | varchar(255) | NO   |     |         |       |
  20 | rendered-hash   |                                                                                                                           | varchar(32)  | NO   |     |         |       |
  21 | rendered-html   | item.body converted to html                                                                                               | mediumtext   | YES  |     | NULL    |       |
  22 | object-type     | ActivityStreams object type                                                                                               | varchar(100) | NO   |     |         |       |
  23 | object          | JSON encoded object structure unless it is an implied object (normal post)                                                | text         | YES  |     | NULL    |       |
  24 | target-type     | ActivityStreams target type if applicable (URI)                                                                           | varchar(100) | NO   |     |         |       |
  25 | target          | JSON encoded target structure if used                                                                                     | text         | YES  |     | NULL    |       |
  26 | resource-id     | Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type | varchar(32)  | NO   |     |         |       |
  27 | plink           | permalink or URL to a displayable copy of the message at its source                                                       | varchar(255) | NO   |     |         |       |
  28
  29 Indexes
  30 ------------
  31
  32 | Name | Fields |
  33 |------|---------|
  34 | PRIMARY | uri-id |
  35 | plink | plink(191) |
  36 | resource-id | resource-id |
  37 | title-content-warning-body | FULLTEXT, title, content-warning, body |
  38
  39 Foreign Keys
  40 ------------
  41
  42 | Field | Target Table | Target Field |
  43 |-------|--------------|--------------|
  44 | uri-id | [item-uri](help/database/db_item-uri) | id |
  45
  46 Return to [database documentation](help/database)