KuTTy_v1

Tables (10)

black_list (블랙리스트 (기피/이수))

  • blacklist_id (블랙리스트아이디) — BIGINT — Primary key — NOT NULL
  • user_id (사용자아이디) — BIGINT — Foreign key → users.user_id — NOT NULL
  • lecture_num (과목번호) — VARCHAR(255)
  • lecture_type (강의유형) — VARCHAR(255)

graduation_requirement (졸업요건)

  • id (졸업요건아이디) — BIGINT — Primary key — NOT NULL
  • year (적용학년도) — INT
  • college (단과대학) — VARCHAR(255)
  • departent_name (학과명) — VARCHAR(255)
  • total_req_credit (총이수요구학점) — INT
  • major_req (전공필수요구학점) — INT
  • major_select (전공선택요구학점) — INT
  • basic_gen (기초교양요구학점) — INT
  • advance_gen (심화교양요구학점) — INT
  • ku_literacy (KU소양요구학점) — INT
  • writing (글쓰기요구학점) — INT
  • presentation_discussion (발표와토론요구학점) — INT
  • foregin_language (외국어요구학점) — INT
  • humanities_basics (인문기초요구학점) — INT
  • science_basics (과학기초요구학점) — INT
  • ai_data (ai/데이터 요구학점) — INT
  • peersonality (인성요구학점) — INT
  • practical_skills (실무요구학점) — INT
  • performance (실기요구학점) — INT
  • memo (메모) — TINYTEXT
  • created_at (생성일시) — TIMESTAMP
  • updated_at (수정일시) — TIMESTAMP

lecture (강의정보)

  • lecture_id (강의정보아이디) — BIGINT — Primary key — NOT NULL
  • lecture_num (과목번호) — VARCHAR(100)
  • grade (학년) — INT
  • lecture_code (학수번호) — VARCHAR(100)
  • completion_code (이수구분) — VARCHAR(100)
  • lecture_name (교과목명) — VARCHAR(100)
  • lecture_name_en (영문교과목명) — VARCHAR(100)
  • credit (학점) — INT
  • hours (시간) — INT
  • department_makor (수강학과) — VARCHAR(100)
  • college (개설대학) — VARCHAR(100)
  • offered_department (개설학과) — VARCHAR(100)
  • intensive_completion_tyoe (집중이수제구분) — VARCHAR(100)
  • professor (교수명) — VARCHAR(100)
  • native_language_type (원어강의) — VARCHAR(100)
  • foreign_lecture (외국인 과목 여부) — TINYINT(1)
  • current_students (수강인원) — INT
  • undergrad_students (학부인원) — INT
  • grad_students (대학원인원) — INT
  • limit_students (제한인원) — INT
  • lecture_type (강의유형) — VARCHAR(100)
  • lecture_category (강의종류) — VARCHAR(100)
  • lecture_kind (교과목유형) — VARCHAR(100)
  • area (영역) — VARCHAR(100)
  • pass_lecture (패스과목) — VARCHAR(100)

lecture_schedule (강의요시/강의실)

  • schedule_id (강의스케줄아이디) — BIGINT — Primary key — NOT NULL
  • lecture_id (강의정보아이디) — BIGINT — Foreign key → lecture.lecture_id — NOT NULL
  • day (강의요일) — VARCHAR(5)
  • start_time (시작시간) — TIME
  • end_time (종료시간) — TIME
  • room (강의실) — VARCHAR(100)

manual_credit (수기 학점)

  • id (수기학점아이디) — BIGINT — Primary key — NOT NULL
  • user_id (사용자아이디) — BIGINT — Foreign key → users.user_id — NOT NULL
  • completion_type (이수구분) — VARCHAR(255)
  • credit (학점) — INT

my_credits (총 이수 학점)

  • user_id (사용자아이디) — BIGINT — Foreign key → users.user_id — NOT NULL
  • advanced_culture (심화교양) — INT
  • basic_culture (기초교양) — INT
  • ku_culture (KU소양) — INT
  • required_major (전공필수) — INT
  • selected_major (전공선택) — INT
  • dirty (Field6) — BIT(1)
  • other (기타) — INT
  • total_earned (총이수학점) — INT
  • updated_at (수정일시) — DATETIME(6)

timetable (시간표)

  • timetable_id (시간표아이디) — BIGINT — Primary key — NOT NULL
  • user_id (사용자아이디) — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at (생성시각) — DATETIME(6)
  • description (설명) — VARCHAR(255)
  • in_use (확정여부) — BIT(1)
  • title (제목) — VARCHAR(255)
  • updated_at (수정일시) — DATETIME(6)

timetable_section (시간표섹션)

  • section_id (시간표섹션아이디) — BIGINT — Primary key — NOT NULL
  • timetable_id (시간표아이디) — BIGINT — Foreign key → timetable.timetable_id — NOT NULL
  • completion_type (이수구분) — VARCHAR(255)
  • course_id (학수번호) — VARCHAR(255)
  • lecture_name (강의명) — VARCHAR(255)
  • lecture_num (과목번호) — VARCHAR(255)
  • offered_department_major (개설학과(전공)) — VARCHAR(255)
  • professor (교수명) — VARCHAR(255)

timetable_slot (시간표슬롯)

  • id (시간표 슬롯아이디) — BIGINT — Primary key — NOT NULL
  • section_id (시간표섹션아이디) — BIGINT — Foreign key → timetable_section.section_id — NOT NULL
  • day (요일) — ENUM('FRI','MON','SAT','SUN','THU','TUE','WED')
  • end_min (종료시각) — INT
  • strat_min (시작시각) — INT

users (사용자)

  • user_id (사용자아이디) — BIGINT — Primary key — NOT NULL
  • admission_year (입학연도) — INT
  • created_at (생성시각) — DATETIME(6)
  • email (이메일) — VARCHAR(255)
  • grade (학년) — INT
  • major (학과) — VARCHAR(255)
  • password (비밀번호) — VARCHAR(255)
  • role (역할) — ENUM('ADMIN','USER')
  • token_version (토큰버전) — BIGINT
  • updated_at (마지막로그인시각) — DATETIME(6)
  • username (사용자명) — VARCHAR(255)