꿈을 잇다
테이블 (11)
Certificate
- certificate_id — INT
- certificate_name — VARCHAR(255) — NOT NULL
- field — VARCHAR(100)
- description — TEXT
Course
- course_id — INT
- course_name — VARCHAR(255) — NOT NULL
- department — VARCHAR(100)
- credit — FLOAT
- prerequisite_id — INT
- semester — ENUM('Spring','Summer','Fall','Winter')
Enrollment
- enrollment_id — INT
- user_id — INT — NOT NULL
- course_id — INT — NOT NULL
- grade — CHAR(2)
- year — YEAR
- semester — ENUM('Spring','Summer','Fall','Winter')
Goal
- goal_id — INT
- user_id — INT — NOT NULL
- goal_type — ENUM('career','grade','skill','certificate') — NOT NULL
- target_value — VARCHAR(255) — NOT NULL
- deadline — DATE
GraduationRequirement
- requirement_id — INT
- department — VARCHAR(100)
- requirement_type — ENUM('credit','mandatory_course','thesis','exam') — NOT NULL
- description — TEXT
- required_value — VARCHAR(255)
Mileage
- mileage_id — INT
- user_id — INT — NOT NULL
- points — INT — NOT NULL
- description — VARCHAR(255)
- created_at — TIMESTAMP
Mission
- mission_id — INT
- mission_name — VARCHAR(255) — NOT NULL
- mission_type — ENUM('course','certificate','campus_activity') — NOT NULL
- description — TEXT
- mileage_reward — INT — NOT NULL
User
- user_id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- major — VARCHAR(100)
- admission_year — YEAR
- current_grade — FLOAT
- career_goal — VARCHAR(255)
- skill_goal — VARCHAR(255)
UserCertificate
- user_certificate_id — INT
- user_id — INT — NOT NULL
- certificate_id — INT — NOT NULL
- status — ENUM('planned','in_progress','completed')
UserMission
- user_mission_id — INT
- user_id — INT — NOT NULL
- mission_id — INT — NOT NULL
- status — ENUM('assigned','completed','failed')
- completed_date — DATE
UserRequirementProgress
- progress_id — INT
- user_id — INT — NOT NULL
- requirement_id — INT — NOT NULL
- is_completed — BOOLEAN