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