1 row where supercategory = "Ab"

View and edit SQL

Link subcategory supercategory reflector_hr reflection_hr
AbTorF Ab    

Advanced export

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

CSV options:

CREATE TABLE "reflective_subcategories" (
	"subcategory"	TEXT NOT NULL,
	"supercategory"	TEXT NOT NULL, "reflector_hr" text, "reflection_hr" text,
	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")
);