|
|
| (9 intermediate revisions by one other user not shown) |
| Line 1: |
Line 1: |
| − | =under construction!! - DiversitySamplingPlots Information Model (version 03.00.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;"
| + | This page lists the published versions of the information model for [[DiversitySamplingPlots]]. |
| − | |-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). DiversitySamplingPlots information model (version 03.00.05). http://diversityworkbench.net/Portal/ProjectsModel_v03.00.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:DiversityProjects_020002.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===
| + | * '''Current version:''' |
| − | | + | **[[ SamplingPlotsModel 01.00.34|DiversitySamplingPlots 01.00.34. March 04th, 2020]] |
| − | [[Image:ER_DiversitySamplingPlots_030005.png|ER]] | + | * '''Older versions:''' |
| − | | + | **[[ SamplingPlotsModel v03.00.05|DiversitySamplingPlots 03.00.05. July 01st, 2014]] |
| − | 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.
| + | ** (Earlier versions were not documented in this format.) |
| − | | + | |
| − | ===A short introduction:===
| + | |
| − | | + | |
| − | * “SamplingPlot” is the central entity, containing the information directly related to ... | + | |
| − | | + | |
| − | | + | |
| − | Entities ending with “_Enum” (“ProjectAgentRole_Enum”) contain enumerated values or strings.
| + | |
| − | | + | |
| − | ----
| + | |
| − | | + | |
| − | ===Table: SamplingPlot===
| + | |
| − | Informations about the sampling plots
| + | |
| − | {|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
| + | |
