full_subcategories

0 rows where subcategory = "Cat"

✎ View and edit SQL

This data as json

0 records

CREATE TABLE "full_subcategories" (
	"subcategory"	TEXT NOT NULL,
	"supercategory"	TEXT NOT NULL,
	FOREIGN KEY("subcategory") REFERENCES "categories"("name") on update cascade on delete restrict,
	FOREIGN KEY("supercategory") REFERENCES "categories"("name") on update cascade on delete restrict,
	PRIMARY KEY("subcategory","supercategory")
);