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