Devmountain-test

Tables (9)

Category

  • category_id — BIGINT
  • category_name — VARCHAR(255)

ChatMessage

  • chat_id — BIGINT
  • chatroom_id — BIGINT
  • user_id — BIGINT
  • message — TEXT
  • is_ai_response — BOOLEAN
  • created_at — DATETIME

ChatRoom

  • chatroom_id — BIGINT
  • user_id — BIGINT
  • room_type — ENUM('DEFAULT', 'PREMIUM')
  • created_at — DATETIME

Lecture

  • lecture_id — BIGINT
  • title — VARCHAR(255)
  • summary — TEXT
  • instructor — VARCHAR(255)
  • price — INTEGER
  • image_url — VARCHAR(255)
  • category_id — BIGINT

Order

  • order_id — BIGINT
  • user_id — BIGINT
  • price — INTEGER
  • status — ENUM('PENDING', 'PAID', 'FAILED')
  • created_at — DATETIME
  • updated_at — DATETIME

Payment

  • payment_id — BIGINT
  • order_id — BIGINT
  • payment_key — VARCHAR(255)
  • method — ENUM('CARD', 'KAKAO', 'TOSS')
  • result — ENUM('SUCCESS', 'FAIL')
  • membership_level_changed_to — ENUM('FREE', 'PRO')
  • created_at — DATETIME

Recommendation

  • recommend_id — BIGINT
  • chat_id — BIGINT
  • user_id — BIGINT
  • lecture_id — BIGINT
  • score — FLOAT
  • created_at — DATETIME

User

  • user_id — BIGINT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(255)
  • login_type — ENUM('EMAIL', 'GOOGLE', 'KAKAO')
  • membership_level — ENUM('FREE', 'PRO')
  • created_at — DATETIME
  • updated_at — DATETIME

UserCategory

  • user_category_id — BIGINT
  • user_id — BIGINT
  • category_id — BIGINT