CudaArtifact
3 rows where platform = 1432, pname = 1960 and sha256 = 1866
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited, object
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);