-
Notifications
You must be signed in to change notification settings - Fork 19
/
0086.sql
62 lines (58 loc) · 2.63 KB
/
0086.sql
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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
CREATE TABLE ag.vioscreen_foodcomponents (
id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
sessionId varchar NOT NULL,
code varchar NOT NULL,
amount float NOT NULL,
UNIQUE (sessionId, code),
FOREIGN KEY (sessionId) REFERENCES ag.vioscreen_sessions (sessionId)
);
CREATE INDEX vio_foodc_by_sessionid ON ag.vioscreen_foodcomponents(sessionId);
CREATE UNIQUE INDEX vio_foodc_by_sessionidcode ON ag.vioscreen_foodcomponents(sessionId, code);
CREATE TABLE ag.vioscreen_eatingpatterns (
id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
sessionId varchar NOT NULL,
code varchar NOT NULL,
amount float NOT NULL,
UNIQUE (sessionId, code),
FOREIGN KEY (sessionId) REFERENCES ag.vioscreen_sessions (sessionId)
);
CREATE INDEX vio_eatpa_by_sessionid ON ag.vioscreen_eatingpatterns(sessionId);
CREATE UNIQUE INDEX vio_eatpa_by_sessionidcode ON ag.vioscreen_eatingpatterns(sessionId,code);
CREATE TABLE ag.vioscreen_mpeds (
id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
sessionId varchar NOT NULL,
code varchar NOT NULL,
amount float NOT NULL,
UNIQUE (sessionId, code),
FOREIGN KEY (sessionId) REFERENCES ag.vioscreen_sessions (sessionId)
);
CREATE INDEX vio_mpeds_by_sessionid ON ag.vioscreen_mpeds(sessionId);
CREATE UNIQUE INDEX vio_mpeds_by_sessionidcode ON ag.vioscreen_mpeds(sessionId,code);
CREATE TABLE ag.vioscreen_foodconsumption (
id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
sessionId varchar NOT NULL,
foodCode varchar NOT NULL,
description varchar NOT NULL,
foodGroup varchar NOT NULL,
amount varchar NOT NULL,
frequency varchar NOT NULL,
consumptionAdjustment varchar NOT NULL,
servingSizeText varchar NOT NULL,
servingFrequencyText varchar NOT NULL,
created varchar NOT NULL,
UNIQUE (sessionId, description),
FOREIGN KEY (sessionId) REFERENCES ag.vioscreen_sessions (sessionId)
);
CREATE INDEX vio_consu_by_sessionid ON ag.vioscreen_foodconsumption(sessionId);
CREATE UNIQUE INDEX vio_consu_by_sessioniddesc ON ag.vioscreen_foodconsumption(sessionId, description);
CREATE TABLE ag.vioscreen_foodconsumptioncomponents (
id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
sessionId varchar NOT NULL,
description varchar NOT NULL,
code varchar NOT NULL,
amount float NOT NULL,
UNIQUE (sessionId, description, code),
FOREIGN KEY (sessionId, description) REFERENCES ag.vioscreen_foodconsumption(sessionId, description)
);
CREATE INDEX vio_consuc_by_sessionid ON ag.vioscreen_foodconsumptioncomponents(sessionId);
CREATE UNIQUE INDEX vio_consuc_by_sessioniddesccode ON ag.vioscreen_foodconsumptioncomponents(sessionId, description, code);