| Column Name | Type | Default | Description |
|---|---|---|---|
| inumber | int(11) | Item ID | |
| ititle | varchar(160) | NULL | Title |
| ibody | text | Body text | |
| imore | text | Extended text | |
| iblog | int(11) | '0' | Blog to which the item belongs to |
| iauthor | int(11) | '0' | Member that is the author of the item |
| itime | datetime | '0000-00-00 00:00:00' | Item time (this is the corrected time, with offset already applies) |
| iclosed | tinyint(2) | '0' | Is item closed? (1=true/0=false). When an item is closed, it's no longer possible to add new comments or cast 'karma votes' |
| idraft | tinyint(2) | '0' | Is the item a draft version? Draft versions only show up in the admin area. |
| ikarmapos | int(11) | '0' | Total amount of positive karma votes casted |
| ikarmaneg | int(11) | '0' | Total amount of negative karma votes casted |
| icat | int(11) | NULL | Category to which the item belongs |