SchemaSpy Analysis of odyssey_test._quest - 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
  off_course.course_id	cal_course.course_id
  off_course.term_id	uw_term.term_id
  off_instruct_section_instructor.uw_id	std_student.uw_id
  std_name.uw_id	std_student.uw_id
  std_plan_history.plan_code	pps_plan.plan_code
  std_service_indicator.uw_id	std_student.uw_id
  std_term.term_id	uw_term.term_id
  std_term.uw_id	std_student.uw_id
  std_term_course.course_id	cal_course.course_id
  std_term_plan_gpa.plan_code	pps_plan.plan_code
  std_term_plan_gpa.term_id	uw_term.term_id
  std_term_plan_gpa.uw_id	std_student.uw_id
  std_term_section.course_id	cal_course.course_id
  std_term_subplan_gpa.plan_code	pps_plan.plan_code
  std_term_subplan_gpa.term_id	uw_term.term_id
  std_term_subplan_gpa.uw_id	std_student.uw_id
  std_transfer_credit_school.plan_code	pps_plan.plan_code
  std_transfer_credit_school.program_code	pps_program.program_code
  uw_room.location_code	uw_location.location_code

  19 instances of anomaly detected

• Tables without indexes:
  Anomaly not 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
  std_address

  1 instance 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