CREATE TABLE [dbo].[ManualDeduction]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY(1,1),
	[Amount] FLOAT (53)  NOT NULL,
	[Description] NVARCHAR(MAX) NULL,
	[DeductionDate] DATETIME NOT NULL DEFAULT GetDate(),
	[ProfileId] INT NOT NULL, -- to whome the deduction is directed
	[UserId] INT NOT NULL, -- Who made this deduction 
    CONSTRAINT [FK_ManualDeduction_Profile] FOREIGN KEY ([ProfileId]) REFERENCES [Profile]([Id]), 
    CONSTRAINT [FK_ManualDeduction_User] FOREIGN KEY ([UserId]) REFERENCES [User]([Id]))
