post_tags

Relationship table to link posts and tags

Data license: CC-BY

9 rows where tag_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, createdAt (date)

Link post_id tag_id createdAt updatedAt
1441,5 Child and Infant Mortality 1441 Child & Infant Mortality 5 2023-10-12 09:53:44  
10179,5 10179 Child & Infant Mortality 5 2023-02-09 10:09:04  
20096,5 Why do women live longer than men? 20096 Child & Infant Mortality 5 2023-02-09 10:09:04  
21052,5 From commonplace to rarer tragedy - declining child mortality across the world 21052 Child & Infant Mortality 5 2023-02-09 10:09:04  
21315,5 The world is awful. The world is much better. The world can be much better. 21315 Child & Infant Mortality 5 2023-10-12 12:18:36  
21721,5 21721 Child & Infant Mortality 5 2023-10-12 09:53:50  
21827,5 21827 Child & Infant Mortality 5 2023-02-09 10:09:04  
22134,5 22134 Child & Infant Mortality 5 2023-02-09 10:09:04  
22161,5 22161 Child & Infant Mortality 5 2023-02-09 10:09:04  

Advanced export

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

CSV options: 

CREATE TABLE "post_tags" (
	"post_id" INTEGER NOT NULL  ,
	"tag_id" INTEGER NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	PRIMARY KEY ("post_id", "tag_id"),
	FOREIGN KEY("post_id") REFERENCES "posts" ("id") ON UPDATE RESTRICT ON DELETE CASCADE,
	FOREIGN KEY("tag_id") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE CASCADE
);
CREATE INDEX "FK_post_tags_tag_id" ON "post_tags" ("tag_id");