Internal - Modell for Monitoring

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