Plank

테이블 (7)

메시지 (message)

  • message_id — PK — 기본 키 — NOT NULL
  • team_id (target_team_id) — FK — 외래 키 → 팀.team_id — NOT NULL
  • sender_id — FK
  • content — NULL
  • created_at — NOT NULL

멤버 (team_members)

  • team_member_id — PK — 기본 키 — NOT NULL
  • team_id (target_team_id) — PK — 외래 키 → 팀.team_id — NOT NULL
  • team_id — FK
  • user_id — FK
  • role — NOT NULL
  • joined_at — NOT NULL

사용자 (users)

  • user_id — PK — 기본 키 — NOT NULL
  • email — NOT NULL — NOT NULL
  • password_hash — NOT NULL
  • name — NOT NULL
  • nickname — NOT NULL
  • profile_image_url — NOT NULL
  • status_message (status_messasge) — NOT NULL
  • created_at — NOT NULL
  • updated_at — NOT NULL

스케쥴 (schedules)

  • schedule_id — PK — 기본 키 — NOT NULL
  • user_id — FK — 외래 키 → 프로젝트.user_id — NOT NULL
  • team_id (target_team_id) — FK — 외래 키 → 프로젝트.team_id — NOT NULL
  • project_id (project_id2) — FK — 외래 키 → 프로젝트.project_id — NOT NULL
  • title — NOT NULL
  • content — NULL
  • start_at — NOT NULL
  • end_at — NOT NULL
  • status — NOT NULL
  • created_at — NOT NULL
  • updated_at — NOT NULL

알림 (notifications)

  • notification_id — PK — 기본 키 — NOT NULL
  • user_id — PK — 외래 키 → 사용자.user_id — NOT NULL
  • type — NOT NULL
  • title — NOT NULL
  • message — NOT NULL
  • is_read — NOT NULL
  • created_at — NOT NULL

팀 (teams)

  • team_id (target_team_id) — PK — 기본 키 — NOT NULL
  • leader_id — FK
  • team_name — NOT NULL
  • description — NULL
  • created_at — NOT NULL
  • updated_at — NOT NULL

프로젝트 (projects)

  • project_id — PK — 기본 키 — NOT NULL
  • user_id — FK — 외래 키 → 사용자.user_id — NOT NULL
  • team_id (target_team_id) — FK — 외래 키 → 팀.team_id — NOT NULL
  • title — NOT NULL
  • description — NULL
  • tech_stack — NULL
  • github_url — NULL
  • demo_url — NULL
  • status — NOT NULL
  • created_at — NOT NULL
  • updated_at — NOT NULL