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