SchemaSpy Analysis of odyssey_test._quest_raw - Anomalies

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:

• Columns whose name and type imply a relationship to another table's primary key:

  Child Column	Implied Parent Column
  ps_acad_calses_tbl.strm	manual_term_exam_dates.strm
  ps_acad_degr.emplid	ps_person_sa.emplid
  ps_acad_degr_hons.emplid	ps_person_sa.emplid
  ps_acad_degr_plan.emplid	ps_person_sa.emplid
  ps_acad_degr_spln.emplid	ps_person_sa.emplid
  ps_acad_plan.emplid	ps_person_sa.emplid
  ps_acad_prog.emplid	ps_person_sa.emplid
  ps_acad_stdng_actn.emplid	ps_person_sa.emplid
  ps_acad_stdng_actn.strm	manual_term_exam_dates.strm
  ps_acad_subplan.emplid	ps_person_sa.emplid
  ps_addresses.country	ps_country_tbl.country
  ps_addresses.emplid	ps_person_sa.emplid
  ps_citizen_sts_tbl.country	ps_country_tbl.country
  ps_citizenship.country	ps_country_tbl.country
  ps_citizenship.emplid	ps_person_sa.emplid
  ps_class_assoc.strm	manual_term_exam_dates.strm
  ps_class_instr.emplid	ps_person_sa.emplid
  ps_class_instr.strm	manual_term_exam_dates.strm
  ps_class_mtg_pat.strm	manual_term_exam_dates.strm
  ps_class_notes.strm	manual_term_exam_dates.strm
  ps_class_rsrv_cap.strm	manual_term_exam_dates.strm
  ps_class_rsrv_grp.strm	manual_term_exam_dates.strm
  ps_class_tbl.strm	manual_term_exam_dates.strm
  ps_external_system.emplid	ps_person_sa.emplid
  ps_honor_award_cs.emplid	ps_person_sa.emplid
  ps_honor_award_cs.strm	manual_term_exam_dates.strm
  ps_location_tbl.country	ps_country_tbl.country
  ps_mlstn_atmpt.emplid	ps_person_sa.emplid
  ps_names.emplid	ps_person_sa.emplid
  ps_pers_data_sa_vw.emplid	ps_person_sa.emplid
  ps_personal_phone.emplid	ps_person_sa.emplid
  ps_sctn_cmbnd.strm	manual_term_exam_dates.strm
  ps_sctn_cmbnd_tbl.strm	manual_term_exam_dates.strm
  ps_sess_time_perod.strm	manual_term_exam_dates.strm
  ps_session_tbl.strm	manual_term_exam_dates.strm
  ps_srvc_ind_data.emplid	ps_person_sa.emplid
  ps_stdnt_car_mlstn.emplid	ps_person_sa.emplid
  ps_stdnt_car_term.emplid	ps_person_sa.emplid
  ps_stdnt_car_term.strm	manual_term_exam_dates.strm
  ps_stdnt_enrl.emplid	ps_person_sa.emplid
  ps_stdnt_enrl.oprid	ps_uw_oper_data_in.oprid
  ps_stdnt_enrl.strm	manual_term_exam_dates.strm
  ps_stdnt_enrl_note.emplid	ps_person_sa.emplid
  ps_stdnt_enrl_note.strm	manual_term_exam_dates.strm
  ps_stdnt_grps_hist.emplid	ps_person_sa.emplid
  ps_stdnt_spcl_gpa.emplid	ps_person_sa.emplid
  ps_stdnt_spcl_gpa.strm	manual_term_exam_dates.strm
  ps_term_tbl.strm	manual_term_exam_dates.strm
  ps_trns_crse_dtl.emplid	ps_person_sa.emplid
  ps_trns_crse_sch.emplid	ps_person_sa.emplid
  ps_tscrpt_text.emplid	ps_person_sa.emplid
  ps_tscrpt_text_loc.emplid	ps_person_sa.emplid
  ps_tscrpt_text_loc.strm	manual_term_exam_dates.strm
  ps_uw_cem_demand.emplid	ps_person_sa.emplid
  ps_uw_cem_demand.oprid	ps_uw_oper_data_in.oprid
  ps_uw_cem_demand.strm	manual_term_exam_dates.strm
  ps_uw_cem_demand_p.emplid	ps_person_sa.emplid
  ps_uw_cem_demand_p.strm	manual_term_exam_dates.strm
  ps_uw_coop_term.emplid	ps_person_sa.emplid
  ps_uw_coop_term.strm	manual_term_exam_dates.strm
  ps_uw_oper_data_in.emplid	ps_person_sa.emplid
  ps_uw_student_rank.emplid	ps_person_sa.emplid
  ps_uw_student_rank.strm	manual_term_exam_dates.strm

  63 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  ps_honor_award_cs	87,100

  1 instance of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':
  Anomaly not detected

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  check_cal_section
  check_cal_section_autoenrol
  check_cal_section_related
  check_cal_section_topic
  check_course_combined_section_meet
  check_course_combined_section_status
  check_course_label_exist
  check_course_section
  check_course_topic_exist
  ps_addresses
  ps_class_tbl
  ps_class_tbl_as_of

  12 instances of anomaly detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected