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`