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