nextplan
Tables (6)
external_activities
- ext_id — SERIAL — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL — 공고
- category — VARCHAR(50) — 활동
- required_skills — JSONB — NOT NULL — 요구
- deadline — DATE — 모집
- origin_url — TEXT — 원문
skill_standard
- std_id — SERIAL — Primary key — NOT NULL
- alias_name — VARCHAR(50) — NOT NULL — 별칭
- standard_name — VARCHAR(50) — NOT NULL — 대표
user_activities
- activity_id — SERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL — 사용자
- title — VARCHAR(200) — NOT NULL — 활동/공모전
- organization — VARCHAR(100) — 주최/소속
- contribution — TEXT — 역할
user_resumes
- resume_id — SERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL — 사용자
- file_url — TEXT — S3
- portfolio_url — TEXT — 외부
- description — VARCHAR(255) — 이력서
user_skills
- user_skill_id — SERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL — 사용자
- skill_name — VARCHAR(50) — NOT NULL — 기술
- proficiency — SMALLINT — NOT NULL — 숙련도
users
- user_id — UUID — Primary key — NOT NULL
- kakao_id — VARCHAR(255) — NOT NULL — 카카오
- email — VARCHAR(255) — 카카오
- nickname — VARCHAR(50) — NOT NULL — 서비스
- profile_img — TEXT — 프로필
- is_onboarded — BOOLEAN — NOT NULL — 2차
- created_at — TIMESTAMPTZ — NOT NULL — 가입