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 — 가입