MOMO_City ver3.5 (public)
Tables (25)
access_log
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id
- ip — VARCHAR(45) — NOT NULL
- action — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
building
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- category — ENUM('FITNESS','STUDY','COOK','BEAUTY','ART') — NOT NULL
- position — INT — NOT NULL
- level — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
calendar
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- start — DATE — NOT NULL
- title — VARCHAR(255) — NOT NULL
- end — DATE
- category — ENUM('MEMO','TODO') — NOT NULL
- is_completed — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
chapter
- id — BIGINT — Primary key — NOT NULL
- lecture_id — BIGINT — Foreign key → lecture.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- order_no — INT — NOT NULL
- video_url — VARCHAR(500)
- video_size_bytes — BIGINT
- duration_sec — INT
- video_status — ENUM('UPLOADING','ENCODING','READY','FAILED') — NOT NULL
- original_filename — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
chat_room
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
chat_room_member
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → chat_room.id — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- joined_at — DATETIME — NOT NULL
comment
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.id — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- parent_id — BIGINT — Foreign key → comment.id
- content — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
enrollment
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- lecture_id — BIGINT — Foreign key → lecture.id — NOT NULL
- total_progress — INT — NOT NULL
- completed_count — INT — NOT NULL
- enrolled_at — DATETIME — NOT NULL
friend
- id — BIGINT — Primary key — NOT NULL
- from_user_id — BIGINT — Foreign key → user.id — NOT NULL
- to_user_id — BIGINT — Foreign key → user.id — NOT NULL
- status — ENUM('SENT','FRIEND','BLOCK') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
guestbook
- id — BIGINT — Primary key — NOT NULL
- writer_id — BIGINT — Foreign key → user.id — NOT NULL
- owner_id — BIGINT — Foreign key → user.id — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
inquiry
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- answer — TEXT
- status — ENUM('WAITING','ANSWERED','CLOSED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- answered_at — DATETIME
learning_history
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- lecture_id — BIGINT — Foreign key → lecture.id — NOT NULL
- chapter_id — BIGINT — Foreign key → chapter.id — NOT NULL
- watched_seconds — INT — NOT NULL
- is_completed — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- last_position_sec — INT — NOT NULL
- progress_rate — INT — NOT NULL
lecture
- id — BIGINT — Primary key — NOT NULL
- teacher_id — BIGINT — Foreign key → user.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- thumbnail_url — VARCHAR(500)
- category — ENUM('FITNESS','STUDY','COOK','BEAUTY','ART') — NOT NULL
- status — ENUM('WAITING','ACTIVE','HOLD','DELETED') — NOT NULL
- completed_user_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- FULLTEXT — KEY
message
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → chat_room.id — NOT NULL
- sender_id — BIGINT — Foreign key → user.id — NOT NULL
- content — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notification
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- type — ENUM('NOTICE','APPROVAL','REPORT','FRIEND_REQUEST','MESSAGE','GUESTBOOK','ENROLLMENT') — NOT NULL
- ref_id — BIGINT
- message — VARCHAR(500)
- created_at — DATETIME — NOT NULL
payment
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- amount — INT — NOT NULL
- method — ENUM('KAKAO','TOSS','CARD','FREE') — NOT NULL
- paid_at — DATETIME — NOT NULL
post
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- type — ENUM('NOTICE','FREE','QNA') — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- is_pinned — BOOLEAN — NOT NULL
- view_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- FULLTEXT — KEY
post_image
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- order_no — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
refresh_token
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- token — VARCHAR(255) — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
report
- id — BIGINT — Primary key — NOT NULL
- reporter_user_id — BIGINT — Foreign key → user.id — NOT NULL
- target_type — ENUM('POST','COMMENT','USER','LECTURE') — NOT NULL
- target_id — BIGINT — NOT NULL
- reason — ENUM('SPAM','ABUSE','INAPPROPRIATE','ETC') — NOT NULL
- detail — VARCHAR(1000)
- status — ENUM('PENDING','REVIEWED','RESOLVED','REJECTED') — NOT NULL
- reported_at — DATETIME — NOT NULL
- handled_at — DATETIME
- handler_admin_id — BIGINT — Foreign key → user.id
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
review
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- lecture_id — BIGINT — Foreign key → lecture.id — NOT NULL
- rating — TINYINT — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
streak
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- chapter_id — BIGINT — Foreign key → chapter.id — NOT NULL
- streak_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
user
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100)
- password — VARCHAR(255)
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- birth — DATE
- profile_image_url — VARCHAR(500)
- role — ENUM('STUDENT','TEACHER','ADMIN') — NOT NULL
- status — ENUM('ACTIVE','PENDING','REJECTED','BANNED','BLACK','DELETED') — NOT NULL
- category — ENUM('FITNESS','STUDY','COOK','BEAUTY','ART')
- proof — VARCHAR(500)
- point — INT — NOT NULL
- is_paid — BOOLEAN — NOT NULL
- do_not_disturb — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- is_tempPWD — BOOLEAN — NOT NULL
user_oauth
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- provider — ENUM('LOCAL','KAKAO','GOOGLE') — NOT NULL
- provider_id — VARCHAR(100)
- created_at — DATETIME — NOT NULL
verification_code
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id
- email — VARCHAR(100) — NOT NULL
- code — VARCHAR(10) — NOT NULL
- purpose — ENUM('SIGNUP','PASSWORD_RESET','EMAIL_CHANGE') — NOT NULL
- expires_at — DATETIME — NOT NULL
- used — BOOLEAN — NOT NULL