filename

14,056,930 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: create_time (date)

Next page

CREATE TABLE "filename" ("usi" TEXT NOT NULL PRIMARY KEY, "filepath" TEXT NOT NULL, "dataset" TEXT NOT NULL, "collection" TEXT NOT NULL, "is_update" INTEGER NOT NULL, "update_name" TEXT NOT NULL, "create_time" DATETIME NOT NULL, "size" INTEGER NOT NULL, "size_mb" INTEGER NOT NULL, "sample_type" TEXT NOT NULL, "spectra_ms1" INTEGER NOT NULL, "spectra_ms2" INTEGER NOT NULL, "instrument_vendor" TEXT NOT NULL, "instrument_model" TEXT NOT NULL, "file_processed" TEXT NOT NULL);
CREATE INDEX "filename_filepath" ON "filename" ("filepath");
CREATE INDEX "filename_dataset" ON "filename" ("dataset");
CREATE INDEX "filename_collection" ON "filename" ("collection");
CREATE INDEX "filename_update_name" ON "filename" ("update_name");
CREATE INDEX "filename_sample_type" ON "filename" ("sample_type");
CREATE INDEX "filename_instrument_vendor" ON "filename" ("instrument_vendor");
CREATE INDEX "filename_instrument_model" ON "filename" ("instrument_model");