categorysteamapplink

Table actions

Data source: steam-to-sqlite

4 rows where steam_app_pk = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Link category_pk steam_app_pk
1,27 1 1 Half-Life: Opposing Force 27
2,27 2 2 Half-Life: Opposing Force 27
22,27 22 22 Half-Life: Opposing Force 27
285,27 285 285 Half-Life: Opposing Force 27

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