Difference between revisions of "DiversitySamplingPlots Information Models"
From Diversity Workbench
| Line 1: | Line 1: | ||
| − | =under construction | + | = *** 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;" | {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;" | ||
| Line 12: | Line 12: | ||
|-style="text-align:left; background:#F5F5F5;" | |-style="text-align:left; background:#F5F5F5;" | ||
|Suggested citation | |Suggested citation | ||
| − | |M. Weiss, W. Reichert (2014). DiversitySamplingPlots information model (version 03.00.05). http://diversityworkbench.net/Portal/ | + | |M. Weiss, W. Reichert (2014). DiversitySamplingPlots information model (version 03.00.05). http://diversityworkbench.net/Portal/SamplingPlotsModel_v03.00.05. |
|- | |- | ||
|-style="text-align:left; background:#FFFFFF;" | |-style="text-align:left; background:#FFFFFF;" | ||
|Notes | |Notes | ||
|The models currently reside in MS SQL Server, so knowledge of some [[SQL Server ER-diagram conventions]] will be helpful. | |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: | + | Besides the screen shots below, a [[Media:DiversitySamplingPlots_030005.txt|Microsoft T-SQL-Script]] for the generation of the tables is provided. |
|} | |} | ||
---- | ---- | ||
Revision as of 15:53, 30 June 2014
Contents
*** under construction *** - DiversitySamplingPlots Information Model (version 03.00.05, 01. July 2014)
| Authors | M. Weiss, W. Reichert 2014 |
| License | 
|
| Suggested citation | M. Weiss, W. Reichert (2014). DiversitySamplingPlots information model (version 03.00.05). http://diversityworkbench.net/Portal/SamplingPlotsModel_v03.00.05. |
| 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 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
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:
- “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
| Column | Data type | Description | Requ. | Ind. |
|---|---|---|---|---|
| todo... | ||||
| todo... | - |
