categorysteamapplink

Table actions

Data source: steam-to-sqlite

4 rows where steam_app_pk = 381

✎ View and edit SQL

This data as json, CSV (advanced)

Link category_pk steam_app_pk
1,381 1 1 Crystal Shard Adventure: META 381
3,381 3 3 Crystal Shard Adventure: META 381
7,381 7 7 Crystal Shard Adventure: META 381
285,381 285 285 Crystal Shard Adventure: META 381

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