schedule_of_classes
Tables (24)
auth_group
- id — integer — Primary key — NOT NULL
- name — character varying — NOT NULL
auth_group_permissions
- id — bigint — Primary key — NOT NULL
- group_id — integer — Foreign key → auth_group.id — NOT NULL
- permission_id — integer — Foreign key → auth_permission.id — NOT NULL
auth_permission
- id — integer — Primary key — NOT NULL
- name — character varying — NOT NULL
- content_type_id — integer — Foreign key → django_content_type.id — NOT NULL
- codename — character varying — NOT NULL
auth_user
- id — integer — Primary key — NOT NULL
- password — character varying — NOT NULL
- last_login — timestamp with time zone
- is_superuser — boolean — NOT NULL
- username — character varying — NOT NULL
- first_name — character varying — NOT NULL
- last_name — character varying — NOT NULL
- email — character varying — NOT NULL
- is_staff — boolean — NOT NULL
- is_active — boolean — NOT NULL
- date_joined — timestamp with time zone — NOT NULL
auth_user_groups
- id — bigint — Primary key — NOT NULL
- user_id — integer — Foreign key → auth_user.id — NOT NULL
- group_id — integer — Foreign key → auth_group.id — NOT NULL
auth_user_user_permissions
- id — bigint — Primary key — NOT NULL
- user_id — integer — Foreign key → auth_user.id — NOT NULL
- permission_id — integer — Foreign key → auth_permission.id — NOT NULL
django_admin_log
- id — integer — Primary key — NOT NULL
- action_time — timestamp with time zone — NOT NULL
- object_id — text
- object_repr — character varying — NOT NULL
- action_flag — smallint — NOT NULL
- change_message — text — NOT NULL
- content_type_id — integer — Foreign key → django_content_type.id
- user_id — integer — Foreign key → auth_user.id — NOT NULL
django_content_type
- id — integer — Primary key — NOT NULL
- app_label — character varying — NOT NULL
- model — character varying — NOT NULL
django_migrations
- id — bigint — Primary key — NOT NULL
- app — character varying — NOT NULL
- name — character varying — NOT NULL
- applied — timestamp with time zone — NOT NULL
django_session
- session_key — character varying — Primary key — NOT NULL
- session_data — text — NOT NULL
- expire_date — timestamp with time zone — NOT NULL
schedule_academicgroup
- id — bigint — Primary key — NOT NULL
- name — character varying — NOT NULL
- direction — character varying — NOT NULL
schedule_building
- id — bigint — Primary key — NOT NULL
- name — character varying — NOT NULL
- address — character varying — NOT NULL
schedule_buildingdistance
- id — bigint — Primary key — NOT NULL
- minutes — integer — NOT NULL
- from_building_id — bigint — Foreign key → schedule_building.id — NOT NULL
- to_building_id — bigint — Foreign key → schedule_building.id — NOT NULL
schedule_curriculum
- id — bigint — Primary key — NOT NULL
- semester — integer — NOT NULL
- year — integer — NOT NULL
- lecture_hours — integer — NOT NULL
- practice_hours — integer — NOT NULL
- lab_hours — integer — NOT NULL
- exam_type — character varying
- academic_group_id — bigint — Foreign key → schedule_academicgroup.id — NOT NULL
- discipline_id — bigint — Foreign key → schedule_discipline.id — NOT NULL
- weeks — smallint — NOT NULL
schedule_department
- id — bigint — Primary key — NOT NULL
- name — character varying — NOT NULL
- dept_type — character varying — NOT NULL
- parent_id — bigint — Foreign key → schedule_department.id
schedule_discipline
- id — bigint — Primary key — NOT NULL
- name — character varying — NOT NULL
schedule_lessontype
- id — bigint — Primary key — NOT NULL
- name — character varying — NOT NULL
- default_duration_minutes — integer — NOT NULL
schedule_room
- id — bigint — Primary key — NOT NULL
- name — character varying — NOT NULL
- capacity — integer — NOT NULL
- room_type — character varying — NOT NULL
- building_id — bigint — Foreign key → schedule_building.id — NOT NULL
schedule_scheduleentry
- id — bigint — Primary key — NOT NULL
- week_parity — character varying — NOT NULL
- is_cancelled — boolean — NOT NULL
- replacement_id — bigint — Foreign key → schedule_scheduleentry.id
- room_id — bigint — Foreign key → schedule_room.id
- student_group_id — bigint — Foreign key → schedule_studentgroup.id — NOT NULL
- teacher_assignment_id — bigint — Foreign key → schedule_teacherassignment.id — NOT NULL
- time_slot_id — bigint — Foreign key → schedule_timeslot.id — NOT NULL
- working_day_id — bigint — Foreign key → schedule_workingday.id — NOT NULL
schedule_studentgroup
- id — bigint — Primary key — NOT NULL
- name — character varying — NOT NULL
- group_type — character varying — NOT NULL
- student_count — integer — NOT NULL
- academic_group_id — bigint — Foreign key → schedule_academicgroup.id
schedule_teacher
- id — bigint — Primary key — NOT NULL
- full_name — character varying — NOT NULL
- academic_degree — character varying — NOT NULL
- academic_title — character varying — NOT NULL
- position — character varying — NOT NULL
- max_hours_per_day — integer — NOT NULL
- department_id — bigint — Foreign key → schedule_department.id — NOT NULL
schedule_teacherassignment
- id — bigint — Primary key — NOT NULL
- hours_allocated — integer — NOT NULL
- discipline_id — bigint — Foreign key → schedule_discipline.id — NOT NULL
- lesson_type_id — bigint — Foreign key → schedule_lessontype.id — NOT NULL
- teacher_id — bigint — Foreign key → schedule_teacher.id — NOT NULL
schedule_timeslot
- id — bigint — Primary key — NOT NULL
- pair_number — smallint — NOT NULL
- start_time — time without time zone — NOT NULL
- end_time — time without time zone — NOT NULL
schedule_workingday
- id — bigint — Primary key — NOT NULL
- date — date — NOT NULL
- weekday — integer — NOT NULL
- is_working — boolean — NOT NULL
- week_parity — character varying — NOT NULL