student_agent
Tables (6)
admin (Untitled5)
- admin_id (관리자 ID) — int — Primary key — NOT NULL
- username (관리자 이름) — varchar
- admin_pw (관리자 비밀번호) — varchar
- created_at (계정 생성일) — timestamp
completed_course (Untitled2)
- completed_id (이수한 관목ID) — int — Primary key — NOT NULL
- course_id (과목ID) — int — Foreign key → course.course_id — NOT NULL
- user_id (사용자_id) — int — Foreign key → student.user_id — NOT NULL
course (Untitled)
- course_id (과목ID) — int — Primary key — NOT NULL
- name_kr (과목명) — varchar
- name_en (과목명(영어)) — varchar
- category_kr (과목 카테고리) — varchar
- subcategory (세부 카테고리) — varchar
- credits (학점) — int
- year (개설 학년) — int
- semester (개설 학기) — varchar
- difficulty (체감 난이도) — varchar
course_prerequisite (Untitled4)
- course_id (과목ID) — int — Foreign key → course.course_id — NOT NULL
- prerequisite_id (선수과목ID) — int
recommendation_log (Untitled3)
- log_id (추천 기록 ID) — int — Primary key — NOT NULL
- user_id (사용자_id) — int — Foreign key → student.user_id — NOT NULL
- transfer_type (편입 유형) — enum
- start_year (편입 학년) — int
- start_semester (편입 학기) — int
- goal (추천 시 선택한 관심분야) — varchar
- total_recommendation_credits (추천된 총 학점) — int
- created_at (추천 요청일) — timestamp
student (사용자)
- user_id (사용자ID) — int — Primary key — NOT NULL
- student_id (학번) — varchar
- name (핫생이름) — varchar
- student_pw (비밀번호) — varchar
- transfer_type (편입 유형) — enum
- background_major (출신 전공학과) — varchar
- start_year (편입 학년) — int
- start_sememster (편입 학기) — int
- goal (관심 분야) — varchar
- recognized_total_credits (인정 총학점) — int
- recognized_major_credits (인정 전공 학점) — int
- recognized_minor_credits (인정 교양 학점) — int
- is_active (계정 활성 여부) — tinyint
- created_at (계정 생성일) — datetime
- updated_at (정보 수정일) — timestamp