tt

Tables (11)

change_named_lecture

  • prev_lecture_name — VARCHAR(100) — NOT NULL
  • current_ — VARCHAR(100) — NOT NULL

external_score

  • external_score_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • external_score_type — ENUM('TOPCIT', 'APC')
  • eng_score_type — ENUM('TOEIC', 'OPIC', 'TEPS')
  • external_score — INT
  • eng_score — INT
  • aquisition_date — DATE

graduation_comparative_score

  • id — INT — NOT NULL
  • toeic — INT
  • teps — INT
  • toeic_speaking — INT
  • opic — INT
  • topcit — INT
  • apc — INT

graduation_requirement_base

  • id — INT — NOT NULL
  • department — VARCHAR(50) — NOT NULL
  • start_year — INT — NOT NULL
  • end_year — INT — NOT NULL
  • total_credit — INT — NOT NULL
  • basic_credit — INT — NOT NULL
  • distribution_area_credit — INT — NOT NULL

graduation_requirement_detail

  • id — INT — NOT NULL
  • base_id — INT — NOT NULL
  • is_dual_degree — BOOLEAN — NOT NULL
  • major_credit — INT — NOT NULL
  • industrial_course_count — INT — NOT NULL

lecture

  • lecture_id — VARCHAR(10) — NOT NULL
  • ###교과목 — 코드
  • credit — INT
  • code — VARCHAR(20)
  • semester — VARCHAR(10)
  • lecture_department — VARCHAR(50)

major

  • lecture_id — VARCHAR(10) — NOT NULL
  • is_required — BOOLEAN
  • start_year — INT
  • end_year — INT
  • is_industry — BOOLEAN

raw_lecture_import_2023

  • num — INT
  • college — VARCHAR(100)
  • department — VARCHAR(100)
  • major — VARCHAR(100)
  • subject_name — VARCHAR(200)
  • class_number — VARCHAR(20)
  • subject_code — VARCHAR(20)
  • professor — VARCHAR(100)
  • professor_department — VARCHAR(100)
  • credit — INT
  • hours — INT
  • course_category — VARCHAR(50)
  • subject_type — VARCHAR(50)
  • is_english — VARCHAR(10)
  • english_grade — VARCHAR(10)
  • is_foreign_only — VARCHAR(10)
  • is_team_teaching — VARCHAR(10)
  • lecture_time_label — VARCHAR(200)
  • split_type — VARCHAR(50)
  • lecture_class — VARCHAR(50)
  • teaching_method — VARCHAR(50)
  • subject_feature — VARCHAR(100)
  • subject_name_eng — VARCHAR(200)
  • subject_id — INT
  • target_grade — VARCHAR(20)
  • split_class_method — VARCHAR(50)
  • split_class_type — VARCHAR(50)

required_general

  • lecture_id — VARCHAR(10) — NOT NULL
  • is_field_required — BOOLEAN
  • subject_field — ENUM('역사와 철학', '문학과 예술', '인간과 사회', '자연과 과학', '연결과 통합', 'Others')
  • start_student_num — INT
  • end_student_num — INT

taken_lecture

  • id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • lecture_id — VARCHAR(10) — NOT NULL
  • taken_year — INT
  • taken_semester — VARCHAR(10)
  • score — ENUM('A+', 'A0', 'B+', 'B0', 'C+', 'C0', 'P', 'F')

user

  • user_id — INT — NOT NULL
  • name — VARCHAR(50)
  • student_number — VARCHAR(20)
  • department — VARCHAR(50)
  • entrance_year — INT
  • is_dual_degree — BOOLEAN