View odyssey_test._quest_raw.ps_class_tbl_as_of
ps_class_tbl augmented with the course effective date assumed to be effective for the class section (most recent effective date as of the beginning of the term)

 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
crse_id varchar 2147483647  √  null
crse_offer_nbr int4 10  √  null
strm varchar 2147483647  √  null
manual_term_exam_dates.strm Implied Constraint R
session_code varchar 2147483647  √  null
class_section varchar 2147483647  √  null
institution varchar 2147483647  √  null
acad_group varchar 2147483647  √  null
subject varchar 2147483647  √  null
catalog_nbr varchar 2147483647  √  null
acad_career varchar 2147483647  √  null
descr varchar 2147483647  √  null
class_nbr int4 10  √  null
ssr_component varchar 2147483647  √  null
enrl_stat varchar 2147483647  √  null
class_stat varchar 2147483647  √  null
class_type varchar 2147483647  √  null
associated_class int4 10  √  null
auto_enroll_sect_1 varchar 2147483647  √  null
auto_enroll_sect_2 varchar 2147483647  √  null
schedule_print varchar 2147483647  √  null
consent varchar 2147483647  √  null
enrl_cap int4 10  √  null
enrl_tot int4 10  √  null
crs_topic_id int4 10  √  null
acad_org varchar 2147483647  √  null
campus varchar 2147483647  √  null
location varchar 2147483647  √  null
instruction_mode varchar 2147483647  √  null
room_cap_request int4 10  √  null
ssr_drop_consent varchar 2147483647  √  null
effdt date 13  √  null

Analyzed at Wed Feb 19 10:31 EST 2014


Close relationships: