P7aLRhXe

1create table if not exists kek.landalord
2(
3	id serial not null
4		constraint landalord_pk
5			primary key,
6	first_name varchar(256),
7	last_name varchar(256),
8	phone_number varchar(256),
9	email varchar(256)
10);
11
12alter table kek.landalord owner to postgres;
13
14create table if not exists kek.price_list
15(
16	id serial not null
17		constraint price_list_pk
18			primary key,
19	price_week01 integer,
20	price_week02 integer,
21	price_week03 integer,
22	price_week04 integer,
23	price_week05 integer,
24	price_week06 integer,
25	price_week07 integer,
26	price_week08 integer,
27	price_week09 integer,
28	price_week10 integer,
29	price_week11 integer,
30	price_week12 integer,
31	price_week13 integer,
32	price_week14 integer,
33	price_week15 integer,
34	price_week16 integer,
35	price_week17 integer,
36	price_week18 integer,
37	price_week19 integer,
38	price_week20 integer,
39	price_week21 integer,
40	price_week22 integer,
41	price_week23 integer,
42	price_week24 integer,
43	price_week25 integer,
44	price_week26 integer,
45	price_week27 integer,
46	price_week28 integer,
47	price_week29 integer,
48	price_week30 integer,
49	price_week31 integer,
50	price_week32 integer,
51	price_week33 integer,
52	price_week34 integer,
53	price_week35 integer,
54	price_week36 integer,
55	price_week37 integer,
56	price_week38 integer,
57	price_week39 integer,
58	price_week40 integer,
59	price_week41 integer,
60	price_week42 integer,
61	price_week43 integer,
62	price_week44 integer,
63	price_week45 integer,
64	price_week46 integer,
65	price_week47 integer,
66	price_week48 integer,
67	price_week49 integer,
68	price_week50 integer,
69	price_week51 integer,
70	price_week52 integer,
71	price_week53 integer
72);
73
74alter table kek.price_list owner to postgres;
75
76create table if not exists kek.comfort_list
77(
78	id serial not null
79		constraint comfort_list_pk
80			primary key,
81	wifi boolean,
82	kettle boolean
83);
84
85alter table kek.comfort_list owner to postgres;
86
87create table if not exists kek.country_commission
88(
89	id serial not null
90		constraint country_commission_pk
91			primary key,
92	country varchar(256) not null,
93	commission integer not null
94);
95
96alter table kek.country_commission owner to postgres;
97
98create table if not exists kek.housing_for_rent
99(
100	id serial not null
101		constraint housing_for_rent_pk
102			primary key,
103	country_commission_id integer
104		constraint housing_for_rent_country_commission_id_fk
105			references kek.country_commission,
106	address varchar(256),
107	gps_x integer,
108	gps_y integer,
109	description varchar(256),
110	max_people integer,
111	landlord_id integer
112		constraint housing_for_rent_landalord_id_fk
113			references kek.landalord,
114	cleaning_price integer,
115	price_list_id integer
116		constraint housing_for_rent_price_list_id_fk
117			references kek.price_list,
118	comfort_list_id integer
119		constraint housing_for_rent_comfort_list_id_fk
120			references kek.comfort_list
121);
122
123alter table kek.housing_for_rent owner to postgres;
124
125create unique index if not exists country_commission_country_uindex
126	on kek.country_commission (country);
127
128create table if not exists kek.tenant
129(
130	id serial not null
131		constraint tenant_pk
132			primary key,
133	first_name varchar(256) not null,
134	last_name varchar(256) not null,
135	email varchar(256) not null,
136	phone_number varchar(256) not null,
137	gender varchar(256),
138	date_of_birth date,
139	photo_url varchar(256)
140);
141
142alter table kek.tenant owner to postgres;
143
144create table if not exists kek.fun_activities
145(
146	id serial not null
147		constraint fun_activities_pk
148			primary key,
149	gps_x integer,
150	gps_y integer,
151	start date,
152	"end" date,
153	genre_id integer
154);
155
156alter table kek.fun_activities owner to postgres;
157
158create table if not exists kek.activity_genre
159(
160	id serial not null
161		constraint activity_genre_pk
162			primary key,
163	name varchar(256) not null
164);
165
166alter table kek.activity_genre owner to postgres;
167
168create table if not exists kek.fun_activity
169(
170	id serial not null
171		constraint fun_activity_pk
172			primary key,
173	gps_x integer,
174	gps_y date,
175	start_date date,
176	end_date date,
177	activity_genre_id integer
178		constraint fun_activity_activity_genre_id_fk
179			references kek.activity_genre
180);
181
182alter table kek.fun_activity owner to postgres;
183
184create table if not exists kek.housing_request
185(
186	id serial not null
187		constraint housing_request_pk
188			primary key,
189	tenant_id integer not null
190		constraint housing_request_tenant_id_fk
191			references kek.tenant,
192	housing_for_rent_id integer not null
193		constraint housing_request_housing_for_rent_id_fk
194			references kek.housing_for_rent,
195	from_date date not null,
196	to_date date not null,
197	status varchar(256) not null
198);
199
200alter table kek.housing_request owner to postgres;
201
202create table if not exists kek.tenant_comment
203(
204	id serial not null
205		constraint tenant_comment_pk
206			primary key,
207	tenant_id integer
208		constraint tenant_comment_tenant_id_fk
209			references kek.tenant,
210	housing_for_rent_id integer
211		constraint tenant_comment_housing_for_rent_id_fk
212			references kek.housing_for_rent,
213	text varchar(1024),
214	location_grade integer,
215	cleaning_grade integer,
216	landlord_grade integer,
217	landlord_id integer
218		constraint tenant_comment_landalord_id_fk
219			references kek.landalord
220);
221
222alter table kek.tenant_comment owner to postgres;
223
224create table if not exists kek.landlord_comment
225(
226	id serial not null
227		constraint landlord_comment_pk
228			primary key,
229	landlord_id integer
230		constraint landlord_comment_landalord_id_fk
231			references kek.landalord,
232	tenant_id integer
233		constraint landlord_comment_tenant_id_fk
234			references kek.tenant,
235	text varchar(256),
236	grade integer
237);
238
239alter table kek.landlord_comment owner to postgres;