Field | Description | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|---|
id | int(10) unsigned | NO | PRI | NULL | auto_increment | |
mid | char(255) | NO | MUL | |||
aid | int(10) unsigned | NO | MUL | 0 | ||
uid | int(10) unsigned | NO | MUL | 0 | ||
parent | int(10) unsigned | NO | MUL | 0 | ||
parent_mid | char(255) | NO | MUL | |||
thr_parent | char(255) | NO | ||||
created | datetime | NO | MUL | 0000-00-00 00:00:00 | ||
edited | datetime | NO | MUL | 0000-00-00 00:00:00 | ||
expires | datetime | NO | MUL | 0000-00-00 00:00:00 | ||
commented | datetime | NO | MUL | 0000-00-00 00:00:00 | ||
received | datetime | NO | MUL | 0000-00-00 00:00:00 | ||
changed | datetime | NO | MUL | 0000-00-00 00:00:00 | ||
comments_closed | datetime | NO | MUL | 0000-00-00 00:00:00 | ||
owner_xchan | char(255) | NO | MUL | |||
author_xchan | char(255) | NO | MUL | |||
source_xchan | char(255) | NO | ||||
mimetype | char(255) | NO | MUL | |||
title | text | NO | MUL | NULL | ||
body | mediumtext | NO | MUL | NULL | ||
app | char(255) | NO | ||||
lang | char(64) | NO | ||||
revision | int(10) unsigned | NO | MUL | 0 | ||
verb | char(255) | NO | MUL | |||
obj_type | char(255) | NO | ||||
object | text | NO | NULL | |||
tgt_type | char(255) | NO | ||||
target | text | NO | NULL | |||
layout_mid | char(255) | NO | MUL | |||
postopts | text | NO | NULL | |||
route | text | NO | NULL | |||
llink | char(255) | NO | MUL | |||
plink | char(255) | NO | ||||
resource_id | char(255) | NO | ||||
resource_type | char(16) | NO | MUL | |||
attach | mediumtext | NO | NULL | |||
sig | text | NO | NULL | |||
diaspora_meta | mediumtext | NO | NULL | |||
location | char(255) | NO | ||||
coord | char(255) | NO | ||||
public_policy | char(255) | NO | MUL | |||
comment_policy | char(255) | NO | MUL | |||
allow_cid | mediumtext | NO | MUL | NULL | ||
allow_gid | mediumtext | NO | MUL | NULL | ||
deny_cid | mediumtext | NO | MUL | NULL | ||
deny_gid | mediumtext | NO | MUL | NULL | ||
item_restrict | int(11) | NO | MUL | 0 | ||
item_flags | int(11) | NO | MUL | 0 | ||
item_private | tinyint(4) | NO | MUL | 0 |
Return to database documentation