subcategories

5 rows where parent = "Set"

✎ View and edit SQL

This data as json, CSV (advanced)

Link subcategory parent
Aut,Set Aut Set
Pos,Set Pos Set
Pros,Set Pros Set
SemiRing,Set SemiRing Set
Top,Set Top Set

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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")
);