latest_blood_pressures_per_patient_per_months

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

bp_id

uuid

2147483647

√

null

patient_id

uuid

2147483647

√

null

registration_facility_id

uuid

2147483647

√

null

assigned_facility_id

uuid

2147483647

√

null

patient_status

varchar

2147483647

√

null

bp_facility_id

uuid

2147483647

√

null

bp_recorded_at

timestamp

29,6

√

null

patient_recorded_at

timestamp

29,6

√

null

systolic

int4

√

null

diastolic

int4

√

null

deleted_at

timestamp

29,6

√

null

medical_history_hypertension

text

2147483647

√

null

month

text

2147483647

√

null

quarter

text

2147483647

√

null

year

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT DISTINCT ON (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('month'::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.patient_id,
    patients.registration_facility_id,
    patients.assigned_facility_id,
    patients.status AS patient_status,
    blood_pressures.facility_id AS bp_facility_id,
    timezone('UTC'::text, timezone('UTC'::text, blood_pressures.recorded_at)) AS bp_recorded_at,
    timezone('UTC'::text, timezone('UTC'::text, patients.recorded_at)) AS patient_recorded_at,
    blood_pressures.systolic,
    blood_pressures.diastolic,
    timezone('UTC'::text, timezone('UTC'::text, blood_pressures.deleted_at)) AS deleted_at,
    medical_histories.hypertension AS medical_history_hypertension,
    (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 patients ON ((patients.id = blood_pressures.patient_id)))
     LEFT JOIN medical_histories ON ((medical_histories.patient_id = blood_pressures.patient_id)))
  WHERE ((blood_pressures.deleted_at IS NULL) AND (patients.deleted_at IS NULL))
  ORDER BY 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('month'::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;

latest_blood_pressures_per_patient_per_months

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views