posts_gdocs_x_images

Data license: CC-BY

2 rows where gdocId = "10xzhxqLpGUdeXB11WLvDYQb2DO3NUggjMuPFJGKZoLg"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ gdocId imageId
4807 The short history of global living conditions and why it matters that we know it 10xzhxqLpGUdeXB11WLvDYQb2DO3NUggjMuPFJGKZoLg 1091 1091
4808 The short history of global living conditions and why it matters that we know it 10xzhxqLpGUdeXB11WLvDYQb2DO3NUggjMuPFJGKZoLg 1092 1092

Advanced export

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

CSV options: 

CREATE TABLE "posts_gdocs_x_images" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"gdocId" VARCHAR(255) NOT NULL  ,
	"imageId" INTEGER NOT NULL,
	FOREIGN KEY("gdocId") REFERENCES "posts_gdocs" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION,
	FOREIGN KEY("imageId") REFERENCES "images" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION
);
CREATE INDEX "gdocId" ON "posts_gdocs_x_images" ("gdocId");
CREATE INDEX "imageId" ON "posts_gdocs_x_images" ("imageId");