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.