Shadowhelix:Datenbank: Unterschied zwischen den Versionen

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 11: Zeile 11:
====contribution====
====contribution====
{|
{|
| valign="top" | [[:Datei:ShxDB contribution.txt|ShxDB contribution.txt]]
| valign="top" | [[:Datei:ShxDB contribution.txt|contribution.txt]]
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> id_source <nowiki>|</nowiki> id_part issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> type_of_contribution <nowiki>|</nowiki> uncredited</tt></small>
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> id_source <nowiki>|</nowiki> id_part issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> type_of_contribution <nowiki>|</nowiki> uncredited</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB contribution old.txt|ShxDB contribution old.txt]]
| valign="top" | [[:Datei:ShxDB contribution old.txt|contribution old.txt]]
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> id_source <nowiki>|</nowiki> standard_descriptor <nowiki>|</nowiki> uncredited <nowiki>|</nowiki> title_contribution</tt></small>
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> id_source <nowiki>|</nowiki> standard_descriptor <nowiki>|</nowiki> uncredited <nowiki>|</nowiki> title_contribution</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB contribution illustration.txt|ShxDB contribution illustration.txt]]
| valign="top" | [[:Datei:ShxDB contribution illustration.txt|contribution illustration.txt]]
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> id_illustration</tt></small>
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> id_illustration</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB contribution text.txt|ShxDB contribution text.txt]]
| valign="top" | [[:Datei:ShxDB contribution text.txt|contribution text.txt]]
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> id_text</tt></small>
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> id_text</tt></small>
|}
|}
Zeile 26: Zeile 26:
====contributor====
====contributor====
{|
{|
| valign="top" | [[:Datei:ShxDB contributor.txt|ShxDB contributor.txt]]
| valign="top" | [[:Datei:ShxDB contributor.txt|contributor.txt]]
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> surname <nowiki>|</nowiki> surname_suffix <nowiki>|</nowiki> forename_first <nowiki>|</nowiki> forename_second <nowiki>|</nowiki> forename_third <nowiki>|</nowiki> year_birth <nowiki>|</nowiki> year_death <nowiki>|</nowiki> sex</tt></small>
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> surname <nowiki>|</nowiki> surname_suffix <nowiki>|</nowiki> forename_first <nowiki>|</nowiki> forename_second <nowiki>|</nowiki> forename_third <nowiki>|</nowiki> year_birth <nowiki>|</nowiki> year_death <nowiki>|</nowiki> sex</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB contributor catalog.txt|ShxDB contributor catalog.txt]]
| valign="top" | [[:Datei:ShxDB contributor catalog.txt|contributor catalog.txt]]
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> catalog <nowiki>|</nowiki> key <nowiki>|</nowiki> archive_copy_timestamp</tt></small>
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> catalog <nowiki>|</nowiki> key <nowiki>|</nowiki> archive_copy_timestamp</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB contributor referenced name.txt|ShxDB contributor referenced name.txt]]
| valign="top" | [[:Datei:ShxDB contributor referenced name.txt|contributor referenced name.txt]]
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> referenced_name</tt></small>
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> referenced_name</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB contributor weblink.txt|ShxDB contributor weblink.txt]]
| valign="top" | [[:Datei:ShxDB contributor weblink.txt|contributor weblink.txt]]
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> url <nowiki>|</nowiki> archive_copy_timestamp</tt></small>
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> url <nowiki>|</nowiki> archive_copy_timestamp</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB contributor weblink hosting service.txt|ShxDB contributor weblink hosting service.txt]]
| valign="top" | [[:Datei:ShxDB contributor weblink hosting service.txt|contributor weblink hosting service.txt]]
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> hosting_service <nowiki>|</nowiki> account_name <nowiki>|</nowiki> archive_copy_timestamp</tt></small>
| valign="top" | <small><tt>id_contributor <nowiki>|</nowiki> hosting_service <nowiki>|</nowiki> account_name <nowiki>|</nowiki> archive_copy_timestamp</tt></small>
|}
|}
Zeile 44: Zeile 44:
====illustration====
====illustration====
{|
{|
| valign="top" | [[:Datei:ShxDB illustration catalog.txt|ShxDB illustration catalog.txt]]
| valign="top" | [[:Datei:ShxDB illustration catalog.txt|illustration catalog.txt]]
| valign="top" | <small><tt>id_illustration <nowiki>|</nowiki> catalog <nowiki>|</nowiki> key</tt></small>
| valign="top" | <small><tt>id_illustration <nowiki>|</nowiki> catalog <nowiki>|</nowiki> key</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB illustration source.txt|ShxDB illustration source.txt]]
| valign="top" | [[:Datei:ShxDB illustration source.txt|illustration source.txt]]
| valign="top" | <small><tt>id_illustration <nowiki>|</nowiki> id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> page_reference <nowiki>|</nowiki> entry_reference <nowiki>|</nowiki> position <nowiki>|</nowiki> modification</tt></small>
| valign="top" | <small><tt>id_illustration <nowiki>|</nowiki> id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> page_reference <nowiki>|</nowiki> entry_reference <nowiki>|</nowiki> position <nowiki>|</nowiki> modification</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB illustration type.txt|ShxDB illustration type.txt]]
| valign="top" | [[:Datei:ShxDB illustration type.txt|illustration type.txt]]
| valign="top" | <small><tt>id_illustration <nowiki>|</nowiki> type</tt></small>
| valign="top" | <small><tt>id_illustration <nowiki>|</nowiki> type</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB illustration weblink.txt|ShxDB illustration weblink.txt]]
| valign="top" | [[:Datei:ShxDB illustration weblink.txt|illustration weblink.txt]]
| valign="top" | <small><tt>id_illustration <nowiki>|</nowiki> web_link <nowiki>|</nowiki> direct_link</tt></small>
| valign="top" | <small><tt>id_illustration <nowiki>|</nowiki> web_link <nowiki>|</nowiki> direct_link</tt></small>
|}
|}
Zeile 59: Zeile 59:
====index====
====index====
{|
{|
| valign="top" | [[:Datei:ShxDB index product.txt|ShxDB index product.txt]]
| valign="top" | [[:Datei:ShxDB index product.txt|index product.txt]]
| valign="top" | <small><tt>id_product <nowiki>|</nowiki> id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> page_reference <nowiki>|</nowiki> entry_reference</tt></small>
| valign="top" | <small><tt>id_product <nowiki>|</nowiki> id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> page_reference <nowiki>|</nowiki> entry_reference</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB index illustration person.txt|ShxDB index illustration person.txt]]
| valign="top" | [[:Datei:ShxDB index illustration person.txt|index illustration person.txt]]
| valign="top" | <small><tt>id_person <nowiki>|</nowiki> id_illustration</tt></small>
| valign="top" | <small><tt>id_person <nowiki>|</nowiki> id_illustration</tt></small>
|}
|}
Zeile 68: Zeile 68:
====original_credits====
====original_credits====
{|
{|
| valign="top" | [[:Datei:ShxDB original credits.txt|ShxDB original credits.txt]]
| valign="top" | [[:Datei:ShxDB original credits.txt|original credits.txt]]
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> version <nowiki>|</nowiki> position <nowiki>|</nowiki> credited_as <nowiki>|</nowiki> name</tt></small>
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> version <nowiki>|</nowiki> position <nowiki>|</nowiki> credited_as <nowiki>|</nowiki> name</tt></small>
| < 1%
| < 1%
Zeile 75: Zeile 75:
====source====
====source====
{|
{|
| valign="top" | [[:Datei:ShxDB source.txt|ShxDB source.txt]]
| valign="top" | [[:Datei:ShxDB source.txt|source.txt]]
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> description <nowiki>|</nowiki> language_code <nowiki>|</nowiki> type</tt></small>
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> description <nowiki>|</nowiki> language_code <nowiki>|</nowiki> type</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB source catalog.txt|ShxDB source catalog.txt]]
| valign="top" | [[:Datei:ShxDB source catalog.txt|source catalog.txt]]
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> catalog <nowiki>|</nowiki> key</tt></small>
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> catalog <nowiki>|</nowiki> key</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB source date.txt|ShxDB source date.txt]]
| valign="top" | [[:Datei:ShxDB source date.txt|source date.txt]]
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> year <nowiki>|</nowiki> month <nowiki>|</nowiki> day</tt></small>
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> year <nowiki>|</nowiki> month <nowiki>|</nowiki> day</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB source date ingame.txt|ShxDB source date ingame.txt]]
| valign="top" | [[:Datei:ShxDB source date ingame.txt|source date ingame.txt]]
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> range_start_year <nowiki>|</nowiki> range_start_month <nowiki>|</nowiki> range_start_day <nowiki>|</nowiki> range_end_year <nowiki>|</nowiki> range_end_month <nowiki>|</nowiki> range_end_day</tt></small>
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> range_start_year <nowiki>|</nowiki> range_start_month <nowiki>|</nowiki> range_start_day <nowiki>|</nowiki> range_end_year <nowiki>|</nowiki> range_end_month <nowiki>|</nowiki> range_end_day</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB source part.txt|ShxDB source part.txt]]
| valign="top" | [[:Datei:ShxDB source part.txt|source part.txt]]
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> description</tt></small>
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> description</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB source translated.txt|ShxDB source translated.txt]]
| valign="top" | [[:Datei:ShxDB source translated.txt|source translated.txt]]
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> id_source_original <nowiki>|</nowiki> partial_translation</tt></small>
| valign="top" | <small><tt>id_source <nowiki>|</nowiki> id_source_original <nowiki>|</nowiki> partial_translation</tt></small>
|}
|}
Zeile 96: Zeile 96:
====text====
====text====
{|
{|
| valign="top" | [[:Datei:ShxDB text source.txt|ShxDB text source.txt]]
| valign="top" | [[:Datei:ShxDB text source.txt|text source.txt]]
| valign="top" | <small><tt>id_text <nowiki>|</nowiki> id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> page_reference <nowiki>|</nowiki> entry_reference</tt></small>
| valign="top" | <small><tt>id_text <nowiki>|</nowiki> id_source <nowiki>|</nowiki> id_part <nowiki>|</nowiki> issue <nowiki>|</nowiki> id_version <nowiki>|</nowiki> page_reference <nowiki>|</nowiki> entry_reference</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB text type.txt|ShxDB text type.txt]]
| valign="top" | [[:Datei:ShxDB text type.txt|text type.txt]]
| valign="top" | <small><tt>id_text <nowiki>|</nowiki> type</tt></small>
| valign="top" | <small><tt>id_text <nowiki>|</nowiki> type</tt></small>
|}
|}
Zeile 107: Zeile 107:
====corporation====
====corporation====
{|
{|
| valign="top" | [[:Datei:ShxDB corporation name.txt|ShxDB corporation name.txt]]
| valign="top" | [[:Datei:ShxDB corporation name.txt|corporation name.txt]]
| valign="top" | <small><tt>id_corporation <nowiki>|</nowiki> language_code <nowiki>|</nowiki> short_name <nowiki>|</nowiki> full_name <nowiki>|</nowiki> abbreviation</tt></small>
| valign="top" | <small><tt>id_corporation <nowiki>|</nowiki> language_code <nowiki>|</nowiki> short_name <nowiki>|</nowiki> full_name <nowiki>|</nowiki> abbreviation</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB corporation ownership.txt|ShxDB corporation ownership.txt]]
| valign="top" | [[:Datei:ShxDB corporation ownership.txt|corporation ownership.txt]]
| valign="top" | <small><tt>id_corporation <nowiki>|</nowiki> id_corporation_owner <nowiki>|</nowiki> id_organisation_owner <nowiki>|</nowiki> id_person_owner <nowiki>|</nowiki> fraction <nowiki>|</nowiki> from_year <nowiki>|</nowiki> from_month <nowiki>|</nowiki> to_year <nowiki>|</nowiki> to_month</tt></small>
| valign="top" | <small><tt>id_corporation <nowiki>|</nowiki> id_corporation_owner <nowiki>|</nowiki> id_organisation_owner <nowiki>|</nowiki> id_person_owner <nowiki>|</nowiki> fraction <nowiki>|</nowiki> from_year <nowiki>|</nowiki> from_month <nowiki>|</nowiki> to_year <nowiki>|</nowiki> to_month</tt></small>
|}
|}
Zeile 116: Zeile 116:
====person====
====person====
{|
{|
| valign="top" | [[:Datei:ShxDB person.txt|ShxDB person.txt]]
| valign="top" | [[:Datei:ShxDB person.txt|person.txt]]
| valign="top" | <small><tt>id_person <nowiki>|</nowiki> description <nowiki>|</nowiki> sex</tt></small>
| valign="top" | <small><tt>id_person <nowiki>|</nowiki> description <nowiki>|</nowiki> sex</tt></small>
|}
|}
Zeile 122: Zeile 122:
====product====
====product====
{|
{|
| valign="top" | [[:Datei:ShxDB product name.txt|ShxDB product name.txt]]
| valign="top" | [[:Datei:ShxDB product name.txt|product name.txt]]
| valign="top" | <small><tt>id_product <nowiki>|</nowiki> language_code <nowiki>|</nowiki> name</tt></small>
| valign="top" | <small><tt>id_product <nowiki>|</nowiki> language_code <nowiki>|</nowiki> name</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB product type.txt|ShxDB product type.txt]]
| valign="top" | [[:Datei:ShxDB product type.txt|product type.txt]]
| valign="top" | <small><tt>id_product <nowiki>|</nowiki> id_type</tt></small>
| valign="top" | <small><tt>id_product <nowiki>|</nowiki> id_type</tt></small>
|}
|}
Zeile 131: Zeile 131:
====shadow matrix====
====shadow matrix====
{|
{|
| valign="top" | [[:Datei:ShxDB shadow matrix user.txt|ShxDB shadow matrix user.txt]]
| valign="top" | [[:Datei:ShxDB shadow matrix user.txt|shadow matrix user.txt]]
| valign="top" | <small><tt>id_user <nowiki>|</nowiki> id_person <nowiki>|</nowiki> name</tt></small>
| valign="top" | <small><tt>id_user <nowiki>|</nowiki> id_person <nowiki>|</nowiki> name</tt></small>
|-
|-
| valign="top" | [[:Datei:ShxDB shadow matrix shadowtalk source.txt|ShxDB shadow matrix shadowtalk source.txt]]
| valign="top" | [[:Datei:ShxDB shadow matrix shadowtalk source.txt|shadow matrix shadowtalk source.txt]]
| valign="top" | <small><tt>id_user <nowiki>|</nowiki> id_source <nowiki>|</nowiki> issue <nowiki>|</nowiki> page_reference <nowiki>|</nowiki> entry_reference</tt></small>
| valign="top" | <small><tt>id_user <nowiki>|</nowiki> id_source <nowiki>|</nowiki> issue <nowiki>|</nowiki> page_reference <nowiki>|</nowiki> entry_reference</tt></small>
|}
|}
Zeile 140: Zeile 140:
====type====
====type====
{|
{|
| valign="top" | [[:Datei:ShxDB type.txt|ShxDB type.txt]]
| valign="top" | [[:Datei:ShxDB type.txt|type.txt]]
| valign="top" | <small><tt>id_type <nowiki>|</nowiki> language_code <nowiki>|</nowiki> name</tt></small>
| valign="top" | <small><tt>id_type <nowiki>|</nowiki> language_code <nowiki>|</nowiki> name</tt></small>
|}
|}

Version vom 28. April 2016, 12:56 Uhr

Letztes Update: 28.04.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

Tabellen - Metainformation

contribution

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

contributor

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

illustration

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

index

index product.txt id_product | id_source | id_part | issue | id_version | page_reference | entry_reference
index illustration person.txt id_person | id_illustration

original_credits

original credits.txt id_source | version | position | credited_as | name < 1%

source

source.txt id_source | description | language_code | type
source catalog.txt id_source | id_part | issue | id_version | catalog | key
source date.txt id_source | id_part | issue | id_version | year | month | day
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
source part.txt id_source | id_part | issue | id_version | description
source translated.txt id_source | id_source_original | partial_translation

text

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

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

person

person.txt id_person | description | sex

product

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

shadow matrix

shadow matrix user.txt id_user | id_person | name
shadow matrix shadowtalk source.txt id_user | id_source | issue | page_reference | entry_reference

type

type.txt id_type | language_code | name

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

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

Listenaufarbeitung

Hilfsmittel

Auswertung

Weblinks