Schema:tag mapping

Schema Summary

+-----------+---------+------+-----+---------+----------------+
| Field     | Type    | Null | Key | Default | Extra          |
+-----------+---------+------+-----+---------+----------------+
| tagmap_id | int(11) | NO   | PRI | NULL    | auto_increment |
| tag_id    | int(11) | YES  | MUL | 0       |                |
| title_id  | int(11) | YES  | MUL | 0       |                |
| user_id   | int(11) | YES  | MUL | 0       |                |
+-----------+---------+------+-----+---------+----------------+

Description

This table maps a unique user-defined tag to a particular title. This table forms unique tuples of (tag, title, user).

• tagmap_id - This column is the unique record id for the tag_mapping table. A tag mapping may be referred to by this unique id.

• tag_id - The id of the tag record.

• title_id - The id of the title record.

• user_id - The id of the user record.