CREATE TABLE [dbo].[ProfileApproval]
(
	[ProfileId] INT PRIMARY KEY NOT NULL,
	[ProfileStatusId] INT NOT NULL,
	[RejectReason] NVARCHAR(2000) NULL, 
    [ReviewDate] DATETIME NOT NULL DEFAULT GETDATE(), 
	[ReviewerId] INT NOT NULL DEFAULT 1,
    CONSTRAINT [FK_ProfileApproval_Profile] FOREIGN KEY ([ProfileId]) REFERENCES [Profile]([Id]), 
    CONSTRAINT [FK_ProfileApproval_ProfileStatusId] FOREIGN KEY ([ProfileStatusId]) REFERENCES [ProfileStatus]([Id]), 
    CONSTRAINT [FK_ProfileApproval_User] FOREIGN KEY ([ReviewerId]) REFERENCES [User]([Id])
)
