CREATE TABLE `store_tbl` (
	`create_date` DATE NOT NULL,
	`store_no` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`store_name` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`store_nick` VARCHAR(100) NOT NULL COLLATE 'utf8mb3_general_ci',
	`store_class1_code` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`store_class1_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`store_class2_code` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`store_class2_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`store_class3_code` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`store_class3_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`stand_class_code` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`stand_class_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone1_code` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone1_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone2_code` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone2_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone3_code` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone3_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`law_code` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`law_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone4_code` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone5_code` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone5_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone6_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone7_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone8_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`road_code` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`road_name` VARCHAR(80) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone9_name` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`zone10_name` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`building_code` VARCHAR(30) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`building_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`road_addr` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`old_addr_no` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`new_addr_no` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`dong_info` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`floor_info` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`ho_info` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`lng` DECIMAL(16,13) NULL DEFAULT NULL,
	`lat` DECIMAL(16,13) NULL DEFAULT NULL,
	PRIMARY KEY (`create_date`, `store_no`) USING BTREE,
	INDEX `idx_store_zone` (`store_no`, `zone1_name`, `zone2_name`, `zone3_name`, `zone8_name`) USING BTREE,
	INDEX `idx_date_zone_class` (`create_date`, `zone1_name`, `zone2_name`, `store_class1_name`, `store_class2_name`, `stand_class_name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
;
