charcoal_report

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

enviro_id

int4

√

null

sample_number

int4

√

null

context_number

int4

√

null

context_group

int4

√

null

trench

varchar

√

null

chr_taxa

varchar

2147483647

√

null

chr_taxa_display

varchar

2147483647

√

null

chr_colloq

varchar

2147483647

√

null

heartwood

numeric

131089

√

null

sapwood

numeric

131089

√

null

roundwood

numeric

131089

√

null

indeterminate

numeric

131089

√

null

scale

numeric

131089

√

null

charcoal_analysis

bool

√

null

entity

_varchar

√

null

View Definition

SELECT DISTINCT e.enviro_id,
    e.sample_number,
    e.context_number,
    ctx.part_of_group AS context_group,
    ctx.trench,
        CASE
            WHEN e.charcoal_analysis THEN chr_b.taxa
            ELSE chr_a.species
        END AS chr_taxa,
        CASE
            WHEN e.charcoal_analysis THEN chr_lkp.charcoal_taxa_display
            ELSE chr_lkp_a.charcoal_taxa_display
        END AS chr_taxa_display,
        CASE
            WHEN e.charcoal_analysis THEN chr_lkp.charcoal_colloq
            ELSE chr_lkp_a.charcoal_colloq
        END AS chr_colloq,
        CASE
            WHEN e.charcoal_analysis THEN chr_b.heartwood
            ELSE NULL::numeric
        END AS heartwood,
        CASE
            WHEN e.charcoal_analysis THEN chr_b.sapwood
            ELSE NULL::numeric
        END AS sapwood,
        CASE
            WHEN e.charcoal_analysis THEN chr_b.roundwood
            ELSE NULL::numeric
        END AS roundwood,
        CASE
            WHEN e.charcoal_analysis THEN chr_b.indeterminate
            ELSE NULL::numeric
        END AS indeterminate,
        CASE
            WHEN e.charcoal_analysis THEN chr_b.scale
            ELSE NULL::numeric
        END AS scale,
    e.charcoal_analysis,
    ARRAY( SELECT view_context_entity.entity
           FROM view_context_entity
          WHERE (view_context_entity.context = ctx.context)) AS entity
   FROM (((((tbl_environmental e
     LEFT JOIN tbl_contexts ctx ON ((e.context_number = ctx.context)))
     LEFT JOIN tbl_charcoal_b chr_b USING (enviro_id))
     LEFT JOIN lkp_charcoal chr_lkp ON (((chr_b.taxa)::text = (chr_lkp.charcoal_taxa)::text)))
     LEFT JOIN tbl_charcoal chr_a USING (sample_number))
     LEFT JOIN lkp_charcoal chr_lkp_a ON (((chr_a.species)::text = (chr_lkp_a.charcoal_taxa)::text)))
  WHERE ((chr_a.sample_number IS NOT NULL) OR (chr_b.enviro_id IS NOT NULL))
  ORDER BY e.sample_number, e.context_number;

Columns

View Definition

Possibly Referenced Tables/Views