Difference between revisions of "Schema:titles"

From ISFDB
Jump to navigation Jump to search
(Bringing the information up to date)
Line 27: Line 27:
 
  | title_ctl        | int(10) unsigned                        | NO  |    | 0      |                |
 
  | title_ctl        | int(10) unsigned                        | NO  |    | 0      |                |
 
  | title_language    | int(11)                                | YES  |    | NULL    |                |
 
  | 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      |                |
 +
 +
+-------------------+-----------------------------------------+------+-----+---------+----------------+
  
 
==Description==
 
==Description==
Line 33: Line 37:
 
* '''title_id''' - This column is the unique record id for the titles table. A title may be referred to by this unique id.  
 
* '''title_id''' - This column is the unique record id for the titles table. A title may be referred to by this unique id.  
  
−
* '''title_title''' - This column holds the working title.  
+
* '''title_title''' - This column holds the work's title.  
  
−
* '''title_translator''' - This column holds information concerning translations. It is currently of the form Translation;Translation;Translation, where each translation is of the form Language,Year,Translator. In general, this format is awkward and error-prone, and a new mechanism is needed to handle translation information. It really should be attached to the publication, but that leaves a problem when talking about a single work of short fiction in a magazine.
+
* '''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''' - This column holds a pointer to a free-form note that describes the basic synopsis of the work.  
+
* '''title_synopsis''' - This column holds a pointer to a free-form note in the notes table. The note describes the basic synopsis of the work.  
  
−
* '''note_id''' - This column contains an integer value which refers to the ID of a record found in the notes table.  
+
* '''note_id''' - This column contains pointer to free-form note found in the notes table.  
  
−
* '''series_id''' - This column contains an integer value which refers to the ID of a record found in the series table.  
+
* '''series_id''' - This column contains a pointer to the ID of a record found in the series table.  
  
−
* '''title_seriesnum''' - This column contains the series number of the title. We need to think about what the right thing to do is if series information is pulled out into another table.  
+
* '''title_seriesnum''' - This column contains the series number of this title.
  
−
* '''title_copyright''' - This column contains the date of first publication. NOT necessarily copyright year, despite the name.
+
* '''title_copyright''' - This column contains the date of first publication. This is NOT necessarily the work's copyright year, despite the misleading name.
  
−
* '''title_storylen''' - This column has been overloaded to mean numerous things. For shortfiction, nv=novella, nt=novelette, ss=shortstory, sf=shortfiction (unknown length). For novels jvn=juvenile, nvz=novelization. This is totally messed up and needs a new mechanism.  
+
* '''title_storylen''' - This column has been overloaded to mean numerous things. For shortfiction, the valid values are nv=novella, nt=novelette, ss=shortstory, sf=shortfiction (unknown length). For novels, the valid values are jvn=juvenile, nvz=novelization. For omnibuses, valid values look like "/1,2+ss". This field will be changed in the future.  
  
−
* '''title_ttype''' - This column identifies the title type. Allowable values are 'ANTHOLOGY', 'COLLECTION', 'COVERART', 'INTERIORART', 'EDITOR', 'ESSAY', 'INTERVIEW', 'NOVEL', 'NONFICTION', 'NONGENRE', 'OMNIBUS', 'POEM', 'REVIEW', 'SERIAL', 'SHORTFICTION', 'CHAPTERBOOK'. Another option 'BACKCOVERART' is allowed but not used.
+
* '''title_ttype''' - This column identifies the title type. Allowable values are 'ANTHOLOGY', 'CHAPBOOK', 'COLLECTION', 'COVERART', 'INTERIORART', 'EDITOR', 'ESSAY', 'INTERVIEW', 'NOVEL', 'NONFICTION', 'OMNIBUS', 'POEM', 'REVIEW', 'SERIAL', 'SHORTFICTION', 'CHAPBOOK'. Another option 'BACKCOVERART' is allowed by the table definition, but not used by the software.
  
−
* '''title_wikipedia''' - This column can hold the URL to a Wikipedia article.
+
* '''title_wikipedia''' - NOT USED (This column was originally used hold the URL of a Wikipedia article, but is empty now.)
  
 
* '''title_views''' - This column contains the number of times a particular title has been viewed.
 
* '''title_views''' - This column contains the number of times a particular title has been viewed.
  
−
* '''title_parent''' - This column is a pointer to a parent title. If zero, the record is a canonical title; if non-zero the record is a variant title, and the column refers to the parent canonical title.
+
* '''title_parent''' - This column is a pointer to a 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 column contains this title's average vote rating. This column is recalculated whenever a users posts a vote against this particular title. This column is set only when 5 or more votes exist for the title.
 
* '''title_rating''' - This column contains this title's average vote rating. This column is recalculated whenever a users posts a vote against this particular title. This column is set only when 5 or more votes exist for the title.
Line 61: Line 65:
 
* '''title_annualviews''' - This column contains the number of times a particular title has been viewed in the current calendar year.
 
* '''title_annualviews''' - This column contains the number of times a particular title has been viewed in the current calendar year.
  
−
* '''title_ctl''' - This column contains exception bits which can be used to control the title display under distinct unique conditions.
+
* '''title_ctl''' - NOT USED (Originally this column was supposed to contain exception bits which could be then used to control the title display under distinct unique conditions.)
  
 
* '''title_language''' - This column may contain an integer value which refers to the ID of a record found in the languages table.
 
* '''title_language''' - This column may contain an integer value which refers to the ID of a record found in the languages table.
 +
 +
* '''title_seriesnum_2''' - This column contains the part of the series number to the right of the decimal point (if one is present.)
 +
 +
* '''title_non_genre''' - This column indicates whether this title non-genre. The valid vales are 'Yes' and 'No'.
 +
 +
* '''title_graphic''' - This column 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.

Revision as of 15:31, 15 July 2016

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',   |      |     |         |                |
|                   |   'NONGENRE', 'OMNIBUS', 'POEM',        |      |     |         |                |
|                   |   'REVIEW','SERIAL', 'SHORTFICTION',    |      |     |         |                |
|                   |   'CHAPTERBOOK')                        | 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      |                |

+-------------------+-----------------------------------------+------+-----+---------+----------------+

Description

  • title_id - This column is the unique record id for the titles table. A title may be referred to by this unique id.
  • title_title - This column holds 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 - This column holds a pointer to a free-form note in the notes table. The note describes the basic synopsis of the work.
  • note_id - This column contains pointer to free-form note found in the notes table.
  • series_id - This column contains a pointer to the ID of a record found in the series table.
  • title_seriesnum - This column contains the series number of this title.
  • title_copyright - This column contains the date of first publication. This is NOT necessarily the work's copyright year, despite the misleading name.
  • title_storylen - This column has been overloaded to mean numerous things. For shortfiction, the valid values are nv=novella, nt=novelette, ss=shortstory, sf=shortfiction (unknown length). For novels, the valid values are jvn=juvenile, nvz=novelization. For omnibuses, valid values look like "/1,2+ss". This field will be changed in the future.
  • title_ttype - This column identifies the title type. Allowable values are 'ANTHOLOGY', 'CHAPBOOK', 'COLLECTION', 'COVERART', 'INTERIORART', 'EDITOR', 'ESSAY', 'INTERVIEW', 'NOVEL', 'NONFICTION', 'OMNIBUS', 'POEM', 'REVIEW', 'SERIAL', 'SHORTFICTION', 'CHAPBOOK'. Another option 'BACKCOVERART' is allowed by the table definition, but not used by the software.
  • title_wikipedia - NOT USED (This column was originally used hold the URL of a Wikipedia article, but is empty now.)
  • title_views - This column contains the number of times a particular title has been viewed.
  • title_parent - This column is a pointer to a 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 column contains this title's average vote rating. This column is recalculated whenever a users posts a vote against this particular title. This column is set only when 5 or more votes exist for the title.
  • title_annualviews - This column contains the number of times a particular 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 distinct unique conditions.)
  • title_language - This column may contain an integer value which refers to the ID of a record found in the languages table.
  • title_seriesnum_2 - This column contains the part of the series number to the right of the decimal point (if one is present.)
  • title_non_genre - This column indicates whether this title non-genre. The valid vales are 'Yes' and 'No'.
  • title_graphic - This column 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.
Retrieved from "https://isfdb.org/wiki/index.php?title=Schema:titles&oldid=433808"