cores
4 rows
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "cores" ( "groupoid" TEXT NOT NULL, "category" TEXT NOT NULL UNIQUE, PRIMARY KEY("category"), FOREIGN KEY("category") REFERENCES "categories"("name") on update cascade on delete restrict, FOREIGN KEY("groupoid") REFERENCES "categories"("name") on update cascade on delete restrict );