this_is_a_test


Columns

Column Type Size Nulls Auto Default Children Parents Comments
patient_id uuid 2147483647 √ null
recorded_at timestamp 29,6 √ null
status varchar 2147483647 √ null
gender varchar 2147483647 √ null
age int4 10 √ null
age_updated_at timestamp 29,6 √ null
date_of_birth date 13 √ null
current_age float8 17,17 √ null
month_date date 13 √ null
month float8 17,17 √ null
quarter float8 17,17 √ null
year float8 17,17 √ null
month_string text 2147483647 √ null
quarter_string text 2147483647 √ null
hypertension text 2147483647 √ null
prior_heart_attack text 2147483647 √ null
prior_stroke text 2147483647 √ null
chronic_kidney_disease text 2147483647 √ null
receiving_treatment_for_hypertension text 2147483647 √ null
diabetes text 2147483647 √ null
assigned_facility_id uuid 2147483647 √ null
assigned_facility_size varchar 2147483647 √ null
assigned_facility_type varchar 2147483647 √ null
assigned_facility_slug varchar 2147483647 √ null
assigned_facility_region_id uuid 2147483647 √ null
assigned_block_slug varchar 2147483647 √ null
assigned_block_region_id uuid 2147483647 √ null
assigned_district_slug varchar 2147483647 √ null
assigned_district_region_id uuid 2147483647 √ null
assigned_state_slug varchar 2147483647 √ null
assigned_state_region_id uuid 2147483647 √ null
assigned_organization_slug varchar 2147483647 √ null
assigned_organization_region_id uuid 2147483647 √ null
registration_facility_id uuid 2147483647 √ null
registration_facility_size varchar 2147483647 √ null
registration_facility_type varchar 2147483647 √ null
registration_facility_slug varchar 2147483647 √ null
registration_facility_region_id uuid 2147483647 √ null
registration_block_slug varchar 2147483647 √ null
registration_block_region_id uuid 2147483647 √ null
registration_district_slug varchar 2147483647 √ null
registration_district_region_id uuid 2147483647 √ null
registration_state_slug varchar 2147483647 √ null
registration_state_region_id uuid 2147483647 √ null
registration_organization_slug varchar 2147483647 √ null
registration_organization_region_id uuid 2147483647 √ null
blood_pressure_id uuid 2147483647 √ null
bp_facility_id uuid 2147483647 √ null
bp_recorded_at timestamp 29,6 √ null
systolic int4 10 √ null
diastolic int4 10 √ null
blood_sugar_id uuid 2147483647 √ null
bs_facility_id uuid 2147483647 √ null
bs_recorded_at timestamp 29,6 √ null
blood_sugar_type varchar 2147483647 √ null
blood_sugar_value numeric 0 √ null
blood_sugar_risk_state text 2147483647 √ null
encounter_id uuid 2147483647 √ null
encounter_recorded_at timestamp 29,6 √ null
prescription_drug_id uuid 2147483647 √ null
prescription_drug_recorded_at timestamp 29,6 √ null
appointment_id uuid 2147483647 √ null
appointment_recorded_at timestamp 29,6 √ null
visited_facility_ids _uuid 2147483647 √ null
months_since_registration float8 17,17 √ null
quarters_since_registration float8 17,17 √ null
months_since_visit float8 17,17 √ null
quarters_since_visit float8 17,17 √ null
months_since_bp float8 17,17 √ null
quarters_since_bp float8 17,17 √ null
months_since_bs float8 17,17 √ null
quarters_since_bs float8 17,17 √ null
last_bp_state text 2147483647 √ null
htn_care_state text 2147483647 √ null
htn_treatment_outcome_in_last_3_months text 2147483647 √ null
htn_treatment_outcome_in_last_2_months text 2147483647 √ null
htn_treatment_outcome_in_quarter text 2147483647 √ null
diabetes_treatment_outcome_in_last_3_months text 2147483647 √ null
diabetes_treatment_outcome_in_last_2_months text 2147483647 √ null
diabetes_treatment_outcome_in_quarter text 2147483647 √ null
titrated bool 1 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views