| SchemaSpy Analysis of odyssey_test._quest | Generated by SchemaSpy |
| Generated by SchemaSpy on Wed Feb 19 10:30 EST 2014 | |
| Database Type: PostgreSQL - 9.2.4 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| cal_course | 3 | 2 | 10 | 14,426 | A course as defined in the Calendar |
| cal_course_history | 8 | 10 | 58,997 | ||
| cal_course_label | 8 | 11 | 14,956 | A subject/catalog number under which a course may be offered | |
| cal_course_label_history | 3 | 8 | 11 | 60,471 | |
| cal_course_topic | 4 | 5 | 8,817 | A topic that may describe the content of a course offering | |
| cal_course_topic_history | 3 | 2 | 5 | 14,456 | |
| cal_requisite | 3 | 2 | 6 | 6,244 | A requisite which may be required in order to enrol in a course or in a reservation slot of a section |
| cal_requisite_history | 2 | 6 | 9,160 | ||
| cal_subject | 2 | 3 | 6 | 206 | A subject code under which a course may be offered |
| cal_subject_history | 2 | 1 | 6 | 225 | |
| off_association | 5 | 2 | 11 | 225,109 | |
| off_course | 2 | 4 | 225,665 | A course enrolment section in which students may be registered and are all eligible to receive the same credit upon completion | |
| off_course_as_of | 4 | 3 | 3 | 161,475 | |
| off_course_section | 12 | 15 | 19 | 263,584 | A course section in which students may be registered and are all eligible to receive the same credit upon completion |
| off_course_section_complete | 38 | view | off_course_section enhanced with fields related to the course labels, topics, and calendar information | ||
| off_course_section_note | 3 | 5 | 16,985 | ||
| off_course_section_plus | 30 | view | off_course_section enhanced with fields related to the course labels and topics | ||
| off_course_section_reserve | 3 | 3 | 7 | 33,565 | |
| off_default_note | 1 | 2 | 5 | 52 | |
| off_default_note_history | 2 | 5 | 52 | ||
| off_instruct_section | 6 | 3 | 12 | 255,134 | An instructional section in which students may be registered and will be managed together as one group |
| off_instruct_section_instructor | 2 | 5 | 89,986 | ||
| off_instruct_section_instructor_plus | 6 | view | Instructor information from off_instruct_section_instructor enhanced with names but missing uw_id so view can be made public | ||
| off_instruct_section_meet | 2 | 7 | 134,196 | ||
| off_instruct_section_meet_plus | 17 | view | off_instruct_section_meet enhanced with information about the room in which the meet takes place | ||
| pps_degree | 3 | 2 | 9 | 204 | |
| pps_degree_history | 2 | 9 | 206 | ||
| pps_plan | 4 | 7 | 15 | 2,217 | |
| pps_plan_history | 2 | 5 | 15 | 3,493 | |
| pps_program | 7 | 5 | 10 | 146 | |
| pps_program_history | 2 | 3 | 10 | 305 | |
| pps_service_indicator | 2 | 6 | 33 | ||
| pps_service_indicator_impact | 1 | 5 | 53 | ||
| pps_service_indicator_reason | 2 | 1 | 6 | 98 | |
| pps_standing | 1 | 5 | 74 | ||
| pps_subplan | 2 | 5 | 11 | 2,183 | |
| pps_subplan_history | 3 | 3 | 11 | 2,822 | |
| std_address | 1 | 10 | 229,433 | ||
| std_degree | 4 | 2 | 7 | 69,572 | |
| std_degree_honour | 2 | 5 | 17,681 | ||
| std_degree_plan | 3 | 3 | 6 | 88,336 | |
| std_degree_subplan | 5 | 4 | 9,068 | ||
| std_name | 7 | 256,848 | Student name; may be primary (PRI) or preferred (PRF) | ||
| std_name_preferred | 7 | view | Student preferred name | ||
| std_name_primary | 7 | view | Student primary name | ||
| std_photo | 1 | 4 | 0 | The WatCard photo for the student | |
| std_plan_history | 6 | 5 | 9 | 954,831 | |
| std_program_history | 5 | 3 | 17 | 876,612 | |
| std_program_milestone | 2 | 11 | 448,845 | ||
| std_program_plan_milestone | 3 | 12 | 64,373 | ||
| std_service_indicator | 2 | 6 | 14,032 | ||
| std_student | 9 | 8 | 125,401 | ||
| std_subplan_history | 6 | 8 | 63,466 | ||
| std_term | 8 | 2 | 25 | 1,166,424 | Summary of each academic term; mostly from ps_stdnt_car_term. |
| std_term_course | 4 | 20 | 4,014,700 | ||
| std_term_course_demand | 2 | 12 | 951,819 | ||
| std_term_plan | 3 | 3 | 6 | 1,284,564 | |
| std_term_plan_gpa | 6 | 1,104,317 | |||
| std_term_plan_plus | 20 | view | |||
| std_term_program | 2 | 4 | 16 | 1,166,420 | |
| std_term_program_plus | 18 | view | std_term_program plus program titles | ||
| std_term_section | 7 | 12 | 5,842,041 | ||
| std_term_subplan | 3 | 5 | 73,856 | ||
| std_term_subplan_gpa | 7 | 3,296 | |||
| std_term_units | 2 | 38 | 1,166,424 | ||
| std_transfer_credit_detail | 2 | 22 | 115,154 | Transfer credit details. Some corrections are done in ps_correction.sql upon load. | |
| std_transfer_credit_school | 1 | 18 | 21,199 | ||
| update_notification | 2 | 5 | 0 | A notification received from Quest of extract process completion | |
| update_process | 1 | 2 | 4 | ||
| update_run | 1 | 4 | 0 | An update run, i.e. a set of notifications expected to be received | |
| update_run_notification | 2 | 2 | 2 | 0 | An expected notification associated with an import run |
| uw_campus | 7 | 3 | 6 | 19 | A campus on which classes may be held, as of the most recent update to that campus in uw_campus_history |
| uw_campus_history | 2 | 1 | 6 | 46 | A campus on which classes may be held, as of a particular date |
| uw_country | 2 | 4 | 264 | A country of the world | |
| uw_group | 6 | 2 | 4 | 14 | An academic group (faculty, affiliated college, or other group), as of the most recent update to that group in uw_group_history |
| uw_group_history | 2 | 4 | 18 | An academic group (faculty, affiliated college, or other group), as of a particular date | |
| uw_location | 3 | 3 | 5 | 131 | A location in which events may be held, as of the most recent update to that location in uw_location_history |
| uw_location_history | 2 | 1 | 5 | 135 | A location in which events may be held, as of a particular date |
| uw_room | 1 | 11 | 810 | A room in which events may be held | |
| uw_term | 13 | 4 | 191 | An academic term | |
| uw_unit | 9 | 4 | 8 | 70 | An academic unit (department, school, or other unit) as of the most recent update to that unit in uw_unit_history |
| uw_unit_history | 2 | 2 | 8 | 92 | An academic unit (department, school, or other unit) as of a particular date |
| 74 Tables | 650 | 21,736,101 | |||
| 8 Views | 143 |