Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| term_id | "_quest"."quest_term_id" | 2147483647 | null |
|
|
The term (eg 1089) this permission number is for. |
||
| class_id | int4 | 10 | null |
|
|
The class ID the permission number is for. |
||
| subject_code | text | 2147483647 | null |
|
|
The course subject (eg: CS). |
||
| catalog | text | 2147483647 | null |
|
|
The course catalog number (eg: 135). |
||
| section_code | text | 2147483647 | null |
|
|
The course section number (eg: 001). |
||
| permission_num | int4 | 10 | null |
|
|
The permission number to give out. |
||
| expiry_date | date | 13 | null |
|
|
The date the permission number expires. |
||
| uw_id | "_quest"."quest_uw_id" | 2147483647 | √ | null |
|
|
The ID of the student given the permission number. |
|
| assigned_date | timestamp | 29,6 | √ | null |
|
|
When the permission number was given. |
|
| assigned_by | text | 2147483647 | √ | null |
|
|
Who assigned the permission number. |
|
| reason | text | 2147483647 | √ | null |
|
|
Why the permission number was assigned. |
Table contained 95122 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oat_perm_num_pkey | Primary key | Asc/Asc/Asc | term_id + class_id + permission_num |
Diagram producer might be missing
No diagrams were produced please see application output for any errors