
--Migration_RCCP_20240618_185652.txt
CREATE TABLE [dbo].[StaffPreferences] (
    [Id] [bigint] NOT NULL IDENTITY,
    [StaffId] [nvarchar](max),
    [DayOfWeek] [int] NOT NULL,
    [IsOffDay] [bit] NOT NULL,
    [StartTime] [datetime] NOT NULL,
    [EndTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.StaffPreferences] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[ActualStaffSchedules] ADD [BreakStartTime] [datetime]
ALTER TABLE [dbo].[ActualStaffSchedules] ADD [BreakEndTime] [datetime]
ALTER TABLE [dbo].[Staffs] ADD [Designation] [nvarchar](max)
