blood_pressures_per_facility_per_days

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

bp_count

int8

19

√

null

facility_id

uuid

2147483647

√

null

deleted_at

timestamp

29,6

√

null

day

text

2147483647

√

null

month

text

2147483647

√

null

quarter

text

2147483647

√

null

year

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

WITH latest_bp_per_patient_per_day AS (
         SELECT DISTINCT ON (blood_pressures.facility_id, blood_pressures.patient_id, (date_part('year'::text, timezone(( SELECT current_setting('TIMEZONE'::text) AS current_setting), timezone('utc'::text, blood_pressures.recorded_at))))::text, (date_part('doy'::text, timezone(( SELECT current_setting('TIMEZONE'::text) AS current_setting), timezone('utc'::text, blood_pressures.recorded_at))))::text) blood_pressures.id AS bp_id,
            blood_pressures.facility_id,
            (date_part('doy'::text, timezone(( SELECT current_setting('TIMEZONE'::text) AS current_setting), timezone('utc'::text, blood_pressures.recorded_at))))::text AS day,
            (date_part('month'::text, timezone(( SELECT current_setting('TIMEZONE'::text) AS current_setting), timezone('utc'::text, blood_pressures.recorded_at))))::text AS month,
            (date_part('quarter'::text, timezone(( SELECT current_setting('TIMEZONE'::text) AS current_setting), timezone('utc'::text, blood_pressures.recorded_at))))::text AS quarter,
            (date_part('year'::text, timezone(( SELECT current_setting('TIMEZONE'::text) AS current_setting), timezone('utc'::text, blood_pressures.recorded_at))))::text AS year
           FROM (blood_pressures
             JOIN medical_histories ON (((blood_pressures.patient_id = medical_histories.patient_id) AND (medical_histories.hypertension = 'yes'::text))))
          WHERE (blood_pressures.deleted_at IS NULL)
          ORDER BY blood_pressures.facility_id, blood_pressures.patient_id, (date_part('year'::text, timezone(( SELECT current_setting('TIMEZONE'::text) AS current_setting), timezone('utc'::text, blood_pressures.recorded_at))))::text, (date_part('doy'::text, timezone(( SELECT current_setting('TIMEZONE'::text) AS current_setting), timezone('utc'::text, blood_pressures.recorded_at))))::text, blood_pressures.recorded_at DESC, blood_pressures.id
        )
 SELECT count(latest_bp_per_patient_per_day.bp_id) AS bp_count,
    facilities.id AS facility_id,
    timezone(( SELECT current_setting('TIMEZONE'::text) AS current_setting), timezone('utc'::text, facilities.deleted_at)) AS deleted_at,
    latest_bp_per_patient_per_day.day,
    latest_bp_per_patient_per_day.month,
    latest_bp_per_patient_per_day.quarter,
    latest_bp_per_patient_per_day.year
   FROM (latest_bp_per_patient_per_day
     JOIN facilities ON ((facilities.id = latest_bp_per_patient_per_day.facility_id)))
  GROUP BY latest_bp_per_patient_per_day.day, latest_bp_per_patient_per_day.month, latest_bp_per_patient_per_day.quarter, latest_bp_per_patient_per_day.year, facilities.deleted_at, facilities.id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views