person_submissions2

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

first_name

varchar

45

√

null

last_name

varchar

45

√

null

email

varchar

100

√

null

person_num

int4

10

√

null

person.person_num

Implied ConstraintR

submission_id

int4

10

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT DISTINCT t1.first_name,
    t1.last_name,
    t1.email,
    t1.person_num,
    t1.submission_id
   FROM (( SELECT p.first_name,
            p.last_name,
            p.email,
            p.person_num,
            a.submission_id
           FROM ((author_list a
             JOIN person p ON (((p.person_num = a.person_num) AND (a.author_order = 1))))
             JOIN submissions s ON (((a.submission_id = s.submission_id) AND (s.release_date < now()) AND (s.status_id = 2) AND (a.person_num IS NOT NULL) AND ((p.email)::text <> 'info@earthchem.org'::text))))) t1
     FULL JOIN ( SELECT g.first_name,
            g.last_name,
            g.email,
            s.submission_id
           FROM (submissions s
             JOIN grl_user g ON ((((g.email)::text <> 'info@earthchem.org'::text) AND (g.account_id = s.owner) AND ((g.last_name)::text <> 'EarthChem'::text) AND (s.status_id = 2) AND (s.release_date <= now()))))) t2 ON ((((t2.first_name)::text = (t1.first_name)::text) AND ((t2.last_name)::text = (t1.last_name)::text) AND ((t2.email)::text = (t1.email)::text))))
  WHERE ((t1.email IS NOT NULL) OR ((t1.email)::text <> ' '::text))
  ORDER BY t1.last_name, t1.first_name, t1.email, t1.person_num, t1.submission_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views