YASpYqd2

1DROP TABLE IF EXISTS Host CASCADE;
2CREATE TABLE Host(
3	id SERIAL,
4	url VARCHAR(255) UNIQUE,
5	name VARCHAR(255),
6	since DATE,
7	about TEXT,
8	response_time VARCHAR(18),
9	response_rate VARCHAR(255),
10	is_superhost BOOLEAN,
11	picture_url VARCHAR(255),
12	identity_verified VARCHAR(255),
13	listings_count INTEGER,
14	PRIMARY KEY (id)
15);
16
17DROP TABLE IF EXISTS Property CASCADE;
18CREATE TABLE Property (
19	id SERIAL,
20	name VARCHAR(255),
21	description TEXT,
22	listing_url VARCHAR(255) UNIQUE,
23	picture_url VARCHAR(255),
24	type varchar(255),
25	accommodates DECIMAL NOT NULL,
26	bathrooms DECIMAL,
27	beds DECIMAL,
28	square_feet DECIMAL,
29	price VARCHAR(255),
30	weekly_price VARCHAR(255),
31	monthly_price VARCHAR(255),
32	security_deposit VARCHAR(255),
33	cleaning_fee VARCHAR(255),
34	minimum_nights INTEGER,
35	maximum_nights INTEGER,
36	PRIMARY KEY (id)
37);
38
39DROP TABLE IF EXISTS Country CASCADE;
40CREATE TABLE Country( 
41	code CHAR(3),
42	name VARCHAR(255),
43	PRIMARY KEY (code)
44);
45
46DROP TABLE IF EXISTS State CASCADE;
47CREATE TABLE State (
48	id SERIAL,
49	country CHAR(3),
50	FOREIGN KEY (country) REFERENCES Country(code),
51	PRIMARY KEY (id)
52);
53
54DROP TABLE IF EXISTS City CASCADE;
55CREATE TABLE City(
56	id SERIAL,
57	state INTEGER,
58	name VARCHAR(255),
59	FOREIGN KEY (state) REFERENCES State (id),
60	PRIMARY KEY (id)
61);
62
63DROP TABLE IF EXISTS Neighborhood CASCADE;
64CREATE TABLE Neighborhood(
65	id SERIAL,
66	city INTEGER,
67	zipcode INTEGER,
68	FOREIGN KEY (city) REFERENCES City (id)
69);
70
71DROP TABLE IF EXISTS Reviewer CASCADE;
72CREATE TABLE Reviewer (
73	id SERIAL,
74	name VARCHAR(255),
75	PRIMARY KEY (id)
76);
77
78DROP TABLE IF EXISTS Review CASCADE;
79CREATE TABLE Review (
80	id SERIAL,
81	comment TEXT,
82	date DATE,
83	PRIMARY KEY (id)
84);
85
86DROP TABLE IF EXISTS Verification;
87CREATE TABLE Verification (
88	id SERIAL,
89	name VARCHAR(255),
90	PRIMARY KEY (id)
91);
92
93DROP TABLE IF EXISTS Amenity;
94CREATE TABLE Amenity (
95	id SERIAL,
96	name VARCHAR(255),
97	PRIMARY KEY (id)
98);