twitter_tweet_media

✎ View and edit SQL

This data as json

0 records

CREATE TABLE `twitter_tweet_media` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`tweet_entities_id` integer,`expanded_url` text,`from_idx` integer,`to_idx` integer,`url` text,`media_url` text,`media_url_http_s` text,`type` text,`display_url` text,PRIMARY KEY (`id`),CONSTRAINT `fk_twitter_tweet_entities_media` FOREIGN KEY (`tweet_entities_id`) REFERENCES `twitter_tweet_entities`(`id`));
CREATE UNIQUE INDEX `twitter_tweet_media_key` ON `twitter_tweet_media`(`id`,`tweet_entities_id`,`from_idx`,`to_idx`);
CREATE INDEX `idx_twitter_tweet_media_deleted_at` ON `twitter_tweet_media`(`deleted_at`);