CREATE TABLE `Restaurant` (
	`id` varchar(255) PRIMARY KEY,
	`name` varchar(255),
	`location` varchar(255),
	`phone` varchar(255),
	`mail` varchar(255),
	`instagram` varchar(255),
	`facebook` varchar(255),
	`work time` time,
	`avg bill` int,
	`kitchen` varchar(255)
);
CREATE TABLE `User` (
	`id` varchar(255) PRIMARY KEY,
	`username` varchar(255),
	`mail` varchar(255),
	`phone` varchar(255),
	`first name` varchar(255),
	`last name` varchar(255),
	`password` varchar(255)
);
CREATE TABLE `Menu` (
	`id` varchar(255) PRIMARY KEY,
	`rest_id` varchar(255),
	`url` varchar(255),
	FOREIGN KEY(`rest_id`) REFERENCES `Restaurant` (`id`)
);
CREATE TABLE `Booking` (
	`id` varchar(255) PRIMARY KEY,
	`rest_id` varchar(255),
	`user_id` varchar(255),
	`time` time,
	`desc` varchar(255),
	`date` datetime,
	FOREIGN KEY(`rest_id`) REFERENCES `Restaurant` (`id`),
	FOREIGN KEY(`user_id`) REFERENCES `User` (`id`)
);
CREATE TABLE `Comment` (
	`id` varchar(255) PRIMARY KEY,
	`user_id` varchar(255),
	`rest_id` varchar(255),
	`content` varchar(255),
	FOREIGN KEY(`user_id`) REFERENCES `User` (`id`),
	FOREIGN KEY(`rest_id`) REFERENCES `Restaurant` (`id`)
);
CREATE TABLE `Image` (
	`id` int PRIMARY KEY,
	`rest_id` varchar(255),
	`url` varchar(255),
	FOREIGN KEY(`rest_id`) REFERENCES `Restaurant` (`id`)
);