sam-docs/dev/deploys/item-master-data-deploy-20260203.sql

-- ============================================================
-- SAM 품목 기준 데이터 배포 SQL
-- 대상: tenant_id = 287 (경동)
-- 생성일: 2026-02-03
-- 용도: 개발서버 배포 (기존 데이터 삭제 후 재삽입)
-- ============================================================

SET @TARGET_TENANT_ID = 287;

-- 안전장치
SET FOREIGN_KEY_CHECKS = 0;
SET AUTOCOMMIT = 0;
START TRANSACTION;

-- ============================================================
-- PHASE 1: 기존 데이터 삭제 (FK 역순)
-- ============================================================

-- 1-1. FK 없는 테이블 (자유 삭제)
DELETE FROM entity_relationships WHERE tenant_id = @TARGET_TENANT_ID;
DELETE FROM item_fields WHERE tenant_id = @TARGET_TENANT_ID;
DELETE FROM item_sections WHERE tenant_id = @TARGET_TENANT_ID;
DELETE FROM item_pages WHERE tenant_id = @TARGET_TENANT_ID;

-- 1-2. items 관련 (자식 → 부모)
DELETE FROM item_details WHERE item_id IN (SELECT id FROM items WHERE tenant_id = @TARGET_TENANT_ID);
DELETE FROM prices WHERE tenant_id = @TARGET_TENANT_ID;
DELETE FROM items WHERE tenant_id = @TARGET_TENANT_ID;

-- 1-3. categories 관련 (자식 → 부모)
DELETE FROM category_fields WHERE category_id IN (SELECT id FROM categories WHERE tenant_id = @TARGET_TENANT_ID);
DELETE FROM category_templates WHERE category_id IN (SELECT id FROM categories WHERE tenant_id = @TARGET_TENANT_ID);
DELETE FROM categories WHERE tenant_id = @TARGET_TENANT_ID AND parent_id IS NOT NULL;
DELETE FROM categories WHERE tenant_id = @TARGET_TENANT_ID;

-- ============================================================
-- PHASE 2: 데이터 삽입
-- ============================================================


