pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
View: yannick_essai
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
View: yannick_essai
Schema
Owner
ychaval
Descriptions
There is no description for view yannick_essai
Fields
Name | Data type | Description |
|---|---|---|
ani_id |
integer |
|
ani_etiq |
varchar(16) |
|
ani_sexe |
|
|
ani_mortalite |
boolean |
|
ani_date_mort |
date |
|
ani_date_mort_arrondi |
boolean |
|
ani_date_mort_text |
char(32) |
|
ani_poids_mort |
real |
|
ani_cause_mort |
char(32) |
|
ani_poids_mort_na |
boolean |
|
ani_remarque |
varchar(255) |
|
ani_mort_x |
double precision |
|
ani_mort_y |
double precision |
|
ani_inconnu |
boolean |
|
cap_date |
date |
|
cap_poids |
double precision |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table yannick_essai
Definition
ani_id,
ani_etiq,
ani_sexe,
ani_mortalite,
ani_date_mort,
ani_date_mort_arrondi,
ani_date_mort_text,
ani_poids_mort,
ani_cause_mort,
ani_poids_mort_na,
ani_remarque,
ani_mort_x,
ani_mort_y,
ani_inconnu,
cap_date,
cap_poids)
AS
SELECT t_animal_ani.ani_id,
t_animal_ani.ani_etiq,
t_animal_ani.ani_sexe,
t_animal_ani.ani_mortalite,
t_animal_ani.ani_date_mort,
t_animal_ani.ani_date_mort_arrondi,
t_animal_ani.ani_date_mort_text,
t_animal_ani.ani_poids_mort,
t_animal_ani.ani_cause_mort,
t_animal_ani.ani_poids_mort_na,
t_animal_ani.ani_remarque,
t_animal_ani.ani_mort_x,
t_animal_ani.ani_mort_y,
t_animal_ani.ani_inconnu,
t_capture_cap.cap_date,
t_capture_cap.cap_poids
FROM t_animal_ani,
t_capture_cap
WHERE t_animal_ani.ani_id = t_capture_cap.cap_ani_id;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|