categories_with_animal_names

5 rows sorted by animal descending

✎ View and edit SQL

This data as json, CSV (advanced)

category animal ▲
Rex t. rex
Pfn puffin
Poiss fish
Ass donkey
Cat cat

Advanced export

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

CSV options: 

CREATE TABLE "categories_with_animal_names" (
	"category"	TEXT NOT NULL UNIQUE,
	"animal"	TEXT NOT NULL,
	FOREIGN KEY("category") REFERENCES "categories"("name") on update cascade on delete restrict,
	PRIMARY KEY("category")
);