CREATE TABLE [dbo].[LoanPayout]
(
	[LoanId] INT NOT NULL PRIMARY KEY,
	[PayoutDate] DATETIME NOT NULL DEFAULT GetDate(),
	[PayoutAmount] Float NOT NULL,
	CONSTRAINT [FK_LoanPayout_Loan] FOREIGN KEY ([LoanId]) REFERENCES [Loan]([Id])
)
