Schema:tags

From ISFDB
Jump to navigation Jump to search

Schema Summary

+------------+------------+------+-----+---------+----------------+
| Field      | Type       | Null | Key | Default | Extra          |
+------------+------------+------+-----+---------+----------------+
| tag_id     | int(11)    | NO   | PRI | NULL    | auto_increment |
| tag_name   | tinytext   | YES  |     | NULL    |                |
| tag_status | tinyint(1) | YES  |     | 0       |                |
+------------+------------+------+-----+---------+----------------+

Description

The tags table tracks all unique user-defined tags that are attached to titles.

  • tag_id - This column is the unique record id for the tags table. A tag may be referred to by this unique id.
  • title_name - The actual tag.
  • tag_status - 1 if this tag has been marked "private", 0 otherwise.