categorysteamapplink

Table actions

Data source: steam-to-sqlite

10 rows where steam_app_pk = 36

✎ View and edit SQL

This data as json, CSV (advanced)

Link category_pk steam_app_pk
1,36 1 1 Half-Life 36
2,36 2 2 Half-Life 36
5,36 5 5 Half-Life 36
7,36 7 7 Half-Life 36
16,36 16 16 Half-Life 36
21,36 21 21 Half-Life 36
22,36 22 22 Half-Life 36
25,36 25 25 Half-Life 36
26,36 26 26 Half-Life 36
285,36 285 285 Half-Life 36

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