db_toff on pggeodb.nancy.inra.fr |
|
View: v_tr_trait_tra
db_toff on pggeodb.nancy.inra.fr |
|
View: v_tr_trait_tra
Schema
Owner
toff
Descriptions
View for a specific access to toff_assistant / Vue dédiée à l'assistant de fabrication des fichiers d'import pour accès spécifique depuis le compte applicatif toff_assistant.
Fields
Name | Data type | Description |
|---|---|---|
tra_id |
integer |
|
tra_fam_id |
integer |
|
tra_name |
varchar(80) |
|
tra_definition |
varchar |
|
tra_unit |
varchar(20) |
|
tra_type |
varchar(25) |
|
tra_controle |
varchar(128) |
|
tra_reference |
varchar |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_tr_trait_tra
Definition
tra_id,
tra_fam_id,
tra_name,
tra_definition,
tra_unit,
tra_type,
tra_controle,
tra_reference)
AS
SELECT tr_trait_tra.tra_id,
tr_trait_tra.tra_fam_id,
tr_trait_tra.tra_name,
tr_trait_tra.tra_definition,
tr_trait_tra.tra_unit,
tr_trait_tra.tra_type,
tr_trait_tra.tra_controle,
tr_trait_tra.tra_reference
FROM tr_trait_tra;
COMMENT ON VIEW public.v_tr_trait_tra
IS 'View for a specific access to toff_assistant / Vue dédiée à l''assistant de fabrication des fichiers d''import pour accès spécifique depuis le compte applicatif toff_assistant.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19/06/2019 10:17 |
|