i_tnp_z

30 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: region, ano

CREATE TABLE "i_tnp_z" (
	"id"	INTEGER NOT NULL UNIQUE,
	"region"	INTEGER NOT NULL,
	"canton"	INTEGER,
	"distrito"	INTEGER,
	"valor"	REAL,
	"ano"	INTEGER NOT NULL,
	"ente"	INTEGER,
	PRIMARY KEY("id" AUTOINCREMENT),
	FOREIGN KEY("ente") REFERENCES "d_entes"("id"),
	FOREIGN KEY("region") REFERENCES "d_regiones"("id")
);