Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| userid | text | 2147483647 | null |
|
|
|||||||
| auth_group | text | 2147483647 | null |
|
|
Group of the person that authorized this user; used to show the authorizing user all the people they have authorized. |
||||||
| col1_prefixes | "_oat"."regex" | 2147483647 | ''::text |
|
|
Comma-separated list of prefixes (regular expressions) for courses to display in the first column of the academic record. |
||||||
| col2_prefixes | "_oat"."regex" | 2147483647 | ''::text |
|
|
Comma-separated list of prefixes (regular expressions) for courses to display in the second column of the academic record. |
||||||
| notes_sort_order | "_oat"."oat_sort_order" | 2147483647 | 'DESC'::_oat.oat_sort_order |
|
|
Order in which notes are displayed. |
||||||
| acad_record_sort_order | "_oat"."oat_sort_order" | 2147483647 | 'ASC'::_oat.oat_sort_order |
|
|
Order in which the terms of the academic record are displayed. |
Table contained 473 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| clt_user_pkey | Primary key | Asc | userid |
Relationships
Close relationships within degrees of separation
