db_venik |
|
View: v_recherche_synonyme
db_venik |
|
View: v_recherche_synonyme
Schema
Owner
albenard
Descriptions
There is no description for view v_recherche_synonyme
Columns
Name | Data type | Description |
|---|---|---|
idsynonyme |
integer |
|
idgeno |
integer |
|
com_syno |
text |
|
nom |
varchar(128) |
|
type_geno |
integer |
|
idgenre |
integer |
|
nom_court |
varchar(30) |
|
idespece |
integer |
|
lieu_origine |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_recherche_synonyme
Definition
idsynonyme,
idgeno,
com_syno,
nom,
type_geno,
idgenre,
nom_court,
idespece,
lieu_origine)
AS
SELECT s.idsynonyme,
gt.idgeno,
s.commentaire AS com_syno,
s.nom,
gt.type_geno,
ge.idgenre,
gt.nom_court,
e.idespece,
gt.lieu_origine
FROM synonyme_geno s,
genotype gt,
espece e,
genre ge
WHERE s.idgeno = gt.idgeno AND gt.idespece = e.idespece AND e.idgenre = ge.idgenre;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|