opposite_categories

0 rows where category = "SpLoc"

✎ View and edit SQL

This data as json

0 records

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