cpr_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

cpr_type

varchar

2147483647

√

null

cpr_sub_type

varchar

2147483647

√

null

cpr_sub_type_display

varchar

2147483647

√

null

cpr_colloq

varchar

2147483647

√

null

count

int4

√

null

scale

numeric

131089

√

null

cpr_environment

varchar

2147483647

√

null

cpr_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.cpr_analysis THEN cpr_lkp.cpr_type
            ELSE cpr_a.cpr_type
        END AS cpr_type,
        CASE
            WHEN e.cpr_analysis THEN cpr_b.cpr_sub_type
            ELSE cpr_a.species
        END AS cpr_sub_type,
        CASE
            WHEN e.cpr_analysis THEN cpr_lkp.cpr_sub_type_display
            ELSE cpr_lkp_a.cpr_sub_type_display
        END AS cpr_sub_type_display,
        CASE
            WHEN e.cpr_analysis THEN cpr_lkp.cpr_colloq
            ELSE cpr_lkp_a.cpr_colloq
        END AS cpr_colloq,
        CASE
            WHEN e.cpr_analysis THEN cpr_b.count
            ELSE NULL::integer
        END AS count,
        CASE
            WHEN e.cpr_analysis THEN cpr_b.scale
            ELSE NULL::numeric
        END AS scale,
        CASE
            WHEN e.cpr_analysis THEN cpr_lkp.cpr_environment
            ELSE cpr_lkp_a.cpr_environment
        END AS cpr_environment,
    e.cpr_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_cpr_b cpr_b USING (enviro_id))
     LEFT JOIN lkp_cpr cpr_lkp USING (cpr_sub_type))
     LEFT JOIN tbl_cpr cpr_a USING (sample_number))
     LEFT JOIN lkp_cpr cpr_lkp_a ON (((cpr_a.species)::text = (cpr_lkp_a.cpr_sub_type)::text)))
  WHERE ((cpr_a.sample_number IS NOT NULL) OR (cpr_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,
    NULL::character varying AS cpr_type,
    'Matrix'::character varying AS cpr_sub_type,
    'Matrix'::character varying AS cpr_sub_type_display,
    matrix.cprmatrix AS cpr_colloq,
    NULL::integer AS count,
    matrix.value AS scale,
    NULL::character varying AS cpr_environment,
    e.cpr_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)))
     JOIN tbl_cpr_matrix matrix USING (enviro_id))
  ORDER BY 1, 2, 3, 4, 5;

Columns

View Definition

Possibly Referenced Tables/Views