pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr |
|
View: v_t4f_poplar_2013_plants
pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr |
|
View: v_t4f_poplar_2013_plants
Schema
public
Owner
albenard
Descriptions
Cette vue établit le listing des plants associés au projet T4F_Poplar_2013. Les informations sont triées par N° de plant
Fields
Name | Data type | Description |
|---|---|---|
plt_id |
integer |
|
plt_numero |
varchar(12) |
|
plt_pjt_id |
integer |
|
plt_commentaire |
varchar(128) |
|
plt_genotype |
varchar(64) |
|
plt_regime_hydrique |
varchar(64) |
|
plt_autre_stress |
varchar(64) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_t4f_poplar_2013_plants
Definition
plt_id,
plt_numero,
plt_pjt_id,
plt_commentaire,
plt_genotype,
plt_regime_hydrique,
plt_autre_stress)
AS
SELECT t_plant_plt.plt_id,
t_plant_plt.plt_numero,
t_plant_plt.plt_pjt_id,
t_plant_plt.plt_commentaire,
t_plant_plt.plt_genotype,
t_plant_plt.plt_regime_hydrique,
t_plant_plt.plt_autre_stress
FROM t_plant_plt
WHERE (t_plant_plt.plt_id IN (
SELECT DISTINCT t_datarobot_dat.dat_plt_id
FROM t_fichier_fic
JOIN tr_robot_rob ON t_fichier_fic.fic_rob_id = tr_robot_rob.rob_id
JOIN tj_affectation_rob_pjt_aff ON tr_robot_rob.rob_id =
tj_affectation_rob_pjt_aff.aff_rob_id
JOIN t_projet_pjt ON t_projet_pjt.pjt_id =
tj_affectation_rob_pjt_aff.aff_pjt_id
JOIN t_datarobot_dat ON t_fichier_fic.fic_id = t_datarobot_dat.dat_fic_id
WHERE t_fichier_fic.fic_date >= tj_affectation_rob_pjt_aff.aff_date_debut
AND t_fichier_fic.fic_date <= tj_affectation_rob_pjt_aff.aff_date_fin AND t_projet_pjt.pjt_nom::text = 'T4F_Poplar_2013'::text
))
ORDER BY t_plant_plt.plt_numero;
COMMENT ON VIEW public.v_t4f_poplar_2013_plants
IS 'Cette vue établit le listing des plants associés au projet T4F_Poplar_2013. Les informations sont triées par N° de plant';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 26/02/2014 11:51 |
|