Add bp

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/weight.sql b/sql/weight.sql
index e97bf057..e1104342 100644
--- a/sql/weight.sql
+++ b/sql/weight.sql
@@ -10,6 +10,11 @@ create table weight.bp (
        kind                      text check (kind in ('standard', 'home', 'doctor')) default 'standard' not null
 );
 
+create table weight.pressure_medication (
+       taken_at                  timestamp with time zone primary key default now(),
+       dose_mg                   numeric(3, 1) not null
+);
+
 create schema zqxjk;
 
 create view zqxjk.weight as (
@@ -27,6 +32,13 @@ create view zqxjk.bp_standard_measure as (
         from   weight.bp
 );
 
+create view zqxjk.pressure_medication as (
+        select to_char(taken_at, 'YYYY-MM-DD"T"HH24:MI:SSOF') as _id,
+               taken_at || ' ' || dose_mg || 'mg' as _display,
+               dose_mg
+        from   weight.pressure_medication
+);
+
 create view zqxjk.admin_weight as (
         select to_char(measured_at, 'YYYY-MM-DD"T"HH24:MI:SSOF') as _id,
                measured_at || ' ' || value as _display,
@@ -43,3 +55,4 @@ create table zqxjk._tables (
 insert into zqxjk._tables(name, default_sort) values ('weight', '{"_id", "desc"}');
 insert into zqxjk._tables(name, default_sort) values ('admin_weight', '{"_id", "desc"}');
 insert into zqxjk._tables(name, default_sort) values ('bp_standard_measure', '{"_id", "desc"}');
+insert into zqxjk._tables(name, default_sort) values ('pressure_medication', '{"_id", "desc"}');