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)