CREATE TABLE [dbo].[LoanSchedule]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY(1,1),
	[Description] NVARCHAR(70) NOT NULL,
	[Amount] FLOAT (53) NOT NULL,
	[ExpectedPayDate] DATETIME NOT NULL,
	[StatusId] INT NOT NULL,
	[LoanId] INT NOT NULL, 
	CONSTRAINT [FK_LoanSchedule_Loan] FOREIGN KEY ([LoanId]) REFERENCES [Loan]([Id]),
	CONSTRAINT [FK_LoanSchedule_LoanScheduleStatus] FOREIGN KEY ([StatusId]) REFERENCES [LoanScheduleStatus]([Id])
)
