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

View: v_pcr_bastian__suzanne_2012

Schema

para_phy

Owner

ychaval

Descriptions

There is no description for view v_pcr_bastian__suzanne_2012

Fields

Rules

Indices

There are no indices for table v_pcr_bastian__suzanne_2012

Definition

CREATE VIEW para_phy.v_pcr_bastian__suzanne_2012 (
   ani_etiq,
   para_laboriginid,
   para_daysampling,
   exp_name,
   var_name_long,
   pat_name,
   para_res,
   para_eli_id,
   pcr_analysis_type,
   para_cnt_id)
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,
   tr_analysis_pcr_pcr.pcr_analysis_type,
   t_parasitology_para.para_cnt_id
FROM para_phy.t_parasitology_para,
   para_phy.tr_analysis_pcr_pcr,
   para_phy.tr_pathogen_pat,
   para_phy.tr_variable_measured_var,
   para_phy.tr_experimenter_exp,
   t_animal_ani
WHERE t_parasitology_para.para_pcr_id = tr_analysis_pcr_pcr.pcr_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 = 'Bastian, Suzanne'::text AND date_part('year'::text, t_parasitology_para.para_daysampling) = 2012::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