opposite_categories
1 row where category = 1 sorted by category descending
This data as json, CSV (advanced)
Link | category ▲ | op |
---|---|---|
1,1 | 1 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "opposite_categories" ( "category" TEXT NOT NULL UNIQUE, "op" TEXT NOT NULL CHECK("category" <= "op") UNIQUE, FOREIGN KEY("category") REFERENCES "categories"("name") on delete restrict on update cascade, PRIMARY KEY("category","op"), FOREIGN KEY("op") REFERENCES "categories"("name") on delete restrict on update cascade );