Schema
Owner
ychaval
Descriptions
There is no description for view v_elisa_rousset__elodie_2013
Fields
Name | Data type | Description |
---|---|---|
ani_etiq |
varchar(16) |
|
para_laboriginid |
text |
|
para_daysampling |
date |
|
exp_name |
text |
|
var_name_long |
text |
|
pat_name |
text |
|
para_res |
text |
|
eli_analysis_kit |
text |
|
para_pcr_id |
integer |
|
para_cnt_id |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Indices
There are no indices for table v_elisa_rousset__elodie_2013
Definition
CREATE VIEW para_phy.v_elisa_rousset__elodie_2013 (
ani_etiq,
para_laboriginid,
para_daysampling,
exp_name,
var_name_long,
pat_name,
para_res,
eli_analysis_kit,
para_pcr_id,
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,
tr_analysis_elisa_eli.eli_analysis_kit,
t_parasitology_para.para_pcr_id,
t_parasitology_para.para_cnt_id
FROM para_phy.t_parasitology_para,
para_phy.tr_analysis_elisa_eli,
para_phy.tr_pathogen_pat,
para_phy.tr_variable_measured_var,
para_phy.tr_experimenter_exp,
t_animal_ani
WHERE t_parasitology_para.para_eli_id = tr_analysis_elisa_eli.eli_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 = 'Rousset, Elodie'::text AND date_part('year'::text, t_parasitology_para.para_daysampling) = 2013::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 |