search envelope-o feed check
Home Unanswered Active Tags New Question
user comment-o

Database

Related article: Timetable Tutorial (ASP.NET, C#, VB.NET)
Asked by Ahsan Hameed
2 years ago.

Can you please share database script for help?

Answer posted by Dan Letecky [DayPilot]
2 years ago.

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

This question is more than 3 months old and has been closed. Please create a new question if you have anything to add.