categorysteamapplink
Data source: steam-to-sqlite
12 rows where steam_app_pk = 1897
This data as json, CSV (advanced)
| Link | category_pk | steam_app_pk |
|---|---|---|
| 1,1897 | 1 1 | Patchwork 1897 |
| 2,1897 | 2 2 | Patchwork 1897 |
| 4,1897 | 4 4 | Patchwork 1897 |
| 6,1897 | 6 6 | Patchwork 1897 |
| 7,1897 | 7 7 | Patchwork 1897 |
| 14,1897 | 14 14 | Patchwork 1897 |
| 16,1897 | 16 16 | Patchwork 1897 |
| 17,1897 | 17 17 | Patchwork 1897 |
| 20,1897 | 20 20 | Patchwork 1897 |
| 21,1897 | 21 21 | Patchwork 1897 |
| 40,1897 | 40 40 | Patchwork 1897 |
| 285,1897 | 285 285 | Patchwork 1897 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "categorysteamapplink" ( category_pk INTEGER NOT NULL, steam_app_pk INTEGER NOT NULL, PRIMARY KEY (category_pk, steam_app_pk), FOREIGN KEY(steam_app_pk) REFERENCES steam_app (pk), FOREIGN KEY(category_pk) REFERENCES category (pk) );