json_std_enrolled_sections

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

uw_id

"_quest"."quest_uw_id"

2147483647

√

null

term_id

"_quest"."quest_term_id"

2147483647

√

null

course_id

"_quest"."quest_course_id"

2147483647

√

null

json

2147483647

√

null

Table contained 0 rows

View Definition

SELECT std_term_section.uw_id,
    std_term_section.term_id,
    ocs2.course_id,
    COALESCE(json_agg(json_build_object('section_code', ocs2.section_code, 'component_code', ocs2.component_code, 'class_id', std_term_section.class_id, 'section_id', ocs2.section_id, 'instructors', ( SELECT COALESCE(json_agg(json_build_object('userid', ins.userid, 'surname', watiam_entry.surname, 'givennames', watiam_entry.givennames)), '[]'::json) AS "coalesce"
           FROM (_quest.off_instruct_section_instructor ins
             LEFT JOIN _watiam.watiam_entry USING (userid))
          WHERE (((ins.term_id)::integer = (ocs2.term_id)::integer) AND (ins.section_id = ocs2.section_id))), 'meets', ( SELECT COALESCE(json_agg(json_build_object('room_description', uw_room.room_description, 'meet_dates', meet.meet_dates, 'meet_days', _quest.course_format_meet_days(meet.meet_days), 'meet_times', meet.meet_times) ORDER BY meet.meet_dates, meet.meet_times), '[]'::json) AS "coalesce"
           FROM (_quest.off_instruct_section_meet meet
             LEFT JOIN _quest.uw_room USING (facility_id))
          WHERE (((meet.term_id)::integer = (ocs2.term_id)::integer) AND (meet.section_id = ocs2.section_id)))) ORDER BY ocs2.section_code), '[]'::json) AS json
   FROM (_quest.std_term_section
     JOIN _quest.off_course_section ocs2 USING (term_id, class_id))
  GROUP BY std_term_section.uw_id, std_term_section.term_id, ocs2.course_id;

Description

Columns

View Definition

Possibly Referenced Tables/Views