CREATE TABLE magic_links ( id VARCHAR NOT NULL PRIMARY KEY, user_id VARCHAR NOT NULL REFERENCES users (id) ON DELETE CASCADE, expires TIMESTAMP NOT NULL );