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 (이름)