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
);