Table odyssey_test._quest_raw.ps_person_sa Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
emplid varchar 2147483647
check_acad_degr_subplan.emplid Implied Constraint R
check_acad_plan_history.emplid Implied Constraint R
check_acad_prog_plan.emplid Implied Constraint R
check_acad_subplan_history.emplid Implied Constraint R
check_gpa.emplid Implied Constraint R
check_std_term_course_transcript_note.emplid Implied Constraint R
check_std_term_section.emplid Implied Constraint R
check_std_term_section_career.emplid Implied Constraint R
check_std_term_section_career_term.emplid Implied Constraint R
check_std_term_section_grade.emplid Implied Constraint R
check_std_term_section_reserve.emplid Implied Constraint R
check_std_term_section_session.emplid Implied Constraint R
check_student_term_plan_01.emplid Implied Constraint R
check_student_term_plan_02.emplid Implied Constraint R
check_tscrpt_text_loc.emplid Implied Constraint R
check_valid_subplans.emplid Implied Constraint R
ps_acad_degr.emplid Implied Constraint R
ps_acad_degr_hons.emplid Implied Constraint R
ps_acad_degr_plan.emplid Implied Constraint R
ps_acad_degr_spln.emplid Implied Constraint R
ps_acad_plan.emplid Implied Constraint R
ps_acad_prog.emplid Implied Constraint R
ps_acad_stdng_actn.emplid Implied Constraint R
ps_acad_subplan.emplid Implied Constraint R
ps_addresses.emplid Implied Constraint R
ps_citizenship.emplid Implied Constraint R
ps_class_instr.emplid Implied Constraint R
ps_external_system.emplid Implied Constraint R
ps_honor_award_cs.emplid Implied Constraint R
ps_mlstn_atmpt.emplid Implied Constraint R
ps_names.emplid Implied Constraint R
ps_pers_data_sa_vw.emplid Implied Constraint R
ps_personal_phone.emplid Implied Constraint R
ps_srvc_ind_data.emplid Implied Constraint R
ps_stdnt_car_mlstn.emplid Implied Constraint R
ps_stdnt_car_term.emplid Implied Constraint R
ps_stdnt_enrl.emplid Implied Constraint R
ps_stdnt_enrl_note.emplid Implied Constraint R
ps_stdnt_grps_hist.emplid Implied Constraint R
ps_stdnt_spcl_gpa.emplid Implied Constraint R
ps_trns_crse_dtl.emplid Implied Constraint R
ps_trns_crse_sch.emplid Implied Constraint R
ps_tscrpt_text.emplid Implied Constraint R
ps_tscrpt_text_loc.emplid Implied Constraint R
ps_uw_cem_demand.emplid Implied Constraint R
ps_uw_cem_demand_p.emplid Implied Constraint R
ps_uw_coop_term.emplid Implied Constraint R
ps_uw_oper_data_in.emplid Implied Constraint R
ps_uw_student_rank.emplid Implied Constraint R
ferpa varchar 2147483647  √  null

Table contained 125,401 rows at Wed Feb 19 10:31 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
emplid Primary key Asc ps_person_sa_pkey

Close relationships: