creator-settlement

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

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

settlement

  • id — BIGINT
  • creator_id — VARCHAR(50) — Foreign key → creator.id — NOT NULL
  • settlement_year_month — VARCHAR(7) — NOT NULL
  • total_sales — DECIMAL(15, 2) — NOT NULL
  • total_refunds — DECIMAL(15, 2) — NOT NULL
  • net_sales — DECIMAL(15, 2) — NOT NULL
  • fee_rate — DECIMAL(5, 2) — NOT NULL
  • fee_amount — DECIMAL(15, 2) — NOT NULL
  • settlement_amount — DECIMAL(15, 2) — NOT NULL
  • sale_count — INT — NOT NULL
  • cancel_count — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL