combined_project_notes_view

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

text

2147483647

√

null

original_id

int4

√

null

project_note

text

2147483647

√

null

created_at

timestamptz

35,6

√

null

created_by_user_id

int4

√

null

project_id

int4

√

null

author

text

2147483647

√

null

note_type_name

text

2147483647

√

null

note_type_slug

text

2147483647

√

null

note_type_id

int4

√

null

note_type_source

text

2147483647

√

null

phase_name

text

2147483647

√

null

phase_key

text

2147483647

√

null

phase_id

int4

√

null

is_editable

bool

√

null

is_status_update

bool

√

null

ecapris_subproject_id

text

2147483647

√

null

View Definition

SELECT ('moped_'::text || moped_proj_notes.project_note_id) AS id,
    moped_proj_notes.project_note_id AS original_id,
    moped_proj_notes.project_note,
    moped_proj_notes.created_at,
    moped_proj_notes.created_by_user_id,
    moped_proj_notes.project_id,
    ((moped_users.first_name || ' '::text) || moped_users.last_name) AS author,
    moped_note_types.name AS note_type_name,
    moped_note_types.slug AS note_type_slug,
    moped_note_types.id AS note_type_id,
    moped_note_types.source AS note_type_source,
    moped_phases.phase_name,
    moped_phases.phase_key,
    moped_proj_notes.phase_id,
    true AS is_editable,
    (moped_note_types.slug = 'status_update'::text) AS is_status_update,
    NULL::text AS ecapris_subproject_id
   FROM (((moped_proj_notes
     LEFT JOIN moped_users ON ((moped_proj_notes.created_by_user_id = moped_users.user_id)))
     LEFT JOIN moped_note_types ON ((moped_proj_notes.project_note_type = moped_note_types.id)))
     LEFT JOIN moped_phases ON ((moped_proj_notes.phase_id = moped_phases.phase_id)))
  WHERE (moped_proj_notes.is_deleted = false)
UNION ALL
 SELECT ('ecapris_'::text || ecapris_subproject_statuses.id) AS id,
    ecapris_subproject_statuses.id AS original_id,
    ecapris_subproject_statuses.sub_project_status_desc AS project_note,
    ecapris_subproject_statuses.review_timestamp AS created_at,
    ecapris_subproject_statuses.created_by_user_id,
    NULL::integer AS project_id,
    COALESCE(((moped_users.first_name || ' '::text) || moped_users.last_name),
        CASE
            WHEN (ecapris_subproject_statuses.reviewed_by_name ~~ '%,%'::text) THEN ((TRIM(BOTH FROM split_part(ecapris_subproject_statuses.reviewed_by_name, ','::text, 2)) || ' '::text) || TRIM(BOTH FROM split_part(ecapris_subproject_statuses.reviewed_by_name, ','::text, 1)))
            ELSE lower(ecapris_subproject_statuses.reviewed_by_name)
        END) AS author,
    moped_note_types.name AS note_type_name,
    moped_note_types.slug AS note_type_slug,
    moped_note_types.id AS note_type_id,
    moped_note_types.source AS note_type_source,
    NULL::text AS phase_name,
    NULL::text AS phase_key,
    NULL::integer AS phase_id,
    false AS is_editable,
    true AS is_status_update,
    ecapris_subproject_statuses.ecapris_subproject_id
   FROM ((ecapris_subproject_statuses
     LEFT JOIN moped_users ON ((ecapris_subproject_statuses.created_by_user_id = moped_users.user_id)))
     LEFT JOIN moped_note_types ON ((moped_note_types.slug = 'ecapris_status_update'::text)));

combined_project_notes_view

Columns

View Definition

Possibly Referenced Tables/Views