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 — 각오 한마디