view_cpr_entity

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

enviro_id

int4

√

null

sample_number

int4

√

null

cpr_type

varchar

2147483647

√

null

cpr_sub_type

varchar

2147483647

√

null

cpr_colloq

varchar

2147483647

√

null

entity

varchar

√

null

View Definition

SELECT DISTINCT e.enviro_id,
    e.sample_number,
        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_colloq
            ELSE cpr_lkp_a.cpr_colloq
        END AS cpr_colloq,
    ent.entity
   FROM ((((((tbl_environmental e
     LEFT JOIN tbl_contexts ctx ON ((e.context_number = ctx.context)))
     LEFT JOIN view_context_entity ent USING (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))
UNION
 SELECT e.enviro_id,
    e.sample_number,
    NULL::character varying AS cpr_type,
    'Matrix'::character varying AS cpr_sub_type,
    matrix.cprmatrix AS cpr_colloq,
    ent.entity
   FROM (((tbl_environmental e
     LEFT JOIN tbl_contexts ctx ON ((e.context_number = ctx.context)))
     LEFT JOIN view_context_entity ent USING (context))
     JOIN tbl_cpr_matrix matrix USING (enviro_id));

Columns

View Definition

Possibly Referenced Tables/Views