CREATE TABLE tweet_map (
       id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
       key_id BIGINT UNSIGNED UNIQUE NOT NULL,
       tweet_id BIGINT UNSIGNED UNIQUE NOT NULL,
       user_id BIGINT UNSIGNED NOT NULL,
       screen_name VARCHAR(64) NOT NULL
) ENGINE = innodb DEFAULT CHARSET utf8;

create index key_idx on tweet_map(key_id);
create index tweet_idx on tweet_map(tweet_id);
