CREATE TABLE [dbo].[Notification]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY(1,1),
	[Recipient] NVARCHAR(100) NOT NULL,
	[Message] NVARCHAR(MAX) NOT NULL,
	[Status] NVARCHAR(100) NOT NULL,
	[NotificationTypeId] INT NOT NULL,
	[DateSent] DateTime NOT NULL DEFAULT GETDATE(), 
	CONSTRAINT [FK_Notification_NotificationType] FOREIGN KEY ([NotificationTypeId]) REFERENCES [NotificationType]([Id]),

)
