| tid | sequential index | int(10) unsigned | NO | PRI | NULL |
| aid | channel_account_id of the controlling channel | int(10) unsigned | NO | MUL | 0 |
| uid | channel_id of the controlling channel | int(10) unsigned | NO | MUL | 0 |
| oid | DB index of linked thing | int(10) unsigned | NO | MUL | 0 |
| otype | type of linked thing | tinyint(3) unsigned | NO | MUL | 0 |
| ttype | taxonomy type (See Tag/term types in boot.php) | tinyint(3) unsigned | NO | MUL | 0 |
| term | the actual taxonomy term | char(191) | NO | MUL | |
| url | | char(191) | NO | | |
| imgurl | rarely used - an image associated with this taxonomy term | char(191) | NO | MUL | |
| term_hash | unique hash for this entry | char(191) | NO | MUL | |
| parent_hash | for hierarchical taxonomies, the hash of the relevant parent | char(191) | NO | MUL | |