Internal - Modell for Monitoring - Revision history

Mweiss at 10:41, 12 September 2013

2013-09-12T10:41:26Z

Triebel: Blanked the page

2013-09-11T13:46:31Z

Blanked the page

← Older revision		Revision as of 15: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>~~

Mweiss at 13:19, 11 September 2013

2013-09-11T13:19:14Z

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

Mweiss at 09:16, 11 September 2013

2013-09-11T09:16:18Z

Show changes

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

← Older revision		Revision as of 10:02, 11 September 2013
Line 10:		Line 10:
	\|hidden		\|hidden
	\|The entity is hidden from a user interface		\|The entity is hidden from a user interface
			\|-style="background:#D3D3D3;"
			\|inapplicable
			\|This entity is not applicable in the given context
	\|-style="background:#FFFFFF;"		\|-style="background:#FFFFFF;"
	\|preset		\|preset

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 15: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>~~