measurement_id |
int4 |
10 |
|
|
|
|
|
person_id |
int4 |
10 |
|
|
|
|
person.person_id
|
fpk_measurement_person R |
|
measurement_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_measurement_concept R |
|
measurement_date |
date |
13 |
|
|
|
|
|
measurement_datetime |
timestamp |
29,6 |
√ |
|
null |
|
|
measurement_type_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_measurement_type_concept R |
|
operator_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_measurement_operator R |
|
value_as_number |
numeric |
131089 |
√ |
|
null |
|
|
value_as_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_measurement_value R |
|
unit_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_measurement_unit R |
|
range_low |
numeric |
131089 |
√ |
|
null |
|
|
range_high |
numeric |
131089 |
√ |
|
null |
|
|
provider_id |
int4 |
10 |
√ |
|
null |
|
provider.provider_id
|
fpk_measurement_provider R |
|
visit_occurrence_id |
int4 |
10 |
√ |
|
null |
|
|
visit_detail_id |
int4 |
10 |
√ |
|
null |
|
|
measurement_source_value |
varchar |
50 |
√ |
|
null |
|
|
measurement_source_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_measurement_concept_s R |
|
unit_source_value |
varchar |
50 |
√ |
|
null |
|
|
value_source_value |
varchar |
50 |
√ |
|
null |
|
|