6 | Field | Description | Type | Null | Key | Default | Extra |
7 | ------------- | --------------------------------------------- | ------------------ | ---- | --- | ------------------- | -------------- |
8 | id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment |
9 | type | | smallint unsigned | NO | | 0 | |
10 | name | | varchar(255) | NO | | | |
11 | url | | varchar(255) | NO | | | |
12 | photo | | varchar(255) | NO | | | |
13 | date | | datetime | NO | | 0001-01-01 00:00:00 | |
14 | msg | | mediumtext | YES | | NULL | |
15 | uid | Owner User id | mediumint unsigned | NO | | 0 | |
16 | link | | varchar(255) | NO | | | |
17 | iid | | int unsigned | YES | | NULL | |
18 | parent | | int unsigned | YES | | NULL | |
19 | uri-id | Item-uri id of the related post | int unsigned | YES | | NULL | |
20 | parent-uri-id | Item-uri id of the parent of the related post | int unsigned | YES | | NULL | |
21 | seen | | boolean | NO | | 0 | |
22 | verb | | varchar(100) | NO | | | |
23 | otype | | varchar(10) | NO | | | |
24 | name_cache | Cached bbcode parsing of name | tinytext | YES | | NULL | |
25 | msg_cache | Cached bbcode parsing of msg | mediumtext | YES | | NULL | |
27 Return to [database documentation](help/database)