스터디 모집 게시판

테이블 (3)

Untitled (Study)

  • Key (studyId) — Int — 기본 키 — NOT NULL
  • id (userId) — Int — 외래 키 → User.id — NOT NULL
  • Field (title) — String
  • Field (description) — String
  • Field (category) — String
  • Field (region) — String
  • Field (maxMembers) — Int
  • Field (deadline) — Date
  • Field (createdAt) — Datetime
  • Field (updatedAt) — Datetime
  • Field (status) — String

Untitled (Apply)

  • Key (applyId) — Int — 기본 키 — NOT NULL
  • Key (studyId) — Int — 외래 키 → Untitled.Key — NOT NULL
  • id (userId) — Int — 외래 키 → Untitled.id — NOT NULL
  • Field (message) — String
  • Field (createdAt) — Datetime
  • Field (updatedAt) — Datetime
  • Field (status) — String

User

  • id (userId) — Int — 기본 키 — NOT NULL
  • Field (email) — String
  • Field (password) — JWT
  • Field (name) — String