MyPage

Tables (7)

Career

  • career_id — INT
  • user_id — INT — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • role — VARCHAR(100) — NOT NULL
  • is_public — BOOLEAN — NOT NULL

Certification

  • certification_id — INT
  • user_id — INT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • acquisition_date — DATE — NOT NULL
  • details — TEXT
  • type — ENUM('자격증', '수상', '어학') — NOT NULL

Education

  • education_id — INT
  • user_id — INT — NOT NULL
  • school_name — VARCHAR(100) — NOT NULL
  • major — VARCHAR(100)
  • grade — TINYINT
  • enrollment_year — YEAR
  • graduation_year — YEAR
  • status — ENUM('졸업', '졸업예정', '수료', '휴학', '재학') — NOT NULL

Experience

  • experience_id — INT
  • user_id — INT — NOT NULL
  • activity_type — ENUM('대외활동', '동아리', '봉사', '아르바이트') — NOT NULL
  • activity_name — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • details — TEXT — NOT NULL
  • is_public — BOOLEAN — NOT NULL

Introduction

  • introduction_id — INT
  • user_id — INT — NOT NULL
  • introduction_text — TEXT — NOT NULL
  • created_at — DATE — NOT NULL
  • is_public — BOOLEAN — NOT NULL

Portfolio

  • portfolio_id — INT
  • user_id — INT — NOT NULL
  • file_name — VARCHAR(255)
  • file_path — VARCHAR(255)
  • url — VARCHAR(255)
  • upload_date — DATE — NOT NULL
  • is_public — BOOLEAN — NOT NULL

Skill

  • skill_id — INT
  • user_id — INT — NOT NULL
  • skill_name — VARCHAR(100) — NOT NULL
  • skill_type — ENUM('보유', '희망') — NOT NULL