categories_of_groups

3 rows where internal_groups = "Ab" sorted by parent descending

✎ View and edit SQL

This data as json, CSV (advanced)

parent ▲ internal_groups
Mon Ab
Grp Ab
Ab Ab

Advanced export

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

CSV options: 

CREATE TABLE "categories_of_groups" (
	"internal_groups"	TEXT NOT NULL,
	"parent"	TEXT NOT NULL UNIQUE,
	FOREIGN KEY("parent") REFERENCES "categories"("name"),
	FOREIGN KEY("internal_groups") REFERENCES "categories"("name"),
	PRIMARY KEY("parent")
);