nextplan

Tables (7)

external_activities

  • ext_id — SERIAL — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL — 공고
  • category — VARCHAR(50) — 활동
  • deadline — DATE — 모집
  • origin_url — TEXT — 원문
  • source — VARCHAR(100) — 공고
  • created_at — TIMESTAMPTZ — NOT NULL — 공고

external_activity_skills

  • ext_skill_id — SERIAL — Primary key — NOT NULL
  • ext_id — INT — Foreign key → external_activities.ext_id — NOT NULL — 공고
  • std_id — INT — Foreign key → skill_standard.std_id — NOT NULL — 표준

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 — 역할
  • start_date — DATE — 활동
  • end_date — DATE — 활동

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) — 이력서
  • is_primary — BOOLEAN — NOT NULL — 대표
  • created_at — TIMESTAMPTZ — NOT NULL — 등록

user_skills

  • user_skill_id — SERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL — 사용자
  • std_id — INT — Foreign key → skill_standard.std_id — 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 — 가입