Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
|
|
|||||||||||||
| group_code | text | 2147483647 | null |
|
|
|||||||||||||
| unit_code | text | 2147483647 | null |
|
|
|||||||||||||
| subject_code | text | 2147483647 | null |
|
|
|||||||||||||
| catalog | text | 2147483647 | null |
|
|
|||||||||||||
| topic | int4 | 10 | √ | null |
|
|
||||||||||||
| component_code | text | 2147483647 | null |
|
|
|||||||||||||
| section_code | text | 2147483647 | null |
|
|
|||||||||||||
| delivery_id | int4 | 10 | null |
|
|
|||||||||||||
| meet_times | timerange | 2147483647 | √ | null |
|
|
||||||||||||
| meet_day | text | 2147483647 | √ | null |
|
|
||||||||||||
| meet_dates | daterange | 2147483647 | √ | null |
|
|
||||||||||||
| interval | int4 | 10 | null |
|
|
|||||||||||||
| building | text | 2147483647 | √ | null |
|
|
||||||||||||
| room | text | 2147483647 | √ | null |
|
|
||||||||||||
| instructor_id | "_quest"."quest_uw_id" | 2147483647 | √ | null |
|
|
||||||||||||
| sub_cat_sec | text | 2147483647 | null |
|
|
Table contained 3051 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| sch_preliminary_schedule_pkey | Primary key | Asc | id |
| sch_preliminary_schedule_building_room_idx | Performance | Asc/Asc | building + room |
| sch_preliminary_schedule_instructor_id_idx | Performance | Asc | instructor_id |
| sch_preliminary_schedule_sub_cat_sec_idx | Performance | Asc | sub_cat_sec |
Relationships
Close relationships within degrees of separation
