subcategories
2 rows where subcategory = "CompCat" sorted by subcategory
This data as json, CSV (advanced)
Link | subcategory ▼ | parent |
---|---|---|
CompCat,*Aut | CompCat | *Aut |
CompCat,TracedSymmMonCat | CompCat | TracedSymmMonCat |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "subcategories" ( "subcategory" TEXT NOT NULL, "parent" TEXT NOT NULL, FOREIGN KEY("parent") REFERENCES "categories"("name") on update cascade on delete restrict, FOREIGN KEY("subcategory") REFERENCES "categories"("name") on update cascade on delete restrict, PRIMARY KEY("subcategory","parent") );