home / sidx

SidxUriSample

0 rows where hash = 2221

✎ View and edit SQL

This data as json

0 records

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);
Powered by Datasette · Queries took 40.111ms