recipeDbQuery.sql

CREATE DATABASE RecipesDB
go

use RecipesDB

--îùúîùéí
create table Users(
--÷åã îùúîù
Id int IDENTITY(1,1) NOT NULL PRIMARY KEY,
--ùí îùôçä
LastName nvarchar (50) NOT NULL,
--ùí ôøèé
FirstName nvarchar (50) NOT NULL,
--àéîééì
Email nvarchar(50) NOT NULL,
--ñéñîä
Password nvarchar(50) NOT NULL
)

--÷èâåøéåú
CREATE TABLE Categories(
--÷åã
Id int IDENTITY(1,1) NOT NULL PRIMARY KEY,
--ùí
Name nvarchar(50) NOT NULL
)

--øîåú
CREATE TABLE Levels(
--÷åã
Id int IDENTITY(1,1) NOT NULL PRIMARY KEY,
--ùí
Name nvarchar(50) NOT NULL
)

--îúëåðéí
create TABLE Recipes(
--÷åã
Id int IDENTITY(1,1) NOT NULL PRIMARY KEY,
--ùí
Name nvarchar(50) NOT NULL, 
--ùí úîåðä
Pic nvarchar(50),
--æîï äëðä
PreparationTime nvarchar(50),
--äåøàåú äëðä
Instructions nvarchar(1000),
--÷åã îùúîù - òåøê äîúëåï
UserId int NOT NULL FOREIGN KEY REFERENCES Users(Id),
--÷åã ÷èâåøéä
CategoryId int NOT NULL FOREIGN KEY REFERENCES Categories(Id),
--÷åã øîä
LevelId int NOT NULL FOREIGN KEY REFERENCES Levels(Id),
--ðéîä àéùéú ùì äòåøê
Note nvarchar(100) 
)

--øëéáéí
CREATE TABLE Ingredients(
--÷åã
Id int IDENTITY(1,1) NOT NULL PRIMARY KEY,
--ùí
Name nvarchar(20) NOT NULL
)

--øëéáéí ìîúëåï
CREATE TABLE IngredientsToRecipe(
--÷åã
Id int IDENTITY(1,1) NOT NULL PRIMARY KEY,
--÷åã îúëåï
RecipeId int NOT NULL FOREIGN KEY REFERENCES Recipes(Id),
--÷åã øëéá
IngredientId int NOT NULL FOREIGN KEY REFERENCES Ingredients(Id),
--ëîåú
Amount nvarchar(50)
)

--úâåáåú ìîúëåï
CREATE TABLE CommentsToRecipe(
--÷åã
Id int IDENTITY(1,1) NOT NULL PRIMARY KEY,
--÷åã îúëåï
RecipeId int NOT NULL FOREIGN KEY REFERENCES Recipes(Id),
--÷åã îùúîù
UserId int NOT NULL FOREIGN KEY REFERENCES Users(Id),
--úâåáä
Comment nvarchar(100)
)