creator-settlement

Tables (7)

Cancel (취소/환불)

  • id (취소 id) — VARCHAR(255) — Primary key — NOT NULL — cancel-1
  • sale_record_id (판매 내역 id) — VARCHAR(255) — Foreign key → SaleRecord.id — NOT NULL
  • amout (환불 금액) — DECIMAL(10,2) — NOT NULL
  • canceled_at (취소 일시) — DATETIME — NOT NULL

CommissionRate (수수료율)

  • id (수수료율 id) — VARCHAR(255) — Primary key — NOT NULL — commission-1
  • rate (수수료율) — DECIMAL(5,2) — NOT NULL
  • applied_from (적용 시작 일시) — DATETIME — NOT NULL
  • applied_to (적용 종료 일시) — DATETIME — NULL = 적용 중

Course (강의)

  • id (강의 id) — VARCHAR(255) — Primary key — NOT NULL — course-1
  • title (강의명) — VARCHAR(255) — NOT NULL
  • creator_id (내부 크리에이터 id) — BIGINT — Foreign key → Creator.id — NOT NULL

Creator (크리에이터)

  • id (크리에이터 id) — VARCHAR(255) — Primary key — NOT NULL — creator-1
  • name (크리에이터 이름) — VARCHAR(255) — NOT NULL

SaleRecord (판매 내역)

  • id (판매 내역 id) — VARCHAR(255) — Primary key — NOT NULL — sale-1
  • course_id (내부 강의 id) — BIGINT — Foreign key → Course.id — NOT NULL
  • student_id (내부 수강생 id) — BIGINT — Foreign key → Student.id — NOT NULL
  • amount (결제 금액) — DECIMAL(10,2) — NOT NULL
  • paid_at (결제 일시) — DATETIME — NOT NULL

Settlement (정산)

  • id (정산 id) — VARCHAR(255) — Primary key — NOT NULL — settlement-1
  • creator_id (내부 크리에이터 id) — BIGINT — Foreign key → Creator.id — NOT NULL
  • settlementMonth (정산 연월) — DATE — NOT NULL — yyyy-MM-01
  • status (정산 상태) — ENUM('PENDING','CONFIRMED','PAID') — NOT NULL
  • total_sale_amount (총 판매 금액) — DECIMAL(10,2) — NOT NULL
  • total_cancel_amount (총 취소 금액) — DECIMAL(10,2) — NOT NULL
  • net_sale_amount (순 판매 금액) — DECIMAL(10,2) — NOT NULL
  • commission (수수료) — DECIMAL(10,2) — NOT NULL
  • total_settlement_amount (정산 예정 금액) — DECIMAL(10,2) — NOT NULL
  • sale_count (판매 건수) — INT — NOT NULL
  • cancel_count (취소 건수) — INT — NOT NULL
  • commission_rate_id (수수료율 id) — BIGINT — Foreign key → CommissionRate.id — NOT NULL

Student (수강생)

  • id (수강생 id) — VARCHAR(255) — Primary key — NOT NULL — student-1