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)