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