| SchemaSpy Analysis of odyssey_test._oat | Generated by SchemaSpy |
| Generated by SchemaSpy on Wed Feb 19 10:31 EST 2014 | |
| Database Type: PostgreSQL - 9.2.4 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| ins_schedule_prefs | 10 | 11 | |||
| mappings | 4 | 5 | |||
| oat_permission | 2 | 1 | 3 | 13 | Define the permissions used by the system. |
| oat_tag | 2 | 4 | 26 | Tags to use in various oat applications: queries, FAQs, etc. | |
| oat_tag_content | 2 | 3 | 283 | Link ids to tags. | |
| oat_unit_groups | 2 | 61 | 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. | ||
| oat_xlate | 3 | 403 | Translate codes from a short form to a longer description. | ||
| pps_plan_core_cs | 15 | view | Core CS plans: BCS/BMath(CS) including options, double degree, joints, all Bioinformatics, but not SE, CFM, CompMath, etc. | ||
| qry_parameter | 1 | 5 | 136 | Parameters users are required to fill in before running a canned query. | |
| qry_parameter_type | 1 | 5 | 12 | Regular expressions for query parameters for error-checking purposes. | |
| qry_query | 4 | 57 | Queries that can be run in OAT. | ||
| std_advisor_view | 1 | 3 | 28,616 | Recent views of students by advisors. | |
| std_note | 7 | 62,376 | Notes added during the advising process (either by an advisor or a program) about particular students. | ||
| std_permission_number | 11 | 7,075 | Permission Numbers for entry into courses. | ||
| usr_permission | 2 | 4 | 133 | Permissions assigned to a user. | |
| usr_user | 2 | 9 | 103 | User-settable preferences. | |
| 15 Tables | 77 | 99,310 | |||
| 1 View | 15 |