SidxUriSample

3 rows where uri = 42

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: hash

CREATE TABLE "SidxUriSample" (
	"id"	INTEGER,
	"uri"	INTEGER NOT NULL,
	"hash"	INTEGER,
	"epoch"	INTEGER NOT NULL DEFAULT (unixepoch()),
	"http_code"	INTEGER,
	"content_type"	INTEGER DEFAULT NULL,
	PRIMARY KEY("id"),
	FOREIGN KEY("content_type") REFERENCES "Str"("id"),
	FOREIGN KEY("hash") REFERENCES "Hash"("id"),
	FOREIGN KEY("uri") REFERENCES "Str"("id")
) STRICT;
CREATE INDEX SidxUriHashIdx
ON SidxUriSample(uri, hash, epoch);