Difference between revisions of "Internal - Modell for Monitoring"
Jump to navigation
Jump to search
| 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:# | + | {|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:# | + | |-style="text-align:left; background:#FFC0CB;" |
!Column | !Column | ||
!Data type | !Data type | ||
!Description | !Description | ||
| − | |- | + | |- |
|<u>AnalysisID</u> | |<u>AnalysisID</u> | ||
|int | |int | ||
|ID of the analysis (Primary key) | |ID of the analysis (Primary key) | ||
| − | |- | + | |- |
|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 | ||
| − | |- | + | |- |
|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 | ||
| − | |- | + | |- |
|Description | |Description | ||
|nvarchar (MAX) | |nvarchar (MAX) | ||
|Description of the analysis | |Description of the analysis | ||
| − | |- | + | |- |
|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 | ||
| − | |- | + | |- |
|Notes | |Notes | ||
|nvarchar (MAX) | |nvarchar (MAX) | ||
|Notes concerning this analysis | |Notes concerning this analysis | ||
| − | |- | + | |- |
|AnalysisURI | |AnalysisURI | ||
|varchar (255) | |varchar (255) | ||
|URI referring to an external documentation of the analysis | |URI referring to an external documentation of the analysis | ||
| − | |- | + | |- |
|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)'' | ||
| − | |- | + | |- |
|LogCreatedWhen | |LogCreatedWhen | ||
|datetime | |datetime | ||
|The time when this dataset was created<br />''DefaultValue: getdate()'' | |The time when this dataset was created<br />''DefaultValue: getdate()'' | ||
| − | |- | + | |- |
|LogCreatedBy | |LogCreatedBy | ||
|nvarchar (50) | |nvarchar (50) | ||
|Who created this dataset<br />''DefaultValue: user_name()'' | |Who created this dataset<br />''DefaultValue: user_name()'' | ||
| − | |- | + | |- |
|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()'' | ||
| − | |- | + | |- |
|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()'' | ||
| − | |- | + | |- |
|RowGUID | |RowGUID | ||
|uniqueidentifier | |uniqueidentifier | ||
Revision as of 13:19, 11 September 2013
Color code for 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 for 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