4 | Field | Description | Type | Null | Key | Default | Extra |
5 |-------------|------------------|------------------|------|-----|---------------------|-------|
6 | iid | sequential ID | int(10) unsigned | NO | PRI | 0 | |
7 | uid | | int(10) unsigned | NO | MUL | 0 | |
8 | contact-id | | int(11) unsigned | NO | | 0 | |
9 | gcontact-id | Global Contact | int(11) unsigned | NO | | 0 | |
10 | created | | datetime | NO | MUL | 0000-00-00 00:00:00 | |
11 | edited | | datetime | NO | | 0000-00-00 00:00:00 | |
12 | commented | | datetime | NO | MUL | 0000-00-00 00:00:00 | |
13 | received | | datetime | NO | | 0000-00-00 00:00:00 | |
14 | changed | | datetime | NO | | 0000-00-00 00:00:00 | |
15 | wall | | tinyint(1) | NO | MUL | 0 | |
16 | private | | tinyint(1) | NO | | 0 | |
17 | pubmail | | tinyint(1) | NO | | 0 | |
18 | moderated | | tinyint(1) | NO | | 0 | |
19 | visible | | tinyint(1) | NO | | 0 | |
20 | spam | | tinyint(1) | NO | | 0 | |
21 | starred | | tinyint(1) | NO | | 0 | |
22 | ignored | | tinyint(1) | NO | | 0 | |
23 | bookmark | | tinyint(1) | NO | | 0 | |
24 | unseen | | tinyint(1) | NO | | 1 | |
25 | deleted | | tinyint(1) | NO | | 0 | |
26 | origin | | tinyint(1) | NO | | 0 | |
27 | forum_mode | | tinyint(1) | NO | | 0 | |
28 | mention | | tinyint(1) | NO | | 0 | |
29 | network | | varchar(32) | NO | | | |
31 Return to [database documentation](help/database)