USE lifanghe_education;

DELETE FROM redemption_orders WHERE user_id IN ('parent_001', 'parent_002', 'parent_003');
DELETE FROM appointments WHERE user_id IN ('parent_001', 'parent_002', 'parent_003');
DELETE FROM referrals WHERE id IN ('rel_001', 'rel_002', 'rel_003');
DELETE FROM point_expiry_schedules WHERE id IN ('exp_001', 'exp_002', 'exp_003');
DELETE FROM point_transactions WHERE id IN ('pt_001', 'pt_002', 'pt_003', 'pt_004', 'pt_005');
DELETE FROM point_accounts WHERE user_id IN ('parent_001', 'parent_002', 'parent_003');
DELETE FROM leads WHERE id IN ('lead_001', 'lead_002', 'lead_003', 'lead_004', 'lead_005');
DELETE FROM courses WHERE id IN ('course_001', 'course_002', 'course_003', 'course_004');
DELETE FROM channel_stats WHERE channel IN ('朋友圈海报', '微信好友', 'H5链接', '顾问二维码');
DELETE FROM users WHERE id IN ('parent_001', 'parent_002', 'parent_003', 'campus_001', 'advisor_001', 'teacher_001', 'finance_001');