CREATE TABLE [dbo].[LoanRequestOffer]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY (1, 1)  ,
	[RequestDate] dateTime not null DEFAULT GETDATE(),
	[Comments]    NVARCHAR(500) NuLL, 
	[OfferStausId] int not null,
	[LoanOfferId] int not null,
	[LoanRequestId] int not null,
    [IsActive] BIT NOT NULL DEFAULT 1,
	[IOU_Accepted] bit NOT NULL DEFAULT 0,
    CONSTRAINT [FK_LoanRequestOffer_LoanRequest] FOREIGN KEY (LoanRequestId) REFERENCES [dbo].[LoanRequest]([Id]), 
    CONSTRAINT [FK_LoanRequestOffer_OfferStaus] FOREIGN KEY ([OfferStausId]) REFERENCES [dbo].[OfferStatus]([Id]),
    CONSTRAINT [FK_LoanRequestOffer_LoanOffer] FOREIGN KEY ([LoanOfferId]) REFERENCES [dbo].[LoanOffer]([Id]),
   


)
