напиши типы связей в формате Блюдо	1..1	содержит	1..1	Состав блюд
--  Таблица отдыхающих -- 

CREATE TABLE vacationers
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Persons_name VARCHAR(20) NOT NULL,
    Persons_surname VARCHAR(20) NOT NULL,
    Age TINYINT UNSIGNED NOT NULL,
    Phone VARCHAR(11) UNIQUE NOT NULL,
    Email VARCHAR(30) UNIQUE,
    Passport VARCHAR(10) NOT NULL UNIQUE,
    Chek_in_date DATETIME NOT NULL,
    Time_of_remain TINYINT UNSIGNED NOT NULL
);

--  Таблица видов блюд -- 

CREATE TABLE dish_type
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
	Dish_name VARCHAR(30) NOT NULL,
	Start_time TIME NOT NULL,
	End_time TIME NOT NULL
);

--  Таблица рецептов -- 

CREATE TABLE recipe
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Action_list TEXT NOT NULL,
    Cooking_time TIME NOT NULL
);

-- Таблица продукта -- 

CREATE TABLE foodstuff
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Food_name VARCHAR(20) NOT NULL,
	Calorific DECIMAL(6,2) NOT NULL
);

-- Таблица склада -- 

CREATE TABLE food_storage
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Foodstuff_id INT UNSIGNED NOT NULL,
    Amount DECIMAL(5, 2) NOT NULL,
    FOREIGN KEY (Foodstuff_id) REFERENCES foodstuff(Id)
);

-- Таблица блюда -- 

CREATE TABLE dish
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Recipe_id INT UNSIGNED NOT NULL,
    Dish_name VARCHAR(20) NOT NULL,
    Calorific DECIMAL(6,2) NOT NULL,
    Weight DECIMAL(6,2) NOT NULL,
    Cost_price DECIMAL(6, 2) NOT NULL,
    FOREIGN KEY (Recipe_id) REFERENCES recipe(Id)
);

-- Таблица блюда -- 

CREATE TABLE composition
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Dish_id INT UNSIGNED NOT NULL,
    Food_id INT UNSIGNED NOT NULL,
    Amount DECIMAL(5, 2) NOT NULL,
    FOREIGN KEY (Dish_id) REFERENCES dish(Id),
    FOREIGN KEY (Food_id) REFERENCES foodstuff(Id)
);

-- Таблица меню -- 

CREATE TABLE menu
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Dish_id INT UNSIGNED NOT NULL,
    Type_id INT UNSIGNED NOT NULL,
    Dish_description TINYTEXT NOT NULL,
    Price DECIMAL(6, 2) NOT NULL,
    FOREIGN KEY (Dish_id) REFERENCES dish(Id),
    FOREIGN KEY (Type_id) REFERENCES dish_type(Id)
);

-- Таблица трапеза -- 

CREATE TABLE repast
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Vacationer_id INT UNSIGNED NOT NULL,
    Menu_id INT UNSIGNED NOT NULL,
    Repast_date DATETIME NOT NULL,
    Cost DECIMAL(7, 2) NOT NULL,
    FOREIGN KEY (Vacationer_id) REFERENCES vacationers(Id),
    FOREIGN KEY (Menu_id) REFERENCES menu(Id)
);

-- Таблица касса -- 

CREATE TABLE till
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Profit DECIMAL(10, 2) NOT NULL,
    Decline DECIMAL(10, 2) NOT NULL,
    Total DECIMAL(10, 2) NOT NULL 
);

--  Таблица поставщиков -- 

CREATE TABLE provider
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Provider_name VARCHAR(20) NOT NULL,
    Provider_type VARCHAR(40) NOT NULL,
    Phone VARCHAR(11) UNIQUE NOT NULL,
    TIN VARCHAR(12) UNIQUE NOT NULL,
    Email VARCHAR(30) UNIQUE,
    Adress TINYTEXT
);

-- Таблица поставок -- 

CREATE TABLE delivery
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Foodstuff_id INT UNSIGNED NOT NULL,
    Amount DECIMAL(5, 2) NOT NULL, 
    Price DECIMAL(7, 2) NOT NULL,
    FOREIGN KEY (Foodstuff_id) REFERENCES foodstuff(Id)
);

-- Таблица квитанция -- 

CREATE TABLE estimates
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Provider_id INT UNSIGNED NOT NULL,
    Delivery_id INT UNSIGNED NOT NULL,
    Cost DECIMAL(8, 2) NOT NULL,
    Receipt_date DATETIME NOT NULL,
    FOREIGN KEY (Provider_id) REFERENCES provider(Id),
    FOREIGN KEY (Delivery_id) REFERENCES delivery(Id)
);

-- Таблица столов -- 

CREATE TABLE places
(
    Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    SeatCount TINYINT UNSIGNED NOT NULL,
    IsEmpty BOOL DEFAULT TRUE
);

-- Таблица бронирования -- 

CREATE TABLE booking
(
	Id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    Place_id INT UNSIGNED NOT NULL,
    Vacationers_id INT UNSIGNED NOT NULL,
    Visibility TINYINT UNSIGNED NOT NULL,
    FOREIGN KEY (Place_id) REFERENCES places(Id),
    FOREIGN KEY (Vacationers_id) REFERENCES vacationers(Id)
);