KuTTy
Tables (18)
category (카테고리)
- category_id (카테고리아이디) — BIGINT — Primary key — NOT NULL
- category_type (카테고리 타입) — ENUM('교양', '전공', '전필', '전선')
course (교과목 마스터_학수번호)
- course_id (교과목아이디) — BIGINT — Primary key — NOT NULL
- lecture_code (학수번호) — VARCHAR(255) — Primary key — NOT NULL
- department_id (학과아이디) — BIGINT — Foreign key → department.department_id — NOT NULL
- course_name (교과목명) — VARCHAR(255)
- credit (학점) — INT
department (학과정보)
- department_id (학과아이디) — BIGINT — Primary key — NOT NULL
- college (단과대학) — VARCHAR(255)
- department_name (학과) — VARCHAR(255)
department_alias (학과별칭)
- alias_id (별칭아이디) — BIGINT — Primary key — NOT NULL
- dep_major_id (수강학과아이디) — BIGINT — Foreign key → department_major.dep_major_id — NOT NULL
- alias_name (별칭명) — VARCHAR(100)
department_major (수강학부(과)/전공)
- dep_major_id (수강학과아이디) — BIGINT — Primary key — NOT NULL
- official_name (공식 명칭) — VARCHAR(100)
general_edu_category (필수교양 세부 항목)
- general_edu_category (필수교양 세부항목 아이디) — BIGINT — Primary key — NOT NULL
- general_edu_name (필수교양 세부 항목명) — VARCHAR(50)
graduation_requirement (졸업요건)
- graduation_requirement_id (졸업요건아이디) — BIGINT — Primary key — NOT NULL
- department_id (학과아이디) — BIGINT — Foreign key → department.department_id — NOT NULL
- year (연도) — YEAR
graduation_requirement_course_detail (졸업요건 상세_과목)
- grad_req_course_id (졸업요건 상세 과목아이디) — BIGINT — Primary key — NOT NULL
- grad_req_credit_detail_id (졸업요건 상세 학점아이디) — BIGINT — Foreign key → graduation_requirement_credit_detail.grad_req_credit_detail_id — NOT NULL
- course_id (교과목아이디) — BIGINT — Foreign key → course.course_id — NOT NULL
- lecture_code (학수번호) — VARCHAR(255) — Foreign key → course.lecture_code — NOT NULL
graduation_requirement_credit_detail (졸업요건 상세_학점)
- grad_req_credit_detail_id (졸업요건 상세 학점아이디) — BIGINT — Primary key — NOT NULL
- req_category_id (필수이수 카테고리 아이디) — BIGINT — Foreign key → requirement_category.req_category_id — NOT NULL
- category_id (카테고리아이디) — BIGINT — Foreign key → category.category_id — NOT NULL
- required_credit (최소 이수 학점수) — INT
lecture (강의정보)
- lecture_id (강의정보아이디) — BIGINT — Primary key — NOT NULL
- course_id (교과목아이디) — BIGINT — Foreign key → course.course_id — NOT NULL
- lecture_code (학수번호) — VARCHAR(255) — Foreign key → course.lecture_code — NOT NULL
- dep_major_id (수강학과아이디) — BIGINT — Foreign key → department_major.dep_major_id — NOT NULL
- year (연도) — YEAR
- semester (학기) — VARCHAR(10)
- lecture_num (과목번호) — INT
- grade (학년) — INT
- completion (이수구분) — VARCHAR(255)
- lecture_name (교과목명) — VARCHAR(255)
- credit (학점) — INT
- hours (시간) — INT
- department_major (수강학부(과)/전공) — VARCHAR(255)
- college (개설대학) — VARCHAR(255)
- offered_department_major (개설학부(과)/전공) — VARCHAR(255)
- intensive_completion_type (집중이수제구분) — VARCHAR(255)
- native_language_lecture (원어강의) — TINYINT(1)
- native_language_type (원어구분) — VARCHAR(255)
- foreign_lecture (외국인과목여부) — TINYINT(1)
- current_students (현재인원) — 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_professor (강의담당교수)
- professor_id (교수정보 아이디) — BIGINT — Foreign key → professor.professor_id — NOT NULL
- Key (Key3) — Foreign key → lecture.lecture_id — NOT NULL
- course_id (교과목아이디) — BIGINT — Foreign key → lecture.course_id — NOT NULL
- lecture_code (학수번호) — VARCHAR(255) — Foreign key → lecture.lecture_code — NOT NULL
lecture_schedule (강의시간/장소)
- schedule_id (강의스케줄아이디) — BIGINT — Primary key — NOT NULL
- Key (Key3) — Foreign key → lecture.lecture_id — NOT NULL
- course_id (교과목아이디) — BIGINT — Foreign key → lecture.course_id — NOT NULL
- lecture_code (학수번호) — VARCHAR(255) — Foreign key → lecture.lecture_code — NOT NULL
- day_of_week (강의요일) — VARCHAR(255)
- start_time (시작시간) — TIME
- end_time (종료시간) — TIME
- classroom (강의실) — VARCHAR(255)
professor (교수정보)
- professor_id (교수정보 아이디) — BIGINT — Primary key — NOT NULL
- professor_name (교수명)
requirement_category (필수교양 카테고리)
- req_category_id (필수교양 카테고리 아이디) — BIGINT — Primary key — NOT NULL
- category_id (카테고리아이디) — BIGINT — Foreign key → category.category_id — NOT NULL
- general_edu_category (필수교양 세부항목 아이디) — BIGINT — Foreign key → general_edu_category.general_edu_category — NOT NULL
- req_category_type (필수교양 카테고리 타입) — ENUM('KU인성', '기초교양', '심화교양, 'KU소양')
students_course_history (수강 이력)
- history_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
- grade_recieve (성적) — VARCHAR(5)
- status (상태) — ENUM('이수', '미이수', '취득학점포기', '재수강'
user (사용자)
- user_id (사용자아이디) — BIGINT — Primary key — NOT NULL
- department_id (학과아이디) — BIGINT — Foreign key → department.department_id — NOT NULL
- admission_year (입학년도) — YEAR
- created_at (생성시각) — TIME
- email (이메일) — VARCHAR(255)
- grade (학년) — INT
- password (비밀번호) — VARCHAR(255)
- role (역할) — VARCHAR(255)
- token_version (토큰버전) — INT
- updated_at (수정시각) — TIME
- username (사용자이름) — VARCHAR(255)
user_blaklist (사용자 블랙리스트)
- blacklist_id (블랙리스트아이디) — BIGINT — Primary key — NOT NULL
- user_id (사용자아이디) — BIGINT — Foreign key → user.user_id — NOT NULL
- lecture_namr (과목이름) — VARCHAR(255)
- lecture_num (과목번호) — VARCHAR(255)
user_preference_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(1)