CudaArtifact

8 rows where pname = 1535 and version = 2002

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: manifest, sha256, md5, relative_path, n_bytes

CREATE TABLE "CudaArtifact" (
	"manifest"	INTEGER NOT NULL,
	"name"	INTEGER,
	"pname"	INTEGER,
	"license_name"	INTEGER,
	"license_path"	INTEGER,
	"version"	INTEGER NOT NULL,
	"compat_tag"	INTEGER,
	"sha256"	INTEGER,
	"md5"	INTEGER,
	"platform"	INTEGER,
	"relative_path"	INTEGER,
	"n_bytes"	INTEGER,
	PRIMARY KEY("sha256","manifest"),
	FOREIGN KEY("compat_tag") REFERENCES "Str"("id"),
	FOREIGN KEY("license_name") REFERENCES "Str"("id"),
	FOREIGN KEY("license_path") REFERENCES "Str"("id"),
	FOREIGN KEY("manifest") REFERENCES "CudaManifest"("id"),
	FOREIGN KEY("manifest") REFERENCES "Hash"("id"),
	FOREIGN KEY("md5") REFERENCES "Hash"("id"),
	FOREIGN KEY("name") REFERENCES "Str"("id"),
	FOREIGN KEY("platform") REFERENCES "Str"("id"),
	FOREIGN KEY("pname") REFERENCES "Str"("id"),
	FOREIGN KEY("relative_path") REFERENCES "Str"("id"),
	FOREIGN KEY("sha256") REFERENCES "Hash"("id"),
	FOREIGN KEY("version") REFERENCES "Str"("id")
) STRICT;
CREATE UNIQUE INDEX CudaArtifactIdx
ON CudaArtifact(pname, platform, version, compat_tag, name, manifest);