common.units

Field	Type	Null	Default	Key	Extra	Comment
unit_id	int(11)	NO		PRI	auto_increment
unit_key	varchar(100)	NO		UNI		web safe key for unit
unit_abbr	varchar(100)	NO		UNI		user friendly abbreviation
unit_name	varchar(100)	NO		UNI		Fully qualified name i.e. Grams
unit_type	varchar(100)	NO				measurement type i.e. mass, length, ratio, etc
unit_num_type	varchar(100)	NO				if unit_type is ratio, outlines numerator unit_type
unit_den_type	varchar(100)	NO				if unit_type is ratio, outlines denominator unit_type
unit_is_type_base	varchar(100)	NO				For converting, indicates that this unit is base for offset and scale
unit_is_base	varchar(100)	NO				Indicates is base unit for given measurement system i.e. gram is base mass for metric
unit_is_metric	varchar(100)	NO				Its metric
unit_offset	double	NO	0			initial offset for converting i.e. C to F is 32
unit_scale	double	NO	0			scale for converting i.e. C to F is 1.8
unit_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
unit_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

unit_id

Table	Column
_1.encounters_soap_vitals	espv_weight_preferred_unit_id
_1.encounters_soap_vitals	espv_height_preferred_unit_id
_1.encounters_soap_vitals	espv_temp_preferred_unit_id
_1.radiology_results_test_codes_results	rrtcres_observ_unit_id
_1188.encounters_soap_vitals	espv_weight_preferred_unit_id
_1188.encounters_soap_vitals	espv_height_preferred_unit_id
_1188.encounters_soap_vitals	espv_temp_preferred_unit_id
_1188.radiology_results_test_codes_results	rrtcres_observ_unit_id
_1218.encounters_soap_vitals	espv_weight_preferred_unit_id
_1218.encounters_soap_vitals	espv_height_preferred_unit_id
_1218.encounters_soap_vitals	espv_temp_preferred_unit_id
_1218.radiology_results_test_codes_results	rrtcres_observ_unit_id
_1548.encounters_soap_vitals	espv_weight_preferred_unit_id
_1548.encounters_soap_vitals	espv_height_preferred_unit_id
_1548.encounters_soap_vitals	espv_temp_preferred_unit_id
_1548.radiology_results_test_codes_results	rrtcres_observ_unit_id
_435.encounters_soap_vitals	espv_weight_preferred_unit_id
_435.encounters_soap_vitals	espv_height_preferred_unit_id
_435.encounters_soap_vitals	espv_temp_preferred_unit_id
_435.procedures_results	pres_value_unit_id
_435.radiology_results_test_codes_results	rrtcres_observ_unit_id
_436.encounters_soap_vitals	espv_weight_preferred_unit_id
_436.encounters_soap_vitals	espv_height_preferred_unit_id
_436.encounters_soap_vitals	espv_temp_preferred_unit_id
_436.procedures_results	pres_value_unit_id
_436.radiology_results_test_codes_results	rrtcres_observ_unit_id
_436_archive_testing.encounters_soap_vitals	espv_weight_preferred_unit_id
_436_archive_testing.encounters_soap_vitals	espv_height_preferred_unit_id
_436_archive_testing.encounters_soap_vitals	espv_temp_preferred_unit_id
_436_archive_testing.procedures_results	pres_value_unit_id
_436_archive_testing.radiology_results_test_codes_results	rrtcres_observ_unit_id
_437.encounters_soap_vitals	espv_weight_preferred_unit_id
_437.encounters_soap_vitals	espv_height_preferred_unit_id
_437.encounters_soap_vitals	espv_temp_preferred_unit_id
_437.procedures_results	pres_value_unit_id
_437.radiology_results_test_codes_results	rrtcres_observ_unit_id
_8.encounters_soap_vitals	espv_weight_preferred_unit_id
_8.encounters_soap_vitals	espv_height_preferred_unit_id
_8.encounters_soap_vitals	espv_temp_preferred_unit_id
_8.radiology_results_test_codes_results	rrtcres_observ_unit_id
_81.encounters_soap_vitals	espv_weight_preferred_unit_id
_81.encounters_soap_vitals	espv_height_preferred_unit_id
_81.encounters_soap_vitals	espv_temp_preferred_unit_id
_81.radiology_results_test_codes_results	rrtcres_observ_unit_id
_999.encounters_soap_vitals	espv_weight_preferred_unit_id
_999.encounters_soap_vitals	espv_height_preferred_unit_id
_999.encounters_soap_vitals	espv_temp_preferred_unit_id
_999.radiology_results_test_codes_results	rrtcres_observ_unit_id

unit_type

Table	Column
_435.procedures_panels_codes	prpac_unit_type
_436.procedures_panels_codes	prpac_unit_type
_436_archive_testing.procedures_panels_codes	prpac_unit_type
_437.procedures_panels_codes	prpac_unit_type

unit_key

Table	Column
_435.procedures_results	pres_value_unit_key
_436.procedures_results	pres_value_unit_key
_436_archive_testing.procedures_results	pres_value_unit_key
_437.procedures_results	pres_value_unit_key