Internal - Modell for Monitoring

From Diversitymobile Wiki
Revision as of 08:19, 11 September 2013 by Mweiss (talk | contribs)
Jump to navigation Jump to search

Color code

no restrictions The value of this entity has no restriction
read only The access to this entity is restricted to read only
hidden The entity is hidden from a user interface
inapplicable This entity is not applicable in the given context
preset The value of this entity is set by the program, not by the user


Table: Analysis

Analysis types used within the database

Column Data type Description Requ. Ind.
AnalysisID int ID of the analysis (Primary key) R U
AnalysisParentID int Analysis ID of the parent analysis if it belongs to a certain type documented in this table   -     -  
DisplayText nvarchar (50) Name of the analysis as e.g. shown in user interface   -     -  
Description nvarchar (MAX) Description of the analysis   -     -  
MeasurementUnit nvarchar (50) The measurement unit used for the analysis, e.g. mm, µmol, kg   -     -  
Notes nvarchar (MAX) Notes concerning this analysis   -     -  
AnalysisURI varchar (255) URI referring to an external documentation of the analysis   -     -  
OnlyHierarchy bit If the entry is only used for the hierarchical arrangement of the entries
DefaultValue: (0)
  -     -  
LogCreatedWhen datetime The time when this dataset was created
DefaultValue: getdate()
  -     -  
LogCreatedBy nvarchar (50) Who created this dataset
DefaultValue: user_name()
  -     -  
LogUpdatedWhen datetime The last time when this dataset was updated
DefaultValue: getdate()
  -     -  
LogUpdatedBy nvarchar (50) Who was the last to update this dataset
DefaultValue: user_name()
  -     -  
RowGUID uniqueidentifier
DefaultValue: newsequentialid()
R   -  


Relations to other tables

Columns Related table Columns in related table Update rule Delete rule
AnalysisParentID Analysis AnalysisID NO ACTION NO ACTION


Footnotes: The following conventions and abbreviations have been used in the tables: Columns of primary key:underlined R: It is required to enter data in this field. I: The field is indexed to enable faster searching. U: unique index