lxp-second

Tables (11)

carts

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • created_at — DATETIME — NOT NULL

courses

  • id — BIGINT — Primary key — NOT NULL
  • instructor_id — BIGINT — Foreign key → instructor.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • price — INT — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

enrollments

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • enrolled_at — DATETIME — NOT NULL
  • expired_at — DATETIME
  • order_item_id — BIGINT — Foreign key → order_items.id — NOT NULL

instructor

  • id — BIGINT — Primary key — NOT NULL
  • introduction — TEXT — NOT NULL
  • expertise — VARCHAR(255) — NOT NULL
  • career — TEXT
  • image_url — VARCHAR(500)
  • contact — VARCHAR(100)
  • portfolio_url — VARCHAR(500)
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL

lectures

  • id — BIGINT — Primary key — NOT NULL
  • section_id — BIGINT — Foreign key → sections.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content_url — VARCHAR(500)
  • video_url — VARCHAR(500)
  • duration_sec — INT
  • sort_order — INT — NOT NULL
  • is_preview — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

members

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(30)
  • role — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

missions

  • id — BIGINT — Primary key — NOT NULL
  • section_id — BIGINT — Foreign key → sections.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

order_items

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • course_title_snapshot — VARCHAR(200) — NOT NULL
  • instructor_name_snapshot — VARCHAR(100) — NOT NULL
  • course_price_snapshot — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

orders

  • id — BIGINT — Primary key — NOT NULL
  • order_no — VARCHAR(100) — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • total_amount — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

payments

  • id — BIGINT — Primary key — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • payment_key — VARCHAR(255)
  • requested_amount — INT — NOT NULL
  • approved_amount — INT
  • status — VARCHAR(30) — NOT NULL
  • approved_at — DATETIME
  • failed_reason — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL

sections

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL