USE [USOSDB]
GO

/****** Object: Table [dbo].[Lesson] Script Date: 23.02.2020 14:17:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Lesson] (
    [ID]         INT            IDENTITY (1, 1) NOT NULL,
    [lecturerId] NVARCHAR (450) NULL,
    [lectureID]  INT            NULL
);


GO
CREATE NONCLUSTERED INDEX [IX_Lesson_lectureID]
    ON [dbo].[Lesson]([lectureID] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Lesson_lecturerId]
    ON [dbo].[Lesson]([lecturerId] ASC);


GO
ALTER TABLE [dbo].[Lesson]
    ADD CONSTRAINT [PK_Lesson] PRIMARY KEY CLUSTERED ([ID] ASC);


GO
ALTER TABLE [dbo].[Lesson]
    ADD CONSTRAINT [FK_Lesson_Lecture_lectureID] FOREIGN KEY ([lectureID]) REFERENCES [dbo].[Lecture] ([ID]);


GO
ALTER TABLE [dbo].[Lesson]
    ADD CONSTRAINT [FK_Lesson_AspNetUsers_lecturerId] FOREIGN KEY ([lecturerId]) REFERENCES [dbo].[AspNetUsers] ([Id]);