Schema:titles
Revision as of 14:29, 17 April 2017 by Uzume (talk | contribs) (→Description: title_storylen updates)
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.