twitter_tweet_user_mentions

✎ View and edit SQL

This data as json

0 records

CREATE TABLE `twitter_tweet_user_mentions` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`tweet_entities_id` integer,`user_id` integer,`from_idx` integer,`to_idx` integer,PRIMARY KEY (`id`),CONSTRAINT `fk_twitter_tweet_entities_user_mentions` FOREIGN KEY (`tweet_entities_id`) REFERENCES `twitter_tweet_entities`(`id`),CONSTRAINT `fk_twitter_tweet_user_mentions_user` FOREIGN KEY (`user_id`) REFERENCES `twitter_users`(`id`));
CREATE UNIQUE INDEX `twitter_tweet_user_mentions_key` ON `twitter_tweet_user_mentions`(`tweet_entities_id`,`user_id`,`from_idx`,`to_idx`);
CREATE INDEX `idx_twitter_tweet_user_mentions_deleted_at` ON `twitter_tweet_user_mentions`(`deleted_at`);