pollen_report

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

spec_id

int4

√

null

enviro_id

int4

√

null

sample_number

int4

√

null

context

int4

√

null

context_group

int4

√

null

trench

varchar

√

null

pollen_name

varchar

2147483647

√

null

lkp_pollen.pollen_name

Implied ConstraintR

pollen_group_letter

varchar

√

null

pollen_group

varchar

√

null

quantity

int4

√

null

min_depth

int4

√

null

max_depth

int4

√

null

depth_range

text

2147483647

√

null

entity

_varchar

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT DISTINCT monspec.spec_id,
    e.enviro_id,
    e.sample_number,
    ctx.context,
    ctx.part_of_group AS context_group,
    ctx.trench,
    pollen.pollen_name,
    pollen.pollen_group_letter,
    pollen.pollen_group,
    monspec.quantity,
    mon.min_depth,
    mon.max_depth,
    ((mon.min_depth || '-'::text) || mon.max_depth) AS depth_range,
    ARRAY( SELECT view_context_entity.entity
           FROM view_context_entity
          WHERE (view_context_entity.context = ctx.context)) AS entity
   FROM ((((tbl_monspec monspec
     JOIN tbl_monolith mon USING (mon_id))
     JOIN tbl_contexts ctx ON ((ctx.context = mon.context)))
     JOIN tbl_environmental e USING (sample_number))
     JOIN lkp_pollen pollen ON (((pollen.pollen_name)::text = (monspec.species)::text)))
  ORDER BY e.sample_number, ctx.context, monspec.spec_id, e.enviro_id, ctx.part_of_group, ctx.trench, pollen.pollen_name, pollen.pollen_group_letter, pollen.pollen_group, monspec.quantity, ARRAY( SELECT view_context_entity.entity
           FROM view_context_entity
          WHERE (view_context_entity.context = ctx.context));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views