0507

Tables (5)

cancel_record

  • id — BIGINT
  • sale_record_id — VARCHAR(50) — Foreign key → sale_record.id — NOT NULL
  • refund_amount — DECIMAL(15,2) — NOT NULL
  • cancelled_at — DATETIME — NOT NULL
  • reason — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_cancel_cancelled_at
  • INDEX — idx_cancel_sale

commission_rate

  • id — BIGINT
  • rate — DECIMAL(5,4) — NOT NULL
  • effective_from — DATETIME — NOT NULL
  • effective_to — DATETIME
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_rate_period

course

  • id — VARCHAR(50)
  • creator_id — VARCHAR(50) — Foreign key → creator.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

creator

  • id — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

sale_record

  • id — VARCHAR(50)
  • course_id — VARCHAR(50) — Foreign key → course.id — NOT NULL
  • student_id — VARCHAR(50) — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • paid_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_sale_paid_at
  • INDEX — idx_sale_course