-- --- 2-1. categories (부모 먼저, 자식 나중) ---
INSERT INTO `categories` (`id`, `tenant_id`, `parent_id`, `code_group`, `profile_code`, `code`, `name`, `is_active`, `sort_order`, `description`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES (202,287,NULL,'account_type',NULL,'ACC_PROD','제품',1,3,'계정코드:2',NULL,NULL,NULL,'2026-01-27 06:21:35','2026-01-27 06:21:35',NULL),(200,287,NULL,'account_type',NULL,'ACC_RAW','원재료',1,1,'계정코드:0',NULL,NULL,NULL,'2026-01-27 06:21:35','2026-01-27 06:21:35',NULL),(203,287,NULL,'account_type',NULL,'ACC_SEMI','반제품',1,4,'계정코드:4',NULL,NULL,NULL,'2026-01-27 06:21:35','2026-01-27 06:21:35',NULL),(201,287,NULL,'account_type',NULL,'ACC_SUB','부재료',1,2,'계정코드:1',NULL,NULL,NULL,'2026-01-27 06:21:35','2026-01-27 06:21:35',NULL),(213,287,NULL,'estimate','estimate_root','fire_shutter_estimate','방화셔터 견적',1,1,'방화셔터 견적 루트 카테고리',NULL,NULL,NULL,'2026-01-27 06:21:35','2026-01-27 06:21:35',NULL),(244,287,213,'estimate','screen_category','screen_product','스크린 제품',1,1,'실리카/와이어 스크린 제품 카테고리',NULL,NULL,NULL,'2026-01-27 06:21:42','2026-01-27 06:21:42',NULL),(245,287,213,'estimate','steel_category','steel_product','철재 제품',1,2,'철재스라트 제품 카테고리',NULL,NULL,NULL,'2026-01-27 06:21:42','2026-01-27 06:21:42',NULL),(217,287,NULL,'item_category',NULL,'ACCESSORY','부자재',1,4,NULL,NULL,NULL,NULL,'2026-01-27 06:21:35','2026-01-27 06:21:35',NULL),(246,287,217,'item_category',NULL,'ANGLE','앵글',1,9,NULL,NULL,1,1,'2026-01-27 06:21:42','2026-01-30 19:50:46',NULL),(215,287,NULL,'item_category',NULL,'BENDING','절곡품',1,2,NULL,NULL,NULL,NULL,'2026-01-27 06:21:35','2026-01-27 06:21:35',NULL),(247,287,215,'item_category',NULL,'BENDING_BOTTOM','하단마감재',1,3,NULL,NULL,NULL,NULL,'2026-01-27 06:21:42','2026-01-27 06:21:42',NULL),(248,287,215,'item_category',NULL,'BENDING_CASE','케이스',1,2,NULL,NULL,NULL,NULL,'2026-01-27 06:21:42','2026-01-27 06:21:42',NULL),(249,287,215,'item_category',NULL,'BENDING_GUIDE','가이드레일',1,1,NULL,NULL,NULL,NULL,'2026-01-27 06:21:42','2026-01-27 06:21:42',NULL),(214,287,NULL,'item_category',NULL,'BODY','본체',1,1,NULL,NULL,1,NULL,'2026-01-27 06:21:35','2026-01-27 10:14:21',NULL),(295,287,NULL,'item_category',NULL,'BOTTOM_TRIM','하단마감재',1,20,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(277,287,NULL,'item_category',NULL,'COLUMNLESS_BODY','무기둥본체',1,4,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(281,287,NULL,'item_category',NULL,'EMBED_BACK_BOX','매립뒷박스',1,13,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(293,287,NULL,'item_category',NULL,'END_PLATE','마구리',1,19,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(299,287,NULL,'item_category',NULL,'FABRIC','원단류',1,27,NULL,NULL,NULL,NULL,'2026-01-30 19:55:06','2026-01-30 19:55:06',NULL),(276,287,NULL,'item_category',NULL,'FIBER_BODY','화이바본체',1,3,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(294,287,NULL,'item_category',NULL,'FLOOR_CUT_PLATE','바닥절단판',1,16,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(301,287,NULL,'item_category',NULL,'GASKET','가스켓',1,29,NULL,NULL,NULL,NULL,'2026-01-30 19:55:06','2026-01-30 19:55:06',NULL),(289,287,NULL,'item_category',NULL,'GUIDE_RAIL','가이드레일',1,14,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(296,287,NULL,'item_category',NULL,'HAJANG_BAR','하장바',1,21,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(280,287,NULL,'item_category',NULL,'INTERLOCK_CTRL','연동제어기',1,12,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(282,287,NULL,'item_category',NULL,'JOINT_BAR','조인트바',1,6,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(286,287,NULL,'item_category',NULL,'L_BAR','엘바',1,23,NULL,1,NULL,NULL,'2026-01-30 19:50:46','2026-01-30 19:50:46',NULL),(302,287,NULL,'item_cate

-- --- 2-2. items ---
INSERT INTO `items` (`id`, `tenant_id`, `item_type`, `code`, `name`, `unit`, `category_id`, `process_type`, `item_category`, `bom`, `attributes`, `attributes_archive`, `options`, `description`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES (12546,287,'PT','00002','하장티바(스크린용)','EA',296,NULL,NULL,NULL,'{\"spec\": \"　\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 1, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12547,287,'PT','00003','힌지-정방향','EA',302,NULL,NULL,NULL,'{\"spec\": \"　\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 2, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12548,287,'PT','00004','쪼인트바','EA',282,NULL,NULL,NULL,'{\"spec\": \"　\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 3, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12549,287,'PT','00007','엘바+하장바','M',286,NULL,NULL,NULL,'{\"spec\": \"2.4\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 4, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12550,287,'PT','00008','엘바+하장바','M',286,NULL,NULL,NULL,'{\"spec\": \"3\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 5, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12551,287,'PT','00009','엘바+하장바','M',286,NULL,NULL,NULL,'{\"spec\": \"4\", \"item_div\": \"[상품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 6, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12552,287,'PT','00010','티바+엘바+평철','　',286,NULL,NULL,NULL,'{\"spec\": \"3000\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 7, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12553,287,'PT','00011','티바+엘바+평철','　',286,NULL,NULL,NULL,'{\"spec\": \"4000\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 8, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12554,287,'PT','00013','점검구3','EA',302,NULL,NULL,NULL,'{\"spec\": \"　\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 9, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12555,287,'PT','00015','가이드레일','m',289,NULL,NULL,NULL,'{\"spec\": \"　\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 10, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12556,287,'PT','00017','평철4.5T','M',287,NULL,NULL,NULL,'{\"spec\": \"1200\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 11, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12557,287,'PT','00018','평철4.5T','M',287,NULL,NULL,NULL,'{\"spec\": \"2000\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 12, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(12558,287,'PT','00019','평철9T','M',287,NULL,NULL,NULL,'{\"spec\": \"2000\", \"item_div\": \"[제품]\", \"Part_type\": \"조립 부품(Assembly Part)\", \"legacy_num\": 13, \"legacy_source\": \"KDunitprice\"}',NULL,NULL,NULL,1,1,1,NULL

-- --- 2-3. item_details ---
INSERT INTO `item_details` (`id`, `item_id`, `is_sellable`, `is_purchasable`, `is_producible`, `safety_stock`, `lead_time`, `is_variable_size`, `product_category`, `part_type`, `bending_diagram`, `bending_details`, `specification_file`, `specification_file_name`, `certification_file`, `certification_file_name`, `certification_number`, `certification_start_date`, `certification_end_date`, `is_inspection`, `item_name`, `specification`, `search_tag`, `remarks`, `created_at`, `updated_at`) VALUES (478,13307,1,1,0,NULL,NULL,0,'controller','방화 방화스위치',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','방화 방화스위치',NULL,NULL,NULL,'2026-01-29 12:00:18','2026-01-29 12:00:18'),(481,13310,1,1,0,NULL,NULL,0,'controller','방범 방범스위치',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','방범 방범스위치',NULL,NULL,NULL,'2026-01-29 12:00:18','2026-01-29 12:00:18'),(482,13311,1,1,0,NULL,NULL,0,'controller','방범 스위치커버',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','방범 스위치커버',NULL,NULL,NULL,'2026-01-29 12:00:18','2026-01-29 12:00:18'),(483,13312,1,1,0,NULL,NULL,0,'controller','방범 안전리미트',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','방범 안전리미트',NULL,NULL,NULL,'2026-01-29 12:00:18','2026-01-29 12:00:18'),(484,13313,1,1,0,NULL,NULL,0,'controller','방범 리모콘+스위치(최초)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','방범 리모콘+스위치(최초)',NULL,NULL,NULL,'2026-01-29 12:00:18','2026-01-29 12:00:18'),(485,13314,1,1,0,NULL,NULL,0,'controller','방범 리모콘4구',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','방범 리모콘4구',NULL,NULL,NULL,'2026-01-29 12:00:18','2026-01-29 12:00:18'),(486,13315,1,1,0,NULL,NULL,0,'controller','방범 스위치(무선+수신기)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','방범 스위치(무선+수신기)',NULL,NULL,NULL,'2026-01-29 12:00:18','2026-01-29 12:00:18'),(524,13147,1,0,1,NULL,NULL,0,'스크린',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','KSS01 스크린 SUS마감 벽면형','SUS마감-벽면형',NULL,NULL,'2026-01-30 20:04:23','2026-01-30 20:04:23'),(525,13148,1,0,1,NULL,NULL,0,'스크린',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','KSS01 스크린 SUS마감 측면형','SUS마감-측면형',NULL,NULL,'2026-01-30 20:04:23','2026-01-30 20:04:23'),(526,13149,1,0,1,NULL,NULL,0,'스크린',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','KSE01 스크린 SUS마감 벽면형','SUS마감-벽면형',NULL,NULL,'2026-01-30 20:04:23','2026-01-30 20:04:23'),(527,13150,1,0,1,NULL,NULL,0,'스크린',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','KSE01 스크린 EGI마감 벽면형','EGI마감-벽면형',NULL,NULL,'2026-01-30 20:04:23','2026-01-30 20:04:23'),(528,13151,1,0,1,NULL,NULL,0,'스크린',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','KSE01 스크린 SUS마감 측면형','SUS마감-측면형',NULL,NULL,'2026-01-30 20:04:23','2026-01-30 20:04:23'),(529,13152,1,0,1,NULL,NULL,0,'스크린',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','KSE01 스크린 EGI마감 측면형','EGI마감-측면형',NULL,NULL,'2026-01-30 20:04:23','2026-01-30 20:04:23'),(530,13153,1,0,1,NULL,NULL,0,'스크린',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','KWE01 스크린 SUS마감 벽면형','SUS마감-벽면형',NULL,NULL,'2026-01-30 20:04:23','2026-01-30 20:04:23'),(531,13154,1,0,1,NULL,NULL,0,'스크린',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','KWE01 스크린 EGI마감 벽면형','EGI마감-벽면형',NULL,NULL,'2026-01-30 20:04:23','2026-01-30 20:04:23'),(532,13155,1,0,1,NULL,NULL,0,'스크린',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','KWE01 스크린 SUS마감 측면형','SUS마감-측면형',NULL,NULL,'2026-01-30 20:04:23','2026-01-30 20:04:23'),(533,13156,1,0,1,NULL,NULL,0,'스크린',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','KWE01 스크린 EGI마감 측면형','EGI마감-측면형',NULL,NULL,'2026-01-30 20:04:23','2026-01-30 20:04:23'),(534,13157,1,0,1,NULL,NULL,0,'철재',NULL,NUL

-- --- 2-4. prices ---
INSERT INTO `prices` (`id`, `tenant_id`, `item_type_code`, `item_id`, `client_group_id`, `purchase_price`, `processing_cost`, `loss_rate`, `margin_rate`, `sales_price`, `rounding_rule`, `rounding_unit`, `supplier`, `effective_from`, `effective_to`, `note`, `status`, `is_final`, `finalized_at`, `finalized_by`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES (1952,287,'FG',12546,NULL,0.0000,NULL,NULL,NULL,0.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1953,287,'FG',12547,NULL,0.0000,NULL,NULL,NULL,520000.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1954,287,'FG',12548,NULL,0.0000,NULL,NULL,NULL,6000.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1955,287,'FG',12549,NULL,0.0000,NULL,NULL,NULL,0.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1956,287,'FG',12550,NULL,0.0000,NULL,NULL,NULL,0.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1957,287,'FG',12551,NULL,0.0000,NULL,NULL,NULL,0.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1958,287,'FG',12552,NULL,0.0000,NULL,NULL,NULL,60000.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1959,287,'FG',12553,NULL,0.0000,NULL,NULL,NULL,80000.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1960,287,'FG',12554,NULL,0.0000,NULL,NULL,NULL,0.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1961,287,'FG',12555,NULL,0.0000,NULL,NULL,NULL,0.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1962,287,'FG',12556,NULL,0.0000,NULL,NULL,NULL,4000.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1963,287,'FG',12557,NULL,0.0000,NULL,NULL,NULL,8000.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1964,287,'FG',12558,NULL,0.0000,NULL,NULL,NULL,10000.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1965,287,'FG',12559,NULL,0.0000,NULL,NULL,NULL,0.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1966,287,'FG',12560,NULL,0.0000,NULL,NULL,NULL,13500.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1967,287,'FG',12561,NULL,0.0000,NULL,NULL,NULL,0.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1968,287,'FG',12562,NULL,0.0000,NULL,NULL,NULL,400.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1969,287,'FG',12563,NULL,0.0000,NULL,NULL,NULL,0.0000,'round',1,NULL,'2026-01-28',NULL,'KDunitprice 마이그레이션','active',0,NULL,NULL,1,1,NULL,'2026-01-28 12:15:54','2026-01-28 12:15:54',NULL),(1970,287,'FG',12564,NULL,0.0000,NULL,NULL,

-- --- 2-5. item_pages, item_sections, item_fields, entity_relationships ---
INSERT INTO `item_pages` (`id`, `tenant_id`, `group_id`, `page_name`, `item_type`, `source_table`, `absolute_path`, `is_active`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES (974,287,1,'테스트1','FG','items','/제품관리/테스트1',1,33,NULL,33,'2025-11-25 02:51:53','2025-11-25 04:12:03','2025-11-25 04:12:03'),(975,287,1,'테스트1','FG','items','/제품관리/테스트1',1,33,NULL,33,'2025-11-25 02:51:53','2025-11-25 04:12:00','2025-11-25 04:12:00'),(976,287,1,'테스트1','FG','items','/제품관리/테스트1',1,33,NULL,33,'2025-11-25 04:12:56','2025-11-25 04:29:06','2025-11-25 04:29:06'),(977,287,1,'테스트1','FG','items','/제품관리/테스트1',1,33,NULL,33,'2025-11-25 04:12:56','2025-11-25 04:29:07','2025-11-25 04:29:07'),(978,287,1,'테스트2','PT','items','/부품관리/테스트2',1,33,NULL,33,'2025-11-25 04:13:45','2025-11-25 04:29:07','2025-11-25 04:29:07'),(979,287,1,'테스트2','PT','items','/부품관리/테스트2',1,33,NULL,33,'2025-11-25 04:13:45','2025-11-25 04:29:08','2025-11-25 04:29:08'),(980,287,1,'테스트2','FG','items','/제품관리/테스트1',1,33,33,33,'2025-11-25 04:29:12','2025-11-25 04:33:22','2025-11-25 04:33:22'),(981,287,1,'테스트1','FG','items','/제품관리/테스트1',1,33,33,33,'2025-11-25 04:33:45','2025-11-25 10:13:57','2025-11-25 10:13:57'),(982,287,1,'1','FG','items','/제품관리/1',1,33,NULL,33,'2025-11-25 10:15:18','2025-11-25 10:15:29','2025-11-25 10:15:29'),(983,287,1,'테스트1 번','FG','items','/제품관리/테스트1 번',1,33,NULL,33,'2025-11-25 10:19:12','2025-11-25 10:19:47','2025-11-25 10:19:47'),(984,287,1,'1','FG','items','/제품관리/1',1,33,NULL,33,'2025-11-25 10:35:02','2025-11-25 10:35:28','2025-11-25 10:35:28'),(985,287,1,'품목관리','FG','items','/제품관리/품목관리',1,33,NULL,33,'2025-11-25 10:36:06','2025-11-25 10:36:40','2025-11-25 10:36:40'),(986,287,1,'1','FG','items','/제품관리/1',1,33,NULL,33,'2025-11-25 10:37:14','2025-11-25 10:45:34','2025-11-25 10:45:34'),(987,287,1,'1','FG','items','/제품관리/1',1,33,NULL,33,'2025-11-25 10:48:09','2025-11-25 11:34:05','2025-11-25 11:34:05'),(988,287,1,'1','FG','items','/제품관리/1',1,33,NULL,33,'2025-11-25 11:47:59','2025-11-26 01:06:35','2025-11-26 01:06:35'),(989,287,1,'1','FG','items','/제품관리/1',1,33,NULL,33,'2025-11-26 01:06:42','2025-11-26 01:58:08','2025-11-26 01:58:08'),(990,287,1,'test 페이지','FG','items','/제품관리/test 페이지',1,33,33,33,'2025-11-26 02:04:42','2025-11-26 02:05:04','2025-11-26 02:05:04'),(991,287,1,'페이지 검색','FG','items','/제품관리/페이지 검색',1,33,33,33,'2025-11-26 02:27:53','2025-11-26 02:34:26','2025-11-26 02:34:26'),(992,287,1,'테스트 페이지1','FG','items','/제품관리/테스트 페이지1',1,33,33,33,'2025-11-26 07:46:59','2025-11-26 11:20:49','2025-11-26 11:20:49'),(993,287,1,'테스트 페이지2','FG','items','/제품관리/테스트 페이지',1,33,33,33,'2025-11-26 11:20:59','2025-11-27 00:41:40','2025-11-27 00:41:40'),(994,287,1,'테스트','FG','items','/제품관리/테스트',1,33,NULL,33,'2025-11-27 00:43:16','2025-11-27 00:43:55','2025-11-27 00:43:55'),(995,287,1,'테스트1','FG','items','/제품관리/테스트1',1,33,NULL,33,'2025-11-27 00:44:03','2025-11-27 00:44:16','2025-11-27 00:44:16'),(996,287,1,'213312312','FG','items','/제품관리/213312312',1,33,NULL,33,'2025-11-27 01:07:28','2025-11-27 01:08:03','2025-11-27 01:08:03'),(997,287,1,'123','FG','items','/제품관리/123',1,33,NULL,33,'2025-11-27 01:11:52','2025-11-27 01:12:22','2025-11-27 01:12:22'),(998,287,1,'페이지 1','FG','items','/제품관리/페이지 1',1,33,NULL,33,'2025-11-27 07:06:50','2025-11-27 07:29:02','2025-11-27 07:29:02'),(999,287,1,'11','FG','items','/제품관리/11',1,33,NULL,33,'2025-11-27 07:09:26','2025-11-27 07:29:03','2025-11-27 07:29:03'),(1000,287,1,'테스트 페이지','FG','items','/제품관리/1',1,33,33,33,'2025-11-27 07:29:11','2025-11-27 07:59:17','2025-11-27 07:59:17'),(1001,287,1,'1','FG','items','/제품관리/1',1,33,NULL,33,'2025-11-
INSERT INTO `item_sections` (`id`, `tenant_id`, `group_id`, `title`, `type`, `order_no`, `is_template`, `is_default`, `description`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,287,1,'테스트 일반 섹션','fields',0,0,0,NULL,33,NULL,33,'2025-11-25 04:34:13','2025-11-25 05:57:20','2025-11-25 05:57:20'),(2,287,1,'섹션 테스트','fields',1,0,0,NULL,33,NULL,33,'2025-11-25 04:34:47','2025-11-25 05:57:21','2025-11-25 05:57:21'),(3,287,1,'섹션 테스트223','fields',0,0,0,NULL,33,33,33,'2025-11-25 05:57:30','2025-11-25 10:13:57','2025-11-25 10:13:57'),(4,287,1,'봄봄테스트','bom',0,0,0,NULL,33,NULL,33,'2025-11-25 10:19:23','2025-11-25 10:19:45','2025-11-25 10:19:45'),(5,287,1,'1','fields',1,0,0,NULL,33,NULL,33,'2025-11-25 10:19:36','2025-11-25 10:19:46','2025-11-25 10:19:46'),(6,287,1,'1','fields',0,0,0,NULL,33,NULL,33,'2025-11-25 10:35:07','2025-11-25 10:35:25','2025-11-25 10:35:25'),(7,287,1,'1','fields',0,0,0,NULL,33,NULL,33,'2025-11-25 10:37:19','2025-11-25 10:40:10','2025-11-25 10:40:10'),(8,287,1,'1','fields',0,0,0,NULL,33,NULL,33,'2025-11-25 10:40:19','2025-11-25 10:40:27','2025-11-25 10:40:27'),(9,287,1,'1','bom',0,0,0,NULL,33,NULL,33,'2025-11-25 10:41:48','2025-11-25 10:45:34','2025-11-25 10:45:34'),(10,287,1,'1','fields',1,0,0,NULL,33,NULL,33,'2025-11-25 10:42:26','2025-11-25 10:45:34','2025-11-25 10:45:34'),(11,287,1,'2','fields',0,0,0,NULL,33,33,33,'2025-11-25 10:48:13','2025-11-25 10:49:00','2025-11-25 10:49:00'),(12,287,1,'12','fields',0,0,0,NULL,33,33,33,'2025-11-25 10:49:29','2025-11-25 11:34:05','2025-11-25 11:34:05'),(13,287,1,'1','fields',0,0,0,NULL,33,NULL,33,'2025-11-25 11:48:42','2025-11-26 01:06:35','2025-11-26 01:06:35'),(14,287,1,'일반 섹션 1','fields',0,0,0,NULL,33,NULL,33,'2025-11-26 01:06:59','2025-11-26 01:11:06','2025-11-26 01:11:06'),(15,287,1,'테스트 일반 섹션1','fields',0,0,0,NULL,33,NULL,33,'2025-11-26 07:47:27','2025-11-26 08:17:08','2025-11-26 08:17:08'),(16,287,1,'테스트 일반 섹션2','fields',1,0,0,NULL,33,NULL,33,'2025-11-26 07:56:40','2025-11-26 08:17:09','2025-11-26 08:17:09'),(17,287,1,'테스트 일반 섹션3','fields',2,0,0,NULL,33,NULL,33,'2025-11-26 07:59:47','2025-11-26 08:17:10','2025-11-26 08:17:10'),(18,287,1,'테스트 일반 섹션 4_new','fields',3,0,0,NULL,33,33,33,'2025-11-26 08:14:41','2025-11-26 08:33:22','2025-11-26 08:33:22'),(19,287,1,'테스트 일반 섹션 4','fields',0,1,0,'테스트 일반 섹션 4',33,NULL,33,'2025-11-26 08:14:41','2025-11-26 08:27:11','2025-11-26 08:27:11'),(20,287,1,'일반 섹션 테스트1_new','fields',0,0,0,NULL,33,33,33,'2025-11-26 08:34:07','2025-11-26 08:40:21','2025-11-26 08:40:21'),(21,287,1,'일반 섹션 테스트1_newnew','fields',0,1,0,'일반 섹션 테스트1',33,33,33,'2025-11-26 08:34:07','2025-11-26 08:36:30','2025-11-26 08:36:30'),(22,287,1,'일반 섹션 테스트1','fields',0,0,0,NULL,33,NULL,33,'2025-11-26 08:50:20','2025-11-26 08:50:35','2025-11-26 08:50:35'),(23,287,1,'일반섹션테스트1_new_new','fields',0,0,0,NULL,33,33,33,'2025-11-26 08:57:38','2025-11-26 10:10:07','2025-11-26 10:10:07'),(24,287,1,'일반섹션테스트1','fields',0,0,0,'일반섹션테스트1',33,NULL,33,'2025-11-26 08:57:38','2025-11-26 08:57:55','2025-11-26 08:57:55'),(25,287,1,'테스트 섹션  1_new','fields',1,0,0,NULL,33,33,33,'2025-11-26 10:08:55','2025-11-26 10:09:25','2025-11-26 10:09:25'),(26,287,1,'일반 섹션 테스트 1','fields',0,0,0,NULL,33,33,33,'2025-11-26 10:17:20','2025-11-26 11:16:20','2025-11-26 11:16:20'),(27,287,1,'1_new_new','fields',1,0,0,NULL,33,33,33,'2025-11-26 10:17:50','2025-11-26 11:16:19','2025-11-26 11:16:19'),(28,287,1,'11212','fields',2,0,0,NULL,33,33,33,'2025-11-26 10:18:08','2025-11-26 10:34:19','2025-11-26 10:34:19'),(29,287,1,'테스트섹션3','fields',0,0,0,'테스트섹션3',33,NULL,33,'2025-11-26 10:54:48','2025-11-26 11:16:21','2025-11-26 11:16:21'),(30,287,1,'테스트 섹션 1_new','fields',0,0,0,NULL,33,33,33,'2025-11-26 11:21:08','2025-11-26 11:27:36','2025-11-26 11:27:36'),(31,287,1,'테스트 일반 섹션 1_new',
INSERT INTO `item_fields` (`id`, `tenant_id`, `group_id`, `field_name`, `field_key`, `field_type`, `order_no`, `is_required`, `default_value`, `placeholder`, `display_condition`, `validation_rules`, `options`, `properties`, `source_table`, `source_column`, `storage_type`, `json_path`, `category`, `description`, `is_common`, `is_active`, `is_locked`, `locked_by`, `locked_at`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES (96,287,1,'품목명','item_name','textbox',0,1,NULL,'품목명 입력',NULL,NULL,NULL,NULL,NULL,NULL,'json',NULL,NULL,NULL,0,1,0,NULL,NULL,33,33,NULL,'2025-12-02 05:52:44','2025-12-02 05:53:29',NULL),(97,287,1,'규격(사양)','specification','textbox',1,1,NULL,'테스트',NULL,NULL,NULL,NULL,NULL,NULL,'json',NULL,NULL,NULL,0,1,0,NULL,NULL,33,33,NULL,'2025-12-02 05:53:25','2025-12-06 06:47:49',NULL),(98,287,1,'단위','unit','dropdown',6,1,NULL,NULL,NULL,NULL,'[{\"label\": \"M\", \"value\": \"M\"}, {\"label\": \"mm\", \"value\": \"mm\"}, {\"label\": \"EA\", \"value\": \"EA\"}]',NULL,NULL,NULL,'json',NULL,NULL,NULL,0,1,0,NULL,NULL,33,33,NULL,'2025-12-02 06:30:14','2025-12-20 08:44:10',NULL),(99,287,1,'비고','note1','textbox',7,0,NULL,'텍스트 박스 테스트',NULL,NULL,NULL,'{\"required\": false, \"inputType\": \"textbox\", \"multiColumn\": false}',NULL,NULL,'json',NULL,NULL,NULL,0,1,0,NULL,NULL,33,33,NULL,'2025-12-02 06:33:54','2025-12-24 07:13:28',NULL),(100,287,1,'품목명','100_item_name','dropdown',1,1,NULL,'품목명을 선택하세요','{\"targetType\": \"field\", \"fieldConditions\": [{\"fieldKey\": \"item_name\", \"expectedValue\": \"철판\", \"targetFieldIds\": [\"101\"]}, {\"fieldKey\": \"item_name\", \"expectedValue\": \"알루미늄\", \"targetFieldIds\": [\"102\"]}, {\"fieldKey\": \"item_name\", \"expectedValue\": \"스테인리스\", \"targetFieldIds\": [\"103\"]}, {\"fieldKey\": \"item_name\", \"expectedValue\": \"아연도금강판\", \"targetFieldIds\": [\"104\"]}, {\"fieldKey\": \"item_name\", \"expectedValue\": \"SUS(스테인리스)\", \"targetFieldIds\": [\"101\", \"102\", \"103\"]}, {\"fieldKey\": \"item_name\", \"expectedValue\": \"EGI(아연도금강판)\", \"targetFieldIds\": [\"101\", \"102\", \"103\"]}, {\"fieldKey\": \"item_name\", \"expectedValue\": \"원단류\", \"targetFieldIds\": [\"101\"]}]}',NULL,'[{\"label\": \"철판\", \"value\": \"철판\"}, {\"label\": \"알루미늄\", \"value\": \"알루미늄\"}, {\"label\": \"스테인리스\", \"value\": \"스테인리스\"}, {\"label\": \"아연도금강판\", \"value\": \"아연도금강판\"}, {\"label\": \"SUS(스테인리스)\", \"value\": \"SUS(스테인리스)\"}, {\"label\": \"EGI(아연도금강판)\", \"value\": \"EGI(아연도금강판)\"}, {\"label\": \"원단류\", \"value\": \"원단류\"}]',NULL,NULL,NULL,'json',NULL,NULL,NULL,0,1,0,NULL,NULL,33,33,NULL,'2025-12-02 08:33:29','2025-12-19 07:04:43',NULL),(101,287,1,'규격','101_specification_1','dropdown',2,1,NULL,NULL,NULL,NULL,'[{\"label\": \"옵션1-1\", \"value\": \"옵션1-1\"}, {\"label\": \"옵션1-2\", \"value\": \"옵션1-2\"}, {\"label\": \"옵션1-3\", \"value\": \"옵션1-3\"}, {\"label\": \"옵션120\", \"value\": \"옵션120\"}, {\"label\": \"옵션130\", \"value\": \"옵션130\"}, {\"label\": \"옵션1229\", \"value\": \"옵션1229\"}, {\"label\": \"옵션2025\", \"value\": \"옵션2025\"}, {\"label\": \"1.17\", \"value\": \"1.17\"}, {\"label\": \"1.2\", \"value\": \"1.2\"}, {\"label\": \"1.2T\", \"value\": \"1.2T\"}, {\"label\": \"1.5\", \"value\": \"1.5\"}, {\"label\": \"1.55\", \"value\": \"1.55\"}, {\"label\": \"1.6\", \"value\": \"1.6\"}, {\"label\": \"1.6T\", \"value\": \"1.6T\"}]',NULL,NULL,NULL,'json',NULL,NULL,NULL,0,1,0,NULL,NULL,33,33,NULL,'2025-12-02 09:27:35','2025-12-19 07:04:43',NULL),(102,287,1,'규격','102_specification_2','dropdown',3,1,NULL,NULL,NULL,NULL,'[{\"label\": \"옵션2-1\", \"value\": \"옵션2-1\"}, {\"label\": \"옵션2-2\", \"value\": \"옵션2-2\"}, {\"label\": \"1219\", \"value\": \"1219\"}]',NULL,NULL,NULL,'json',NULL,NULL,NULL,0,1,0,NULL,NULL,33,33,NULL,'2025-
INSERT INTO `entity_relationships` (`id`, `tenant_id`, `group_id`, `parent_type`, `parent_id`, `child_type`, `child_id`, `order_no`, `metadata`, `is_locked`, `locked_by`, `locked_at`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES (1,287,1,'page',981,'section',1,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(2,287,1,'page',981,'section',2,1,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(3,287,1,'page',981,'section',3,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(4,287,1,'page',983,'section',4,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(5,287,1,'page',983,'section',5,1,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(6,287,1,'page',984,'section',6,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(7,287,1,'page',986,'section',7,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(8,287,1,'page',986,'section',8,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(9,287,1,'page',986,'section',9,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(10,287,1,'page',986,'section',10,1,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(11,287,1,'page',987,'section',11,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(12,287,1,'page',987,'section',12,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(13,287,1,'page',988,'section',13,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(14,287,1,'page',989,'section',14,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(16,287,1,'section',3,'field',1,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(17,287,1,'section',3,'field',2,1,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(18,287,1,'section',3,'field',3,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(19,287,1,'section',10,'field',4,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(20,287,1,'section',14,'field',5,0,NULL,0,NULL,NULL,33,NULL,'2025-11-26 05:27:17','2025-11-26 05:27:17'),(26,287,1,'page',993,'section',42,1,NULL,0,NULL,NULL,NULL,NULL,'2025-11-26 12:37:57','2025-11-26 12:37:57'),(27,287,1,'page',993,'section',44,2,NULL,0,NULL,NULL,NULL,NULL,'2025-11-26 12:42:47','2025-11-26 12:42:47'),(130,287,1,'page',1015,'section',92,0,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 05:51:49','2025-12-02 05:51:49'),(131,287,1,'section',92,'field',96,0,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 05:52:44','2025-12-02 05:52:44'),(132,287,1,'section',92,'field',97,1,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 05:53:25','2025-12-02 05:53:25'),(133,287,1,'section',92,'field',98,2,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 06:30:14','2025-12-02 06:30:14'),(134,287,1,'section',92,'field',99,3,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 06:33:54','2025-12-02 06:33:54'),(135,287,1,'page',1016,'section',93,0,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 08:32:21','2025-12-02 08:32:21'),(136,287,1,'section',93,'field',100,1,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 08:33:29','2025-12-19 07:04:43'),(137,287,1,'section',93,'field',101,2,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 09:27:35','2025-12-19 07:04:43'),(138,287,1,'section',93,'field',102,3,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 09:27:52','2025-12-19 07:04:43'),(139,287,1,'section',93,'field',103,4,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 09:28:18','2025-12-19 07:04:43'),(140,287,1,'section',93,'field',104,5,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 09:28:45','2025-12-19 07:04:43'),(145,287,1,'section',93,'field',98,7,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 09:42:57','2025-12-19 07:04:43'),(146,287,1,'section',93,'field',99,8,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 09:43:34','2025-12-19 07:04:43'),(147,287,1,'page',1017,'section',94,0,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 10:56:53','2025-12-02 10:56:53'),(148,287,1,'section',94,'field',107,1,NULL,0,NULL,NULL,NULL,NULL,'2025-12-02 10:58:22','2025-12-20 08:44:10'),

-- ============================================================
-- PHASE 3: 검증
-- ============================================================

SELECT 'item_pages' AS tbl, COUNT(*) AS cnt FROM item_pages WHERE tenant_id = @TARGET_TENANT_ID
UNION ALL SELECT 'item_sections', COUNT(*) FROM item_sections WHERE tenant_id = @TARGET_TENANT_ID
UNION ALL SELECT 'item_fields', COUNT(*) FROM item_fields WHERE tenant_id = @TARGET_TENANT_ID
UNION ALL SELECT 'entity_relationships', COUNT(*) FROM entity_relationships WHERE tenant_id = @TARGET_TENANT_ID
UNION ALL SELECT 'categories', COUNT(*) FROM categories WHERE tenant_id = @TARGET_TENANT_ID
UNION ALL SELECT 'items', COUNT(*) FROM items WHERE tenant_id = @TARGET_TENANT_ID
UNION ALL SELECT 'item_details', COUNT(*) FROM item_details WHERE item_id IN (SELECT id FROM items WHERE tenant_id = @TARGET_TENANT_ID)
UNION ALL SELECT 'prices', COUNT(*) FROM prices WHERE tenant_id = @TARGET_TENANT_ID;

COMMIT;
SET FOREIGN_KEY_CHECKS = 1;

-- ============================================================
-- 예상 결과:
-- item_pages: 47, item_sections: 102, item_fields: 66
-- entity_relationships: 96, categories: 72
-- items: 780, item_details: 147, prices: 780
-- ============================================================