Database Model - Revision history

Gskluzacek: /* Issues */ added alternate issue number

2017-06-16T19:13:10Z

‎Issues: added alternate issue number

2017-06-16T18:57:01Z

‎Issues: info on issue number

2017-06-16T18:44:10Z

‎Variants

2017-06-16T18:37:35Z

‎Issues: moved info on issue type to special design considerations page

2017-06-16T18:35:39Z

‎Publishers

2017-06-16T18:24:15Z

‎Titles: added comment regarding when a series repeated issue number that were previously used, a new series is created.

2017-06-16T17:58:00Z

‎Issues: added content about issue type being used in conjunction with issue number to uniquely identify an issue

2017-06-16T17:27:16Z

‎Issues: added link to gcd page count wiki page

2017-06-16T17:22:31Z

‎Variants

2017-06-16T16:57:00Z

‎Variants: added info from GCD regarding variant types

@@ Line 38: / Line 38: @@
 * issue number - one shots, annuals, specials, etc. typically do not have issue numbers... should this be null, 1, or identified as not having an issue number (i.e., No Issue Number).
 * issue extension
-* full issue number
+* display issue number
 * issue type
 * issue sub type ?

@@ Line 36: / Line 36: @@
 * ttl_id: FK
 * volume number - should be left NULL, unless issue number resets to 1 multiple times in the series and Volume Number is documented. ''See series for additional details.''
-* issue number
+* issue number - one shots, annuals, specials, etc. typically do not have issue numbers... should this be null, 1, or identified as not having an issue number (i.e., No Issue Number).
 * issue extension
 * full issue number

@@ Line 121: / Line 121: @@
 Cover Material variant ???<br />
-like foil, 3-D, holographic, embossed
+like chromium (foil), 3-D, holographic, embossed
 International variants <br />

@@ Line 49: / Line 49: @@
 * cover price ?
 * currency
 * mature content flag / content rating ?
 * number of pages - standard page count versus ''actual page count'' see GCD wiki page on [http://docs.comics.org/wiki/Page_Count page count]
@@ Line 78: / Line 77: @@
 full issue number - this is the issue number and extension and any additional text that are used by the publisher to identify the issue in the series
 mature content flag / content rating - values of: Contains mature content or Does not contain mature content... alternatively could have ratings similar to G, PG, R, etc.

@@ Line 1: / Line 1: @@
 == Main Tables ==
 === Publishers ===
 === Titles  ===
 aka Series Titles<br />

@@ Line 4: / Line 4: @@
 aka Series Titles<br />
 Titles are unique by Publisher, series title, series year and series year sequence.
 * series title - the name of the series

@@ Line 20: / Line 20: @@
 === Issues ===
 There will be only 1 record for a given comic book issue, which will contain data about when it released, cover date, cover price, type, etc.
-If there are multiple variants of a given comic book issue, these will be describe in the variants table. Additionally, the variants table may provide fields that override values on the issues table. For example a 2nd printing variant may have a release date that is later than the release date of the first issue.
+If there are multiple variants of a given comic book issue, these will be describe in the variants table. Additionally, the variants table may provide fields that override values on the issues table. For example a 2nd printing variant may have a release date that is slightly later than the release date of the first issue.
 * iss_id: PK
@@ Line 28: / Line 32: @@
 * issue extension
 * full issue number
 * title / Issue Name ?
 * sub title / Issue Tagline ?

@@ Line 37: / Line 37: @@
 * issue type ?
 * mature content flag / content rating ?
-* number of pages ?
+* number of pages - standard page count versus ''actual page count'' see GCD wiki page on [http://docs.comics.org/wiki/Page_Count page count]
 * color / black & white ?
 * age ?
@@ Line 57: / Line 57: @@
 Key Date - how the issues should be sorted chronologically... closely related to Cover date/release, but would contain the day of the month (and possibly the time), so that when all the issue of the series or of a story arc are listed, they can be sorted by the key date and be displayed in the order that the issues
-Cover Price - should have a method to indicate FREE
+Cover Price - should have a method to indicate FREE or Promotional or Giveaway.
 Issue Number: a numeric value, typically an integer starting at 1, but on occasion can be a negative number or zero, for example issue # -1 or issue number # 0. Sometimes the issue number can be a floating point number, e.g. 15.1

@@ Line 105: / Line 105: @@
 Sketch Cover variants<br />
-Blank Cover variants<br>
+Blank Cover variants<br />
 International variants <br />

@@ Line 88: / Line 88: @@
 * Special Edition
 * Collectors' Edition
 * etc..
 === Related Material ===