Schema:tag mapping
Jump to navigation
Jump to search
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.