categories_with_animal_names
1 row where category = "Cat"
This data as json, CSV (advanced)
| category ▼ | animal |
|---|---|
| Cat | cat |
Advanced export
JSON shape: default, array, newline-delimited, object
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")
);