꿈을 잇다

테이블 (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