Internal - Modell for Monitoring - Revision history

Mweiss at 10:41, 12 September 2013

2013-09-12T10:41:26Z

Show changes

Triebel: Blanked the page

2013-09-11T13:46:31Z

Blanked the page

Mweiss at 13:19, 11 September 2013

2013-09-11T13:19:14Z

Mweiss at 09:16, 11 September 2013

2013-09-11T09:16:18Z

Mweiss at 08:19, 11 September 2013

2013-09-11T08:19:46Z

Show changes

Mweiss at 08:02, 11 September 2013

2013-09-11T08:02:27Z

Mweiss: Created page with '====Color code==== {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; border:1px #AAA solid; border-collapse:collapse; empty-cells:show; |-style="background:#FFFFFF;" |no re…'

2013-09-11T07:57:37Z

Created page with '====Color code==== {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; border:1px #AAA solid; border-collapse:collapse; empty-cells:show; |-style="background:#FFFFFF;" |no re…'

Show changes

← Older revision		Revision as of 13:46, 11 September 2013
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>~~

@@ Line 1: / Line 1: @@
-====Color code accessibility====
+====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:;"
@@ Line 13: / Line 13: @@
-====Color code determination====
+====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:;"
@@ Line 29: / Line 29: @@
 ===Table: Analysis===
 Analysis types used within the database
-{|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:#FFC0CB;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
-|-style="text-align:left; background:#FFFFFF;"
+|-style="text-align:left; background:#FFC0CB;"
 !Column
 !Data type
 !Description
-|-style="background:#FFFFFF;"
+|-
 |<u>AnalysisID</u>
 |int
 |ID of the analysis (Primary key)
-|-style="background:#FFFFFF;"
+|-
 |AnalysisParentID
 |int
 |Analysis ID of the parent analysis if it belongs to a certain type documented in this table
-|-style="background:#FFFFFF;"
+|-
 |DisplayText
 |nvarchar (50)
 |Name of the analysis as e.g. shown in user interface
-|-style="background:#FFFFFF;"
+|-
 |Description
 |nvarchar (MAX)
 |Description of the analysis
-|-style="background:#FFFFFF;"
+|-
 |MeasurementUnit
 |nvarchar (50)
 |The measurement unit used for the analysis, e.g. mm, µmol, kg
-|-style="background:#FFFFFF;"
+|-
 |Notes
 |nvarchar (MAX)
 |Notes concerning this analysis
-|-style="background:#FFFFFF;"
+|-
 |AnalysisURI
 |varchar (255)
 |URI referring to an external documentation of the analysis
-|-style="background:#FFFFFF;"
+|-
 |OnlyHierarchy
 |bit
 |If the entry is only used for the hierarchical arrangement of the entries<br />''DefaultValue: (0)''
-|-style="background:#FFFFFF;"
+|-
 |LogCreatedWhen
 |datetime
 |The time when this dataset was created<br />''DefaultValue: getdate()''
-|-style="background:#FFFFFF;"
+|-
 |LogCreatedBy
 |nvarchar (50)
 |Who created this dataset<br />''DefaultValue: user_name()''
-|-style="background:#FFFFFF;"
+|-
 |LogUpdatedWhen
 |datetime
 |The last time when this dataset was updated<br />''DefaultValue: getdate()''
-|-style="background:#FFFFFF;"
+|-
 |LogUpdatedBy
 |nvarchar (50)
 |Who was the last to update this dataset<br />''DefaultValue: user_name()''
-|-style="background:#FFFFFF;"
+|-
 |RowGUID
 |uniqueidentifier

@@ Line 1: / Line 1: @@
-====Color code====
+====Color code accessibility====
 {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; border:1px #AAA solid; border-collapse:collapse; empty-cells:show;
-|-style="background:#FFFFFF;"
+|-style="background:;"
-|no restrictions
+|no_restrictions
-|The value of this entity has no restriction
+|there are no restrictions to access this entity
 |-style="background:#FFC0CB;"
-|read only
+|read_only
-|The access to this entity is restricted to read only
+|the access is limited to read only
 |-style="background:#D3D3D3;"
 |inapplicable
-|This entity is not applicable in the given context
+|the entity is inapplicable
-|-style="background:#FFFFFF;"
+|}
-|preset
-|The value of this entity is set by the program, not by the user
 |}
@@ Line 26: / Line 34: @@
 !Data type
 !Description
 |-style="background:#FFFFFF;"
 |<u>AnalysisID</u>
 |int
 |ID of the analysis (Primary key)
 |-style="background:#FFFFFF;"
 |AnalysisParentID
 |int
 |Analysis ID of the parent analysis if it belongs to a certain type documented in this table
 |-style="background:#FFFFFF;"
 |DisplayText
 |nvarchar (50)
 |Name of the analysis as e.g. shown in user interface
 |-style="background:#FFFFFF;"
 |Description
 |nvarchar (MAX)
 |Description of the analysis
 |-style="background:#FFFFFF;"
 |MeasurementUnit
 |nvarchar (50)
 |The measurement unit used for the analysis, e.g. mm, µmol, kg
 |-style="background:#FFFFFF;"
 |Notes
 |nvarchar (MAX)
 |Notes concerning this analysis
 |-style="background:#FFFFFF;"
 |AnalysisURI
 |varchar (255)
 |URI referring to an external documentation of the analysis
 |-style="background:#FFFFFF;"
 |OnlyHierarchy
 |bit
 |If the entry is only used for the hierarchical arrangement of the entries<br />''DefaultValue: (0)''
 |-style="background:#FFFFFF;"
 |LogCreatedWhen
 |datetime
 |The time when this dataset was created<br />''DefaultValue: getdate()''
 |-style="background:#FFFFFF;"
 |LogCreatedBy
 |nvarchar (50)
 |Who created this dataset<br />''DefaultValue: user_name()''
 |-style="background:#FFFFFF;"
 |LogUpdatedWhen
 |datetime
 |The last time when this dataset was updated<br />''DefaultValue: getdate()''
 |-style="background:#FFFFFF;"
 |LogUpdatedBy
 |nvarchar (50)
 |Who was the last to update this dataset<br />''DefaultValue: user_name()''
 |-style="background:#FFFFFF;"
 |RowGUID
 |uniqueidentifier
 |<br />''DefaultValue: newsequentialid()''
 |}
-'''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
+'''Footnotes''': The following conventions and abbreviations have been used in the tables: Columns of primary key:<u>underlined</u>

@@ Line 10: / Line 10: @@
 |hidden
 |The entity is hidden from a user interface
 |-style="background:#FFFFFF;"
 |preset