Table odyssey_test._oat.std_note
Notes added during the advising process (either by an advisor or a program) about particular students.

 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 Student this note applies to.
note_id serial 10  √  nextval('_oat.std_note_note_id_seq'::regclass) Unique identifier for this note.
when_added timestamp 29,6 now() When this note was added.
origin text 2147483647 The source of this note. Either an advisor's userid or the name of a program that added the note automatically.
subject text 2147483647 A short description of this note.
body text 2147483647  √  null The main content of this note, if elaboration is needed on the subject.
note_category std_note_category 2147483647 A categorization of the note content (used for filtering).

Table contained 62,376 rows at Wed Feb 19 10:31 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
uw_id + note_id Primary key Asc/Asc oat_note_pkey