Table odyssey_test._oat.std_advisor_view
Recent views of students by advisors.

 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
uw_id quest_uw_id 2147483647 The uw_id of the student who was viewed by an advisor.
advisor_userid quest_userid 2147483647
usr_user.userid oat_student_view_advisor_userid_fkey C
The userid of the advisor who viewed the student.
date_viewed timestamp 29,6 now() The date (but not time) of the viewing.

Table contained 28,616 rows at Wed Feb 19 10:31 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
uw_id + advisor_userid + date_viewed Primary key Asc/Asc/Asc oat_student_view_pkey

Close relationships  within of separation: