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