urinalysis

Qualitative and semi-quantitative test array using reagent test strips to indicate possible abnormalities in a sample of urine, often performed as part of Point of Care Testing (P…

Qualitative and semi-quantitative test array using reagent test strips to indicate possible abnormalities in a sample of urine, often performed as part of Point of Care Testing (POCT).

Purpose. To record the results of a qualitative and semi-quantitative test array using reagent test strips to indicate possible abnormalities in a sample of urine.

Source

Columns

Constraints

check ((glucose_code is null and glucose_system is null and glucose_numeric is null and glucose is null) or (glucose_valueset_id is not null and glucose_code is not null and glucose_system is not null and glucose_numeric is not null and glucose is not null))
check ((bilirubin_code is null and bilirubin_system is null and bilirubin_numeric is null and bilirubin is null) or (bilirubin_valueset_id is not null and bilirubin_code is not null and bilirubin_system is not null and bilirubin_numeric is not null and bilirubin is not null))
check ((ketones_code is null and ketones_system is null and ketones_numeric is null and ketones is null) or (ketones_valueset_id is not null and ketones_code is not null and ketones_system is not null and ketones_numeric is not null and ketones is not null))
check ((specific_gravity_code is null and specific_gravity_system is null and specific_gravity_numeric is null and specific_gravity is null) or (specific_gravity_valueset_id is not null and specific_gravity_code is not null and specific_gravity_system is not null and specific_gravity_numeric is not null and specific_gravity is not null))
check ((blood_code is null and blood_system is null and blood_numeric is null and blood is null) or (blood_valueset_id is not null and blood_code is not null and blood_system is not null and blood_numeric is not null and blood is not null))
check ((p_h_code is null and p_h_system is null and p_h_numeric is null and p_h is null) or (p_h_valueset_id is not null and p_h_code is not null and p_h_system is not null and p_h_numeric is not null and p_h is not null))
check ((protein_code is null and protein_system is null and protein_numeric is null and protein is null) or (protein_valueset_id is not null and protein_code is not null and protein_system is not null and protein_numeric is not null and protein is not null))
check ((urobilinogen_code is null and urobilinogen_system is null and urobilinogen_numeric is null and urobilinogen is null) or (urobilinogen_valueset_id is not null and urobilinogen_code is not null and urobilinogen_system is not null and urobilinogen_numeric is not null and urobilinogen is not null))
check ((nitrite_code is null and nitrite_system is null and nitrite_numeric is null and nitrite is null) or (nitrite_valueset_id is not null and nitrite_code is not null and nitrite_system is not null and nitrite_numeric is not null and nitrite is not null))
check ((leukocytes_code is null and leukocytes_system is null and leukocytes_numeric is null and leukocytes is null) or (leukocytes_valueset_id is not null and leukocytes_code is not null and leukocytes_system is not null and leukocytes_numeric is not null and leukocytes is not null))
check ((clinical_interpretation_code is null and clinical_interpretation_system is null and clinical_interpretation_valueset_id is null) or (clinical_interpretation is not null and clinical_interpretation_code is not null and clinical_interpretation_system is not null and clinical_interpretation_valueset_id is not null))
check ((method_code is null and method_system is null and method_valueset_id is null and method is null) or (method is not null and method_code is not null and method_system is not null and method_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• urinalysis_exam_not_done via urinalysis_id

Indexes

• urinalysis_form_id_idx on form_id
• urinalysis_reagent_strips_idx on reagent_strips
• urinalysis_device_idx on device

Child tables

1 table hang off urinalysis, one row per repetition.

urinalysis_exam_not_done

Child table — one row per repetition, deleted with its parent.

Unique

• urinalysis_id, position
• urinalysis_id, exclusion_exam_id

References

Indexes

• urinalysis_exam_not_done_exclusion_exam_id_idx on exclusion_exam_id

Value sets