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