Gaepom ERD
Tables (10)
application (애플리케이션)
- application_id (applicaiton_id) — Primary key — NOT NULL
- 모집idx (recruit_idx) — Foreign key → project_recruit.모집idx — NOT NULL
- date
- position
- selected — Y/N
- words
category (Untitled4)
- 분야idx (category_idx) — Primary key — NOT NULL
- Name
comment reply (대댓글)
- reply_id — Primary key — NOT NULL
- 댓글idx (comment_id) — Foreign key → comments.댓글idx — NOT NULL
- user_id
- body
- date — datetime
comments (댓글)
- 댓글idx (comment_id) — Primary key — NOT NULL
- 사용자아이디 (user_id) — varchar2 — Foreign key → user.사용자아이디 — NOT NULL
- 댓글내용 (comment)
- 생성 날짜 (date) — datetime
- post_id
likes (좋아요)
- like_id — Primary key — NOT NULL
- user_id
- post_id
portfolio (Untitled3)
- 포트폴리오idx (portfolio_idx) — Primary key — NOT NULL
- 분야idx (category_idx) — Foreign key → category.분야idx — NOT NULL
- project_title
- duration
- position
- description
- participation_num
- languages
- tools
- dbms
- link
project (중복테이블)
- 프로젝트idx (project_id) — Primary key — NOT NULL
- 모집idx (recruit_idx) — Foreign key → project_recruit.모집idx — NOT NULL
- 트레킹idx (tracking_idx) — Foreign key → project_tracking.트레킹idx — NOT NULL
- 분야idx (category_idx) — Foreign key → category.분야idx — NOT NULL
- 프로젝트명 (title)
- 상세 설명 (description)
- 프로젝트 기간 (duration)
- 사용툴 (tools)
project_recruit (모집테이블)
- 모집idx (recruit_idx) — Primary key — NOT NULL
- Field (ppl_needed)
- 지역 (location)
- 우대사항 (perference)
- 모집상태 (status)
- 모집기간 (recruit_duration)
- 기획자id (creator_id)
- 프로젝트 타입 (project_type)
project_tracking (트레킹테이블)
- 트레킹idx (tracking_idx) — Primary key — NOT NULL
- 댓글idx (comment_id) — Foreign key → comments.댓글idx — NOT NULL
- like_id — Foreign key → likes.like_id — NOT NULL
- Field (stage)
- Field2 (issues)
- Field3 (output)
- Field4 (like)
- image (image_path)
- participant — user id 리스트
user (Untitled)
- 사용자아이디 (user_id) — VARCHAR2 — Primary key — NOT NULL
- 포트폴리오id (portfolio_idx) — Foreign key → portfolio.포트폴리오idx — NOT NULL
- 분야idx (category_idx) — Foreign key → category.분야idx — NOT NULL
- 프로젝트idx (project_idx) — Foreign key → project.프로젝트idx — NOT NULL
- password
- name
- age
- email
- phone_num
- address
- job_preference
- stack
- image path (image_path)
- interests
- words — 각오 한마디