CREATE TABLE [dbo].[LoanScheduleFee]
(
	[LoanScheduleId] INT NOT NULL PRIMARY KEY,
	[BillDate] DATETIME  NOT NULL DEFAULT GETDATE(),
	[TransactionFeeId] INT NOT NUll,
	CONSTRAINT [FK_LoanScheduleFee_LoanSchedule] FOREIGN KEY ([LoanScheduleId]) REFERENCES [LoanSchedule]([Id]),
	CONSTRAINT [FK_LoanScheduleFee_TransactionFee] FOREIGN KEY ([TransactionFeeId]) REFERENCES [TransactionFee]([Id])
)
