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