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