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