db_globoxylo |
|
View: v_measure_tre
db_globoxylo |
|
View: v_measure_tre
Schema
Owner
globoxylo_application
Descriptions
There is no description for view v_measure_tre
Columns
Name | Data type | Description |
|---|---|---|
hierarchical_study_zone |
public.ltree |
|
study_zone_code |
varchar(64) |
|
type_of_zone |
varchar(32) |
|
tree_code |
varchar(24) |
|
tree_note |
varchar |
|
taxon_label |
varchar(255) |
|
taxon_code |
varchar(64) |
|
variable_name |
varchar(50) |
|
variable_code |
varchar(25) |
|
numeric_value |
double precision |
|
text_value |
varchar |
|
date_value |
date |
|
generic_value |
text |
|
measurement_date |
date |
|
precision_measurement_date |
double precision |
|
precision_measurement |
double precision |
|
unit_name |
varchar(50) |
|
protocol_name |
varchar(50) |
|
protocol_description |
varchar(255) |
|
protocol_url |
varchar(255) |
|
origin_file_name |
varchar(120) |
|
origin_file_url_path |
varchar(255) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_measure_tre
Definition
hierarchical_study_zone,
study_zone_code,
type_of_zone,
tree_code,
tree_note,
taxon_label,
taxon_code,
variable_name,
variable_code,
numeric_value,
text_value,
date_value,
generic_value,
measurement_date,
precision_measurement_date,
precision_measurement,
unit_name,
protocol_name,
protocol_description,
protocol_url,
origin_file_name,
origin_file_url_path)
AS
SELECT tr_study_zone_zon.zon_tree AS hierarchical_study_zone,
tr_study_zone_zon.zon_code AS study_zone_code,
tr_type_study_zone_typz.typz_code AS type_of_zone,
t_tree_tre.tre_code AS tree_code,
t_tree_tre.tre_note AS tree_note,
tr_taxon_tax.tax_label AS taxon_label,
tr_taxon_tax.tax_identifier_ext AS taxon_code,
tr_variable_var.var_name AS variable_name,
tr_variable_var.var_code AS variable_code,
t_measure_mtre.mtre_value_num AS numeric_value,
t_measure_mtre.mtre_value_text AS text_value,
t_measure_mtre.mtre_value_date AS date_value,
COALESCE(t_measure_mtre.mtre_value_num::text,
t_measure_mtre.mtre_value_text::text, t_measure_mtre.mtre_value_date::text) AS generic_value,
t_measure_mtre.mtre_date_measurement AS measurement_date,
t_measure_mtre.mtre_precision_date_measurement AS precision_measurement_date,
t_measure_mtre.mtre_precision_measurement AS precision_measurement,
tr_unit_uni.uni_name AS unit_name,
tr_protocol_prot.prot_name AS protocol_name,
tr_protocol_prot.prot_description AS protocol_description,
tr_protocol_prot.prot_url AS protocol_url,
tr_file_fil.fil_name AS origin_file_name,
tr_file_fil.fil_url AS origin_file_url_path
FROM tr_study_zone_zon
JOIN tr_type_study_zone_typz ON tr_study_zone_zon.zon_typz_id =
tr_type_study_zone_typz.typz_id
JOIN t_tree_tre ON tr_study_zone_zon.zon_id = t_tree_tre.tre_zon_id
JOIN tr_taxon_tax ON t_tree_tre.tre_tax_id = tr_taxon_tax.tax_id
LEFT JOIN t_measure_mtre ON t_tree_tre.tre_id = t_measure_mtre.mtre_tre_id
JOIN tr_variable_var ON t_measure_mtre.mtre_var_id = tr_variable_var.var_id
LEFT JOIN tr_unit_uni ON t_measure_mtre.mtre_uni_id = tr_unit_uni.uni_id
LEFT JOIN tr_type_measure_tym ON t_measure_mtre.mtre_tym_id =
tr_type_measure_tym.tym_id
LEFT JOIN tr_protocol_prot ON t_measure_mtre.mtre_prot_id =
tr_protocol_prot.prot_id
LEFT JOIN tr_file_fil ON t_measure_mtre.mtre_fil_id = tr_file_fil.fil_id
ORDER BY tr_study_zone_zon.zon_tree, t_tree_tre.tre_code,
t_measure_mtre.mtre_date_measurement, tr_variable_var.var_code;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|