prelib_relationinterpersonnelle
Data license: Licence Ouverte version 2.0
7 rows where relation_id = 378
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|
223 | 1936 | 357 357 | connaissance 21 | 378 378 | |||||
232 | 361 361 | connaissance 21 | 378 378 | ||||||
234 | 359 359 | connaissance 21 | 378 378 | ||||||
271 | 376 376 | connaissance 21 | 378 378 | ||||||
281 | 340 340 | connaissance 21 | 378 378 | ||||||
294 | 380 380 | connaissance 21 | 378 378 | ||||||
315 | 379 379 | connaissance 21 | 378 378 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );