Shadowhelix:Datenbank

Letztes Update: 28.06.2016

Die Seite Shadowhelix:Datenbank dient der Erarbeitung eines Entwurfs für eine Datenbank, die Bereiche von Shadowrun mit großen Datenmengen besser zugänglich machen soll. Vorallem soll ein Datenbank-Schema erstellt werden, auf dessen Basis eine Datenbank aufgesetzt werden kann.

Datenbank

Siehe auch Shadowhelix:Datenbank/Umsetzung SQL

Stand

• Datenbankobjekte: 60967 (teilweise veröffentlicht)

Tabellen - Metainformation

contribution

contribution.txt	id_contributor | id_source | id_part issue | id_version | type_of_contribution | uncredited | id_reference
contribution old.txt	id_contributor | id_source | standard_descriptor | uncredited | title_contribution
contribution illustration.txt	id_contributor | id_illustration | id_reference
contribution text.txt	id_contributor | id_text | id_reference

contributor

contributor.txt	id_contributor | surname | surname_suffix | forename_first | forename_second | forename_third | year_birth | year_death | sex | id_reference
contributor catalog.txt	id_contributor | catalog | key | archive_copy_timestamp | id_reference
contributor referenced name.txt	id_contributor | referenced_name | id_reference
contributor weblink.txt	id_contributor | url | archive_copy_timestamp | id_reference
contributor weblink hosting service.txt	id_contributor | hosting_service | account_name | archive_copy_timestamp | id_reference

illustration

illustration catalog.txt	id_illustration | catalog | key | id_reference
illustration source.txt	id_illustration | id_source | id_part | issue | id_version | page_reference | entry_reference | position | modification | id_reference
illustration type.txt	id_illustration | type | id_reference
illustration weblink.txt	id_illustration | web_link | direct_link | id_reference

index

index creature.txt	id_creature | id_source | id_part | issue | id_version | page_reference | entry_reference | id_reference
index object.txt	id_object | id_source | id_part | issue | id_version | page_reference | entry_reference | id_reference
index product.txt	id_product | id_source | id_part | issue | id_version | page_reference | entry_reference | id_reference
index illustration person.txt	id_person | id_illustration | id_reference
index text document.txt	id_document | id_text | id_reference

original_credits

original credits.txt

id_source | version | position | credited_as | name | id_reference

< 1%

source

source.txt	id_source | description | language_code | type | id_reference
source catalog.txt	id_source | id_part | issue | id_version | catalog | key | id_reference
source date.txt	id_source | id_part | issue | id_version | year | month | day | id_reference
source date ingame.txt	id_source | id_part | issue | id_version | range_start_year | range_start_month | range_start_day | range_end_year | range_end_month | range_end_day | id_reference
source edition.txt	id_source | id_part | issue | id_version | edition | id_reference
source page number.txt	id_source | id_part | issue | id_version | page_number | id_reference
source part.txt	id_source | id_part | issue | id_version | description | id_reference
source title.txt	id_source | id_part | issue | id_version | prefix | pre_article | title | subtitle | id_reference
source translated.txt	id_source | id_source_original | partial_translation | id_reference

text

text source.txt	id_text | id_source | id_part | issue | id_version | page_reference | entry_reference | id_reference
text type.txt	id_text | type | id_reference

Tabellen - Weltinformation

corporation

corporation name.txt	id_corporation | language_code | short_name | full_name | abbreviation
corporation ownership.txt	id_corporation | id_corporation_owner | id_organisation_owner | id_person_owner | fraction | from_year | from_month | to_year | to_month

creature

creature name.txt

id_creature | language_code | sex | name | grammatical_number | generic_form | id_reference

document

document producer organisation.txt	id_document | id_organisation | id_reference
document producer person.txt	id_document | id_person | production_role | id_reference
document title.txt	id_document | language_code | title | original | id_reference

object

object group.txt	id_object | group_name | id_reference
object name.txt	id_object | language_code | name | id_reference

organisation

organisation.txt	id_organisation | description | id_reference
organisation hierarchy.txt	id_organisation_below | id_organisation_above | type | start_year | start_month | start_day | end_year | end_month | end_day | id_reference

person

person.txt	id_person | description | sex | id_reference
person creature.txt	id_person | id_creature | id_reference

product

product name.txt	id_product | language_code | name | id_reference
product type.txt	id_product | id_type | id_reference

type

type.txt

id_type | language_code | name

virtual entity

virtual entity name.txt	id_virtual_entity | name | id_reference
virtual entity shadowtalk.txt	id_text | id_virtual_entity | id_reference

Erläuterung von Werten

illustration_catalog / catalog

Wert	Name	URL
isfdb-title	Internet Speculative Fiction Database (title records)	http://www.isfdb.org/cgi-bin/title.cgi?[key]

Erläuterung ID

ID	Erläuterung	Beispielobjekte
id_source	Quellen	Quellenbuch, Nicht-Rollenspielprodukt, Outtake
id_part	Bestandteile einer Quelle	Handout, Box Set-Inhalt, DLC
issue	Element einer durchnummerierten Reihe	Ausgabe eines Magazins
id_version	Erscheinungsform	Digital- oder Printformat, Auflage, Sonderausgabe
id_illustration	Abbildung	Illustration, Schaubild, Layoutelement
id_text	zusammenhängender Textabschnitt	Kapitel, Kurzgeschichte, Infobox, Shadowtalk-Kommentar

Beitragende

siehe auch Versionsgeschichte von Shadowhelix:Datenbank/Vorschläge

• Greadle

Datenquellen

• Richter
  • Die zu "corporations" und "products" gehörenden Tabellen, basieren auf umfangreichen Listen, die von Richter angelegt wurden.
• mattdroz.com
  • Die zu "shadow matrix" gehörenden Tabellen, basieren auf dem Shadowtalker-Verzeichnis, das auf mattdroz.com gehostet wird. (http://www.mattdroz.com/PDF/)

Bearbeitung

Erweiterung oder Korrektur

• Shadowhelix:Datenbank/Vorschläge
• Shadowhelix:Datenbank/Übersicht Fehlende Illustrationeneinträge
• Shadowhelix:Datenbank/Zuordnung Weblinks zu Illustrationen

Listenaufarbeitung

• Listenaufarbeitung - Konzerne
• Listenaufarbeitung - Typen
• Listenaufarbeitung - Produkte, Produzenten, Quellen

Hilfsmittel

• Shadowhelix:Signaturidentifikation

Auswertung

• Shadowhelix:Datenbank/Statistiken

Weblinks

• Dumpshock-Forum: Shadowhelix Database (engl.)
• Pegasus-Forum: Shadowhelix - Datenbank
• ShadowGrid: Shadowhelix Database (engl.)