categories_of_abelian_groups
1 row where internal_abelian_groups = "Ab"
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "categories_of_abelian_groups" (
"internal_abelian_groups" TEXT NOT NULL UNIQUE,
"parent" TEXT NOT NULL UNIQUE,
PRIMARY KEY("parent","internal_abelian_groups"),
FOREIGN KEY("internal_abelian_groups") REFERENCES "categories"("name") on update cascade on delete restrict,
FOREIGN KEY("parent") REFERENCES "categories"("name") on update cascade on delete restrict
);