relevant link (for tags and mentions, a link to the associated resource)

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		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