chart_tags
Data license: CC-BY
4 rows where chartId = 1170
This data as json, CSV (advanced)
Suggested facets: createdAt (date)
| Link | chartId | tagId | keyChartLevel | createdAt | updatedAt | isApproved |
|---|---|---|---|---|---|---|
| 1170,255 | Women's universal right to vote 1170 | Democracy 255 | 0 | 2024-03-13 16:14:05 | 1 | |
| 1170,269 | Women's universal right to vote 1170 | Women in Politics 269 | 0 | 2024-03-13 16:14:05 | 1 | |
| 1170,282 | Women's universal right to vote 1170 | Women's Rights 282 | 0 | 2024-03-13 16:14:05 | 1 | |
| 1170,285 | Women's universal right to vote 1170 | Human Rights 285 | 0 | 2024-03-13 16:14:05 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "chart_tags" (
"chartId" INTEGER NOT NULL ,
"tagId" INTEGER NOT NULL ,
"keyChartLevel" TINYINT NOT NULL DEFAULT '0' ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"isApproved" TINYINT NOT NULL DEFAULT '0' ,
PRIMARY KEY ("chartId", "tagId"),
FOREIGN KEY("chartId") REFERENCES "charts" ("id") ON UPDATE RESTRICT ON DELETE CASCADE,
FOREIGN KEY("tagId") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "FK_chart_tags_tagId" ON "chart_tags" ("tagId");