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

View: v_counting_hoste__herve_2010

Schema

para_phy

Owner

ychaval

Descriptions

There is no description for view v_counting_hoste__herve_2010

Fields

Rules

Indices

There are no indices for table v_counting_hoste__herve_2010

Definition

CREATE VIEW para_phy.v_counting_hoste__herve_2010 (
   ani_etiq,
   para_laboriginid,
   para_daysampling,
   exp_name,
   var_name_long,
   pat_name,
   para_res,
   para_eli_id,
   para_pcr_id,
   cnt_analysis_type)
AS
SELECT t_animal_ani.ani_etiq,
   t_parasitology_para.para_laboriginid,
   t_parasitology_para.para_daysampling,
   tr_experimenter_exp.exp_name,
   tr_variable_measured_var.var_name_long,
   tr_pathogen_pat.pat_name,
   t_parasitology_para.para_res,
   t_parasitology_para.para_eli_id,
   t_parasitology_para.para_pcr_id,
   tr_analysis_counting_cnt.cnt_analysis_type
FROM para_phy.t_parasitology_para,
   para_phy.tr_analysis_counting_cnt,
   para_phy.tr_pathogen_pat,
   para_phy.tr_variable_measured_var,
   para_phy.tr_experimenter_exp,
   t_animal_ani
WHERE t_parasitology_para.para_cnt_id = tr_analysis_counting_cnt.cnt_id AND
   t_parasitology_para.para_pat_id = tr_pathogen_pat.pat_id AND t_parasitology_para.para_var_id = tr_variable_measured_var.var_id AND t_parasitology_para.para_exp_id = tr_experimenter_exp.exp_id AND t_parasitology_para.para_ani_id = t_animal_ani.ani_id AND tr_experimenter_exp.exp_name = 'Hoste, Herve'::text AND date_part('year'::text, t_parasitology_para.para_daysampling) = 2010::double precision
ORDER BY tr_pathogen_pat.pat_name, tr_variable_measured_var.var_name_long,
   t_parasitology_para.para_daysampling;

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