CREATE TABLE "regions" (
	"id" int PRIMARY KEY,
	"reg_title" varchar(255)
);
CREATE TABLE "citys" (
	"id" int PRIMARY KEY,
	"regions_id" int FOREIGN KEY("regions_id") REFERENCES "regions" ("id"),
	"city_title" varchar(255) FOREIGN KEY("city_title") REFERENCES "city" ("title")
);
CREATE TABLE "housing" (
	"id" int PRIMARY KEY,
	"citys_id" int FOREIGN KEY("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 FOREIGN KEY("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 FOREIGN KEY("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 FOREIGN KEY("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 FOREIGN KEY("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 FOREIGN KEY("citys_id") REFERENCES "citys" ("id"),
	"guest_houses_id" int FOREIGN KEY("guest_houses_id") REFERENCES "guest_houses" ("id"),
	"hotels_id" int FOREIGN KEY("hotels_id") REFERENCES "hotels" ("id"),
	"articles_id" int FOREIGN KEY("articles_id") REFERENCES "articles" ("id"),
	"housing_id" int FOREIGN KEY("housing_id") REFERENCES "housing" ("id"),
	"entertainment_id" int FOREIGN KEY("entertainment_id") REFERENCES "entertainment" ("id"),
	"camping_id" int FOREIGN KEY("camping_id") REFERENCES "camping" ("id"),
	"photo_tags_id" int FOREIGN KEY("photo_tags_id") REFERENCES "photo_tags" ("id"),
	"photo_categories_id" int FOREIGN KEY("photo_categories_id") REFERENCES "photo_categories" ("id"),
	"photo_link_addr" varchar(255),
	"photos_date_added" varchar(255),
	"users_id" int FOREIGN KEY("users_id") REFERENCES "users" ("id")
);
CREATE TABLE "photo_tags" (
	"id" int PRIMARY KEY,
	"photo_tag_title" varchar(255) FOREIGN KEY("photo_tag_title") REFERENCES "photo_tag" ("title")
);
CREATE TABLE "photo_categories" (
	"id" int PRIMARY KEY,
	"photo_cat_title" varchar(255) FOREIGN KEY("photo_cat_title") REFERENCES "photo_cat" ("title")
);
CREATE TABLE "camping" (
	"id" int PRIMARY KEY,
	"citys_id" int FOREIGN KEY("citys_id") REFERENCES "citys" ("id"),
	"camp_title" varchar(255),
	"camp_map" varchar(255),
	"camp_description" varchar(255),
	"camp_content" varchar(255) FOREIGN KEY("camp_content") REFERENCES "camp" ("content")
);
CREATE TABLE "articles" (
	"id" int PRIMARY KEY,
	"citys_id" int FOREIGN KEY("citys_id") REFERENCES "citys" ("id"),
	"article_title" varchar(255),
	"article_content" varchar(255),
	"article_date_added" varchar(255),
	"article_author" varchar(255) FOREIGN KEY("article_author") REFERENCES "article" ("author")
);
CREATE TABLE "maps" (
	"id" int PRIMARY KEY,
	"citys_id" int FOREIGN KEY("citys_id") REFERENCES "citys" ("id"),
	"guest_houses_id" int FOREIGN KEY("guest_houses_id") REFERENCES "guest_houses" ("id"),
	"hotels_id" int FOREIGN KEY("hotels_id") REFERENCES "hotels" ("id"),
	"articles_id" int FOREIGN KEY("articles_id") REFERENCES "articles" ("id"),
	"housing_id" int FOREIGN KEY("housing_id") REFERENCES "housing" ("id"),
	"entertainment_id" int FOREIGN KEY("entertainment_id") REFERENCES "entertainment" ("id"),
	"camping_id" int FOREIGN KEY("camping_id") REFERENCES "camping" ("id"),
	"map_link" varchar(255) FOREIGN KEY("map_link") REFERENCES "map" ("link")
);
CREATE TABLE "property" (
	"id" int,
	"regions_id" int FOREIGN KEY("regions_id") REFERENCES "regions" ("id"),
	"citys_id" int FOREIGN KEY("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)
);