categorysteamapplink
Data source: steam-to-sqlite
14 rows where steam_app_pk = 42
This data as json, CSV (advanced)
| Link | category_pk | steam_app_pk |
|---|---|---|
| 1,42 | 1 1 | Knight Squad 2 42 |
| 2,42 | 2 2 | Knight Squad 2 42 |
| 4,42 | 4 4 | Knight Squad 2 42 |
| 9,42 | 9 9 | Knight Squad 2 42 |
| 10,42 | 10 10 | Knight Squad 2 42 |
| 12,42 | 12 12 | Knight Squad 2 42 |
| 13,42 | 13 13 | Knight Squad 2 42 |
| 14,42 | 14 14 | Knight Squad 2 42 |
| 15,42 | 15 15 | Knight Squad 2 42 |
| 16,42 | 16 16 | Knight Squad 2 42 |
| 17,42 | 17 17 | Knight Squad 2 42 |
| 20,42 | 20 20 | Knight Squad 2 42 |
| 21,42 | 21 21 | Knight Squad 2 42 |
| 285,42 | 285 285 | Knight Squad 2 42 |
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) );