4 | Field | Description | Type | Null | Key | Default | Extra |
5 | ------ | --------------------------------- | ------------ | ---- | --- | ------------------- | --------------- |
6 | id | sequential ID | int(11) | NO | PRI | NULL | auto_increment |
7 | hash | | varchar(64) | NO | | | |
8 | type | | int(11) | NO | | 0 | |
9 | name | | varchar(255) | NO | | | |
10 | url | | varchar(255) | NO | | | |
11 | photo | | varchar(255) | NO | | | |
12 | date | | datetime | NO | | 0000-00-00 00:00:00 | |
13 | msg | | mediumtext | NO | | NULL | |
14 | uid | user.id of the owner of this data | int(11) | NO | MUL | 0 | |
15 | link | | varchar(255) | NO | | | |
16 | parent | | int(11) | NO | | 0 | |
17 | seen | | tinyint(1) | NO | | 0 | |
18 | verb | | varchar(255) | NO | | | |
19 | otype | | varchar(16) | NO | | | |
20 | iid | item.id | int(11) | NO | | 0 | |
22 Return to [database documentation](help/database)