Schema:tags

From ISFDB
Revision as of 22:05, 22 May 2008 by Alvonruff (talk | contribs) (Breaking up larger article)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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    |                |
+----------+----------+------+-----+---------+----------------+

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.