team
2 rows where division_id = 5
This data as json, CSV (advanced)
| id ▼ | name | year_founded | division_id | franchise_id |
|---|---|---|---|---|
| 1 | Abbotsford Heat | 2009 | West 5 | |
| 53 | Abbotsford Heat | 2009 | West 5 | 2 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "team" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(32) NULL, "year_founded" integer NULL, "division_id" bigint NULL REFERENCES "division" ("id") DEFERRABLE INITIALLY DEFERRED, "franchise_id" bigint NULL REFERENCES "franchise" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE INDEX "team_division_id_d045beb7" ON "team" ("division_id");
CREATE INDEX "team_franchise_id_c7da83a8" ON "team" ("franchise_id");