Postgres_Food_Access_Database/data_tables.sql at main · ElenaChurch/Postgres_Food_Access_Database · GitHub

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
drop table low_access;
drop table irsincome_df;
drop table heart_disease

create table low_access(
county varchar(50) not null,
state varchar(50) not null,
population_percent INTEGER,
low_income_percent	INTEGER,
households_no_car_percent INTEGER,
snap_households_percent	INTEGER,
children_percent INTEGER,
seniors_percent	INTEGER,
white_percent INTEGER,
black_percent INTEGER,
hispanic_percent INTEGER,
asian_percent INTEGER,
hawaiian_pacific_islander_percent INTEGER,
multiracial_percent	INTEGER,
american_indian_alaska_native_percent INTEGER
PRIMARY KEY (County)
);

select * from low_access


CREATE TABLE irsincome_df(
County  varchar(30),
Number_of_Returns INTEGER,
Single_Returns INTEGER,
Joint_Returns INTEGER,
Elderly_Returns INTEGER,
Total_Income_Amount INTEGER,
Returns_w_Uunemployment_Compensation INTEGER,
Unemployment_Compensation_Amount INTEGER,
FOREIGN KEY (County) REFERENCES low_access(County),
PRIMARY KEY (County));

select * from irsincome_df


CREATE TABLE heart_disease(
State VARCHAR(30) NOT NULL,
County VARCHAR(30) NOT NULL,
Heart_Disease_Mortality_Rate INTEGER,
Value_Unit VARCHAR(50) NOT NULL,
Location_ID INTEGER,
FOREIGN KEY (County) REFERENCES low_access(County),
PRIMARY KEY (County));

select * from heart_disease