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