DiversitySamplingPlots Information Models
From Diversity Workbench
Revision as of 15:53, 30 June 2014 by Wolfgang Reichert (Talk | contribs)
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... | - |
