tdis_users

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

contact_id

int4

√

null

last_name

varchar

2147483647

√

null

first_name

varchar

2147483647

√

null

username

varchar

2147483647

√

null

varchar

2147483647

√

null

cell_phone

varchar

2147483647

√

null

work_phone

varchar

2147483647

√

null

agency

varchar

2147483647

√

null

user_project_role

jsonb

2147483647

√

null

comments

text

2147483647

√

null

login_status

varchar

2147483647

√

null

last_logged_in

timestamptz

35,6

√

null

date_created

timestamptz

35,6

√

null

date_updated

timestamptz

35,6

√

null

View Definition

SELECT sq.contact_id,
    sq.last_name,
    sq.first_name,
    sq.username,
    sq.email,
    sq.cell_phone,
    sq.work_phone,
    sq.agency,
    (json_agg(sq.user_project_role))::jsonb AS user_project_role,
    sq.comments,
    sq.login_status,
    sq.last_logged_in,
    sq.date_created,
    sq.date_updated
   FROM ( SELECT c.id AS contact_id,
            c.last_name,
            c.first_name,
            u.username,
            c.email,
            c.cell_phone,
            c.work_phone,
            a.name AS agency,
            (json_build_object(p.name, json_agg(r.name)))::jsonb AS user_project_role,
            c.comments,
            u.login_status,
            u.last_logged_in,
            u.date_created,
            u.date_updated
           FROM (((((tdis_contact c
             JOIN tdis_user u ON ((c.id = u.contact_id)))
             JOIN tdis_user_project_role upr ON ((u.contact_id = upr.user_id)))
             JOIN tdis_project p ON ((upr.project_id = p.id)))
             JOIN tdis_user_role r ON ((upr.role_id = r.id)))
             LEFT JOIN tdis_agency a ON ((c.agency_id = a.id)))
          WHERE (c.deleted = false)
          GROUP BY c.id, c.last_name, c.first_name, u.username, c.email, c.cell_phone, c.work_phone, a.name, c.comments, u.login_status, u.last_logged_in, u.date_created, u.date_updated, p.name) sq
  GROUP BY sq.contact_id, sq.last_name, sq.first_name, sq.username, sq.email, sq.cell_phone, sq.work_phone, sq.agency, sq.comments, sq.login_status, sq.last_logged_in, sq.date_created, sq.date_updated;

Columns

View Definition

Possibly Referenced Tables/Views