community
Tables (10)
member (유저)
- id (PK) — Primary key — NOT NULL
- email (이메일)
- password (비밀번호)
- nickname (닉네임)
- img_url (프로필 이미지)
- is_deleted (탈퇴여부)
- created_at (생성일)
member_tech_stack (유저 기술 스택)
- id (PK) — Primary key — NOT NULL
- tech_stack_id (기술스택FK) — Foreign key → tech_stack.id — NOT NULL
- member_id (멤버FK) — Foreign key → member.id — NOT NULL
people (팀원)
- id (PK) — Primary key — NOT NULL
- member_id (멤버FK) — Foreign key → member.id — NOT NULL
- project_id (프로젝트FK) — Foreign key → project.id — NOT NULL
- position_id (직군FK) — Foreign key → position.id — NOT NULL
- role (권한)
position (직군)
- id (PK) — Primary key — NOT NULL
- name (이름)
post (구인글)
- id (PK) — Primary key — NOT NULL
- project_id (프로젝트FK) — Foreign key → project.id — NOT NULL
- title (제목)
- content (내용)
- deadline (마감일)
- status (모집 상태)
- created_at (생성일)
- is_deleted (삭제 여부)
post_position (모집 직군)
- id (PK) — Primary key — NOT NULL
- post_id (구인글FK) — Foreign key → post.id — NOT NULL
- position_id (직군FK) — Foreign key → position.id — NOT NULL
- count (모집 인원)
post_tech_stack (모집 기술스택)
- id (PK) — Primary key — NOT NULL
- post_id (구인글FK) — Foreign key → post.id — NOT NULL
- teck_stack_id (기술스택FK) — Foreign key → tech_stack.id — NOT NULL
project (프로젝트)
- id (PK) — Primary key — NOT NULL
- leader_id (리더FK) — Foreign key → member.id — NOT NULL
- title (이름)
- description (설명)
- is_public (공개 여부)
- img_url (이미지 주소)
- is_deleted (삭제 여부)
- created_at (생성일)
team_join_request (참가 요청)
- id (PK) — Primary key — NOT NULL
- position_id (직군FK) — Foreign key → position.id — NOT NULL
- member_Id (유저FK) — Foreign key → member.id — NOT NULL
- post_id (모집글FK) — Foreign key → post.id — NOT NULL
- status (상태)
- comment (자기소개)
tech_stack (기술스택)
- id (PK) — Primary key — NOT NULL
- name (이름)