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