prelib_ecritoeuvre
Data license: Licence Ouverte version 2.0
34 rows where personne_id = 42 sorted by personne_id
This data as json, CSV (advanced)
Suggested facets: fonction_id
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "prelib_ecritoeuvre" ( "id" INTEGER, "date_ecriture" TEXT, "fonction_id" INTEGER, "oeuvre_id" INTEGER, "personne_id" INTEGER ,PRIMARY KEY ([id]), FOREIGN KEY(fonction_id) REFERENCES prelib_fonctionecritoeuvre(id), FOREIGN KEY(personne_id) REFERENCES prelib_personne(id), FOREIGN KEY(oeuvre_id) REFERENCES prelib_oeuvre(id) );