X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_post-content.md;h=27b372093a5480d5b7a0f2926a9f75f1eb7f90dd;hb=a275f0a719c605e358334833a3a9d49a310f2389;hp=69aa06c4bac744c46b2a9455ec47775df0063a72;hpb=a827f948c867ceebf60d82b0740032512be23302;p=friendica.git diff --git a/doc/database/db_post-content.md b/doc/database/db_post-content.md index 69aa06c4ba..27b372093a 100644 --- a/doc/database/db_post-content.md +++ b/doc/database/db_post-content.md @@ -1,25 +1,49 @@ Table post-content =========== + Content for all posts -| 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 | | | | +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 | | +| quote-uri-id | Id of the item-uri table that contains the quoted uri | int unsigned | 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 | varbinary(383) | NO | | | | + +Indexes +------------ + +| Name | Fields | +| -------------------------- | -------------------------------------- | +| PRIMARY | uri-id | +| plink | plink(191) | +| resource-id | resource-id | +| title-content-warning-body | FULLTEXT, title, content-warning, body | +| quote-uri-id | quote-uri-id | + +Foreign Keys +------------ + +| Field | Target Table | Target Field | +|-------|--------------|--------------| +| uri-id | [item-uri](help/database/db_item-uri) | id | +| quote-uri-id | [item-uri](help/database/db_item-uri) | id | Return to [database documentation](help/database)