likelion

Tables (7)

Course (전공수업정보)

  • course_id (수업 번호) — Primary key — NOT NULL
  • name (수업명)
  • credit (학점)
  • description (수업설명)
  • difficulty (난이도)
  • department_id (학과 번호) — Foreign key → Department.department_id — NOT NULL

Department (학과 정보)

  • department_id (학과 번호) — Primary key — NOT NULL
  • name (학과명)
  • college (단과대학)
  • description (학과설명)
  • career_path (졸업 후 진로)

DepartmentInterest (학과관련성)

  • department_interest_id (학과관심사번호) — Primary key — NOT NULL
  • relevance_level (관련도)
  • department_id (학과 번호) — Foreign key → Department.department_id — NOT NULL
  • interest_id (관심사번호) — Foreign key → Interest.interest_id — NOT NULL

Interest (관심사)

  • interest_id (관심사번호) — Primary key — NOT NULL
  • name (관심사명)

Recommendation (학과추천)

  • recommendation_id (추천번호) — Primary key — NOT NULL
  • score (추천점수)
  • reason (추천이유)
  • created_at (추천생성일)
  • student_id (학생 번호) — Foreign key → Student.student_id — NOT NULL
  • department_id (학과 번호) — Foreign key → Department.department_id — NOT NULL

Student (학생정보)

  • student_id (학생 번호) — Primary key — NOT NULL
  • name (이름)
  • grade (학년)
  • description (희망진로)

StudentInterest (학생 관심사)

  • student_interest_id (학생관심사번호) — Primary key — NOT NULL
  • preference_level (선호도)
  • student_id (학생 번호) — Foreign key → Student.student_id — NOT NULL
  • interest_id (관심사번호) — Foreign key → Interest.interest_id — NOT NULL