Internal - Modell for Monitoring
Jump to navigation
Jump to search
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