Task06 - Notification table

CREATE TABLE [Notification](
	[Id] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
	[Guid] [uniqueidentifier] NOT NULL,
	[CreatedAt] [datetime2](7) NOT NULL,
	[UpdatedAt] [datetime2](7) NULL,
	[Receiver] [nvarchar](256) NOT NULL,
	[Subject] [nvarchar](256) NULL,
	[Body] [nvarchar](max) NOT NULL,
	[SentAt] [datetime2](7) NULL
)

ALTER TABLE [Notification]
ADD  CONSTRAINT [DF_Notification_Guid]
DEFAULT (newid()) FOR [Guid]
GO

ALTER TABLE [Notification]
ADD  CONSTRAINT [DF_Notification_CreatedAt]
DEFAULT (getutcdate()) FOR [CreatedAt]
GO