MOIMLOG

Tables (23)

admin_actions

  • id — VARCHAR(36) — Primary key
  • admin_id — VARCHAR(36) — Foreign key → users.id
  • action_type — ENUM('user_ban', 'user_unban', 'moim_suspend', 'moim_restore', 'post_delete', 'comment_delete') — NOT NULL
  • target_id — VARCHAR(36)
  • target_type — VARCHAR(50)
  • reason — TEXT
  • created_at — TIMESTAMP

chat_messages

  • id — VARCHAR(36) — Primary key
  • sender_id — VARCHAR(36) — Foreign key → users.id
  • moim_id — VARCHAR(36) — NOT NULL
  • message — TEXT — NOT NULL
  • message_type — ENUM('text', 'image', 'file', 'system')
  • file_url — VARCHAR(500)
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP

chat_read_status

  • id — VARCHAR(36)
  • moim_id — VARCHAR(36) — NOT NULL
  • user_id — VARCHAR(36) — NOT NULL
  • last_read_message_id — VARCHAR(36)
  • last_read_at — TIMESTAMP

comment_likes

  • id — VARCHAR(36)
  • comment_id — VARCHAR(36) — NOT NULL
  • user_id — VARCHAR(36) — NOT NULL
  • created_at — TIMESTAMP

comments

  • id — VARCHAR(36)
  • post_id — VARCHAR(36) — NOT NULL
  • author_id — VARCHAR(36) — NOT NULL
  • parent_id — VARCHAR(36)
  • content — TEXT — NOT NULL
  • is_anonymous — BOOLEAN
  • like_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

file_uploads

  • id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • moim_id — VARCHAR(36)
  • post_id — VARCHAR(36)
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • file_size — INT — NOT NULL
  • file_type — VARCHAR(100) — NOT NULL
  • mime_type — VARCHAR(100)
  • upload_type — ENUM('profile', 'moim_thumbnail', 'post_image', 'chat_file') — NOT NULL
  • created_at — TIMESTAMP

moim_categories

  • id — VARCHAR(36)
  • name — VARCHAR(50) — NOT NULL
  • label — VARCHAR(100) — NOT NULL
  • description — TEXT
  • icon — VARCHAR(50)
  • color — VARCHAR(7)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

moim_members

  • id — VARCHAR(36) — Primary key
  • moim_id — VARCHAR(36) — Foreign key → users.id
  • user_id — VARCHAR(36) — NOT NULL
  • role — ENUM('admin', 'moderator', 'member')
  • status — ENUM('active', 'pending', 'banned')
  • joined_at — TIMESTAMP
  • last_active_at — TIMESTAMP

moim_settings

  • id — VARCHAR(36)
  • moim_id — VARCHAR(36) — NOT NULL
  • allow_anonymous_posts — BOOLEAN
  • require_approval_for_posts — BOOLEAN
  • notification_new_message — BOOLEAN
  • notification_new_post — BOOLEAN
  • notification_new_event — BOOLEAN
  • notification_member_join — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

moims

  • id — VARCHAR(36)
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • category_id — VARCHAR(36)
  • tags — JSON
  • thumbnail — VARCHAR(500)
  • max_members — INT
  • current_members — INT
  • is_private — BOOLEAN
  • is_active — BOOLEAN
  • online_type — ENUM('online', 'offline', 'hybrid')
  • location — VARCHAR(500)
  • location_detail — TEXT
  • created_by — VARCHAR(36) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

notifications

  • id — VARCHAR(36) — Primary key
  • user_id — VARCHAR(36) — Foreign key → users.id
  • type — ENUM('schedule_reminder', 'new_post', 'new_comment', 'moim_update', 'system') — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • message — TEXT — NOT NULL
  • related_id — VARCHAR(36)
  • related_type — VARCHAR(50)
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

post_images

  • id — VARCHAR(36)
  • post_id — VARCHAR(36) — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • image_order — INT
  • created_at — TIMESTAMP

post_likes

  • id — VARCHAR(36)
  • post_id — VARCHAR(36) — NOT NULL
  • user_id — VARCHAR(36) — NOT NULL
  • created_at — TIMESTAMP

posts

  • id — VARCHAR(36)
  • moim_id — VARCHAR(36) — NOT NULL
  • author_id — VARCHAR(36) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • type — ENUM('notice', 'free', 'photo', 'event')
  • is_pinned — BOOLEAN
  • is_anonymous — BOOLEAN
  • view_count — INT
  • like_count — INT
  • comment_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

reports

  • id — VARCHAR(36)
  • reporter_id — VARCHAR(36) — NOT NULL
  • reported_user_id — VARCHAR(36)
  • reported_moim_id — VARCHAR(36)
  • reported_post_id — VARCHAR(36)
  • reported_comment_id — VARCHAR(36)
  • report_type — ENUM('user', 'moim', 'post', 'comment') — NOT NULL
  • reason — ENUM('spam', 'inappropriate', 'harassment', 'violence', 'other') — NOT NULL
  • description — TEXT
  • status — ENUM('pending', 'investigating', 'resolved', 'dismissed')
  • admin_notes — TEXT
  • resolved_by — VARCHAR(36)
  • resolved_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

roles

  • id — VARCHAR(36) — Primary key
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • permissions — JSON
  • created_at — TIMESTAMP

schedule_participants

  • id — VARCHAR(36)
  • schedule_id — VARCHAR(36) — NOT NULL
  • user_id — VARCHAR(36) — NOT NULL
  • status — ENUM('attending', 'not_attending', 'maybe', 'pending')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

schedules

  • id — VARCHAR(36)
  • moim_id — VARCHAR(36) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME
  • location — VARCHAR(500)
  • location_detail — TEXT
  • max_attendees — INT
  • type — ENUM('meeting', 'task', 'deadline', 'event')
  • is_recurring — BOOLEAN
  • recurrence_rule — VARCHAR(200)
  • created_by — VARCHAR(36) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

social_logins

  • id — VARCHAR(36) — Primary key
  • user_id — VARCHAR(36) — Foreign key → users.id
  • provider — ENUM('google', 'kakao', 'naver') — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • access_token — VARCHAR(500)
  • refresh_token — VARCHAR(500)
  • expires_at — TIMESTAMP
  • created_at — TIMESTAMP

user_activity_logs

  • id — VARCHAR(36) — Primary key
  • user_id — VARCHAR(36) — Foreign key → users.id
  • moim_id — VARCHAR(36)
  • activity_type — ENUM('login', 'logout', 'moim_join', 'moim_leave', 'post_create', 'comment_create', 'schedule_create', 'file_upload') — NOT NULL
  • activity_data — JSON
  • ip_address — VARCHAR(45)
  • user_agent — TEXT
  • created_at — TIMESTAMP

user_favorites

  • id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • moim_id — VARCHAR(36) — NOT NULL
  • created_at — TIMESTAMP

user_roles

  • id — VARCHAR(36) — Primary key
  • user_id — VARCHAR(36) — Foreign key → users.id
  • role_id — VARCHAR(36) — Foreign key → roles.id
  • created_at — TIMESTAMP

users

  • id — VARCHAR(36) — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50)
  • profile_image — VARCHAR(500)
  • bio — TEXT
  • phone — VARCHAR(20)
  • birth_date — DATE
  • gender — ENUM('male', 'female', 'other')
  • is_active — BOOLEAN
  • is_verified — BOOLEAN
  • last_login_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP