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