gistfile1.yml

- base_view: assessments
  joins:
    - join: users
      foreign_key: user_id
  
    - join: course_registrations
      foreign_key: course_registration_id
      
    - join: course_prototypes
      foreign_key: ${course_registrations.course_prototype_id}