Difference between revisions of "Internal - Modell for Monitoring"
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: | + | |-style="background:;" |
− | |no restrictions | + | |no_restrictions |
− | + | |there are no restrictions to access this entity | |
|-style="background:#FFC0CB;" | |-style="background:#FFC0CB;" | ||
− | | | + | |read_only |
− | | | + | |the access is limited to read only |
− | |||
− | |||
− | |||
|-style="background:#D3D3D3;" | |-style="background:#D3D3D3;" | ||
|inapplicable | |inapplicable | ||
− | | | + | |the entity is inapplicable |
− | |-style="background:# | + | |} |
− | | | + | |
− | | | + | |
+ | ====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 | ||
− | |||
− | |||
|-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) | ||
− | |||
− | |||
|-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 | ||
− | |||
− | |||
|-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 | ||
− | |||
− | |||
|-style="background:#FFFFFF;" | |-style="background:#FFFFFF;" | ||
|Description | |Description | ||
|nvarchar (MAX) | |nvarchar (MAX) | ||
|Description of the analysis | |Description of the analysis | ||
− | |||
− | |||
|-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 | ||
− | |||
− | |||
|-style="background:#FFFFFF;" | |-style="background:#FFFFFF;" | ||
|Notes | |Notes | ||
|nvarchar (MAX) | |nvarchar (MAX) | ||
|Notes concerning this analysis | |Notes concerning this analysis | ||
− | |||
− | |||
|-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 | ||
− | |||
− | |||
|-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)'' | ||
− | |||
− | |||
|-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()'' | ||
− | |||
− | |||
|-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()'' | ||
− | |||
− | |||
|-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()'' | ||
− | |||
− | |||
|-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()'' | ||
− | |||
− | |||
|-style="background:#FFFFFF;" | |-style="background:#FFFFFF;" | ||
|RowGUID | |RowGUID | ||
|uniqueidentifier | |uniqueidentifier | ||
|<br />''DefaultValue: newsequentialid()'' | |<br />''DefaultValue: newsequentialid()'' | ||
− | |||
− | |||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | '''Footnotes''': The following conventions and abbreviations have been used in the tables: Columns of primary key:<u>underlined</u> | + | '''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