데이터 이관 확인 - 전 도메인

-- 현행→신규 1:1 추적(migration_map)으로 집계
SELECT count(*) FROM migration_map
WHERE target_table = 'products';

SELECT count(*) FROM products;

-- 현행 _kte_attributes(직렬화) 역직렬화한
--  '옵션 축' 수 (표본 5상품)

SELECT count(*) FROM option_groups;

-- 현행 _kte_attributes 내 옵션 항목 수

SELECT count(*) FROM option_items;

SELECT count(*) FROM migration_map
WHERE target_table = 'price_rules';   -- 현행 kte_variation ↔ 신규 price_rules

SELECT count(*) FROM price_rules;

SELECT count(*) FROM migration_map
WHERE target_table = 'orders';

SELECT count(*) FROM orders;

-- 이관 주문의 라인아이템 + 수수료(fee)
SELECT count(*) FROM wp_woocommerce_order_items
WHERE order_item_type IN ('line_item','fee')
  AND order_id IN (이관된 주문 id들);

SELECT count(*) FROM order_items;

-- 현행 주문 환불 레코드 (표본)

SELECT count(*) FROM order_refunds;

SELECT count(*) FROM migration_map
WHERE target_table = 'users';

SELECT count(*) FROM users;

SELECT count(*) FROM migration_map
WHERE target_table = 'partners';

SELECT count(*) FROM partners;

-- 표본 5상품 리뷰 (review+comment 최상위)
SELECT count(*) FROM wp_comments
WHERE comment_post_ID IN (표본 상품)
  AND comment_type IN ('review','comment')
  AND comment_approved = 1 AND comment_parent = 0;

SELECT count(*) FROM reviews;

-- 현행 driver-schedule (입금가 배차)

SELECT count(*) FROM driver_dispatches;

-- 현행 usermeta 포인트 잔액 보유 회원

SELECT count(*) FROM point_balances;

-- 현행 포인트 적립/사용 로그 (표본 회원)

SELECT count(*) FROM point_transactions;

SELECT sum(total_amount) FROM wp_wc_orders
WHERE id IN (이관된 주문 id들);

SELECT sum(total_sell_amount) FROM orders;

-- 현행 배차 정산액 (KRW)

SELECT sum(cost_amount) FROM driver_dispatches;