View and edit SQL

0 records

CREATE TABLE `instagram_media_hashtag_mentions` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`media_id` integer,`hashtag_id` integer,`from_idx` integer,`to_idx` integer,PRIMARY KEY (`id`),CONSTRAINT `fk_instagram_media_hashtag_mentions_hashtag` FOREIGN KEY (`hashtag_id`) REFERENCES `instagram_hashtags`(`id`),CONSTRAINT `fk_instagram_media_hashtag_mentions` FOREIGN KEY (`media_id`) REFERENCES `instagram_media`(`id`));
CREATE UNIQUE INDEX `instagram_media_hashtag_mentions_key` ON `instagram_media_hashtag_mentions`(`media_id`,`hashtag_id`,`from_idx`,`to_idx`);
CREATE INDEX `idx_instagram_media_hashtag_mentions_deleted_at` ON `instagram_media_hashtag_mentions`(`deleted_at`);