opposite_categories

1 row where category = "Prof"

✎ View and edit SQL

This data as json, CSV (advanced)

Link category op
Prof,Prof Prof Prof

Advanced export

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

CSV options: 

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