Schema:title views

Schema Summary

+--------------+---------+------+-----+---------+-------+
| Field        | Type    | Null | Key | Default | Extra |
+--------------+---------+------+-----+---------+-------+
| title_id     | int(11) | NO   | PRI | NULL    |       |
| views        | int(11) | YES  |     | NULL    |       |
| annual_views | int(11) | YES  |     | NULL    |       |
+--------------+---------+------+-----+---------+-------+

Description

The title_views table contains statistical information about the number of times each title has been viewed by ISFDB users. This data used to be stored in the main "title" table and was migrated to "title_views" in September 2022 for performance reasons.

• title_id - This column is the same as the "title_id" value in the "title" table. It is the primary key for this table.

• views - This column contains the number of times a title has been viewed by ISFDB users.

• annual_views - This column is supposed to contain the number of times a title 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 title. See FR 1533, "Re-enable and display annual views", for details.