The SQL Server database schema looks like this:
CREATE TABLE [dbo].[Assignment] (
[AssignmentId] BIGINT IDENTITY (1, 1) NOT NULL,
[AssignmentNote] VARCHAR (2000) NULL,
[AssignmentStart] DATETIME NOT NULL,
[AssignmentEnd] DATETIME NOT NULL,
[AssignmentColor] VARCHAR (50) NULL,
CONSTRAINT [PK_Assignment] PRIMARY KEY CLUSTERED ([AssignmentId] ASC)
);
CREATE TABLE [dbo].[Block] (
[BlockId] INT NOT NULL,
[BlockStart] DATETIME NOT NULL,
[BlockEnd] DATETIME NOT NULL,
CONSTRAINT [PK_Block] PRIMARY KEY CLUSTERED ([BlockId] ASC)
);
Now you can also find it at the bottom of the article:
https://code.daypilot.org/65101/timetable-tutorial-asp-net-c-vb-net