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)