Tables


SchemaSpy Analysis of odyssey

Generated on Wed Jan 30 09:35 EST 2019

XML Representation
Insertion Order Deletion Order
TABLES 46
VIEWS 14
COLUMNS 339
Constraints 11
Anomalies 6
Routines 0

Database Properties

Database Type: PostgreSQL - 9.5.15

Schema _oat

Online Advising Tools

Tables

Table / View Children Parents Columns Rows Type Comments
qry_history 0 0 4 2166 Table

Records changes to canned query. Old query is the JSON returned by _oat.json_qry_query_complete
right before the update.
std_removal_letters_sent 0 0 6 3416 Table

Details of letters sent to students notifying them of removal from a course due to failed requisites.
dd_sample_values 0 2 5 2889 Table

Data dictionary sample values.
qry_query 0 0 6 423 Table

Queries that can be run in OAT.
bm_blast 0 0 22 291 Table

A bulk email blast. It may be in one of three states: a template used as a starting point for other email blasts,
a blast that is in preparation, or a blast that has been sent.
pps_plan_group_description 0 0 2 2 Table

Describe a plan group. A plan group groups plans either directly or indirectly via other plan groups.
vq_reason 0 0 5 8 Table

Definition of reasons and its associated queue.
clt_perm_group 0 2 2 82 Table

Make a DAG out of the user permissions.
pps_plan_group 0 0 2 3234 Table

A tree where subtrees place plans into meaningful groups.
oat_unit_groups 0 0 2 61 Table

Unit descriptions to show in the Instructor Preferences form. There are additional units (eg CEMC) that are not in the official uw_unit table. Likewise, there are groups (eg fuac) that do not show up in the official uw_group table.
ins_schedule_prefs 0 0 10 26 Table
qry_run_log 0 0 5 28107 Table

Record each run of a canned query.
vq_line 0 0 4 593 Table

A virtual line allows students to join.
qry_parameter 0 0 5 1078 Table

Parameters users are required to fill in before running a canned query.
oat_message 0 0 3 91 Table

Messages of the day
mappings 0 3 4 1013 Table
req_course_id_pairs 0 0 9 45 Table
vq_queue 0 0 12 2 Table

A virtual queue that contains information for a particular office hour. A queue can contain
multiple lines in which students can join the line.
clt_perm_definition 3 0 2 92 Table

A description of permissions that may be assigned to users and web service clients. Permissions make a tree (see clt_perm_group); these may be either leaf nodes or interior notes.
std_advisor_view 0 1 3 915264 Table

Recent views of students by advisors.
std_note 0 0 10 286840 Table

Notes added during the advising process (either by an advisor or a program) about particular students.
dd_fields 2 1 6 895 Table

Data dictionary field documenation.
sch_preliminary_schedule 5 0 17 3051 Table
qry_favourite 0 0 2 382 Table

Stores users’ favourite queries’
std_permission_number 0 0 11 95122 Table

Permission Numbers for entry into courses.
faq_tags 0 0 2 16 Table

Tags that can be attached to frequently asked questions to help
group/classify/search them.
bm_notifications 0 0 2 268 Table

Who to notify when a bulk mail is sent.
clt_perm_grant 0 3 4 1003 Table

Permissions assigned to a client.
form_form 0 0 4 18 Table

Form definitions.
qry_change_log 0 0 4 439 Table
oat_filter_content 0 2 3 1893 Table

Link ids to filters.
oat_filter 2 0 5 90 Table

Filters to use in various oat applications: queries, FAQs, etc.
oat_xlate 0 0 3 418 Table

Translate codes from a short form to a longer description.
bm_recipient_log 0 2 9 241017 Table

A log of who was sent a copy of this email.
uw_standard_meet_times 0 0 2 49 Table

Standard times that classes meet.
faq_content_tags 0 0 2 161 Table

A table joining frequently asked questions with relevent tags.
dd_tables 1 0 5 93 Table

Data dictionary table documentation.
oat_filter_group 0 0 3 14 Table

Map filter group codes to text.
form_data 0 0 9 1792 Table

Data for a specified form, as provided by the submitter.
vq_queue_server 0 0 4 13 Table

Advisors that are allowed to serve a particular queue.
bm_recipient_selection_parameters 0 0 4 486 Table

Query parameters used to select the recipients for this email blast.
clt_program 0 1 5 13 Table

Programs that use web services and otherwise need to authenticate.
vq_ticket 0 0 13 13573 Table

Virtual ticket for students to acquire. Each ticket is associated with a line.
faq_content 0 0 3 72 Table

Frequently asked question/answer pairs for CS students.
clt_user 1 1 6 473 Table

Human clients of OAT.
clt_client 4 0 5 486 Table

OAT clients, both programs and humans.
json_std_course_details 0 0 6 0 View
json_qry_query_complete 0 0 4 0 View

Complete view of a canned query: query, run-time parameters, filters.
json_vq_queues 0 0 2 0 View

Json with the basic information on all virtual queues.
json_clt_user 0 0 3 0 View
json_std_enrolled_sections 0 0 4 0 View

Make JSON available that summarizes the sections (including instructors
and meet times) in which a student has been enrolled, selectable by uw_id,
term_id, and course_id. Used directely by _oat.json_std_course_details view
and indirectly by _oat.json_std_course_details functions.
util_search_suggestions 0 0 5 0 View

Look up people by prefix of name, uw_id, userid.
pps_plan_all_cs 0 0 15 0 View
std_term_plan_share 0 0 5 0 View

A view to make it easy to count the fraction of a student that belongs to a given PLAN.
json_bm_email_basic 0 0 7 0 View

Json with the basic information on bulk mail blasts.
json_std_course_complete 0 0 5 0 View

Complete view of a course a student has taken.
json_std_society_membership 0 0 4 0 View

A view for selecting students to use in testing for undergrad student society membership. Presented with a userid and group code, return either NOT_FOUND or their plan and term of first enrolment.
std_degree_share 0 0 5 0 View

A view to make it easy to count the fraction of a student that belongs to a given DEGREE.
pps_plan_core_cs 0 0 15 0 View
json_qry_query_info 0 0 3 0 View

Information about a canned query: title, description, filters.