liveclass_backend

Tables (5)

course (강의 정보)

  • course_id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • title (Field) — VARCHAR(200)
  • creator_id (Key2) — VARCHAR(50) — Foreign key → creator.creator_id — NOT NULL

creator (크리에이터)

  • creator_id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)

refund_record (취소/환불 내역)

  • refund_record_id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • refund_amount (Field) — BIGINT
  • cacelled_at (Field2) — DATETIME
  • Field3
  • sale_record_id (Key2) — VARCHAR(50) — Foreign key → sale_record.sale_record_id — NOT NULL

sale_record (판매 내역)

  • sale_record_id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • student_id (Field) — VARCHAR(50)
  • amount (Field2) — BIGINT
  • paid_at (Field3) — DATETIME
  • Field4
  • course_id (Key2) — VARCHAR(50) — Foreign key → course.course_id — NOT NULL

settlement (정산상태)

  • settlement_id (Key) — BIGINT — Primary key — NOT NULL
  • settlement_month (Field) — CHAR(7)
  • creator_id (Key2) — VARCHAR(50) — Foreign key → creator.creator_id — NOT NULL
  • total_sales_amount (Field2) — BIGINT
  • total_refund_amount (Field3) — BIGINT
  • net_sales_amount (Field4) — BIGINT
  • platform_fee_amount (Field5) — BIGINT
  • payout_amount (Field6) — BIGINT
  • sale_count (Field7) — INT
  • refund_count (Field8) — INT
  • fee_rate (Field9) — DECIMAL(5,2)
  • status (Field10) — VARCHAR(20)
  • created_at (Field11) — DATETIME
  • confirmed_at (Field12) — DATETIME
  • paid_at (Field13) — DATETIME