Table odyssey_test._oat.usr_user
User-settable preferences.

 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
userid quest_userid 2147483647
std_advisor_view.advisor_userid oat_student_view_advisor_userid_fkey C
usr_permission.userid oat_user_permission_userid_fkey C
User this set of preferences applies to.
col1_prefixes regex 2147483647 ''::text Comma-separated list of prefixes (regular expressions) for courses to display in the first column of the academic record.
col2_prefixes regex 2147483647 ''::text Comma-separated list of prefixes (regular expressions) for courses to display in the second column of the academic record.
notes_sort_order oat_sort_order 2147483647 'DESC'::_oat.oat_sort_order Order in which notes are displayed.
acad_record_sort_order oat_sort_order 2147483647 'ASC'::_oat.oat_sort_order Order in which the terms of the academic record are displayed.
last_change timestamp 29,6 now() A timestamp applied when the record is updated (to debug). NULL when first created.
added_by quest_userid 2147483647 Who added this user.
added_when timestamp 29,6 now() When this user was added.
auth_group text 2147483647 Group of the person that authorized this user; used to show the authorizing user all the people they have authorized.

Table contained 103 rows at Wed Feb 19 10:31 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
userid Primary key Asc oat_user_pkey

Close relationships  within of separation: