CREATE TABLE transmission_processed
(
    id         INTEGER PRIMARY KEY,
    magnet_id  INTEGER NOT NULL,
    processed_at DATETIME NOT NULL,
    FOREIGN KEY (magnet_id) REFERENCES magnets(id)
);

CREATE INDEX transmission_processed_magnet_id ON transmission_processed(magnet_id);