Difference between revisions of "Schema:author views"
Jump to navigation
Jump to search
(Page creation) |
m (Wording) |
||
| Line 11: | Line 11: | ||
==Description== | ==Description== | ||
| − | The author_views table contains statistical information about the number of times each author | + | The author_views table contains statistical information about the number of times each author has been viewed by ISFDB users. This data used to be stored in the main "authors" table and was migrated to "author_views" in September 2022 for performance reasons. |
* '''author_id''' - This column is the same as the "author_id" value in the "authors" table. It is the primary key for this table. | * '''author_id''' - This column is the same as the "author_id" value in the "authors" table. It is the primary key for this table. | ||
Latest revision as of 11:39, 11 September 2022
Schema Summary
+--------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------+------+-----+---------+-------+ | author_id | int(11) | NO | PRI | NULL | | | views | int(11) | YES | | NULL | | | annual_views | int(11) | YES | | NULL | | +--------------+---------+------+-----+---------+-------+
Description
The author_views table contains statistical information about the number of times each author has been viewed by ISFDB users. This data used to be stored in the main "authors" table and was migrated to "author_views" in September 2022 for performance reasons.
- author_id - This column is the same as the "author_id" value in the "authors" table. It is the primary key for this table.
- views - This column contains the number of times an author has been viewed by ISFDB users.
- annual_views - This column is supposed to contain the number of times an author has been viewed by ISFDB users during the current year. Due to software limitations, it currently contains the same value as the value of the "views" column for this author. See FR 1533, "Re-enable and display annual views", for details.