view_typed_analysis_values

Columns

Column

Type

Size

Nulls

Auto

Children

Parents

Comments

table_id

int4

10

√

analysis_value_id

int8

19

√

tbl_analysis_values.analysis_value_id

Implied Constraint

R

Relationships

Close relationships within degrees of separation

View Definition

SELECT 1 AS table_id,
    tbl_analysis_boolean_values.analysis_value_id
   FROM tbl_analysis_boolean_values
UNION
 SELECT 2 AS table_id,
    tbl_analysis_categorical_values.analysis_value_id
   FROM tbl_analysis_categorical_values
UNION
 SELECT 3 AS table_id,
    tbl_analysis_dating_ranges.analysis_value_id
   FROM tbl_analysis_dating_ranges
UNION
 SELECT 4 AS table_id,
    tbl_analysis_identifiers.analysis_value_id
   FROM tbl_analysis_identifiers
UNION
 SELECT 5 AS table_id,
    tbl_analysis_integer_ranges.analysis_value_id
   FROM tbl_analysis_integer_ranges
UNION
 SELECT 6 AS table_id,
    tbl_analysis_integer_values.analysis_value_id
   FROM tbl_analysis_integer_values
UNION
 SELECT 7 AS table_id,
    tbl_analysis_notes.analysis_value_id
   FROM tbl_analysis_notes
UNION
 SELECT 8 AS table_id,
    tbl_analysis_numerical_ranges.analysis_value_id
   FROM tbl_analysis_numerical_ranges
UNION
 SELECT 9 AS table_id,
    tbl_analysis_numerical_values.analysis_value_id
   FROM tbl_analysis_numerical_values
UNION
 SELECT 10 AS table_id,
    tbl_analysis_taxon_counts.analysis_value_id
   FROM tbl_analysis_taxon_counts
UNION
 SELECT 11 AS table_id,
    tbl_analysis_value_dimensions.analysis_value_id
   FROM tbl_analysis_value_dimensions;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views