prelib_batiment

Bâtiments

Data license: Licence Ouverte version 2.0

0 rows where departement_id = 48

View and edit SQL

0 records

CREATE TABLE "prelib_batiment" (
"id" INTEGER,
  "nom" TEXT,
  "wikidata" TEXT,
  "aire_geographique_id" INTEGER,
  "departement_id" INTEGER,
  "pays_id" INTEGER,
  "ville_id" INTEGER
  ,PRIMARY KEY ([id]),
   FOREIGN KEY(aire_geographique_id) REFERENCES prelib_airegeographique(id),
   FOREIGN KEY(departement_id) REFERENCES prelib_departement(id),
   FOREIGN KEY(ville_id) REFERENCES prelib_ville(id),
   FOREIGN KEY(pays_id) REFERENCES prelib_pays(id)
);
Powered by Datasette · Query took 16.724ms · Data license: Licence Ouverte version 2.0