Difference between revisions of "Internal - Modell for Monitoring"

@@ Line 1: / Line 1: @@
-====Color code for accessibility====
-{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; border:1px #AAA solid; border-collapse:collapse; empty-cells:show;
-|-style="background:;"
-|no_restrictions
-|there are no restrictions to access this entity
-|-style="background:#FFC0CB;"
-|read_only
-|the access is limited to read only
-|-style="background:#D3D3D3;"
-|inapplicable
-|the entity is inapplicable
-|}
-====Color code for determination====
-{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; border:1px #AAA solid; border-collapse:collapse; empty-cells:show;
-|-style="background:;"
-|user_defined
-|the value can be defined by the user
-|-style="background:#00FFFF;"
-|service_link
-|the value represents a link to a module
-|-style="background:#FFFF00;"
-|calculated
-|the value is calculated by the system e.g. from other entries
-|}
-===Table: Analysis===
-Analysis types used within the database
-{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFC0CB;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
-|-style="text-align:left; background:#FFC0CB;"
-!Column
-!Data type
-!Description
-|-
-|<u>AnalysisID</u>
-|int
-|ID of the analysis (Primary key)
-|-
-|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<br />''DefaultValue: (0)''
-|-
-|LogCreatedWhen
-|datetime
-|The time when this dataset was created<br />''DefaultValue: getdate()''
-|-
-|LogCreatedBy
-|nvarchar (50)
-|Who created this dataset<br />''DefaultValue: user_name()''
-|-
-|LogUpdatedWhen
-|datetime
-|The last time when this dataset was updated<br />''DefaultValue: getdate()''
-|-
-|LogUpdatedBy
-|nvarchar (50)
-|Who was the last to update this dataset<br />''DefaultValue: user_name()''
-|-
-|RowGUID
-|uniqueidentifier
-|<br />''DefaultValue: newsequentialid()''
-|}
-'''Footnotes''': The following conventions and abbreviations have been used in the tables: Columns of primary key:<u>underlined</u>

Difference between revisions of "Internal - Modell for Monitoring"

Revision as of 13:46, 11 September 2013

Navigation menu

Search