moduplan

Tables (5)

group_applications (참여 신청)

  • id (참여 신청 ID) — BIGINT — Primary key — NOT NULL
  • group_id (모임 ID) — BIGINT — Foreign key → meeting_groups.id — NOT NULL
  • user_id (신청 회원 ID) — BIGINT — Foreign key → users.id — NOT NULL
  • status (신청 상태) — VARCHAR(20) — NOT NULL
  • created_at (신청 일시) — DATETIME — NOT NULL
  • processed_at (처리 일시) — DATETIME

group_members (그룹 멤버)

  • id (그룹 멤버 ID) — BIGINT — Primary key — NOT NULL
  • group_id (모임 ID) — BIGINT — Foreign key → meeting_groups.id — NOT NULL
  • user_id (회원 ID) — BIGINT — Foreign key → users.id — NOT NULL
  • role (역할) — VARCHAR(20) — NOT NULL
  • joined_at (참여일시) — DATETIME — NOT NULL

meeting_groups (모임)

  • id (모임 ID) — BIGINT — Primary key — NOT NULL
  • leader_id (모임장 ID) — BIGINT — Foreign key → users.id — NOT NULL
  • name (모임명) — VARCHAR(100) — NOT NULL
  • description (모임 설명) — TEXT — NOT NULL
  • category (카테고리) — VARCHAR(50) — NOT NULL
  • max_members (최대인원) — INT — NOT NULL
  • region (지역) — VARCHAR(100) — NOT NULL
  • is_public (공개 여부) — BOOLEAN — NOT NULL
  • status (모임 상태) — VARCHAR(20) — NOT NULL
  • created_at (생성일시) — DATETIME — NOT NULL
  • updated_at (수정일시) — DATETIME — NOT NULL
  • deleted_at (삭제일시) — DATETIME

schedules (일정)

  • id (일정 ID) — BIGINT — Primary key — NOT NULL
  • group_id (모임 ID) — BIGINT — Foreign key → meeting_groups.id — NOT NULL
  • created_by (생성자 ID) — BIGINT — Foreign key → users.id — NOT NULL
  • title (일정 제목) — VARCHAR(100) — NOT NULL
  • description (일정 설명) — TEXT
  • scheduled_at (일정 일시) — DATETIME — NOT NULL
  • location (장소) — VARCHAR(200)
  • created_at (생성 일시) — DATETIME — NOT NULL
  • updated_at (수정 일시) — DATETIME — NOT NULL

users (유저)

  • id (회원 ID) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • nickname (닉네임) — VARCHAR(50) — NOT NULL
  • status (회원 상태) — VARCHAR(20) — NOT NULL
  • created_at (생성일시) — DATETIME — NOT NULL
  • updated_at (수정일시) — DATETIME — NOT NULL
  • deleted_at (삭제일시) — DATETIME
  • provider (로그인 제공자) — VARCHAR(20)
  • provider_id (oauth 고유 ID) — VARCHAR(100)