| A unified view of all astrophysical parameter analyses across all working groups |
| This view provides a single queryable row set that unifies all astrophysical parameter analyses across all working groups of the Gaia-ESO Consortium for those parameters in common between those analyses. The view filters out those older analyses that are deprecated and superseded by newer ones. |
SELECT specID, aamID, gratings, cName, TEff, logG, FeH, 'GiraffeAstroAnalysisWG10' AS originatingTable
FROM GiraffeAstroAnalysisWG10
WHERE deprecated = 0
UNION
SELECT specID, aamID, gratings, cName, TEff, logG, FeH, 'UvesAstroAnalysisWG11' AS originatingTable
FROM UvesAstroAnalysisWG11
WHERE deprecated = 0
UNION
SELECT specID, aamID, gratings, cName, TEff, logG, FeH, 'UvesAstroAnalysisWG12' AS originatingTable
FROM UvesAstroAnalysisWG12
WHERE deprecated = 0
UNION
SELECT specID, aamID, gratings, cName, TEff, logG, FeH, 'GiraffeAstroAnalysisWG12' AS originatingTable
FROM GiraffeAstroAnalysisWG12
WHERE deprecated = 0
UNION
SELECT specID, aamID, gratings, cName, TEff, logG, FeH, 'AstroAnalysisWG13' AS originatingTable
FROM AstroAnalysisWG13
WHERE deprecated = 0
The details of the table defined by this view are available here.