|
|
| Line 1: |
Line 1: |
| − | = *** under construction *** - DiversityGazetteers Information Model (version 01.03.05, 01. July 2014)=
| |
| | | | |
| − | {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
| |
| − | |-style="text-align:left; background:#F5F5F5;"
| |
| − | |Authors
| |
| − | |M. Weiss, W. Reichert 2014
| |
| − | |-
| |
| − | |-style="text-align:left; background:# FFFFFF;"
| |
| − | |License
| |
| − | |[http://creativecommons.org/licenses/by-nd/3.0/ http://i.creativecommons.org/l/by-nd/3.0/80x15.png]
| |
| − | |-
| |
| − | |-style="text-align:left; background:#F5F5F5;"
| |
| − | |Suggested citation
| |
| − | |M. Weiss, W. Reichert (2014). DiversityGazetteers information model (version 01.03.05). http://diversityworkbench.net/Portal/GazetteersModel_v01.03.05.
| |
| − | |-
| |
| − | |-style="text-align:left; background:#FFFFFF;"
| |
| − | |Notes
| |
| − | |The models currently reside in MS SQL Server, so knowledge of some [[SQL Server ER-diagram conventions]] will be helpful.
| |
| − | Besides the screen shots below, a [[Media:DiversityGazetteers_010305.txt|Microsoft T-SQL-Script]] for the generation of the tables is provided.
| |
| − | |}
| |
| − | ----
| |
| − | ==ER Diagrams==
| |
| − |
| |
| − | ===Overview over all entities and relations used in the database model===
| |
| − |
| |
| − | [[Image:ER_DiversityGazetteers_010305.png|ER]]
| |
| − |
| |
| − | Some “housekeeping” fields and tables for the documentation when and by whom the data were inserted or changed are not shown in the overview or the detail diagrams.
| |
| − |
| |
| − | ===A short introduction:===
| |
| − |
| |
| − | * “GeoPlace” is the central entity, containing the information directly related to ...
| |
| − |
| |
| − |
| |
| − | Entities ending with “_Enum” (“LanguageCode_Enum”) contain enumerated values or strings.
| |
| − |
| |
| − | ----
| |
| − |
| |
| − | ===Table: GeoPlace===
| |
| − | Informations about the geographic places
| |
| − | {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
| |
| − | |-style="text-align:left; background:#D3D3D3;"
| |
| − | !Column
| |
| − | !Data type
| |
| − | !Description
| |
| − | !Requ.
| |
| − | !Ind.
| |
| − | |-
| |
| − | |<u>todo...</u>
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |todo...
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | | -
| |
| − | |-
| |
| − |
| |
| − |
| |
| − |
| |
| − | '''Footnotes''': The following conventions and abbreviations have been used in the tables: Columns of primary key:<u>underlined</u> '''R''': It is required to enter data in this field. '''I''': The field is indexed to enable faster searching. '''U''': unique index
| |
