|
|
| Line 1: |
Line 1: |
| ====Color code for accessibility====
| |
| {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; border:1px #AAA solid; border-collapse:collapse; empty-cells:show;
| |
| |-style="background:;"
| |
| |no_restrictions
| |
| |there are no restrictions to access this entity
| |
| |-style="background:#FFC0CB;"
| |
| |read_only
| |
| |the access is limited to read only
| |
| |-style="background:#D3D3D3;"
| |
| |inapplicable
| |
| |the entity is inapplicable
| |
| |}
| |
|
| |
|
|
| |
| ====Color code for 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
| |
| |}
| |
|
| |
|
| |
| ===Table: Analysis===
| |
| Analysis types used within the database
| |
| {|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:#FFC0CB;"
| |
| !Column
| |
| !Data type
| |
| !Description
| |
| |-
| |
| |<u>AnalysisID</u>
| |
| |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<br />''DefaultValue: (0)''
| |
| |-
| |
| |LogCreatedWhen
| |
| |datetime
| |
| |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| |-
| |
| |LogCreatedBy
| |
| |nvarchar (50)
| |
| |Who created this dataset<br />''DefaultValue: user_name()''
| |
| |-
| |
| |LogUpdatedWhen
| |
| |datetime
| |
| |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| |-
| |
| |LogUpdatedBy
| |
| |nvarchar (50)
| |
| |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| |-
| |
| |RowGUID
| |
| |uniqueidentifier
| |
| |<br />''DefaultValue: newsequentialid()''
| |
| |}
| |
|
| |
|
| |
|
| |
|
| |
| '''Footnotes''': The following conventions and abbreviations have been used in the tables: Columns of primary key:<u>underlined</u>
| |