Page Comparison

...

Column Name	Data Type	Description
`concept_reference_range_id`	`INT`	Primary key. Unique identifier for each concept reference range.
`concept_id`	`INT`	Foreign key linking to `concept_numeric`.
`criteria`	`VARCHAR`	An expression that specifies conditions for when the reference range is applicable.
`hi_critical`	`DOUBLE`	The high critical for the concept.
`hi_normal`	`DOUBLE`	The high normal for the concept.
`hi_absolute`	`DOUBLE`	The upper high absolute for the concept.
`low_critical`	`DOUBLE`	The lower low critical for the concept.
`low_normal`	`DOUBLE`	The lower low normal for the concept.
`low_absolute`	`DOUBLE`	The lower low absolute for the concept.

RelationshipsRelationship:

1:N relationship with concept_numeric: A single concept can have multiple reference ranges based on different criteria.

...

Column Name	Data Type	Description
`obs_reference_range_id`	`INT`	Primary key. Unique identifier for each observation reference range.
`obs_id`	`INT`	Foreign key linking to the `obs` table.
`hi_critical`	`DOUBLE`	The high critical limit for the observation.
`hi_normal`	`DOUBLE`	The high normal limit for the observation.
`hi_absolute`	`DOUBLE`	The high absolute limit for the observation.
`low_critical`	`DOUBLE`	The low critical limit for the observation.
`low_normal`	`DOUBLE`	The low normal limit for the observation.
`low_absolute`	`DOUBLE`	The low absolute limit for the observation.

RelationshipsRelationship:

Has 1:1 relationship with obs: Each observation has one associated reference range.

Versions Compared