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