-
Notifications
You must be signed in to change notification settings - Fork 19
/
0046.sql
81 lines (75 loc) · 3.34 KB
/
0046.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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
CREATE TABLE ag.vioscreen_foodcomponents (
amount float8 NOT NULL,
code varchar NOT NULL,
description varchar(500) ,
survey_id varchar NOT NULL,
units varchar NOT NULL,
valueType varchar,
CONSTRAINT pk_vioscreen_foodcomponents PRIMARY KEY ( survey_id, code ),
CONSTRAINT fk_vioscreen_foodcomponents FOREIGN KEY ( survey_id ) REFERENCES ag.ag_login_surveys ( survey_id )
);
CREATE TABLE ag.vioscreen_percentenergy (
amount float8 NOT NULL,
code varchar NOT NULL,
description varchar(500) ,
foodComponentType int ,
foodDataDefinition varchar ,
precision int ,
shortDescription varchar ,
survey_id varchar NOT NULL,
units varchar NOT NULL,
CONSTRAINT pk_vioscreen_percentenergy PRIMARY KEY ( survey_id, code ),
CONSTRAINT fk_vioscreen_percentenergy FOREIGN KEY ( survey_id ) REFERENCES ag.ag_login_surveys ( survey_id )
);
CREATE TABLE ag.vioscreen_mpeds (
amount float8 NOT NULL,
code varchar NOT NULL,
description varchar(500) ,
survey_id varchar NOT NULL,
units varchar NOT NULL,
valueType varchar ,
CONSTRAINT pk_vioscreen_mpeds PRIMARY KEY ( survey_id, code ),
CONSTRAINT fk_vioscreen_mpeds FOREIGN KEY ( survey_id ) REFERENCES ag.ag_login_surveys ( survey_id )
);
CREATE TABLE ag.vioscreen_eatingpatterns (
amount float8 NOT NULL,
code varchar NOT NULL,
description varchar(500) ,
survey_id varchar NOT NULL,
units varchar ,
valueType varchar ,
CONSTRAINT pk_vioscreen_eatingpatterns PRIMARY KEY ( survey_id, code ),
CONSTRAINT fk_vioscreen_eatingpatterns FOREIGN KEY ( survey_id ) REFERENCES ag.ag_login_surveys ( survey_id )
);
CREATE TABLE ag.vioscreen_foodconsumption (
amount float8 NOT NULL,
consumptionAdjustment float8 ,
created varchar ,
data json NOT NULL,
description varchar(500) ,
foodCode varchar NOT NULL,
foodGroup varchar NOT NULL,
frequency int NOT NULL,
servingFrequencyText varchar(500) NOT NULL,
servingSizeText varchar(500) NOT NULL,
survey_id varchar NOT NULL,
CONSTRAINT pk_vioscreen_foodconsumption PRIMARY KEY ( survey_id, foodCode, foodGroup ),
CONSTRAINT fk_vioscreen_foodconsumption FOREIGN KEY ( survey_id ) REFERENCES ag.ag_login_surveys ( survey_id )
);
CREATE TABLE ag.vioscreen_dietaryscore (
lowerLimit float8 ,
name varchar NOT NULL,
score float8 NOT NULL,
survey_id varchar NOT NULL,
type varchar NOT NULL,
upperLimit float8 ,
CONSTRAINT pk_vioscreen_dietaryscore PRIMARY KEY ( survey_id, type ),
CONSTRAINT fk_vioscreen_dietaryscore FOREIGN KEY ( survey_id ) REFERENCES ag.ag_login_surveys ( survey_id )
);
CREATE TABLE ag.vioscreen_surveys (
status varchar NOT NULL,
survey_id varchar NOT NULL,
pulldown_date date ,
CONSTRAINT pk_vioscreen_surveys PRIMARY KEY ( survey_id ),
CONSTRAINT fk_vioscreen_surveys FOREIGN KEY ( survey_id ) REFERENCES ag.ag_login_surveys ( survey_id )
);