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) CONSTRAINT Restaurant_id REFERENCES Restaurant(id),
	"url" varchar(255)
);
CREATE TABLE "Booking" (
	"id" varchar(255) PRIMARY KEY,
	"rest_id" varchar(255) CONSTRAINT Restaurant_id REFERENCES Restaurant(id),
	"user_id" varchar(255) CONSTRAINT User_id REFERENCES User(id),
	"time" time,
	"desc" varchar(255),
	"date" datetime
);
CREATE TABLE "Comment" (
	"id" varchar(255) PRIMARY KEY,
	"user_id" varchar(255) CONSTRAINT User_id REFERENCES User(id),
	"rest_id" varchar(255) CONSTRAINT Restaurant_id REFERENCES Restaurant(id),
	"content" varchar(255)
);
CREATE TABLE "Image" (
	"id" int PRIMARY KEY,
	"rest_id" varchar(255) CONSTRAINT Restaurant_id REFERENCES Restaurant(id),
	"url" varchar(255)
);