Create view to combine Moped internal notes, Moped status updates, and eCapris status updates

[mddilley]

To show the eCapris statuses in the Notes tab in the same timeline as the Moped status updates and internal notes, we need to capture them together in the same view so the front end can handle displaying them and filtering them. This view would join records from the moped_proj_notes table and ecapris_subproject_statuses.

In Scope

• The view should support:
  • Map ecapris_subproject_statuses columns to moped_proj_notes column names so the front end can display them without translating eCapris statuses column names to Moped notes column names
    • subproject_status_id to project_note_id <- This could lead to eventual id collisions
      • Prefix existing unique ids to prevent collisions
    • sub_project_status_desc to project_note
    • review_timestamp to created_at
    • 3 as project_note_type and add new type to moped_note_types?
    • false as is_deleted
    • NULL as project_id
    • NULL as phase_id
    • is_editable is false for eCapris statuses and true for Moped rows
  • Displaying Moped status updates and internal notes associated with a project ID and the eCapris statuses associated with the project's eCapris ID in newest to oldest order
  • Filtering to:
    • Moped status updates and internal notes only
    • Moped status updates only
    • Moped internal notes only