Difference between revisions of "Internal - Modell for Monitoring"

From Diversitymobile Wiki
Jump to navigation Jump to search
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;
 
{|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;"
 
|-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:#FFFFFF;"
 
|hidden
 
|The entity is hidden from a user interface
 
 
|-style="background:#D3D3D3;"
 
|-style="background:#D3D3D3;"
 
|inapplicable
 
|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
+
 
 +
====Color code 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
 
|}
 
|}
  
Line 26: Line 34:
 
!Data type
 
!Data type
 
!Description
 
!Description
!Requ.
 
!Ind.
 
 
|-style="background:#FFFFFF;"
 
|-style="background:#FFFFFF;"
 
|<u>AnalysisID</u>
 
|<u>AnalysisID</u>
 
|int
 
|int
 
|ID of the analysis (Primary key)
 
|ID of the analysis (Primary key)
|R
 
|U
 
 
|-style="background:#FFFFFF;"
 
|-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
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-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
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-style="background:#FFFFFF;"
 
|Description
 
|Description
 
|nvarchar (MAX)
 
|nvarchar (MAX)
 
|Description of the analysis
 
|Description of the analysis
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-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
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-style="background:#FFFFFF;"
 
|Notes
 
|Notes
 
|nvarchar (MAX)
 
|nvarchar (MAX)
 
|Notes concerning this analysis
 
|Notes concerning this analysis
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-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
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-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)''
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-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()''
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-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()''
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-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()''
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-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()''
|&nbsp; - &nbsp;
 
|&nbsp; - &nbsp;
 
 
|-style="background:#FFFFFF;"
 
|-style="background:#FFFFFF;"
 
|RowGUID
 
|RowGUID
 
|uniqueidentifier
 
|uniqueidentifier
 
|<br />''DefaultValue: newsequentialid()''
 
|<br />''DefaultValue: newsequentialid()''
|R
 
|&nbsp; - &nbsp;
 
 
|}
 
|}
  
 
 
<u>'''Relations to other tables'''</u>
 
 
{|
 
|'''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:<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>

Revision as of 09:16, 11 September 2013

Color code accessibility

no_restrictions there are no restrictions to access this entity
read_only the access is limited to read only
inapplicable the entity is inapplicable


Color code determination

user_defined the value can be defined by the user
service_link the value represents a link to a module
calculated the value is calculated by the system e.g. from other entries


Table: Analysis

Analysis types used within the database

Column Data type Description
AnalysisID 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
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()



Footnotes: The following conventions and abbreviations have been used in the tables: Columns of primary key:underlined