Difference between revisions of "Schema:tags"
Jump to navigation
Jump to search
(Breaking up larger article) |
(2016 update) |
||
Line 1: | Line 1: | ||
==Schema Summary== | ==Schema Summary== | ||
− | +----------+----------+------+-----+---------+----------------+ | + | +------------+------------+------+-----+---------+----------------+ |
− | | Field | + | | Field | Type | Null | Key | Default | Extra | |
− | +----------+----------+------+-----+---------+----------------+ | + | +------------+------------+------+-----+---------+----------------+ |
− | | tag_id | + | | tag_id | int(11) | NO | PRI | NULL | auto_increment | |
− | | tag_name | tinytext | YES | | NULL | | | + | | tag_name | tinytext | YES | | NULL | | |
− | +----------+----------+------+-----+---------+----------------+ | + | | tag_status | tinyint(1) | YES | | 0 | | |
+ | +------------+------------+------+-----+---------+----------------+ | ||
==Description== | ==Description== | ||
Line 15: | Line 16: | ||
* '''title_name''' - The actual tag. | * '''title_name''' - The actual tag. | ||
+ | |||
+ | * '''tag_status''' - 1 if this tag has been marked "private", 0 otherwise. |
Latest revision as of 20:14, 3 September 2016
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.