Schema of the trades table

trades.sql

CREATE TABLE portfolio
(
    id BIGINT AUTO_INCREMENT PRIMARY KEY
);

CREATE TABLE trades
(
    id           BIGINT AUTO_INCREMENT PRIMARY KEY,
    portfolio_id BIGINT         NOT NULL,
    type         VARCHAR(255)   NOT NULL,
    date         DATETIME       NOT NULL,
    quantity     DECIMAL(20, 5) NOT NULL,
    CONSTRAINT fk_trades_portfolio_id
        FOREIGN KEY (portfolio_id) REFERENCES portfolios (id)
);

CREATE INDEX trades_portfolio_type_date
    ON trades (portfolio_id, type, date);