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.