User:Zhtew/database structure

There are four intertwined databases.

Authors
fields: name, firstname, wikilink, alias

alias is a pointer to another author item, which contains the full (or the correct) information about this author. This is inteded for acronyms, existence of several transcriptions etc. Example: item A has alias=B. Whenever item A is requested (for export of citations etc.), the values of B will be shown.

sample entry: Birkhoff, Garrett, Garrett Birkhoff

Journals
fields: name, abbrname, wikilink, issn, alias

sample entry: Inventiones Mathematicae, Invent. Math., 0020-9910, Inventiones Mathematicae

Publishers

 * fields: name, location, wikilink, alias