post_tags
Data license: CC-BY
5 rows where tag_id = 1
This data as json, CSV (advanced)
Suggested facets: createdAt (date)
Link | post_id | tag_id | createdAt | updatedAt |
---|---|---|---|---|
1308,1 | 1308 | Population Growth 1 | 2023-02-09 10:09:04 | |
22133,1 | India's population growth will come to an end: the number of children has already peaked 22133 | Population Growth 1 | 2023-03-20 10:57:53 | |
23503,1 | 23503 | Population Growth 1 | 2023-03-20 11:32:32 | |
23933,1 | More than 8 out of 10 people in the world will live in Asia or Africa by 2100 23933 | Population Growth 1 | 2023-03-20 11:09:49 | |
56663,1 | Population Growth 56663 | Population Growth 1 | 2023-04-10 09:45:51 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");