]> git.mxchange.org Git - friendica.git/blob - doc/database/db_post-content.md
HTML-escape notification contact names
[friendica.git] / 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 | quote-uri-id    | Id of the item-uri table that contains the quoted uri                                                                     | int unsigned   | YES  |     | NULL    |       |
17 | location        | text location where this item originated                                                                                  | varchar(255)   | NO   |     |         |       |
18 | coord           | longitude/latitude pair representing location where this item originated                                                  | varchar(255)   | NO   |     |         |       |
19 | language        | Language information about this post                                                                                      | text           | YES  |     | NULL    |       |
20 | app             | application which generated this item                                                                                     | varchar(255)   | NO   |     |         |       |
21 | rendered-hash   |                                                                                                                           | varchar(32)    | NO   |     |         |       |
22 | rendered-html   | item.body converted to html                                                                                               | mediumtext     | YES  |     | NULL    |       |
23 | object-type     | ActivityStreams object type                                                                                               | varchar(100)   | NO   |     |         |       |
24 | object          | JSON encoded object structure unless it is an implied object (normal post)                                                | text           | YES  |     | NULL    |       |
25 | target-type     | ActivityStreams target type if applicable (URI)                                                                           | varchar(100)   | NO   |     |         |       |
26 | target          | JSON encoded target structure if used                                                                                     | text           | YES  |     | NULL    |       |
27 | 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   |     |         |       |
28 | plink           | permalink or URL to a displayable copy of the message at its source                                                       | varbinary(383) | NO   |     |         |       |
29
30 Indexes
31 ------------
32
33 | Name                       | Fields                                 |
34 | -------------------------- | -------------------------------------- |
35 | PRIMARY                    | uri-id                                 |
36 | plink                      | plink(191)                             |
37 | resource-id                | resource-id                            |
38 | title-content-warning-body | FULLTEXT, title, content-warning, body |
39 | quote-uri-id               | quote-uri-id                           |
40
41 Foreign Keys
42 ------------
43
44 | Field | Target Table | Target Field |
45 |-------|--------------|--------------|
46 | uri-id | [item-uri](help/database/db_item-uri) | id |
47 | quote-uri-id | [item-uri](help/database/db_item-uri) | id |
48
49 Return to [database documentation](help/database)