wpr_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

wpr

varchar

2147483647

√

null

wpr_botanical

varchar

2147483647

√

null

wpr_botanical_display

varchar

2147483647

√

null

wpr_colloquial

varchar

2147483647

√

null

scale

numeric

131089

√

null

count

int4

√

null

wpr_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.wpr_analysis THEN wpr_lkp_b.wpr
            ELSE wpr_lkp_a.wpr
        END AS wpr,
        CASE
            WHEN e.wpr_analysis THEN wpr_b.wpr_botanical
            ELSE wpr_a.species
        END AS wpr_botanical,
        CASE
            WHEN e.wpr_analysis THEN wpr_lkp_b.waterlogged_name_display
            ELSE wpr_lkp_a.waterlogged_name_display
        END AS wpr_botanical_display,
        CASE
            WHEN e.wpr_analysis THEN wpr_lkp_b.waterlogged_colloq
            ELSE wpr_lkp_a.waterlogged_colloq
        END AS wpr_colloquial,
        CASE
            WHEN e.wpr_analysis THEN wpr_b.scale
            ELSE NULL::numeric
        END AS scale,
        CASE
            WHEN e.wpr_analysis THEN wpr_b.count
            ELSE NULL::integer
        END AS count,
    e.wpr_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_wpr_species_b wpr_b USING (enviro_id))
     LEFT JOIN lkp_waterlogged wpr_lkp_b ON (((wpr_b.wpr_botanical)::text = (wpr_lkp_b.waterlogged_name)::text)))
     LEFT JOIN tbl_wpr_species wpr_a USING (sample_number))
     LEFT JOIN lkp_waterlogged wpr_lkp_a ON (((wpr_a.species)::text = (wpr_lkp_a.waterlogged_name)::text)))
  WHERE ((wpr_a.sample_number IS NOT NULL) OR (wpr_b.enviro_id IS NOT NULL))
  ORDER BY e.sample_number, e.context_number)
UNION
 SELECT e.enviro_id,
    e.sample_number,
    e.context_number,
    ctx.part_of_group AS context_group,
    ctx.trench,
        CASE
            WHEN e.wpr_analysis THEN ('Matrix: '::text || (wm_b.wprmatrix_subtype)::text)
            ELSE ('Matrix: '::text || (wm_a.wprmatrix_subtype)::text)
        END AS wpr,
    NULL::character varying AS wpr_botanical,
    ''::character varying AS wpr_botanical_display,
        CASE
            WHEN e.wpr_analysis THEN wpr_b.wpr_matrix
            ELSE wpr_a.wpr_matrix
        END AS wpr_colloquial,
        CASE
            WHEN e.wpr_analysis THEN wpr_b.wpr_score
            ELSE wpr_a.wpr_score
        END AS scale,
    NULL::integer AS count,
    e.wpr_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_wpr_matrix_b wpr_b USING (enviro_id))
     LEFT JOIN tbl_wpr_matrix wpr_a USING (enviro_id))
     LEFT JOIN lkp_wpr_matrix wm_a ON (((wm_a.wprmatrix)::text = (wpr_a.wpr_matrix)::text)))
     LEFT JOIN lkp_wpr_matrix wm_b ON (((wm_b.wprmatrix)::text = (wpr_b.wpr_matrix)::text)))
  WHERE ((wpr_a.enviro_id IS NOT NULL) OR (wpr_b.enviro_id IS NOT NULL))
  ORDER BY 2, 3;

Columns

View Definition

Possibly Referenced Tables/Views