pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr

View: v_activite_2012

Schema

public

Owner

morellet

Descriptions

Vue contenant toutes les activités de 2012 et le n° individu et le cap_bague

Fields

Rules

Indices

There are no indices for table v_activite_2012

Definition

CREATE VIEW public.v_activite_2012 (
   act_id,
   act_ani_id,
   ani_etiq,
   cap_bague,
   act_sequence,
   act_doublon_horodatage,
   act_date,
   act_heure,
   act_x,
   act_y,
   act_head_down,
   act_temp,
   cap_annee_suivi)
AS
SELECT t_activite_act.act_id,
   t_activite_act.act_ani_id,
   t_animal_ani.ani_etiq,
   t_capture_cap.cap_bague,
   t_activite_act.act_sequence,
   t_activite_act.act_doublon_horodatage,
   t_activite_act.act_date,
   t_activite_act.act_heure,
   t_activite_act.act_x,
   t_activite_act.act_y,
   t_activite_act.act_head_down,
   t_activite_act.act_temp,
   t_capture_cap.cap_annee_suivi
FROM t_activite_act
    JOIN t_animal_ani ON t_activite_act.act_ani_id = t_animal_ani.ani_id
    JOIN t_capture_cap ON t_animal_ani.ani_id = t_capture_cap.cap_ani_id
WHERE t_capture_cap.cap_annee_suivi = t_activite_act.act_annee_suivi AND
   t_capture_cap.cap_annee_suivi = 2012
GROUP BY t_activite_act.act_id, t_activite_act.act_ani_id,
   t_activite_act.act_sequence, t_activite_act.act_doublon_horodatage, t_activite_act.act_date, t_activite_act.act_heure, t_activite_act.act_x, t_activite_act.act_y, t_activite_act.act_head_down, t_activite_act.act_temp, t_animal_ani.ani_etiq, t_capture_cap.cap_annee_suivi, t_capture_cap.cap_bague
ORDER BY t_activite_act.act_id;

COMMENT ON VIEW public.v_activite_2012
IS 'Vue contenant toutes les activités de 2012 et le n° individu et le cap_bague';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23