1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
create table weight.weight (
measured_at timestamp with time zone primary key default now(),
value numeric(4,1) not null
);
create table weight.bp (
measured_at timestamp with time zone primary key default now(),
systolic numeric(3, 0) not null,
diastolic numeric(3, 0) not null
);
create schema zqxjk;
create view zqxjk.weight as (
select to_char(measured_at, 'YYYY-MM-DD"T"HH24:MI:SSOF') as _id,
measured_at || ' ' || value as _display,
value
from weight.weight
);
create view zqxjk.bp as (
select to_char(measured_at, 'YYYY-MM-DD"T"HH24:MI:SSOF') as _id,
measured_at || ' ' || systolic || '-' || diastolic as _display,
systolic,
diastolic
from weight.bp
);
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,
measured_at,
value
from weight.weight
);
create table zqxjk._tables (
name text primary key,
default_sort text[]
);
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', '{"_id", "desc"}');
|
