pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr |
|
View: v_UpTrans_2016_data
pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr |
|
View: v_UpTrans_2016_data
Schema
public
Owner
albenard
Descriptions
There is no description for view v_UpTrans_2016_data
Fields
Name | Data type | Description |
|---|---|---|
dat_id |
integer |
|
plt_id |
integer |
|
plt_numero |
varchar(12) |
|
plt_genotype |
varchar(64) |
|
plt_regime_hydrique |
varchar(64) |
|
plt_autre_stress |
varchar(64) |
|
rob_prefix |
varchar(3) |
|
emp_palette |
integer |
|
dat_palette |
integer |
|
dat_date |
date |
|
dat_time |
time(6) |
|
dat_horodatage |
timestamp(0) |
|
dat_consigne |
integer |
|
dat_poids_avant |
integer |
|
dat_poids_apres |
integer |
|
dat_taout |
boolean |
|
dat_taadd |
integer |
|
dat_coadd |
integer |
|
dat_wa |
integer |
|
dat_wa_corrige |
integer |
|
dat_ta |
integer |
|
dat_ta_corrige |
integer |
|
dat_tdiff |
double precision |
|
dat_tdiff_corrige |
double precision |
|
dat_tr |
double precision |
|
dat_tr_corrige |
double precision |
|
dat_remarque |
varchar(64) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_UpTrans_2016_data
Definition
dat_id,
plt_id,
plt_numero,
plt_genotype,
plt_regime_hydrique,
plt_autre_stress,
rob_prefix,
emp_palette,
dat_palette,
dat_date,
dat_time,
dat_horodatage,
dat_consigne,
dat_poids_avant,
dat_poids_apres,
dat_taout,
dat_taadd,
dat_coadd,
dat_wa,
dat_wa_corrige,
dat_ta,
dat_ta_corrige,
dat_tdiff,
dat_tdiff_corrige,
dat_tr,
dat_tr_corrige,
dat_remarque)
AS
SELECT t_datarobot_dat.dat_id,
t_plant_plt.plt_id,
t_plant_plt.plt_numero,
t_plant_plt.plt_genotype,
t_plant_plt.plt_regime_hydrique,
t_plant_plt.plt_autre_stress,
tr_robot_rob.rob_prefix,
tj_emplacement_plt_rob_emp.emp_palette,
t_datarobot_dat.dat_palette,
t_datarobot_dat.dat_date,
t_datarobot_dat.dat_time,
t_datarobot_dat.dat_horodatage,
t_datarobot_dat.dat_consigne,
t_datarobot_dat.dat_poids_avant,
t_datarobot_dat.dat_poids_apres,
t_datarobot_dat.dat_taout,
t_datarobot_dat.dat_taadd,
t_datarobot_dat.dat_coadd,
t_datarobot_dat.dat_wa,
t_datarobot_dat.dat_wa_corrige,
t_datarobot_dat.dat_ta,
t_datarobot_dat.dat_ta_corrige,
t_datarobot_dat.dat_tdiff,
t_datarobot_dat.dat_tdiff_corrige,
t_datarobot_dat.dat_tr,
t_datarobot_dat.dat_tr_corrige,
t_datarobot_dat.dat_remarque
FROM tj_emplacement_plt_rob_emp
JOIN t_plant_plt ON tj_emplacement_plt_rob_emp.emp_plt_id = t_plant_plt.plt_id
JOIN t_datarobot_dat ON t_plant_plt.plt_id = t_datarobot_dat.dat_plt_id
JOIN tr_robot_rob ON tj_emplacement_plt_rob_emp.emp_rob_id = tr_robot_rob.rob_id
JOIN t_fichier_fic ON t_datarobot_dat.dat_fic_id = t_fichier_fic.fic_id
WHERE (t_datarobot_dat.dat_id IN (
SELECT t_datarobot_dat_1.dat_id
FROM t_fichier_fic t_fichier_fic_1
JOIN tr_robot_rob tr_robot_rob_1 ON t_fichier_fic_1.fic_rob_id =
tr_robot_rob_1.rob_id
JOIN tj_affectation_rob_pjt_aff ON tr_robot_rob_1.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 t_datarobot_dat_1 ON t_fichier_fic_1.fic_id =
t_datarobot_dat_1.dat_fic_id
WHERE t_fichier_fic_1.fic_date >= tj_affectation_rob_pjt_aff.aff_date_debut
AND t_fichier_fic_1.fic_date <= tj_affectation_rob_pjt_aff.aff_date_fin AND t_projet_pjt.pjt_nom::text = 'UpTrans_2016'::text
)) AND t_fichier_fic.fic_rob_id = tr_robot_rob.rob_id AND
t_datarobot_dat.dat_palette = tj_emplacement_plt_rob_emp.emp_palette AND t_datarobot_dat.dat_horodatage >= lower(tj_emplacement_plt_rob_emp.emp_periode) AND t_datarobot_dat.dat_horodatage <= upper(tj_emplacement_plt_rob_emp.emp_periode)
ORDER BY t_plant_plt.plt_numero, t_datarobot_dat.dat_horodatage;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 26/02/2014 11:51 |
|