Contents
| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| tid | sequential index | int(10) unsigned | NO | PRI | NULL | auto_increment |
| 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 | NULL | |
| otype | type of linked thing | tinyint(3) unsigned | NO | MUL | NULL | |
| ttype | taxonomy type (See Tag/term types in boot.php) | tinyint(3) unsigned | NO | MUL | NULL | |
| term | the actual taxonomy term | char(255) | NO | MUL | NULL | |
| url | relevant link (for tags and mentions, a link to the associated resource)char(255) | NO | NULL | |||
| imgurl | rarely used - an image associated with this taxonomy term | char(255) | NO | MUL | NULL | |
| term_hash | unique hash for this entry | char(255) | NO | MUL | ||
| parent_hash | for hierarchical taxonomies, the hash of the relevant parent | char(255) | NO | MUL |
Return to database documentation