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