Table odyssey_test._oat.std_permission_number
Permission Numbers for entry into courses.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
term_id quest_term_id 2147483647 The term (eg 1089) this permission number is for.
class_id int4 10 The class ID the permission number is for.
subject_code text 2147483647 The course subject (eg: CS).
catalog text 2147483647 The course catalog number (eg: 135).
section_code text 2147483647 The course section number (eg: 001).
permission_num int4 10 The permission number to give out.
expiry_date date 13 The date the permission number expires.
uw_id quest_uw_id 2147483647  √  null The ID of the student given the permission number.
assigned_date timestamp 29,6  √  null When the permission number was given.
assigned_by text 2147483647  √  null Who assigned the permission number.
reason text 2147483647  √  null Why the permission number was assigned.

Table contained 7,075 rows at Wed Feb 19 10:31 EST 2014

Indexes:
Column(s) Type Sort
term_id + class_id + permission_num Primary key Asc/Asc/Asc