odyssey
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
std_term_program_history
Description
Most recent term activation for students as of each term
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
request_term_id
"_quest"."quest_term_id"
2147483647
√
null
uw_term
.term_id
Implied Constraint
R
uw_id
"_quest"."quest_uw_id"
2147483647
√
null
term_id
"_quest"."quest_term_id"
2147483647
√
null
uw_term
.term_id
Implied Constraint
R
Table contained
0
rows
Relationships
Close relationships within degrees of separation
One
One implied
Two implied
View Definition
SELECT uw_term.term_id AS request_term_id, std_student.uw_id, repeat_agg(stp.term_id) OVER (PARTITION BY std_student.uw_id ORDER BY uw_term.term_id) AS term_id FROM ((_quest.uw_term CROSS JOIN _quest.std_student) LEFT JOIN _quest.std_term stp USING (term_id, uw_id));
Possibly Referenced Tables/Views
uw_term
std_student
std_term