CREATE TABLE [dbo].[EatenMeals] (
    [Id]          INT            IDENTITY (1, 1) NOT NULL,
    [Serving]     FLOAT (53)     NOT NULL,
    [Username]    NVARCHAR (MAX) NULL,
    [DATE]        DATETIME       NOT NULL,
    [Meal_MealId] INT            NULL,
    [MealType_Id] INT            NULL,
    CONSTRAINT [PK_dbo.EatenMeals] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_dbo.EatenMeals_dbo.Meals_Meal_MealId] FOREIGN KEY ([Meal_MealId]) REFERENCES [dbo].[Meals] ([MealId]),
    CONSTRAINT [FK_dbo.EatenMeals_dbo.MealTypes_MealType_Id] FOREIGN KEY ([MealType_Id]) REFERENCES [dbo].[MealTypes] ([Id])
);


GO
CREATE NONCLUSTERED INDEX [IX_Meal_MealId]
    ON [dbo].[EatenMeals]([Meal_MealId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_MealType_Id]
    ON [dbo].[EatenMeals]([MealType_Id] ASC);


CREATE TABLE [dbo].[Meals] (
    [MealId]        INT            IDENTITY (1, 1) NOT NULL,
    [Name]          NVARCHAR (MAX) NOT NULL,
    [Protein]       FLOAT (53)     NOT NULL,
    [Carbohydrates] FLOAT (53)     NOT NULL,
    [Fat]           FLOAT (53)     NOT NULL,
    [Calories]      FLOAT (53)     NOT NULL,
    CONSTRAINT [PK_dbo.Meals] PRIMARY KEY CLUSTERED ([MealId] ASC)
);



CREATE TABLE [dbo].[MealTypes] (
    [Id]   INT            IDENTITY (1, 1) NOT NULL,
    [Name] NVARCHAR (MAX) NULL,
    CONSTRAINT [PK_dbo.MealTypes] PRIMARY KEY CLUSTERED ([Id] ASC)
);