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