categorysteamapplink

Table actions

Data source: steam-to-sqlite

5 rows where steam_app_pk = 2072

✎ View and edit SQL

This data as json, CSV (advanced)

Link category_pk steam_app_pk
1,2072 1 1 Pixel Puzzles 2: Paintings 2072
4,2072 4 4 Pixel Puzzles 2: Paintings 2072
7,2072 7 7 Pixel Puzzles 2: Paintings 2072
24,2072 24 24 Pixel Puzzles 2: Paintings 2072
285,2072 285 285 Pixel Puzzles 2: Paintings 2072

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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