find people

Tables (4)

Board (게시글)

  • id (게시판 ID) — Primary key — NOT NULL
  • title (제목) — NOT NULL
  • content (게시판 내용) — NOT NULL
  • state (상태) — NOT NULL
  • created_at (작성일시) — NOT NULL
  • end_date (마감일시) — NOT NULL
  • number (모집인원수) — NOT NULL
  • category (카테고리) — Foreign key → Category.category_id — NOT NULL
  • writer (사용자) — Foreign key → User.uid — NOT NULL

Category (카테고리)

  • category_id (카테고리 ID) — Primary key — NOT NULL
  • name (카테고리명) — NOT NULL

Participant (참여자)

  • id (참여자 ID) — Primary key — NOT NULL
  • board_id (게시판 ID) — Foreign key → Board.id — NOT NULL
  • user (사용자) — Foreign key → User.uid — NOT NULL

User (회원)

  • uid (사용자 ID) — Primary key — NOT NULL
  • email (이메일) — NOT NULL
  • state (상태) — NOT NULL
  • name (이름) — NOT NULL
  • age (나이)
  • gender (성별)
  • created_at (가입일시) — NOT NULL