Schema
Owner
morellet
Descriptions
Vue contenant toutes les activités de 2003 et le n° individu et le cap_bague
Fields
Name | Data type | Description |
---|---|---|
act_id |
integer |
|
act_ani_id |
integer |
|
ani_etiq |
varchar(16) |
|
cap_bague |
varchar(12) |
|
act_sequence |
integer |
|
act_doublon_horodatage |
boolean |
|
act_date |
date |
|
act_heure |
time |
|
act_x |
real |
|
act_y |
real |
|
act_head_down |
real |
|
act_temp |
real |
|
cap_annee_suivi |
smallint |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Indices
There are no indices for table v_activite_2003
Definition
CREATE VIEW public.v_activite_2003 (
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 = 2003
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_2003
IS 'Vue contenant toutes les activités de 2003 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 |