Skip to content

Table post-content#

Content for all posts

Fields#

Field Description Type Null Key Default Extra
uri-id Id of the item-uri table entry that contains the item uri int unsigned NO PRI NULL
title item title varchar(255) NO
content-warning varchar(255) NO
body item body content mediumtext YES NULL
raw-body Body without embedded media links mediumtext YES NULL
location text location where this item originated varchar(255) NO
coord longitude/latitude pair representing location where this item originated varchar(255) NO
language Language information about this post text YES NULL
app application which generated this item varchar(255) NO
rendered-hash varchar(32) NO
rendered-html item.body converted to html mediumtext YES NULL
object-type ActivityStreams object type varchar(100) NO
object JSON encoded object structure unless it is an implied object (normal post) text YES NULL
target-type ActivityStreams target type if applicable (URI) varchar(100) NO
target JSON encoded target structure if used text YES NULL
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
plink permalink or URL to a displayable copy of the message at its source varchar(255) NO

Indexes#

Name Fields
PRIMARY uri-id
plink plink(191)
resource-id resource-id
title-content-warning-body FULLTEXT, title, content-warning, body

Foreign Keys#

Field Target Table Target Field
uri-id item-uri id

Return to database documentation