subcategories

5 rows where parent = "Pos"

✎ View and edit SQL

This data as json, CSV (advanced)

Link subcategory parent
DCPO,Pos DCPO Pos
HeytAlg,Pos HeytAlg Pos
Lat,Pos Lat Pos
SemiLat,Pos SemiLat Pos
Δ,Pos Δ Pos

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