prelib_relationinterpersonnelle

Relations entre personnes

Data license: Licence Ouverte version 2.0

1 row where personne_id = 2179

View and edit SQL

id jour_debut_relation mois_debut_relation annee_debut_relation jour_fin_relation mois_fin_relation annee_fin_relation personne_id qualite_relation_id relation_id
1457             Bernard de Parades 2179 correspondant 83 Francis Even 451

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "prelib_relationinterpersonnelle" (
"id" INTEGER,
  "jour_debut_relation" INTEGER,
  "mois_debut_relation" INTEGER,
  "annee_debut_relation" INTEGER,
  "jour_fin_relation" INTEGER,
  "mois_fin_relation" INTEGER,
  "annee_fin_relation" INTEGER,
  "personne_id" INTEGER,
  "qualite_relation_id" INTEGER,
  "relation_id" INTEGER
  ,PRIMARY KEY ([id]),
   FOREIGN KEY(personne_id) REFERENCES prelib_personne(id),
   FOREIGN KEY(relation_id) REFERENCES prelib_personne(id),
   FOREIGN KEY(qualite_relation_id) REFERENCES prelib_qualiterelation(id)
);
Powered by Datasette · Query took 26.729ms · Data license: Licence Ouverte version 2.0