person_submission_download_stats

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

last_name

varchar

2147483647

√

null

first_name

varchar

2147483647

√

null

email

varchar

100

√

null

submission_id

int4

10

√

null

life_time_download_cnt

int8

19

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT p.first_name AS last_name,
    p.last_name AS first_name,
    p.email,
    p.submission_id,
    d.life_time_download_cnt
   FROM (( SELECT p_1.first_name,
            p_1.last_name,
            p_1.email,
            a.submission_id
           FROM ((author_list a
             JOIN person p_1 ON (((p_1.person_num = a.person_num) AND (a.author_order = 1) AND (p_1.email IS NOT NULL))))
             JOIN submissions s ON (((a.submission_id = s.submission_id) AND (s.release_date < now()) AND (s.status_id = 2) AND (s.owner <> 158) AND (a.person_num IS NOT NULL))))
        UNION
         SELECT g.first_name,
            g.last_name,
            g.email,
            s.submission_id
           FROM (submissions s
             JOIN grl_user g ON (((g.account_id = s.created_by) AND ((g.last_name)::text <> 'EarthChem'::text) AND (s.status_id = 2) AND (s.release_date <= now()) AND (s.owner <> 158))))) p
     JOIN ( SELECT download_stats.submission_id,
            count(download_stats.submission_id) AS life_time_download_cnt
           FROM download_stats
          WHERE (download_stats.submission_id IS NOT NULL)
          GROUP BY download_stats.submission_id) d ON ((d.submission_id = p.submission_id)))
  ORDER BY p.last_name, p.first_name, p.email, p.submission_id;

person_submission_download_stats

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views