geaform
Tables (7)
application (지원 테이블)
- 지원idx (application_idx) — Primary key — NOT NULL
- 프로젝트idx (project_idx) — Foreign key → project.프로젝트idx — NOT NULL
- 지원자 아이디 (user_id)
- 각오 (resolution)
- Field (position)
comments (댓글)
- 댓글idx (comment_id) — Primary key — NOT NULL
- 사용자아이디 (user_id) — varchar2 — Foreign key → user.사용자아이디 — NOT NULL
- Field (comment)
- Field2 (write_date)
- Field (liked_cnt)
- Field (parent_id) — varchar2
- Field2 (depth) — number
portfolio (Untitled3)
- 포트폴리오idx (portfolio_idx) — Primary key — NOT NULL
- project_title
- duration
- description
- participation_num
- languages
- tools
- dbms
- link
- Field (category)
project (중복테이블)
- 프로젝트idx (project_idx) — Primary key — NOT NULL
- 모집idx (recruit_idx) — Foreign key → project_recruit.모집idx — NOT NULL
- 트레킹idx (tracking_idx) — Foreign key → project_tracking.트레킹idx — NOT NULL
- 프로젝트명 (title)
- 상세 설명 (description)
- 프로젝트 기간 (duration)
- 사용툴 (tools)
- 참가자 (participants)
- Field (category)
project_recruit (모집테이블)
- 모집idx (recruit_idx) — Primary key — NOT NULL
- Field (ppl_needed)
- 지역 (location)
- 우대사항 (perference)
- 모집상태 (status)
- 모집기간 (recruit_duration)
- 기획자id (creator_id)
project_tracking (트레킹테이블)
- 트레킹idx (tracking_idx) — Primary key — NOT NULL
- 댓글idx (comment_id) — Foreign key → comments.댓글idx — NOT NULL
- Field (stage)
- Field2 (issues)
- Field3 (output)
- Field4 (like)
- Field (image_path)
user (Untitled)
- 사용자아이디 (user_id) — varchar2 — Primary key — NOT NULL
- 포트폴리오idx (portfolio_idx) — Foreign key → portfolio.포트폴리오idx — NOT NULL
- password
- name
- age
- email
- phone_num
- address
- stack
- Field (image_path)
- 프로젝트idx (project_idx) — Foreign key → project.프로젝트idx — NOT NULL
- Field (category)