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) );