categorysteamapplink
Data source: steam-to-sqlite
16 rows where steam_app_pk = 195
This data as json, CSV (advanced)
| Link | category_pk | steam_app_pk |
|---|---|---|
| 1,195 | 1 1 | Portal 195 |
| 4,195 | 4 4 | Portal 195 |
| 5,195 | 5 5 | Portal 195 |
| 18,195 | 18 18 | Portal 195 |
| 25,195 | 25 25 | Portal 195 |
| 26,195 | 26 26 | Portal 195 |
| 27,195 | 27 27 | Portal 195 |
| 29,195 | 29 29 | Portal 195 |
| 32,195 | 32 32 | Portal 195 |
| 285,195 | 285 285 | Portal 195 |
| 287,195 | 287 287 | Portal 195 |
| 291,195 | 291 291 | Portal 195 |
| 292,195 | 292 292 | Portal 195 |
| 295,195 | 295 295 | Portal 195 |
| 298,195 | 298 298 | Portal 195 |
| 299,195 | 299 299 | Portal 195 |
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) );