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