Current Schema
Jump to navigation
Jump to search
Much of this page is based on earlier documentation by Peter Croome.
DB Column | Name in New Code | Description | Usage Notes |
---|---|---|---|
ID | id | DB-generated primary key. | In the lasso-based site, this is the number you see in URLs like http://www.comics.org/publisher_details.lasso?id=4066 It is generated by the database and has no inherent meaning. |
PubName | name | Name of the publisher, imprint, or set of imprints | Because imprints are not stored per-issue, in some cases a semicolon-separated list of imprints corresponding to all imprints used for a given series has been given an entry int this table. Also, not all things that we term "Publishers" or "Imprints" strictly fall into those categories, and we do not accurately reflect the evolution of company names over time (for instance, "DC" was not until fairly recently the official name of the company, although it was long an informal name. It is still not exactly correct- "DC Comics" appears to be the current legal name. But "DC" is what everyone knows, so that is what appears in the database). |
YearBegan | year_began | Year (by cover date) of first publication. | |
YearEnded | year_ended | Year (by cover date) of last publication, if any. | |
CountryID | country | The country from which the publisher operates. | Foreign key into the Countries table. |
Notes | notes | Space for arbitrary notes. | |
web | url | The URL for the publisher's website. | While this column sometimes has data, it does not appear to be used by the Lasso-based site. |
AlphaSortCode | alpha_sort_code | A single character. | Appears to be used to sort related publishers near each other even if the more obvious alphabetical sort would not do so. It's a touch unclear. |
ImprintCount | imprint_count | Count of how many imprints a given publisher has. | Does not appear to be uniformly accurate. |
BookCount | series_count | Count of how many series this publisher publishes. | Does not appear to be uniformly accurate. |
IssueCount | issue_count | Total number of issues in all series published by the publisher. | Does not appear to be uniformly accurate. |