full_subcategories
21 rows
This data as json, CSV (advanced)
Suggested facets: supercategory
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "full_subcategories" ( "subcategory" TEXT NOT NULL, "supercategory" TEXT NOT NULL, FOREIGN KEY("subcategory") REFERENCES "categories"("name") on update cascade on delete restrict, FOREIGN KEY("supercategory") REFERENCES "categories"("name") on update cascade on delete restrict, PRIMARY KEY("subcategory","supercategory") );