db_venik |
|
View: geno_sans_graines2
db_venik |
|
View: geno_sans_graines2
Schema
Owner
albenard
Descriptions
There is no description for view geno_sans_graines2
Columns
Name | Data type | Description |
|---|---|---|
idgeno |
integer |
|
idespece |
integer |
|
nom_court |
varchar(30) |
|
type_geno |
integer |
|
nb_lots |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table geno_sans_graines2
Definition
idgeno,
idespece,
nom_court,
type_geno,
nb_lots)
AS
SELECT genotype.idgeno,
genotype.idespece,
genotype.nom_court,
genotype.type_geno,
graine.nb_lots
FROM genotype,
graine
WHERE genotype.idgeno = graine.idgeno_gr AND graine.nb_lots > 1;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|