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