majubom
Tables (5)
gatherings (모임)
- id (모임 식별자) — BIG INT — Primary key — NOT NULL
- title (제목) — VARCHAR(200) — NOT NULL
- scheduled_date (예정일) — DATE — NOT NULL — 년.월.일
- progress (진행 상태) — VARCHAR(10) — NOT NULL — ONGOING, FINISHED
- invite_code (초대 코드) — VARCHAR(10)
- status (상태) — VARCHAR(16) — NOT NULL — ACTIVE, INACTIVE
- created_at (생성일) — TIMESTAMP — NOT NULL
- updated_at (수정일) — TIMESTAMP — NOT NULL
matchings (매칭)
- id (매칭 식별자) — BIG INT — Primary key — NOT NULL
- gathering_id (모임 식별자) — BIG INT — Foreign key → gatherings.id — NOT NULL
- participant1_id (참가자 1 식별자) — BIG INT — Foreign key → participants.id — NOT NULL — 매칭된 멤버 1
- participant2_id (참가자 2 식별자) — BIG INT — Foreign key → participants.id — NOT NULL — 매칭된 멤버 2
- status (상태) — VARCHAR(16) — NOT NULL — ACTIVE, INACTIVE
- created_at (생성일) — TIMESTAMP — NOT NULL
- updated_at (수정일) — TIMESTAMP — NOT NULL
participants (참가자)
- id (모임 멤버 식별자) — BIG INT — Primary key — NOT NULL
- gathering_id (참여 모임 식별자) — BIG INT — Foreign key → gatherings.id — NOT NULL
- user_id (참여 유저 식별자) — BIG INT — Foreign key → users.id — NOT NULL
- role (유저 역할) — VARCHAR(20) — NOT NULL — HOST, PARTICIPANT
- participation_state (참여 상태) — VARCHAR(20) — NOT NULL — JOINED, LEFT_VOLUNTARILY, KICKED
- status (상태) — VARCHAR(16) — NOT NULL — ACTIVE, INACTIVE
- created_at (생성일) — TIMESTAMP — NOT NULL
- updated_at (수정일) — TIMESTAMP — NOT NULL
preference (선호도)
- id (선호도 식별자) — BIG INT — Primary key — NOT NULL
- chooser_participant_id (선택하는 참가자 식별자) — BIG INT — Foreign key → participants.id — NOT NULL
- chosen_participant_id (선택받은 참가자 식별자) — BIG INT — Foreign key → participants.id — NOT NULL
- is_liked (호불호) — BOOLEAN — 호(true) / 불호(false)
- message (메시지) — VARCHAR(500) — 호 선택 시 남기는 메시지
- status (상태) — VARCHAR(16) — NOT NULL — ACTIVE, INACTIVE
- created_at (생성일) — TIMESTAMP — NOT NULL
- updated_at (수정일) — TIMESTAMP — NOT NULL
users (사용자)
- id (사용자 식별자) — BIG INT — Primary key — NOT NULL
- name (이름) — VARCHAR(30) — NOT NULL
- nickname (닉네임) — VARCHAR(30) — NOT NULL
- gender (성별) — VARCHAR(10) — NOT NULL — MALE, FEMALE, PRIVATE
- email (이메일) — VARCHAR(255) — NOT NULL
- password (비밀번호) — VARCHAR(100) — NOT NULL
- status (상태) — VARCHAR(16) — NOT NULL — ACTIVE, INACTIVE
- created_at (생성일) — TIMESTAMP — NOT NULL
- updated_at (수정일) — TIMESTAMP — NOT NULL