sentic0719

Tables (10)

announcements

  • announcement_id — bigint — Primary key — NOT NULL
  • admin_id — bigint — Foreign key → users.user_id — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • is_pinned — tinyint(1) — NOT NULL
  • is_deleted — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

faqs

  • faq_id — bigint — Primary key — NOT NULL
  • question — varchar(255) — NOT NULL
  • answer — text — NOT NULL
  • order_num — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

feedbacks

  • feedback_id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → rooms.room_id — NOT NULL
  • message_id — bigint — Foreign key → messages.message_id
  • word_errors — json
  • grammar_errors — json
  • expression_errors — json
  • perfect_sentence — text
  • created_at — datetime — NOT NULL

messages

  • message_id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → rooms.room_id — NOT NULL
  • sender_type — enum('USER','AI') — NOT NULL
  • content_text — text
  • audio_url — varchar(500)
  • sequence_no — int — NOT NULL
  • created_at — datetime — NOT NULL

payments

  • payment_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • plan_id — int — Foreign key → subscription_plans.plan_id — NOT NULL
  • amount — int — NOT NULL
  • status — enum('PENDING','SUCCESS','FAILED','CANCELLED') — NOT NULL
  • payment_method — varchar(50)
  • external_payment_id — varchar(200)
  • paid_at — datetime
  • expires_at — datetime
  • created_at — datetime — NOT NULL

rooms

  • room_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • room_type — enum('VOICE','CHAT') — NOT NULL
  • room_name — varchar(100)
  • characters — json
  • memory_bank — json
  • participant_count — int
  • situation — text
  • difficulty — enum('BEGINNER','INTERMEDIATE','ADVANCED') — NOT NULL
  • is_random — tinyint(1) — NOT NULL
  • last_active_at — datetime
  • is_deleted — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

scraps

  • scrap_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • feedback_id — bigint — Foreign key → feedbacks.feedback_id
  • expression — varchar(500) — NOT NULL
  • context — text
  • category — enum('WORD','GRAMMAR','EXPRESSION')
  • user_note — text
  • created_at — datetime — NOT NULL

subscription_plans

  • plan_id — int — Primary key — NOT NULL
  • plan_name — varchar(50) — NOT NULL
  • price — int — NOT NULL
  • duration_days — int — NOT NULL
  • room_limit — int
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL

user_settings

  • setting_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • default_mode — enum('VOICE','CHAT') — NOT NULL
  • default_difficulty — enum('BEGINNER','INTERMEDIATE','ADVANCED') — NOT NULL
  • subtitle_enabled — tinyint(1) — NOT NULL
  • notification_enabled — tinyint(1) — NOT NULL
  • weekly_study_time — int
  • daily_avg_time — int
  • streak_days — int
  • last_studied_at — datetime
  • session_started_at — datetime
  • updated_at — datetime — NOT NULL

users

  • user_id — bigint — Primary key — NOT NULL
  • email — varchar(100)
  • password — varchar(255)
  • nickname — varchar(50) — NOT NULL
  • profile_image — varchar(500)
  • provider — enum('LOCAL','KAKAO','GOOGLE') — NOT NULL
  • provider_id — varchar(255)
  • role — enum('USER','ADMIN') — NOT NULL
  • status — enum('ACTIVE','INACTIVE','BANNED') — NOT NULL
  • email_verified — tinyint(1) — NOT NULL
  • login_id — varchar(50) — NOT NULL
  • deleted_at — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL