User (user_id,user_name,first_name,last_name,e-mail,password)

Alergies(id,name)

User_Alegries (id,user_id^,allergy_id^)

Diet(diet_id,name)

User_Diets(id,user_id^,died_id^)

Ingridient (id,name)

Ingridient_Diet(id,ingridiet_id^,diet_id^)

Recipe(recipe_id,name,description,time_of_day,cook_time)

Recipe_User(id,recpe_id^,user_id^,is_favorite)

Steps(step_id,description,picture)

Recipe_Steps(id,recipe_id^,step_id^)

Allergy_Recipe(id,allergy_id^,recipe_id^)

Diets_Recipe(id,allergy_id^,recipe_id^)





CREATE TABLE Users (

    User_id int NOT NULL PRIMARY KEY

    user_name varchar(255),

    first_name varchar(255),

    last_name varchar(255),

    email varchar(255)

    password varchar(255)

);

CREATE TABLE Alergies (

    id int NOT NULL PRIMARY KEY

    name varchar(255),

);

CREATE TABLE Users_Alergies (

    id int NOT NULL PRIMARY KEY

    user_id int,

    allergy_id int

    FOREIGN KEY (user_id) REFERENCES Users(user_id)

    FOREIGN KEY (alergy_id) REFERENCES Users(id)

);

CREATE TABLE Allergy_Recipes (

    id int NOT NULL PRIMARY KEY

    allergy_id int,

    recipe_id int

    FOREIGN KEY (allergy_id) REFERENCES Allergy(id)

    FOREIGN KEY (recipe_id) REFERENCES Recipe(recipe_id)

);

CREATE TABLE Diet (

    id int NOT NULL PRIMARY KEY

    name varchar(255),

);

CREATE TABLE User_Diets (

    id int NOT NULL PRIMARY KEY

    user_id int,

    diet_id int

    FOREIGN KEY (user_id) REFERENCES Users(user_id)

    FOREIGN KEY (diet_id) REFERENCES Diet(id)

);

CREATE TABLE Diets_Recipes (

    id int NOT NULL PRIMARY KEY

    diet_id int,

    recipe_id int

    FOREIGN KEY (diet_id) REFERENCES Diets(id)

    FOREIGN KEY (recipe_id) REFERENCES Recipe(recipe_id)

);

CREATE TABLE Ingridient (

    id int NOT NULL PRIMARY KEY

    name varchar(255),

);

CREATE TABLE Ingridient_Diet (

    id int NOT NULL PRIMARY KEY

    ungridient_id int,

    diet_id int

    FOREIGN KEY (ingridient_id) REFERENCES Ingridient(id)

    FOREIGN KEY (diet_id) REFERENCES Diet(id)

);

CREATE TABLE Recipe (

    recipe_id int NOT NULL PRIMARY KEY

    name varchar(255),

    description TEXT,

    time_of_day TIMESTAMP,

    cook_time TIMESTAMP

);

CREATE TABLE Recipe_User (

    id int NOT NULL PRIMARY KEY

    user_id int,

    recipe_id int

    FOREIGN KEY (user_id) REFERENCES Users(user_id)

    FOREIGN KEY (recipe_id) REFERENCES Recipe(recipe_id)

);

CREATE TABLE Steps (

    Step_id int NOT NULL PRIMARY KEY

    description TEXT,

picture varchar(255)

);

CREATE TABLE Recipe_Steps (

    id int NOT NULL PRIMARY KEY

    step_id int,

    recipe_id int

    FOREIGN KEY (step_id) REFERENCES Steps(step_id)

    FOREIGN KEY (recipe_id) REFERENCES Recipe(recipe_id)

);





INSERT INTO Users VALUES(1,”Jej”,”Jovan”,”Mitrovski”,”jey@jey.com”, "bazi1234")

INSTERT INTO Alergies VALUES(1,”polen”)

INSERT INTO Users_Aleries VALUES(1,1,1)

INSERT INTO Diet VALUES(1,”hrono”)

INSERT INTO User_Diets VALUES(1,1,1)

INSERT INTO Ingridients VALUES(1,”jajce”)

INSERT INTO Ingridient_Diet VALUES(1,1,1)

INSERT INTO Recipe VALUES(1,”jajca”,”na oko”,282678900,767856787)

INSERT INTO Recipe_User VALUES(1,1,1)

INSERT INTO Steps VALUES(1,”se zemaat dve jajca”,”slika.jpg”)

INSERT INTO Recipe_Steps VALUES(1,1,1)

INSERT INTO Allergy_Recipe VALUES(1,1,1)

INSERT INTO Diets_Recipe VALUES(1,1,1)