dataset_un_released

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

first_name

varchar

2147483647

√

null

last_name

varchar

2147483647

√

null

email

varchar

100

√

null

submission_id

int4

10

√

null

title

varchar

500

√

null

release_date

date

13

√

null

dataset_doi

varchar

100

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT DISTINCT t1.first_name,
    t1.last_name,
    t1.email,
    t1.submission_id,
    t1.title,
    t1.release_date,
    t1.dataset_doi
   FROM ( SELECT p.first_name,
            p.last_name,
            p.email,
            a.submission_id,
            s.title,
            s.release_date,
            s.dataset_doi
           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 (date_trunc('day'::text, (s.release_date)::timestamp with time zone) >= date_trunc('day'::text, now())) AND (s.status_id = 2) AND (a.person_num IS NOT NULL) AND ((p.email)::text <> 'info@earthchem.org'::text) AND (p.email IS NOT NULL) AND ((p.email)::text <> ' '::text))))
        UNION
         SELECT g.first_name,
            g.last_name,
            g.email,
            s.submission_id,
            s.title,
            s.release_date,
            s.dataset_doi
           FROM (submissions s
             JOIN grl_user g ON (((g.email IS NOT NULL) AND ((g.email)::text <> ' '::text) AND ((g.email)::text <> 'info@earthchem.org'::text) AND (g.account_id = s.created_by) AND ((g.last_name)::text <> 'EarthChem'::text) AND (s.status_id = 2) AND (date_trunc('day'::text, (s.release_date)::timestamp with time zone) >= date_trunc('day'::text, now())))))) t1
  ORDER BY t1.release_date;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views