| SchemaSpy Analysis of odyssey_test._quest_raw | Generated by SchemaSpy |
| Generated by SchemaSpy on Wed Feb 19 10:31 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 |
|---|---|---|---|---|---|
| check_acad_degr_subplan | 4 | view | Check for subplans listed in degrees that are not listed in subplan table. | ||
| check_acad_plan_history | 9 | view | Check for records in ps_acad_subplan that are missing corresponding records in ps_acad_plan. | ||
| check_acad_prog_plan | 18 | view | Students in programs without a corresponding effective-dated plan | ||
| check_acad_subplan_history | 8 | view | |||
| check_cal_association | 11 | view | Courses in cal_association without a corresponding entry in course | ||
| check_cal_section | 30 | view | Course sections whose class type or session does not match their section number or with invalid section number | ||
| check_cal_section_autoenrol | 30 | view | Course sections which have a non-existent related 1 or 2 assigned | ||
| check_cal_section_combined | 5 | view | Course sections participating in a non-existent combined section | ||
| check_cal_section_note | 8 | view | Section notes in which the text indicates there is no note, but the numeric reference is not empty | ||
| check_cal_section_related | 30 | view | Course sections referring to non-existent auto enroll sections | ||
| check_cal_section_topic | 30 | view | Course sections which have a non-existent topic assigned | ||
| check_course_combined_section_meet | 5 | view | Combined sections with different individual sections having different meets | ||
| check_course_combined_section_status | 6 | view | Combined sections with different individual sections having different status | ||
| check_course_label_duplicate | 6 | view | Duplicate offerings: more than one ps_crse_offer record simultaneously effective for the same subject/catalog | ||
| check_course_label_exist | 31 | view | Class sections with non-existent labels | ||
| check_course_offer | 12 | view | Course offers that do not match up with a catalog update | ||
| check_course_section | 30 | view | Duplicate sections: more than one ps_class_tbl for the same strm/class_nbr | ||
| check_course_section_combined | 5 | view | Duplicate combined sections: more than one ps_sctn_cmbnd for the same strm/class_nbr | ||
| check_course_topic | 6 | view | Course topics that do not match up with a catalog update | ||
| check_course_topic_exist | 31 | view | Class sections with non-existent topics | ||
| check_facility_unit | 15 | view | Facilities where being open for general assignment is not equivalent to not being owned by an academic unit | ||
| check_gpa | 5 | view | |||
| check_plan_degree | 15 | view | |||
| check_session_dates | 5 | view | Sessions with inconsistent dates | ||
| check_std_term_course_transcript_note | 7 | view | Transcript notes on non-enrolment sections | ||
| check_std_term_section | 34 | view | Student class enrolments in non-existent classes | ||
| check_std_term_section_career | 3 | view | Student/term combinations in which the student is registered in sections under multiple careers | ||
| check_std_term_section_career_term | 34 | view | Student class section enrolments for which the student does not have a ps_stdnt_car_term row | ||
| check_std_term_section_grade | 34 | view | Student registration in non-enrolment sections with grade information | ||
| check_std_term_section_reserve | 4 | view | Student class enrolments which refer to a nonexistent reservation cap | ||
| check_std_term_section_session | 34 | view | Student class section enrolments in which the session code does not match the session code of the class section | ||
| check_student_term_plan_01 | 9 | view | Plan codes in ps_acad_plan without a corresponding entry in ps_acad_plan_tbl | ||
| check_student_term_plan_02 | 9 | view | Students with a degree listed in ps_acad_plan but not listed in ps_acad_degr | ||
| check_term_class_dates | 2 | view | Recent terms with inconsistent class dates | ||
| check_tscrpt_text_loc | 10 | view | Records with null terms. Currently excluded from our DB. | ||
| check_valid_subplans | 8 | view | Check for invalid plan-subplan combinations. | ||
| manual_term_exam_dates | 3 | 3 | |||
| manual_unit_group | 3 | 92 | |||
| ps_acad_calses_tbl | 12 | 756 | |||
| ps_acad_degr | 8 | 69,572 | |||
| ps_acad_degr_hons | 5 | 17,681 | |||
| ps_acad_degr_plan | 6 | 88,336 | |||
| ps_acad_degr_spln | 4 | 9,070 | |||
| ps_acad_group_tbl | 6 | 18 | |||
| ps_acad_org_tbl | 8 | 92 | |||
| ps_acad_plan | 9 | 954,837 | |||
| ps_acad_plan_owner | 5 | 3,494 | |||
| ps_acad_plan_tbl | 15 | 3,494 | |||
| ps_acad_prog | 18 | 876,612 | |||
| ps_acad_prog_tbl | 11 | 305 | |||
| ps_acad_stactn_tbl | 9 | 919 | |||
| ps_acad_stdng_actn | 10 | 733,740 | |||
| ps_acad_subplan | 8 | 63,482 | |||
| ps_acad_subpln_tbl | 12 | 2,822 | |||
| ps_addresses | 12 | 230,647 | |||
| ps_bldg_tbl | 5 | 188 | |||
| ps_campus_tbl | 7 | 46 | |||
| ps_citizen_sts_tbl | 4 | 592 | |||
| ps_citizenship | 3 | 155,465 | |||
| ps_class_assoc | 11 | 225,112 | |||
| ps_class_instr | 9 | 106,810 | |||
| ps_class_mtg_pat | 19 | 164,901 | |||
| ps_class_notes | 8 | 27,711 | |||
| ps_class_notes_tbl | 6 | 52 | |||
| ps_class_rsrv_cap | 9 | 33,571 | |||
| ps_class_rsrv_grp | 7 | 33,791 | |||
| ps_class_tbl | 30 | 263,584 | |||
| ps_class_tbl_as_of | 31 | view | ps_class_tbl augmented with the course effective date assumed to be effective for the class section (most recent effective date as of the beginning of the term) | ||
| ps_country_tbl | 4 | 264 | |||
| ps_crse_catalog | 10 | 58,997 | |||
| ps_crse_offer | 12 | 60,471 | |||
| ps_crse_topics | 6 | 14,456 | |||
| ps_degr_honors_tbl | 10 | 14 | |||
| ps_degree_tbl | 9 | 206 | |||
| ps_external_system | 4 | 4,378 | |||
| ps_facility_tbl | 15 | 1,725 | |||
| ps_honor_award_cs | 11 | 87,100 | |||
| ps_honor_award_tbl | 10 | 88 | |||
| ps_instruct_mode | 6 | 2 | |||
| ps_location_tbl | 6 | 135 | |||
| ps_mlstn_atmpt | 10 | 513,315 | |||
| ps_names | 8 | 256,840 | |||
| ps_pers_data_sa_vw | 4 | 125,401 | |||
| ps_person_sa | 2 | 125,401 | |||
| ps_personal_phone | 6 | 314,233 | |||
| ps_rq_grp_tbl | 7 | 9,160 | |||
| ps_sctn_cmbnd | 5 | 15,655 | |||
| ps_sctn_cmbnd_tbl | 12 | 8,733 | |||
| ps_service_impact | 6 | 66 | |||
| ps_sess_time_perod | 6 | 2,291 | |||
| ps_session_tbl | 15 | 792 | |||
| ps_srvc_in_rsn_tbl | 7 | 113 | |||
| ps_srvc_ind_cd_tbl | 8 | 40 | |||
| ps_srvc_ind_data | 7 | 14,032 | |||
| ps_stdnt_car_mlstn | 15 | 513,218 | |||
| ps_stdnt_car_term | 55 | 1,490,985 | |||
| ps_stdnt_enrl | 34 | 5,842,041 | |||
| ps_stdnt_enrl_note | 7 | 2,039 | |||
| ps_stdnt_group_tbl | 6 | 361 | |||
| ps_stdnt_grps_hist | 6 | 40,534 | |||
| ps_stdnt_spcl_gpa | 11 | 1,107,613 | |||
| ps_study_agrm_tbl | 6 | 240 | |||
| ps_subject_tbl | 8 | 225 | |||
| ps_term_tbl | 9 | 373 | |||
| ps_trns_crse_dtl | 26 | 115,154 | |||
| ps_trns_crse_sch | 19 | 21,199 | |||
| ps_tscrpt_note_tbl | 6 | 6 | |||
| ps_tscrpt_text | 7 | 191,228 | |||
| ps_tscrpt_text_loc | 10 | 149,492 | |||
| ps_uw_acstdng_rule | 8 | 727 | |||
| ps_uw_cem_demand | 16 | 951,819 | |||
| ps_uw_cem_demand_p | 5 | 224,969 | |||
| ps_uw_coop_term | 6 | 230,994 | |||
| ps_uw_oper_data_in | 3 | 128,198 | |||
| ps_uw_student_rank | 10 | 594,134 | |||
| 78 Tables | 761 | 17,287,252 | |||
| 37 Views | 574 |