KuTTy_2025
Tables (13)
department (학과정보)
- department_id (학과아이디) — BIGINT — Primary key — NOT NULL
- college (단과대학) — VARCHAR(255)
- department_name (학과명) — VARCHAR(255)
department_major (수강학부(과)/전공)
- dep_major_id (수강학과아이디) — BIGINT — Primary key — NOT NULL
- lecture_id (강의정보아이디) — BIGINT — Foreign key → lecture.lecture_id — NOT NULL
- department_name (학과이름) — VARCHAR(100)
gen_edu_category (교양 카테고리)
- gen_category_id (교양아이디) — BIGINT — Primary key — NOT NULL
- sub_basic_gen_edu_category_id (세부 기초교양 카테고리 아이디) — BIGINT — Foreign key → sub_basic_gen_edu_category.sub_basic_gen_edu_category_id — NOT NULL
- sub_KU_literacy_category_id (세부 KU소양 카테고리) — BIGINT — Foreign key → sub_KU_literacy_category.sub_KU_literacy_category_id — NOT NULL
- basic_gen (기초교양) — INT
- advanced_gen (심화교양) — INT
- KU_literacy (KU소양) — INT
graduation_requirement (졸업요건)
- grad_req_id (졸업요건아이디) — BIGINT — Primary key — NOT NULL
- year (연도) — YEAR
- department_id (학과아이디) — BIGINT — Foreign key → department.department_id — NOT NULL
- category_id (카테고리아이디) — BIGINT — Foreign key → subject_category.category_id — NOT NULL
- total_req_credit (졸업이수학점) — INT
- memo (비고) — VARCHAR(500)
lecture (강의정보 테이블)
- lecture_id (강의정보아이디) — BIGINT — Primary key — NOT NULL
- year (개설연도) — YEAR
- semester (개설학기) — VARCHAR(255)
- lecture_num (과목번호) — VARCHAR(255)
- lecture_code (학수번호) — VARCHAR(255)
- grade (학년) — INT
- completion (이수구분) — VARCHAR(255)
- lecture_name (교과목명) — VARCHAR(255)
- credit (학점) — INT
- hours (시간) — INT
- college (개설대학) — VARCHAR(255)
- offered_dep_major (개설학부(과)/전공) — VARCHAR(255)
- intensive_completion_type (집중이수제구분) — VARCHAR(255)
- native_lang_lecture (원어강의) — TINYINT(1)
- native_lang_type (원어구분) — VARCHAR(255)
- foreign_lecture (외국인과목여부) — TINYINT(1)
- current_student (수강인원) — INT
- undergrad_students (학부인원) — INT
- grad_students (대학원인원) — INT
- limit_students (제한인원) — INT
- lecture_type (강의유형) — VARCHAR(255)
- lecture_category (강의종류) — VARCHAR(255)
- lecture_kind (교과목유형) — VARCHAR(255)
- area (영역) — VARCHAR(255)
- pass_lecture (패스과목) — VARCHAR(255)
lecture_schedule (강의시간 / 장소)
- schedule_id (강의스케줄아이디) — BIGINT — Primary key — NOT NULL
- lecture_id (강의정보아이디) — BIGINT — Foreign key → lecture.lecture_id — NOT NULL
- day (강의요일) — VARCHAR(255)
- strat_time (시작시간) — TIME
- end_time (종료시간) — TIME
- classromm (강의실) — VARCHAR(255)
professor (교수정보)
- professor_id (교수정보아이디) — Primary key — NOT NULL
- lecture_id (강의정보아이디) — BIGINT — Foreign key → lecture.lecture_id — NOT NULL
- professor_name (교수명) — VARCHAR(255)
sub_KU_literacy_category (세부 KU소양 카테고리)
- sub_KU_literacy_category_id (세부 KU소양 카테고리) — BIGINT — Primary key — NOT NULL
- personality (인성) — INT
- practical Skills (실무) — INT
- performance (실기) — INT
sub_basic_gen_edu_category (세부 기초교양 카테고리)
- sub_basic_gen_edu_category_id (세부 기초교양 카테고리 아이디) — BIGINT — Primary key — NOT NULL
- writing (글쓰기) — INT
- presentation_discussion (발표·토론) — INT
- foreign _language (외국어) — INT
- humanities_basics (인문기초) — INT
- science_basics (과학기초) — INT
- AI/data (AI/데이터) — INT
subject_category (과목 카테고리)
- category_id (카테고리아이디) — BIGINT — Primary key — NOT NULL
- gen_category_id (교양아이디) — BIGINT — Foreign key → gen_edu_category.gen_category_id — NOT NULL
- major_req (전공필수) — INT
- major_select (전공선택) — INT
user (사용자)
- user_id (사용자아이디) — BIGINT — Primary key — NOT NULL
- username (사용자이름) — VARCHAR(255)
- addmission_year (입학연도) — YEAR
- department_id (학과아이디) — BIGINT — Foreign key → department.department_id — NOT NULL
- grad_req_id (졸업요건아이디) — BIGINT — Foreign key → graduation_requirement.grad_req_id — NOT NULL
- created_at (생성시각) — TIME
- updated_at (수정시각) — TIME
- email (이메일) — VARCHAR(255)
- grade (학년) — INT
- password (비밀번호) — VARCHAR(255)
- role (역할) — VARCHAR(255)
- token_version (토큰버전) — INT
user_blacklist (사용자 블랙리스트)
- blacklist_id (블랙리스트아이디) — BIGINT — Primary key — NOT NULL
- user_id (사용자아이디) — BIGINT — Foreign key → user.user_id — NOT NULL
- lecture_id (강의정보아이디) — BIGINT — Foreign key → lecture.lecture_id — NOT NULL
- lecture_name (과목이름) — VARCHAR(255)
- grade (성적) — VARCHAR(5)
- grade (상태) — ENUM(taken, completed, preference, blacklist)
- memo (비고) — VARCHAR(255)
user_tag (사용자 선호 태그)
- user_id (사용자아이디) — BIGINT — Foreign key → user.user_id — NOT NULL
- avoid_morning (아침수업기피) — TINYINT(1)
- free_day (공강요일) — VARCHAR(255)
- max_daily_credit (하루 최대 학점 수) — INT
- optimize_commute (강의 간 이동시간 고려) — TINYINT