-
Notifications
You must be signed in to change notification settings - Fork 0
/
view ViewGlobale.sql
76 lines (76 loc) · 3.26 KB
/
view ViewGlobale.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
CREATE OR REPLACE VIEW "BREF"."ViewGlobale"
AS
SELECT "Individu"."IdIndividu",
"Individu"."IdEluRNEHisto",
"Individu"."IdEluSenat",
"Individu"."IdEluAssemblee",
"Individu"."NomDeNaissance",
"Individu"."NomMarital1",
"Individu"."NomMarital2",
"Individu"."Prenom",
"Individu"."Sexe",
"Individu"."DateNaissance",
"Individu"."DateDeces",
"Individu"."Nationalite",
"Individu"."IdEurope",
"Individu"."CommuneNaissance",
"Individu"."DepartementNaissance",
"Individu"."PaysNaissance",
"Individu"."Prénom2",
"Individu"."Prénom3",
"Individu"."Dit",
"Individu"."IdPolitiquemania",
"Mandat"."IdMandat",
"Mandat"."TypeDuMandat_IdTypeMandat",
"Mandat"."DateDebutMandat",
"Mandat"."DateFinMandat",
"Mandat"."MotifFinMandat",
"Mandat"."Elu_IdIndividu",
"Mandat"."NomDUsageIndividu",
"Mandat"."Territoire_IdTerritoire",
"Mandat"."IdNuancePolitique",
"Mandat"."IdProfession",
"Mandat"."Sources",
"Mandat"."CorrectionsDate",
"Mandat"."CorrectionsAutres",
"Mandat"."Commentaire",
"Mandat"."IdPartiPolitique",
"TypeMandat"."IdTypeMandat",
"TypeMandat"."TypeMandat",
"ViewFonction"."IdFonction",
"ViewFonction"."DateDebutFonction",
"ViewFonction"."DateFinFonction",
"ViewFonction"."MotifFinFonction",
"ViewFonction"."TypeDeFonction_IdTypeFonction",
"ViewFonction"."Fonction_IdMandat",
"TypeFonction"."IdTypeFonction",
"TypeFonction"."TypeFonction",
"Territoire"."IdTerritoire",
"Territoire"."NomTerritoire",
"Territoire"."TypeTerritoire",
"Territoire"."CodeTerritoire",
"Territoire"."DateLiee",
"Territoire"."Actif",
"Inclusion"."IdInclusion",
"Inclusion"."TerritoireInclu_IdTerritoire",
"Inclusion"."TerritoireIncluant_IdTerritoire",
"Inclusion"."DateDebutInclusion",
"Inclusion"."DateFinInclusion",
"ViewPopulationCommune"."IdPopulationCommune",
"ViewPopulationCommune"."Population",
"ViewPopulationCommune"."DateReference",
"ViewPopulationCommune"."PCTerritoire_IdTerritoire",
"ViewNuancePolitique"."NP_IdNuancePolitique",
"ViewNuancePolitique"."NuancePolitique",
"Profession"."CodeProfession",
"Profession"."LibelleProfession"
FROM "BREF"."Individu"
JOIN "BREF"."Mandat" ON "Individu"."IdIndividu"::text = "Mandat"."Elu_IdIndividu"::text
JOIN "BREF"."TypeMandat" ON "Mandat"."TypeDuMandat_IdTypeMandat" = "TypeMandat"."IdTypeMandat"
JOIN "BREF"."ViewFonction" ON "Mandat"."IdMandat" = "ViewFonction"."Fonction_IdMandat"
JOIN "BREF"."TypeFonction" ON "ViewFonction"."TypeDeFonction_IdTypeFonction" = "TypeFonction"."IdTypeFonction"
JOIN "BREF"."Territoire" ON "Mandat"."Territoire_IdTerritoire"::text = "Territoire"."IdTerritoire"::text
JOIN "BREF"."Inclusion" ON "Territoire"."IdTerritoire"::text = "Inclusion"."TerritoireInclu_IdTerritoire"::text
JOIN "BREF"."ViewPopulationCommune" ON "Territoire"."IdTerritoire"::text = "ViewPopulationCommune"."PCTerritoire_IdTerritoire"::text
JOIN "BREF"."ViewNuancePolitique" ON "Mandat"."IdNuancePolitique" = "ViewNuancePolitique"."NP_IdNuancePolitique"
JOIN "BREF"."Profession" ON "Mandat"."IdProfession" = "Profession"."CodeProfession";