CREATE TABLE [dbo].[TransactionFee] (
    [Id]            INT        IDENTITY (1, 1) NOT NULL,
    [TransactionId] INT        NOT NULL,
    [FeeTypeId]     INT        NOT NULL,
    [FeeAmount]     FLOAT (53) NOT NULL,
    CONSTRAINT [PK_TransactionFee] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_TransactionFee_FeeType] FOREIGN KEY ([FeeTypeId]) REFERENCES [dbo].[FeeType] ([Id]),
    CONSTRAINT [FK_TransactionFee_Transaction] FOREIGN KEY ([TransactionId]) REFERENCES [dbo].[Transaction] ([Id])
);

