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