easter_egg_discovery

1 row where user_id = "iBuK1HOsIw8dtGxDGPHwyfawnDerpMhY"

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE TABLE `easter_egg_discovery` (
	`id` text PRIMARY KEY NOT NULL,
	`user_id` text NOT NULL,
	`egg_id` text NOT NULL,
	`discovered_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
	FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade,
	FOREIGN KEY (`egg_id`) REFERENCES `easter_egg`(`id`) ON UPDATE no action ON DELETE restrict
);
CREATE INDEX `easter_egg_discovery_user_idx` ON `easter_egg_discovery` (`user_id`);
CREATE UNIQUE INDEX `easter_egg_discovery_user_egg` ON `easter_egg_discovery` (`user_id`,`egg_id`);