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