Schema:titles

Schema Summary

+-------------------+-----------------------------------------+------+-----+---------+----------------+
| Field             | Type                                    | Null | Key | Default | Extra          |
+-------------------+-----------------------------------------+------+-----+---------+----------------+
| title_id          | int(11)                                 | NO   | PRI | NULL    | auto_increment |
| title_title       | mediumtext                              | YES  | MUL | NULL    |                |
| title_translator  | mediumtext                              | YES  |     | NULL    |                |
| title_synopsis    | int(11)                                 | YES  |     | NULL    |                |
| note_id           | int(11)                                 | YES  | MUL | NULL    |                |
| series_id         | int(11)                                 | YES  | MUL | NULL    |                |
| title_seriesnum   | int(11)                                 | YES  |     | NULL    |                |
| title_copyright   | date                                    | YES  |     | NULL    |                |
| title_storylen    | mediumtext                              | YES  |     | NULL    |                |
| title_ttype       | enum('ANTHOLOGY', 'BACKCOVERART',       |      |     |         |                |
|                   |   'COLLECTION', 'COVERART',             |      |     |         |                |
|                   |   'INTERIORART', 'EDITOR', 'ESSAY',     |      |     |         |                |
|                   |   'INTERVIEW', 'NOVEL', 'NONFICTION',   |      |     |         |                |
|                   |   'OMNIBUS', 'POEM', 'REVIEW', 'SERIAL' |      |     |         |                |
|                   |   'SHORTFICTION', 'CHAPBOOK')           |      |     |         |                |                              | YES  | MUL | NULL    |                |
| title_wikipedia   | mediumtext                              | YES  |     | NULL    |                |
| title_views       | int(11)                                 | NO   |     | 0       |                |
| title_parent      | int(11)                                 | NO   | MUL | 0       |                |
| title_rating      | float                                   | YES  |     | NULL    |                |
| title_annualviews | int(11)                                 | NO   |     | 0       |                |
| title_ctl         | int(10) unsigned                        | NO   |     | 0       |                |
| title_language    | int(11)                                 | YES  |     | NULL    |                |
| title_seriesnum_2 | varchar(4)                              | YES  |     | NULL    |                |
| title_non_genre   | enum('Yes','No')                        | YES  |     | No      |                |
| title_graphic     | enum('Yes','No')                        | YES  |     | No      |                |
| title_nvz         | enum('Yes','No')                        | YES  |     | No      |                |
| title_jvn         | enum('Yes','No')                        | YES  |     | No      |                |
| title_content     | varchar(32)                             | YES  |     | NULL    |                |
+-------------------+-----------------------------------------+------+-----+---------+----------------+

Description

• title_id - Unique record id for the titles table.

• title_title - The work's title.

• title_translator - Not Used (This column was supposed to hold information concerning translations. The format was supposed to be Translation;Translation;Translation, where each translation was of the form Language,Year,Translator.)

• title_synopsis - A pointer to a free-form note in the notes table. The note describes the basic synopsis of the work.

• note_id - A pointer to free-form note found in the notes table.

• series_id - Series number associated with this title and stored in the series table.

• title_seriesnum - This title's number within its series

• title_copyright - The date of first publication. This is NOT necessarily the work's copyright year, despite the misleading name.

• title_storylen - This column is only for use by shortfiction, however, historically is was overloaded for other things things. For shortfiction, the valid values are nv=novella, nt=novelette, ss=shortstory, sf=shortfiction (unknown length). For novels, the valid values were jvn=juvenile and nvz=novelization but these were moved to their own fields title_jvn and title_nvz respectively. For omnibuses, valid values used to look like "/1,2+ss" but this was moved to its own field title_content (without the leading "/").

• title_ttype - The type of this title. Allowable values are listed in the field definition. Note that 'BACKCOVERART' is allowed by the table definition but not used by the software.

• title_wikipedia - Not Used. (This column was originally used to hold the URL of a Wikipedia article, but is empty now.)

• title_views - The number of times this title has been viewed.

• title_parent - ID of this title's parent title. If zero, this title record is a canonical title; if non-zero, this title record is a variant title, and the column refers to the parent canonical title.

• title_rating - This title's average vote rating. This value is recalculated whenever a users posts a vote for this title. This column is set only when 5 or more votes exist for the title.

• title_annualviews - The number of times this title has been viewed in the current calendar year.

• title_ctl - Not Used (Originally this column was supposed to contain exception bits which could be then used to control the title display under certain conditions.)

• title_language - ID of this title's language. Points to a record found in the "languages" table.

• title_seriesnum_2 - The part of the series number to the right of the decimal point (if one is present.)

• title_non_genre - Indicates whether this title non-genre. The valid vales are 'Yes' and 'No'.

• title_graphic - Indicates whether this title is graphic in nature. The valid values are 'Yes' and 'No'. Note that COVERART and INTERIORART titles are not considered graphic.

• title_nvz - Indicates whether this title is a novelization. The valid vales are 'Yes' and 'No'.

• title_jvn - Indicates whether this title is aimed at the juvenile/young adult audience. The valid vales are 'Yes' and 'No'.

• title_content - Content indicator for omnibuses.