tags_variables_topic_tags

Data license: CC-BY

129,393 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE "tags_variables_topic_tags" (
	"tagId" INTEGER NOT NULL  ,
	"variableId" INTEGER NOT NULL  ,
	"displayOrder" SMALLINT NOT NULL DEFAULT '0' ,
	PRIMARY KEY ("tagId", "variableId"),
	FOREIGN KEY("tagId") REFERENCES "tags" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION,
	FOREIGN KEY("variableId") REFERENCES "variables" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION
);