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