Difference between revisions of "Database Model"
Gskluzacek (Talk | contribs) (added additional tables and descriptions of what they would contain) |
Gskluzacek (Talk | contribs) (→Issues: added table description and fields) |
||
| Line 4: | Line 4: | ||
aka Series Titles | aka Series Titles | ||
=== Issues === | === 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. | ||
| + | |||
| + | * iss_id: PK | ||
| + | * issue number | ||
| + | * issue extension | ||
| + | * title | ||
| + | * sub title | ||
| + | * release date | ||
| + | * cover date - generally will just have a month and a year | ||
| + | * key date - how the issues should be sorted chronologically | ||
| + | * issue type ? | ||
| + | * number of pages | ||
| + | * color / black & white ? | ||
| + | * age ? | ||
| + | * country ? | ||
| + | * language ? | ||
| + | |||
=== Variants === | === Variants === | ||
=== Related Material === | === Related Material === | ||
Revision as of 20:14, 13 June 2017
Contents
Main Tables
Publishers
Titles
aka Series Titles
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.
- iss_id: PK
- issue number
- issue extension
- title
- sub title
- release date
- cover date - generally will just have a month and a year
- key date - how the issues should be sorted chronologically
- issue type ?
- number of pages
- color / black & white ?
- age ?
- country ?
- language ?
Variants
Related Material
The inclusion of other related Titles when listing a main Title. For example, in a list of the Fantastic Four Series Title, additional titles such as Annuals, Specials, Reprints, Trade Paper Baks, etc would be listed after the main listing of issues. There would be types of related materials that the user could choose to show, and the user may also choose to incorporate these additional series titles in the main listing. For a given Series Title, the main series, there will several related series, that do not have the same Series Title as the main series, such as: - Annuals - Specials - Collected Issues (TPB, etc.) - Reprints These related series should be displayed underneath the issues for the main series, sorted by: type (e.g., annuals first, then specials, then collected issues, etc.), then issue number (desc).
title continuity
for a given series title, if it continues a different series, or continued from a different series.
collected in
tracks all the places a given issue is published in, e.g., trade paper backs collect individual issues. So the collated_in table would list all trades that the issue appears in. so when creating the data model for Trade Paper backs, you would have a Header table (PK: tpb_id) and a detail table. In the detail table you would have the tpb_dtl_id, tpb_hdr_id, iss_id. one could then query this table by iss_id and get the list of Trade Paper backs that collect the issue.
reprints
if a
Additional Tables
Imprints
could we store these in the same table as publishers and have fields to indicate that the record is an Imprint and the imprint's parent publisher?
Story Arcs & Cross Overs
tracks all the issues that make up a given Story Arc A story arc is an extended or continuing storyline in episodic storytelling media such as comic books with each episode following a narrative arc.
group and families
???
