- `thr-parent` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `owner-id` int NOT NULL DEFAULT 0 COMMENT '',
- `owner-name` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `owner-link` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `owner-avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `author-id` int NOT NULL DEFAULT 0 COMMENT '',
- `author-name` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `author-link` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `author-avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `title` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `body` mediumtext COMMENT '',
- `app` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `verb` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `object-type` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `object` text COMMENT '',
- `target-type` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `target` text COMMENT '',
- `postopts` text COMMENT '',
- `plink` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `resource-id` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `event-id` int NOT NULL DEFAULT 0 COMMENT '',
+ `thr-parent` varchar(255) NOT NULL DEFAULT '' COMMENT 'If the parent of this item is not the top-level item in the conversation, the uri of the immediate parent; otherwise set to parent-uri',
+ `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation timestamp.',
+ `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last edit (default is created)',
+ `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last comment/reply to this item',
+ `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime',
+ `changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date that something in the conversation changed, indicating clients should fetch the conversation again',
+ `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the owner of this item',
+ `owner-name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name of the owner of this item',
+ `owner-link` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link to the profile page of the owner of this item',
+ `owner-avatar` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link to the avatar picture of the owner of this item',
+ `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the author of this item',
+ `author-name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name of the author of this item',
+ `author-link` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link to the profile page of the author of this item',
+ `author-avatar` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link to the avatar picture of the author of this item',
+ `icid` int unsigned COMMENT 'Id of the item-content table entry that contains the whole item content',
+ `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'item title',
+ `content-warning` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `body` mediumtext COMMENT 'item body content',
+ `app` varchar(255) NOT NULL DEFAULT '' COMMENT 'application which generated this item',
+ `verb` varchar(100) NOT NULL DEFAULT '' COMMENT 'ActivityStreams verb',
+ `object-type` varchar(100) NOT NULL DEFAULT '' COMMENT 'ActivityStreams object type',
+ `object` text COMMENT 'JSON encoded object structure unless it is an implied object (normal post)',
+ `target-type` varchar(100) NOT NULL DEFAULT '' COMMENT 'ActivityStreams target type if applicable (URI)',
+ `target` text COMMENT 'JSON encoded target structure if used',
+ `postopts` text COMMENT 'External post connectors add their network name to this comma-separated string to identify that they should be delivered to these networks during delivery',
+ `plink` varchar(255) NOT NULL DEFAULT '' COMMENT 'permalink or URL to a displayable copy of the message at its source',
+ `resource-id` varchar(32) NOT NULL DEFAULT '' COMMENT 'Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type',
+ `event-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Used to link to the event.id',