FormEnglish
Tables (36)
book_options
- id — INT — Primary key — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- originalPrice — DECIMAL(10,2) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- isBest — TINYINT — NOT NULL
- bookId — INT — Foreign key → books.id — NOT NULL
- optionType — ENUM('integrated_edition', 'textbook') — NOT NULL
- INDEX — `FK_cc80963ea33abfe0ee502bdc1df`
bookmarks
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → users.id — NOT NULL
- pageId — INT — Foreign key → pages.id — NOT NULL
- note — VARCHAR(255)
- createdAt — DATETIME(6) — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL
- INDEX — `FK_ec1427f3e1b8554a475eccdc915`
- INDEX — `FK_c6065536f2f6de3a0163e19a584`
books
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(255) — NOT NULL
- textbook_image — VARCHAR(255)
- workbook_image — VARCHAR(255)
- activation_status — ENUM('active', 'inactive') — NOT NULL
- sales_value — INT — NOT NULL
- brief_description — TEXT
- detailed_description — TEXT
- registration_date — DATETIME(6) — NOT NULL
cart_items
- id — INT — Primary key — NOT NULL
- cart_id — INT — Foreign key → carts.id — NOT NULL
- book_id — INT — Foreign key → books.id — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- book_option_id — INT — Foreign key → book_options.id — NOT NULL
- INDEX — `FK_6385a745d9e12a89b859bb25623`
- INDEX — `FK_1370b44aebf949937da90fc0ef6`
- INDEX — `FK_a25523db6e07783ee3343102834`
carts
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- subtotal — DECIMAL(10,2) — NOT NULL
- tax — DECIMAL(10,2) — NOT NULL
- discount — DECIMAL(10,2) — NOT NULL
- total — DECIMAL(10,2) — NOT NULL
- couponCode — VARCHAR(255)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_2ec1c94a977b940d85a4f498aea`
chapter_progress
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → users.id — NOT NULL
- ebookId — INT — Foreign key → ebooks.id — NOT NULL
- chapterName — VARCHAR(255) — NOT NULL
- totalPages — INT — NOT NULL
- currentPage — INT — NOT NULL
- progressPercentage — FLOAT — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL
- INDEX — `FK_a419ef3da2439a95c6a2028273b`
- INDEX — `FK_38051895bedaeb224badba9dcfd`
coupon_sent
- id — INT — Primary key — NOT NULL
- recipient_type — ENUM('all_members', 'regular_members', 'paid_members', 'free_members', 'corporate_members', 'individual') — NOT NULL
- userId — INT — Foreign key → users.id
- couponId — INT — Foreign key → coupons.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- notification — TEXT — NOT NULL
- recipients_count — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_09b6f844e72d8fc5addb7fd4b87`
- INDEX — `FK_bf7a044354bd54518079cf2809d`
coupons
- id — INT — Primary key — NOT NULL
- is_active — TINYINT — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- amount — INT — NOT NULL
- scope_of_application — ENUM('overall', 'ebook', 'subscription') — NOT NULL
- usage_period — TIMESTAMP — NOT NULL
- registration_date — DATETIME(6) — NOT NULL
dialogue_entity
- id — INT — Primary key — NOT NULL
- englishText — VARCHAR(255) — NOT NULL
- originalText — VARCHAR(255) — NOT NULL
- gender — ENUM('male', 'female') — NOT NULL
- sequence — INT — NOT NULL
- pageId — INT — Foreign key → pages.id — NOT NULL
- INDEX — `FK_7c180f9ff5fae316b0e3b11d9a3`
ebook_guides
- id — INT — Primary key — NOT NULL
- ebook_id — INT — Foreign key → ebooks.id — NOT NULL
- message — TEXT — NOT NULL
- audio — VARCHAR(255)
- subtitle — TEXT
- sample_count — TEXT
- bullet_points — TEXT
- conclusion — TEXT
- INDEX — `FK_a0459504c2b1c2543adb8240cc8`
ebooks
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- type — ENUM('textbook', 'workbook') — NOT NULL
- book_id — INT — Foreign key → books.id — NOT NULL
- INDEX — `FK_bf8a0109654d433865d2ecd0730`
faqs
- id — INT — Primary key — NOT NULL
- question — VARCHAR(255) — NOT NULL
- answer — TEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
guides
- id — INT — Primary key — NOT NULL
- phrase — VARCHAR(255) — NOT NULL
- context — TEXT
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
incorrect_answers
- id — INT — Primary key — NOT NULL
- userId — INT — NOT NULL
- pageId — INT — Foreign key → pages.id
- ebookId — INT — Foreign key → ebooks.id
- learningId — INT — Foreign key → learning.id
- question — VARCHAR(255) — NOT NULL
- userAnswer — VARCHAR(255) — NOT NULL
- correctAnswer — VARCHAR(255) — NOT NULL
- explanation — VARCHAR(255)
- createdAt — DATETIME(6) — NOT NULL
- isCompleted — TINYINT — NOT NULL
- completedAt — DATETIME
- INDEX — `FK_254672e77cc997b1dbe420b3459`
- INDEX — `FK_b209edcd63ed3f1b88af3cccab0`
- INDEX — `FK_58d96e20366bdaaa5fb22f56ef6`
introductions
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- video_link — VARCHAR(255) — NOT NULL
- is_active — TINYINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
learning
- id — INT — Primary key — NOT NULL
- topic — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- image — VARCHAR(255) — NOT NULL
- activation_status — ENUM('active', 'inactive') — NOT NULL
notification_pushed
- id — INT — Primary key — NOT NULL
- recipient_type — ENUM('all', 'regular', 'paid', 'free', 'corporate') — NOT NULL
- title — VARCHAR(30) — NOT NULL
- message — VARCHAR(100) — NOT NULL
- sent_count — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — TIMESTAMP
notification_settings
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- push_enabled — TINYINT — NOT NULL
- notification_days — TEXT
- notification_time — TIME
- updated_at — TIMESTAMP
notifications
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- message — VARCHAR(255) — NOT NULL
- is_read — TINYINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_9a8a82462cab47c73d25f49261f`
offline_content
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- content_type — ENUM('ebook', 'learning') — NOT NULL
- ebook_id — INT — Foreign key → ebooks.id
- learning_id — INT — Foreign key → learning.id
- size_mb — FLOAT — NOT NULL
- file_path — VARCHAR(255)
- synced_at — DATETIME(6) — NOT NULL
- last_accessed — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_a45cfccca3eda8df3e3d06615c9`
- INDEX — `FK_a67ee73e4546896e65f359ccbb1`
- INDEX — `FK_9ed3dc6adf7bf96780e48bdc631`
order_items
- id — INT — Primary key — NOT NULL
- order_id — INT — Foreign key → orders.id — NOT NULL
- book_id — INT — Foreign key → books.id
- price — DECIMAL(10,2) — NOT NULL
- type — ENUM('book', 'subscription') — NOT NULL
- subscription_id — INT — Foreign key → subscriptions.id
- INDEX — `FK_145532db85752b29c57d2b7b1f1`
- INDEX — `FK_baed643dd2210484ceac5ec81ea`
- INDEX — `FK_8618a9142c88e0e73ccecd690a8`
orders
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- total_amount — DECIMAL(10,2) — NOT NULL
- points_used — INT — NOT NULL
- status — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_a922b820eeef29ac1c6800e826a`
pages
- id — INT — Primary key — NOT NULL
- pageNumber — INT — NOT NULL
- contentType — ENUM('book', 'learning') — NOT NULL
- chapter — VARCHAR(255)
- topic — VARCHAR(255)
- type — ENUM('example', 'description', 'dialogue', 'title', 'full_sentence', 'speaking', 'sentence_arrangement') — NOT NULL
- exampleNumber — INT
- example — VARCHAR(255)
- meaning — VARCHAR(255)
- audio — VARCHAR(255)
- more — VARCHAR(255)
- phrasalVerb — VARCHAR(255)
- description — VARCHAR(255)
- ebookId — INT — Foreign key → ebooks.id
- learningId — INT — Foreign key → learning.id
- pronunciation_tips — VARCHAR(255)
- pronunciation_text — VARCHAR(255)
- pronunciation_audio — VARCHAR(255)
- INDEX — `FK_52af48647eef812b65ea15b432d`
- INDEX — `FK_83c98dfaff437267e48f98297d4`
payments
- id — INT — Primary key — NOT NULL
- order_id — INT — Foreign key → orders.id — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- method — VARCHAR(255) — NOT NULL
- status — ENUM('pending', 'completed', 'failed') — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_b2f7b823a21562eeca20e72b006`
point_sent
- id — INT — Primary key — NOT NULL
- recipient_type — ENUM('all_members', 'regular_members', 'paid_members', 'free_members', 'corporate_members', 'individual') — NOT NULL
- userId — INT — Foreign key → users.id
- amount — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- notification — TEXT — NOT NULL
- recipients_count — INT — NOT NULL
- dispatch_date — TIMESTAMP — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_e7c9d18ea45a233e13e3d7c7d85`
recently_viewed
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- content_type — ENUM('ebook', 'learning') — NOT NULL
- ebook_id — INT — Foreign key → ebooks.id
- learning_id — INT — Foreign key → learning.id
- viewed_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_13c5b56da6d00c32cb4c0764a0e`
- INDEX — `FK_05b7e0da5b0731e935058ff46f4`
- INDEX — `FK_106beef50d34dc24bc92a5661a6`
subscriptions
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- durationMonths — INT — NOT NULL
- originalPrice — DECIMAL(10,2) — NOT NULL
- discountedPrice — DECIMAL(10,2)
- isDefault — TINYINT — NOT NULL
- discountPercentage — DECIMAL(5,2)
- isActive — TINYINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
user_coupons
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → users.id — NOT NULL
- couponId — INT — Foreign key → coupons.id — NOT NULL
- is_used — TINYINT — NOT NULL
- used_at — TIMESTAMP
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_8c358ab3b82c503b6c1c30350bf`
- INDEX — `FK_136f241e87d0465785012ad3617`
user_ebook_settings
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → users.id — NOT NULL
- ebookId — INT — Foreign key → ebooks.id — NOT NULL
- soundEnabled — TINYINT — NOT NULL
- darkModeEnabled — TINYINT — NOT NULL
- fontSize — ENUM('very_small', 'small', 'medium', 'large', 'very_large')
- listeningTrainingEnabled — TINYINT
- speakingTrainingEnabled — TINYINT
- wordArrangementEnabled — TINYINT
- createdAt — TIMESTAMP(6) — NOT NULL
- updatedAt — TIMESTAMP(6) — NOT NULL
- INDEX — `FK_94fcfbb4c915bbaa196cf9ca46c`
- INDEX — `FK_8e0f886474a81cdc2bf8cfc7b51`
user_learning_progress
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- learning_id — INT — Foreign key → learning.id — NOT NULL
- current_page — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_59b678cf64af6e03985b48f839f`
- INDEX — `FK_2055270fcecc8e18a2b13f7f314`
user_learning_settings
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → users.id — NOT NULL
- learningId — INT — Foreign key → learning.id — NOT NULL
- soundEnabled — TINYINT — NOT NULL
- darkModeEnabled — TINYINT — NOT NULL
- listeningTrainingEnabled — TINYINT
- speakingTrainingEnabled — TINYINT
- wordArrangementEnabled — TINYINT
- createdAt — TIMESTAMP(6) — NOT NULL
- updatedAt — TIMESTAMP(6) — NOT NULL
- INDEX — `FK_dee9f3c8b918e6b7fcdd9fe1682`
- INDEX — `FK_983c1b7dad6e5302af4718e5a94`
user_learning_topic_progress
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- learning_id — INT — Foreign key → learning.id — NOT NULL
- topic — VARCHAR(255) — NOT NULL
- current_page — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — `FK_b0fc4c49e975ccbed992c4416c8`
- INDEX — `FK_1787080abb6b1a247ba220a4fee`
user_progress
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- ebook_id — INT — Foreign key → ebooks.id — NOT NULL
- current_page — INT — NOT NULL
- progress_percentage — INT — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
- INDEX — `FK_f2f91b2a5f57b846712a4f85082`
- INDEX — `FK_c41601eeb8415a9eb15c8a4e557`
user_textbook_settings
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → users.id — NOT NULL
- ebookId — INT — Foreign key → ebooks.id — NOT NULL
- soundEnabled — TINYINT — NOT NULL
- darkModeEnabled — TINYINT — NOT NULL
- fontSize — ENUM('very_small', 'small', 'medium', 'large', 'very_large') — NOT NULL
- createdAt — TIMESTAMP(6) — NOT NULL
- updatedAt — TIMESTAMP(6) — NOT NULL
- INDEX — `FK_3e7958fdb02a86743e721f29493`
- INDEX — `FK_31c2db02a882f9a950e23bbfa69`
users
- id — INT — Primary key — NOT NULL
- idAddress — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- role — ENUM('general', 'corporate', 'admin') — NOT NULL
- points — INT — NOT NULL
- registration_type — ENUM('kakao', 'google', 'apple', 'general') — NOT NULL
- member_type — ENUM('paid', 'free') — NOT NULL
- registration_date — DATETIME(6) — NOT NULL
- last_access — TIMESTAMP
- model — ENUM('ios', 'android')
- company — VARCHAR(255)
- grade — ENUM('boss', 'staff')
- metadata — TEXT
- isAgreedTerms — TINYINT
users_ebooks
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- ebook_id — INT — Foreign key → books.id
- purchased_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
- book_id — INT — NOT NULL
- INDEX — `FK_622bd0e96f7c34b85d004453bc0`
- INDEX — `FK_cadf16f40999fce426c5450de49`