CREATE TABLE "regions" (
	"id" int PRIMARY KEY,
	"reg_title" varchar(255)
);
CREATE TABLE "citys" (
	"id" int PRIMARY KEY,
	"regions_id" int CONSTRAINT regions_id REFERENCES regions(id),
	"city_title" varchar(255) CONSTRAINT city_title REFERENCES city(title)
);
CREATE TABLE "housing" (
	"id" int PRIMARY KEY,
	"citys_id" int CONSTRAINT citys_id REFERENCES citys(id),
	"hous_owner" varchar(255),
	"hous_title" varchar(255),
	"hous_requisites" varchar(255),
	"hous_distance_food_parking_Array" varchar(255),
	"hous_description" longtext,
	"house_notes" varchar(255),
	"level" varchar(255),
	"rooms" varchar(255),
	"is_tv" bool,
	"is_fridge" bool,
	"is_telefone" bool,
	"is_conditioning" bool,
	"is_ventilator" bool,
	"is_shower" bool,
	"is_safe" bool,
	"is_kitchen" bool,
	"hous_price" varchar(255),
	"housing_services" longtext,
	"house_services" varchar(255),
	"booking_Details" varchar(255),
	"sleeps_places" varchar(255),
	"other_serialized_arrays" longtext,
	"hous_map" varchar(255),
	"hous_date_added" varchar(255)
);
CREATE TABLE "hotels" (
	"id" int PRIMARY KEY,
	"citys_id" int CONSTRAINT citys_id REFERENCES citys(id),
	"hotel_owner" varchar(255),
	"hotel_title" varchar(255),
	"hotel_requisites" varchar(255),
	"hotel_distance_food_parking_Array" varchar(255),
	"hotel_notes" varchar(255),
	"hotel_description" varchar(255),
	"is_wifi" bool,
	"is_dining" bool,
	"is_yard_area" bool,
	"is_playground" bool,
	"is_comewidth_pets" bool,
	"is_Satellite_tv" bool,
	"is_private_beach" bool,
	"is_parking" bool,
	"is_payment_bank_card" bool,
	"is_children_all_age" bool,
	"is_pool" bool,
	"is_sauna" bool,
	"is_open_year_round" bool,
	"is_conference_hall" bool,
	"hotel_servise" varchar(255),
	"hotel_map" varchar(255),
	"hotel_date_added" varchar(255)
);
CREATE TABLE "guest_houses" (
	"id" int PRIMARY KEY,
	"citys_id" int CONSTRAINT citys_id REFERENCES citys(id),
	"gh_owner" varchar(255),
	"gh_title" varchar(255),
	"gh_requisites" varchar(255),
	"gh_hous_distance_food_parking_Array" varchar(255),
	"gh_notes" varchar(255),
	"gh_description" varchar(255),
	"is_wifi" bool,
	"is_dining" bool,
	"is_yard_area" bool,
	"is_playground" bool,
	"is_comewidth_pets" bool,
	"is_Satellite_tv" bool,
	"is_private_beach" bool,
	"is_parking" bool,
	"is_payment_bank_card" bool,
	"is_children_all_age" bool,
	"is_pool" bool,
	"is_sauna" bool,
	"is_open_year_round" bool,
	"is_conference_hall" bool,
	"gh_map" varchar(255),
	"gh_services" varchar(255),
	"gh_date_added" varchar(255)
);
CREATE TABLE "users" (
	"id" int PRIMARY KEY,
	"social_network_fio" varchar(255),
	"usr_city" varchar(255),
	"usr_tel" varchar(255),
	"usr_site" varchar(255),
	"usr_avatar" varchar(255)
);
CREATE TABLE "entertainment" (
	"id" int PRIMARY KEY,
	"citys_id" int CONSTRAINT citys_id REFERENCES citys(id),
	"kind_entertainment" varchar(255),
	"entert_title" varchar(255),
	"entert_content" varchar(255),
	"entert_map" varchar(255)
);
CREATE TABLE "kind_entertainment" (
	"id" int PRIMARY KEY,
	"citys_id" int CONSTRAINT citys_id REFERENCES citys(id),
	"entert_title" varchar(255),
	"excursions" varchar(255),
	"beach_activities_and_attractions" varchar(255),
	"active_life" varchar(255),
	"boat_trips" varchar(255),
	"saunas" varchar(255),
	"discos_and_clubs" varchar(255),
	"entertainment_centers" varchar(255),
	"museums_and_exhibitions" varchar(255),
	"dining_and_bistro" varchar(255)
);
CREATE TABLE "photos" (
	"id" int PRIMARY KEY,
	"citys_id" int CONSTRAINT citys_id REFERENCES citys(id),
	"guest_houses_id" int CONSTRAINT guest_houses_id REFERENCES guest_houses(id),
	"hotels_id" int CONSTRAINT hotels_id REFERENCES hotels(id),
	"articles_id" int CONSTRAINT articles_id REFERENCES articles(id),
	"housing_id" int CONSTRAINT housing_id REFERENCES housing(id),
	"entertainment_id" int CONSTRAINT entertainment_id REFERENCES entertainment(id),
	"camping_id" int CONSTRAINT camping_id REFERENCES camping(id),
	"photo_tags_id" int CONSTRAINT photo_tags_id REFERENCES photo_tags(id),
	"photo_categories_id" int CONSTRAINT photo_categories_id REFERENCES photo_categories(id),
	"photo_link_addr" varchar(255),
	"photos_date_added" varchar(255),
	"users_id" int CONSTRAINT users_id REFERENCES users(id)
);
CREATE TABLE "photo_tags" (
	"id" int PRIMARY KEY,
	"photo_tag_title" varchar(255) CONSTRAINT photo_tag_title REFERENCES photo_tag(title)
);
CREATE TABLE "photo_categories" (
	"id" int PRIMARY KEY,
	"photo_cat_title" varchar(255) CONSTRAINT photo_cat_title REFERENCES photo_cat(title)
);
CREATE TABLE "camping" (
	"id" int PRIMARY KEY,
	"citys_id" int CONSTRAINT citys_id REFERENCES citys(id),
	"camp_title" varchar(255),
	"camp_map" varchar(255),
	"camp_description" varchar(255),
	"camp_content" varchar(255) CONSTRAINT camp_content REFERENCES camp(content)
);
CREATE TABLE "articles" (
	"id" int PRIMARY KEY,
	"citys_id" int CONSTRAINT citys_id REFERENCES citys(id),
	"article_title" varchar(255),
	"article_content" varchar(255),
	"article_date_added" varchar(255),
	"article_author" varchar(255) CONSTRAINT article_author REFERENCES article(author)
);
CREATE TABLE "maps" (
	"id" int PRIMARY KEY,
	"citys_id" int CONSTRAINT citys_id REFERENCES citys(id),
	"guest_houses_id" int CONSTRAINT guest_houses_id REFERENCES guest_houses(id),
	"hotels_id" int CONSTRAINT hotels_id REFERENCES hotels(id),
	"articles_id" int CONSTRAINT articles_id REFERENCES articles(id),
	"housing_id" int CONSTRAINT housing_id REFERENCES housing(id),
	"entertainment_id" int CONSTRAINT entertainment_id REFERENCES entertainment(id),
	"camping_id" int CONSTRAINT camping_id REFERENCES camping(id),
	"map_link" varchar(255) CONSTRAINT map_link REFERENCES map(link)
);
CREATE TABLE "property" (
	"id" int,
	"regions_id" int CONSTRAINT regions_id REFERENCES regions(id),
	"citys_id" int CONSTRAINT citys_id REFERENCES citys(id),
	"Area" varchar(255),
	"price" varchar(255),
	"Price_weaving" varchar(255),
	"location" varchar(255),
	"Date_Added" datetime,
	"Date_of_update" datetime,
	"Seller" varchar(255),
	"phone" varchar(255),
	"email" varchar(255),
	"description" varchar(255),
	"type" varchar(255)
);