--
-- Host: localhost    Database: asolution
-- ------------------------------------------------------


--
-- Table structure for table `TB_ADMIN`
--

CREATE TABLE `TB_ADMIN` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `privacy` text,
  `terms` text,
  `map_google` text,
  `map_naver` text,
  `map_daum` text,
  `meta_title` varchar(100) DEFAULT NULL,
  `meta_description` varchar(200) DEFAULT NULL,
  `meta_image` varchar(100) DEFAULT NULL,
  `meta_keyword` varchar(100) DEFAULT NULL,
  `meta_subject` varchar(100) DEFAULT NULL,
  `bbs_site` varchar(20) DEFAULT NULL,
  `sns_facebook` varchar(100) DEFAULT NULL,
  `sns_insta` varchar(100) DEFAULT NULL,
  `sns_youtube` varchar(100) DEFAULT NULL,
  `sns_blog` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_ADMIN`
--

INSERT INTO `TB_ADMIN` VALUES (1,'-- 개인정보를 입력하십시오 --\r\n',NULL,'1','2','3','에이솔루션(주)\r\n하나둘셋','LED 조명, 디스플레이, tv, 음향시스템, 시스템에어컨, 생활가전, 솔루션 ',NULL,'삼성 비즈니스솔루션 파트너 에이솔루션(주)','에이솔루션','ko','22','33','44','55');

--
-- Table structure for table `TB_APPLY`
--

CREATE TABLE `TB_APPLY` (
  `SEQ` int(11) NOT NULL AUTO_INCREMENT,
  `APPLY_TYPE` varchar(20) DEFAULT NULL,
  `APPLY_ID` varchar(20) DEFAULT NULL,
  `APPLY_NAME` varchar(50) DEFAULT NULL,
  `APPLY_POSITION` varchar(100) DEFAULT NULL,
  `APPLY_PRODUCT_ID` varchar(20) DEFAULT NULL,
  `APPLY_PRODUCT` varchar(100) DEFAULT NULL,
  `APPLY_COUNSELTYPE` varchar(100) DEFAULT NULL,
  `APPLY_COMPANY` varchar(100) DEFAULT NULL,
  `APPLY_BUSINESSNO` varchar(20) DEFAULT NULL,
  `APPLY_EMAIL` varchar(100) DEFAULT NULL,
  `APPLY_TEL` varchar(50) DEFAULT NULL,
  `APPLY_HP` varchar(50) DEFAULT NULL,
  `APPLY_POST` varchar(10) DEFAULT NULL,
  `APPLY_ADDR` varchar(200) DEFAULT NULL,
  `APPLY_SUBJECT` varchar(200) DEFAULT NULL,
  `APPLY_CONTENT` text,
  `APPLY_FILE` varchar(100) DEFAULT NULL,
  `APPLY_SITE` varchar(20) DEFAULT NULL,
  `APPLY_COST` int(11) DEFAULT NULL,
  `APPLY_QTY` int(11) DEFAULT NULL,
  `APPLY_TIME` varchar(20) DEFAULT NULL,
  `ORDER_CATE1` varchar(50) DEFAULT NULL,
  `ORDER_CATE2` varchar(50) DEFAULT NULL,
  `ORDER_CATE3` varchar(50) DEFAULT NULL,
  `INSERT_DATE` datetime DEFAULT NULL,
  `REPLY_NAME` varchar(50) DEFAULT NULL,
  `REPLY_CONTENT` text,
  `REPLY_DATE` datetime DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `bbs_site` varchar(20) DEFAULT NULL,
  `trade_code` varchar(20) NOT NULL,
  PRIMARY KEY (`SEQ`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_APPLY`
--

INSERT INTO `TB_APPLY` VALUES (26,'estimate','','test','test',NULL,NULL,NULL,'test','000-00-00000','test@test.com','00-000-0000','010-0000-0000',NULL,NULL,'테스트 테스트입니다','테스트 테스트 테스트<br>','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-09-14 14:05:28',NULL,NULL,NULL,'2020-09-14 14:05:28',NULL,'ko','200914-1405-285267'),(11,NULL,'','테스트','테스트',NULL,NULL,NULL,'에이솔루션','000-00-00000','test@test.com','02-000-0000','010-0000-0000',NULL,NULL,'테스트입니다','테스트입니다','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-09-08 15:06:19',NULL,'','2020-09-08 15:08:31','2020-09-08 15:06:19',NULL,'ko',''),(9,NULL,'','이동희','이사',NULL,NULL,NULL,'디자인포르테','111-22-33333','cs@designforte.co.kr','010-4466-2105','010-4466-2105',NULL,NULL,'견적문의 테스트','견적문의 테스트\r\n견적문의 테스트\r\n견적문의 테스트견적문의 테스트\r\n견적문의 테스트\r\n견적문의 테스트\r\n\r\n견적문의 테스트견적문의 테스트견적문의 테스트견적문의 테스트\r\n','0XflIPX.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-09-07 14:01:22',NULL,'<p>dfsfsdf</p><p>sdfs</p><p>sfs</p><p>dfs</p><p>&nbsp;</p>','2020-09-07 14:07:08','2020-09-07 14:01:22',NULL,'ko',''),(27,'estimate','','2','3',NULL,NULL,NULL,'1','0-456-645','9@0','7-8-7','4-5-6',NULL,NULL,'456','3456<br>','957fa686edc1669b0acbd3cc121279a2_1516777795_9748[4].jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-09-14 17:32:31',NULL,NULL,NULL,'2020-09-14 17:32:31',NULL,'ko','200914-1732-315796'),(25,NULL,'','22','33',NULL,NULL,NULL,'11','1212-1313-1414','1010@1111','77-88-99','44-55-66',NULL,NULL,'1515','<p style=\"margin-left: 40px;\">1616</p>','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-09-11 10:47:37',NULL,NULL,NULL,'2020-09-11 10:47:37',NULL,'ko','200911-1047-378820');

--
-- Table structure for table `TB_BANNER`
--

CREATE TABLE `TB_BANNER` (
  `idx` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `display` tinyint(3) unsigned DEFAULT '0',
  `status` tinyint(3) unsigned DEFAULT '0',
  `title` varchar(200) DEFAULT '',
  `link_url` varchar(200) DEFAULT '',
  `target` tinyint(3) unsigned DEFAULT '0',
  `banner_images` varchar(100) DEFAULT '',
  `content` text,
  `useyn` varchar(1) DEFAULT 'Y',
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_BANNER`
--

INSERT INTO `TB_BANNER` VALUES (2,1,1,'디스플레이 샘플','http://asolutionkorea.co.kr/html',0,'BANNER_1600028381','','Y');

--
-- Table structure for table `TB_BBS_CATEGORY`
--

CREATE TABLE `TB_BBS_CATEGORY` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `mgr_id` varchar(20) DEFAULT NULL,
  `cate_id` varchar(20) DEFAULT NULL,
  `cate_name` varchar(100) DEFAULT NULL,
  `cate_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_BBS_CATEGORY`
--

INSERT INTO `TB_BBS_CATEGORY` VALUES (2,'faq','11','상품',1),(3,'faq','21','세금계산서',2),(4,'faq','31','결제 안내',3),(5,'faq','41','배송/설치',4),(6,'faq','51','교환/환불',5);

--
-- Table structure for table `TB_BBS_COMMENT`
--

CREATE TABLE `TB_BBS_COMMENT` (
  `seqid` int(10) NOT NULL AUTO_INCREMENT,
  `comment` text,
  `name` varchar(20) DEFAULT NULL,
  `bbs_id` varchar(10) NOT NULL DEFAULT '',
  `mgr_id` varchar(10) NOT NULL DEFAULT '',
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`seqid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_BBS_COMMENT`
--


--
-- Table structure for table `TB_BBS_FILE`
--

CREATE TABLE `TB_BBS_FILE` (
  `file_id` int(10) NOT NULL DEFAULT '0',
  `file_name` varchar(200) DEFAULT NULL,
  `file_path` varchar(100) DEFAULT NULL,
  `file_size` varchar(20) DEFAULT NULL,
  `bbs_id` varchar(10) DEFAULT NULL,
  `mgr_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_BBS_FILE`
--


--
-- Table structure for table `TB_BBS_MGR`
--

CREATE TABLE `TB_BBS_MGR` (
  `mgr_id` varchar(20) NOT NULL DEFAULT '',
  `mgr_title` varchar(50) DEFAULT NULL,
  `mgr_group` varchar(20) DEFAULT NULL,
  `mgr_type` varchar(20) DEFAULT NULL,
  `mgr_seq` int(11) DEFAULT NULL,
  `mgr_use_flag` varchar(1) DEFAULT NULL,
  `mgr_upload_flag` varchar(10) DEFAULT NULL,
  `mgr_upload_no` varchar(10) DEFAULT NULL,
  `mgr_upload_size` varchar(10) DEFAULT NULL,
  `mgr_answer_flag` varchar(10) DEFAULT NULL,
  `mgr_memo_flag` varchar(10) DEFAULT NULL,
  `mgr_thumb_flag` varchar(1) DEFAULT NULL,
  `mgr_content_flag` varchar(1) DEFAULT NULL,
  `mgr_order` varchar(10) DEFAULT NULL,
  `mgr_term_flag` varchar(1) DEFAULT 'N',
  `bbs_site` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`mgr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_BBS_MGR`
--

INSERT INTO `TB_BBS_MGR` VALUES ('notice','공지사항','','list',1,'Y','N','5','5000000','N','N','N','Y','2','N',''),('news','새소식','','list',2,'Y','N','','','N','N','N','Y','2','N',''),('inquiry','제품문의','','qna',101,'N','N','','','N','N','N','N','2','N',''),('gallery','시공사례','','gallery',3,'Y','N','','','N','N','Y','Y','2','Y',NULL),('estimate','견적문의','','qna',103,'N','N','','','N','N','N','N','2','N',''),('faq','질문과 답변','','qna',9,'Y','N','','','N','N','N','Y','2','N',NULL);

--
-- Table structure for table `TB_CATEGORY`
--

CREATE TABLE `TB_CATEGORY` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `cate_name` varchar(100) DEFAULT NULL,
  `cate_fullname` varchar(100) DEFAULT NULL,
  `cate_type` varchar(20) DEFAULT NULL,
  `cate_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_CATEGORY`
--

INSERT INTO `TB_CATEGORY` VALUES (1,'LED 조명',NULL,'10',1),(2,'스마트 사이니지',NULL,'20',1),(3,'비즈니스TV(호텔TV)',NULL,'20',2),(4,'모니터',NULL,'20',3),(5,'TV',NULL,'20',4),(6,'하만 프로 오디오',NULL,'20',5),(7,'냉장고',NULL,'30',1),(8,'전기레인지',NULL,'30',2),(9,'식기세척기',NULL,'30',3),(10,'세탁기/건조기',NULL,'30',4),(11,'청소기',NULL,'30',5),(12,'에어드레서',NULL,'30',6),(13,'공기청정기',NULL,'30',7),(14,'시스템제습기',NULL,'30',8),(15,'대형건물용 시스템에어컨',NULL,'40',1),(16,'중소건물용 시스템에어컨',NULL,'40',2),(17,'주거용 시스템에어컨',NULL,'40',3),(18,'바닥난방/ 급탕솔루션',NULL,'40',4),(19,'환기 솔루션',NULL,'40',5),(20,'중앙공조',NULL,'40',6),(21,'중대형에어컨',NULL,'40',7),(22,'에어컨 세척 서비스',NULL,'50',1);

--
-- Table structure for table `TB_CODE`
--

CREATE TABLE `TB_CODE` (
  `codediv` varchar(20) NOT NULL,
  `code` varchar(20) NOT NULL,
  `codename` varchar(100) NOT NULL,
  `useyn` varchar(1) NOT NULL,
  `seq` int(11) DEFAULT NULL,
  `ref` varchar(20) DEFAULT NULL,
  `ref_desc` varchar(100) DEFAULT NULL,
  `ref2` varchar(20) DEFAULT NULL,
  `ref2_desc` varchar(100) DEFAULT NULL,
  `ref3` varchar(200) DEFAULT NULL,
  `ref3_desc` varchar(100) DEFAULT NULL,
  `bbs_site` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`codediv`,`code`),
  KEY `codediv` (`codediv`,`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_CODE`
--

INSERT INTO `TB_CODE` VALUES ('trade_stat','4','Delivery completed','N',4,'order','ë°°ì†¡ì™„ë£Œ','','','','',''),('trade_courier','CJ','CJ','Y',1,'','','','','','',''),('trade_stat','2','Deposit completed','Y',2,'order','ìž…ê¸ˆí™•ì¸','','','','',''),('trade_stat','3','Ready for delivery','Y',3,'order','ë°°ì†¡ì¤€ë¹„','','','','',''),('trade_stat','1','Deposit waiting','Y',1,'order','ìž…ê¸ˆëŒ€ê¸°','','','','',''),('ALL','prod_type','상품 타입','Y',1,'','','','','','',''),('prod_type','20','디스플레이/TV/음향시스템','Y',2,'css','sub-visual--display','','','','',''),('prod_type','10','LED 조명','Y',1,'css','sub-visual--led','','','','',''),('prod_type','30','생활가전','Y',3,'css','sub-visual--homeapp','','','','',''),('prod_type','40','시스템에어컨','Y',4,'css','sub-visual--airc','','','','',''),('spec_type','10','Input specification','Y',1,'1','','','','','',''),('spec_type','20','Output Specification','Y',2,'1','','','','','',''),('spec_type','30','Protection circuit','Y',3,'1','','','','','',''),('spec_type','40','Lightning Surge','Y',4,'1','','','','','',''),('spec_type','50','Isolation Resistance','Y',5,'1','','','','','',''),('spec_type','60','Dielectric withstand Voltage','Y',6,'1','','','','','',''),('spec_type','70','Environment & Others','Y',7,'1','','','','','',''),('ALL','spec_type','제품 세부사항 분류','N',1,'','','','','','','ko'),('ALL','inquiry','문의하기 유형','Y',1,'','','','','','','ko'),('apply_type','inquiry','제품문의','Y',1,'','','','','','','ko'),('apply_type','product','세부사양서','Y',1,'','','','','','','ko'),('apply_type','estimate','견적문의','Y',1,'','','','','','','ko'),('ALL','recruit','채용공고 상태','N',1,'','','','','','','ko'),('recruit','0','진행중','Y',1,'','','','','','',''),('recruit','9','마감','Y',9,'','','','','','',''),('prod_type','50','솔루션','Y',5,'css','sub-visual--solution',NULL,NULL,NULL,NULL,NULL),('ALL','prod_opt_type','상품 옵션 타입','Y',1,'','','','','','',''),('prod_opt_type','10','색상','Y',1,'','',NULL,NULL,NULL,NULL,NULL),('prod_opt_type','20','용량','Y',2,'','',NULL,NULL,NULL,NULL,NULL),('prod_opt_type','30','사이즈','Y',3,'','',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `TB_GRADE`
--

CREATE TABLE `TB_GRADE` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `grade_name` varchar(20) NOT NULL,
  `grade_level` int(11) NOT NULL,
  `grade_desc` varchar(200) NOT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_GRADE`
--


--
-- Table structure for table `TB_GRP_MGR_MAP`
--

CREATE TABLE `TB_GRP_MGR_MAP` (
  `mgr_id` varchar(20) NOT NULL DEFAULT '',
  `grp_id` varchar(20) NOT NULL DEFAULT '',
  `map_open` varchar(10) DEFAULT NULL,
  `map_list` varchar(10) DEFAULT NULL,
  `map_view` varchar(10) DEFAULT NULL,
  `map_create` varchar(10) DEFAULT NULL,
  `map_answer` varchar(10) DEFAULT NULL,
  `map_update` varchar(10) DEFAULT NULL,
  `map_delete` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_GRP_MGR_MAP`
--

INSERT INTO `TB_GRP_MGR_MAP` VALUES ('portfolio','1','Y','Y','Y','Y','Y','Y','Y'),('portfolio','A','Y','Y','Y','Y','Y','Y','Y'),('portfolio','0','Y','Y','Y','Y','Y','Y','Y');

--
-- Table structure for table `TB_LEVEL_MGR_MAP`
--

CREATE TABLE `TB_LEVEL_MGR_MAP` (
  `mgr_id` varchar(20) NOT NULL DEFAULT '',
  `level_id` varchar(20) NOT NULL DEFAULT '',
  `map_open` varchar(10) DEFAULT NULL,
  `map_list` varchar(10) DEFAULT NULL,
  `map_view` varchar(10) DEFAULT NULL,
  `map_create` varchar(10) DEFAULT NULL,
  `map_answer` varchar(10) DEFAULT NULL,
  `map_update` varchar(10) DEFAULT NULL,
  `map_delete` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`mgr_id`,`level_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_LEVEL_MGR_MAP`
--

INSERT INTO `TB_LEVEL_MGR_MAP` VALUES ('portfolio','1','Y','Y','Y','Y','Y','Y','Y'),('portfolio','A','Y','Y','Y','Y','Y','Y','Y'),('portfolio','0','Y','Y','Y','Y','Y','Y','Y'),('notice','1','Y','Y','Y','Y','Y','Y','Y'),('notice','A','Y','Y','Y','Y','Y','Y','Y'),('notice','0','Y','Y','Y','Y','Y','Y','Y'),('data','1','Y','Y','Y','Y','Y','Y','Y'),('data','A','Y','Y','Y','Y','Y','Y','Y'),('data','0','Y','Y','Y','Y','Y','Y','Y'),('inquiry','0','Y','Y','Y','Y','Y','Y','Y'),('inquiry','A','Y','Y','Y','Y','Y','Y','Y'),('inquiry','1','Y','Y','Y','Y','Y','Y','Y'),('privacy','0','Y','Y','Y','Y','Y','Y','Y'),('privacy','A','Y','Y','Y','Y','Y','Y','Y'),('privacy','1','Y','Y','Y','Y','Y','Y','Y');

--
-- Table structure for table `TB_MEMBER_JOIN`
--

CREATE TABLE `TB_MEMBER_JOIN` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `mem_id` varchar(100) NOT NULL,
  `join_code` varchar(20) NOT NULL,
  `chk_code` varchar(20) NOT NULL,
  `join_register` datetime NOT NULL,
  `chk_register` datetime NOT NULL,
  `url_register` varchar(20) NOT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_MEMBER_JOIN`
--


--
-- Table structure for table `TB_MEMBER_LOGIN`
--

CREATE TABLE `TB_MEMBER_LOGIN` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `mem_id` varchar(100) NOT NULL,
  `login_register` datetime NOT NULL,
  `url_register` varchar(20) NOT NULL,
  `remark` varchar(20) NOT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_MEMBER_LOGIN`
--


--
-- Table structure for table `TB_MEMBER_WITHDRAW`
--

CREATE TABLE `TB_MEMBER_WITHDRAW` (
  `seqid` int(10) NOT NULL AUTO_INCREMENT,
  `mem_id` varchar(100) NOT NULL DEFAULT '',
  `mem_desc` text NOT NULL,
  `withdraw_date` datetime NOT NULL,
  `withdraw_reason` varchar(20) NOT NULL,
  `withdraw_desc` varchar(200) NOT NULL,
  `bbs_site` varchar(20) NOT NULL,
  PRIMARY KEY (`seqid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_MEMBER_WITHDRAW`
--


--
-- Table structure for table `TB_PART`
--

CREATE TABLE `TB_PART` (
  `idx` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `part_name` varchar(100) NOT NULL DEFAULT '',
  `part0_code` varchar(20) NOT NULL DEFAULT '',
  `part1_code` varchar(20) NOT NULL DEFAULT '',
  `part2_code` varchar(20) NOT NULL DEFAULT '',
  `part3_code` varchar(20) NOT NULL DEFAULT '',
  `part_url` varchar(100) NOT NULL DEFAULT '',
  `part_index` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `part_ranking` int(10) unsigned NOT NULL DEFAULT '0',
  `part_desc` varchar(200) NOT NULL DEFAULT '',
  `list_display_check` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `list_display_images1` varchar(100) NOT NULL DEFAULT '',
  `list_display_images2` varchar(100) NOT NULL DEFAULT '',
  `goods_cnt` int(10) unsigned NOT NULL DEFAULT '0',
  `part_display_check` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `part_low_check` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `part_display_item` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `title_display_check` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `title_display_images` varchar(100) NOT NULL DEFAULT '',
  `title_html_code` text,
  `part_type` varchar(20) NOT NULL DEFAULT '',
  `part_mgrid` varchar(20) NOT NULL DEFAULT '',
  `part_size` int(11) NOT NULL DEFAULT '0',
  `member_level` varchar(20) NOT NULL DEFAULT '0',
  `part_content` text,
  `part_content_ko` text,
  `part_use` varchar(1) NOT NULL DEFAULT 'Y',
  `bbs_site` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`idx`),
  KEY `part1_code` (`part1_code`),
  KEY `part_index` (`part_index`),
  KEY `part1_code_2` (`part1_code`,`part2_code`),
  KEY `part_name` (`part_name`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_PART`
--

INSERT INTO `TB_PART` VALUES (1,'LED 조명','','1599176088','','','product_led&prodType=1',1,1,'LED 조명',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(2,'디스플레이/TV/음향시스템','','1599185168','','','product_display&prodType=2',1,2,'디스플레이/TV/음향시스템',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(3,'생활가전','','1599185189','','','product_homeapp&prodType=7',1,3,'생활가전',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(4,'시스템에어컨','','1599185202','','','product_airconditioner&prodType=15',1,4,'시스템에어컨',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(5,'솔루션','','1599185213','','','solution_air_cleaning&prodType=22',1,5,'솔루션',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(6,'회사소개','','1599185231','','','company01',1,6,'회사소개',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(7,'시공사례','','1599185243','','','construction_case',1,7,'시공사례',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(8,'고객센터','','1599185256','','','notice',1,9,'고객센터',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(9,'공지사항','','1599185256','1599185286','','notice',2,1,'공지사항',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(10,'새소식','','1599185256','1599185304','','news',2,2,'새소식',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(11,'FAQ','','1599185256','1599185321','','faq',2,3,'FAQ',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(12,'회사개요/비전','','1599185231','1599185408','','company01',2,4,'회사개요/비전',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(13,'연혁','','1599185231','1599185420','','company02',2,5,'연혁',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(14,'주요고객','','1599185231','1599185430','','company03',2,6,'주요고객',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(15,'오시는 길','','1599185231','1599185449','','company04',2,7,'오시는 길',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(16,'스마트 사이니지','','1599185168','1599185466','','product_display&prodType=2',2,8,'스마트 사이니지',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(17,'비즈니스TV(호텔TV)','','1599185168','1599185481','','product_display&prodType=3',2,9,'비즈니스TV(호텔TV)',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(18,'모니터','','1599185168','1599185494','','product_display&prodType=4',2,10,'모니터',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(19,'TV','','1599185168','1599185502','','product_display&prodType=5',2,11,'TV',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(20,'하만 프로 오디오','','1599185168','1599185511','','product_display&prodType=6',2,12,'하만 프로 오디오',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(21,'냉장고','','1599185189','1599185533','','product_homeapp&prodType=7',2,13,'냉장고',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(22,'전기레인지','','1599185189','1599185543','','product_homeapp&prodType=8',2,14,'전기레인지',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(23,'식기세척기','','1599185189','1599185556','','product_homeapp&prodType=9',2,15,'식기세척기',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(24,'세탁기/건조기','','1599185189','1599185567','','product_homeapp&prodType=10',2,16,'세탁기/건조기',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(25,'청소기','','1599185189','1599185578','','product_homeapp&prodType=11',2,17,'청소기',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(26,'에어드레서','','1599185189','1599185587','','product_homeapp&prodType=12',2,18,'에어드레서',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(27,'공기청정기','','1599185189','1599185598','','product_homeapp&prodType=13',2,19,'공기청정기',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(28,'시스템제습기','','1599185189','1599185611','','product_homeapp&prodType=14',2,20,'시스템제습기',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(29,'대형건물용 시스템에어컨','','1599185202','1599185626','','product_airconditioner&prodType=15',2,21,'대형건물용 시스템에어컨',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(30,'중소건물용 시스템에어컨','','1599185202','1599185635','','product_airconditioner&prodType=16',2,22,'중소건물용 시스템에어컨',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(31,'주거용 시스템에어컨','','1599185202','1599185646','','product_airconditioner&prodType=17',2,23,'주거용 시스템에어컨',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(32,'바닥난방/ 급탕솔루션','','1599185202','1599185655','','product_airconditioner&prodType=18',2,24,'바닥난방/ 급탕솔루션',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(33,'환기 솔루션','','1599185202','1599185675','','product_airconditioner&prodType=19',2,25,'환기 솔루션',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(34,'중앙공조','','1599185202','1599185683','','product_airconditioner&prodType=20',2,26,'중앙공조',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(35,'중대형에어컨','','1599185202','1599185693','','product_airconditioner&prodType=21',2,27,'중대형에어컨',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(36,'에어컨 세척 서비스','','1599185213','1599185711','','solution_air_cleaning&prodType=22',2,28,'에어컨 세척 서비스',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko'),(37,'견적문의','','1599703359','','','estimate',1,8,'견적문의',0,'','',0,0,0,0,0,'',NULL,'','',0,'0','<br>',NULL,'Y','ko');

--
-- Table structure for table `TB_POP`
--

CREATE TABLE `TB_POP` (
  `POP_SEQ` int(11) NOT NULL AUTO_INCREMENT,
  `TITLE` varchar(255) NOT NULL DEFAULT '',
  `SUB_TITLE` varchar(255) NOT NULL DEFAULT '',
  `CONTENTS` text NOT NULL,
  `REG_DATE` datetime DEFAULT NULL,
  `START_DATE` varchar(8) NOT NULL DEFAULT '',
  `END_DATE` varchar(8) NOT NULL DEFAULT '',
  `WIDTH` int(11) NOT NULL DEFAULT '0',
  `HEIGHT` int(11) NOT NULL DEFAULT '0',
  `TOP_POS` int(11) NOT NULL DEFAULT '0',
  `LEFT_POS` int(11) NOT NULL DEFAULT '0',
  `GUBUN` char(1) NOT NULL DEFAULT '',
  `POP_TYPE` char(1) NOT NULL DEFAULT '',
  `SCROLLBARS` char(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`POP_SEQ`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_POP`
--


--
-- Table structure for table `TB_PRODUCT`
--

CREATE TABLE `TB_PRODUCT` (
  `prod_id` int(10) NOT NULL AUTO_INCREMENT,
  `brand_id` int(10) DEFAULT NULL,
  `type_id` varchar(50) DEFAULT NULL,
  `online_id` varchar(50) DEFAULT NULL,
  `offline_id` varchar(50) DEFAULT NULL,
  `prod_name` varchar(100) DEFAULT NULL,
  `prod_model` varchar(100) DEFAULT NULL,
  `prod_desc` varchar(200) DEFAULT NULL,
  `prod_price` int(11) NOT NULL DEFAULT '0',
  `prod_dc_price` int(11) NOT NULL DEFAULT '0',
  `prod_function` varchar(50) DEFAULT NULL,
  `prod_volume` varchar(100) DEFAULT NULL,
  `prod_time` varchar(20) DEFAULT NULL,
  `prod_together` varchar(30) DEFAULT NULL,
  `prod_point` text,
  `prod_ingred` text,
  `prod_ingred_p` text,
  `prod_ingred_m` text,
  `prod_use` text,
  `prod_order` varchar(10) DEFAULT NULL,
  `prod_view` varchar(10) DEFAULT NULL,
  `prod_new` varchar(10) DEFAULT NULL,
  `prod_best` varchar(10) DEFAULT NULL,
  `prod_banner` varchar(50) DEFAULT NULL,
  `prod_thumb` varchar(100) DEFAULT NULL,
  `prod_content` text,
  `prod_spec_img` varchar(100) DEFAULT NULL,
  `prod_series` varchar(100) DEFAULT NULL,
  `prod_power` varchar(100) DEFAULT NULL,
  `prod_input` varchar(100) DEFAULT NULL,
  `prod_output` varchar(100) DEFAULT NULL,
  `prod_capa` varchar(100) DEFAULT NULL,
  `prod_spec` varchar(100) DEFAULT NULL,
  `prod_sheet` varchar(100) DEFAULT NULL,
  `prod_relative` varchar(100) DEFAULT NULL,
  `prod_remark` varchar(100) DEFAULT NULL,
  `prod_opt_type` varchar(20) DEFAULT NULL,
  `prod_overview` varchar(100) DEFAULT NULL,
  `prod_document` varchar(200) DEFAULT NULL,
  `prod_option` varchar(20) DEFAULT NULL,
  `prod_opt_text` varchar(200) DEFAULT NULL,
  `prod_ico_new` varchar(20) DEFAULT NULL,
  `prod_ico_best` varchar(20) DEFAULT NULL,
  `prod_ico_samsung` varchar(20) DEFAULT NULL,
  `prod_main_best` varchar(20) DEFAULT NULL,
  `prod_main_recom` varchar(20) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `bbs_site` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`prod_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1600068447 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_PRODUCT`
--

INSERT INTO `TB_PRODUCT` VALUES (1600056383,1,'',',,',',,','LED 방등(네오) 50 W 5,700K','LIH650Q85502D','',0,0,'','','','','','','','','','','Y','','','','SI-GFUT40B1A1D_thumb_01.jpg','<img title=\"207701.jpg\" src=\"/smart_editor/upload/207701.jpg\"><br style=\"clear: both;\"><br style=\"clear: both;\"><br>','LIH650Q85502D_spec.png','주거조명','','','','','소비전력 : 50.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'눈의 피로가 적은 조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-14 13:06:23','2020-09-14 13:06:23','ko'),(1599625712,1,'',',,',',,','LED 주방등 40 W 5,700K','SI-GFYQ40C3A1D','',0,0,'','','','','','','','','','','Y','','','','SI-GFYT40C3A1D_thumb_01.jpg','<img title=\"761715.jpg\" src=\"/smart_editor/upload/761715.jpg\"><br style=\"clear: both;\"><br>','spec_SI-GFYQ40B2A1D.png','주거조명','','','','','소비전력 : 40 W\r\n온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'삼성 홈 LED 주방욕실등 ','다양한 공간과 조화를 이루는 간결하고 모던한 디자인','0','','','',NULL,'','','2020-09-09 13:28:32','2020-09-09 13:33:00','ko'),(1599626341,1,'',',,',',,','LED 주방등 20 W 4,000K','SI-GFYT20B2A1D','',0,0,'','','','','','','','','','','Y','','','','SI-GFYT20B2A1D_thumb_01[1].jpg','<img title=\"450549.jpg\" src=\"/smart_editor/upload/450549.jpg\"><br style=\"clear: both;\"><br>','spec_SI-GFYT20B2A1D.png','주거조명','','','','','소비전력 : 20 W\r\n색온도 : 4,000 K (온백색)\r\n빔각도 : 160 ˚','','','',NULL,'삼성 홈 LED 주방욕실등','다양한 공간과 조화를 이루는 간결하고 모던한 디자인','0','','','',NULL,'','','2020-09-09 13:39:01','2020-09-14 16:23:34','ko'),(1600056497,1,'',',,',',,','LED 방등(밴드) 37 W 5,700K','LIH640Q80114D','',0,0,'','','','','','','','','','','Y','','','','SI-GFUQ50B1A1D_thumb_01.jpg','<img title=\"297126.jpg\" src=\"/smart_editor/upload/297126.jpg\"><br style=\"clear: both;\"><br>','LIH640Q80114D_spec.png','주거조명','','','','','소비전력 : 37.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'눈의 피로가 적은 조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-14 13:08:17','2020-09-14 13:08:17','ko'),(1599623205,1,'',',,',',,','LED 주방등 20 W 5,700K','SI-GFYQ20B2A1D','',0,0,'','','','','','','','','','','Y','','','','SI-GFYT20B2A1D_thumb_01.jpg','<img title=\"855968.jpg\" src=\"/smart_editor/upload/855968.jpg\"><br style=\"clear: both;\"><br style=\"clear: both;\"><br>','spec_SI-GFYQ20B2A1D.png','주거조명','','','','','소비전력 : 20 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'삼성 홈 LED 주방욕실등','다양한 공간과 조화를 이루는 간결하고 모던한 디자인','0','','','',NULL,'','Y','2020-09-09 12:46:45','2020-09-09 13:30:40','ko'),(1599626692,1,'',',,',',,','LED 주방등 40 W 4,000K','SI-GFYT40C3A1D','',0,0,'','','','','','','','','','','Y','','','','SI-GFYT40C3A1D_thumb_01[1].jpg','<img title=\"104035.jpg\" src=\"/smart_editor/upload/104035.jpg\"><br style=\"clear: both;\"><br>','spec_SI-GFYT40B2A1D.png','주거조명','','','','','소비전력 : 40 W\r\n온도 : 4,000 K (온백색)\r\n각도 : 160 ˚','','','',NULL,'삼성 홈 LED 주방욕실등','다양한 공간과 조화를 이루는 간결하고 모던한 디자인','0','','','',NULL,'','','2020-09-09 13:44:52','2020-09-14 13:04:07','ko'),(1599717926,1,'',',,',',,','LED 거실등 50 W 5,700 K','SI-GFTQ50B2A1D','',0,0,'','','','','','','','','','','N','','','','SI-GFTQ50B2A1D_thumb_01.jpg','<img title=\"212405.jpg\" src=\"/smart_editor/upload/212405.jpg\"><br style=\"clear: both;\"><br>','SI-GFTQ50B2A1D_spec.png','주거조명','','','','','소비전력 : 50 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'가족을 위한 건강조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-10 15:05:26','2020-09-14 13:04:17','ko'),(1599718480,1,'',',,',',,','LED 거실등 50 W 4,000 K','SI-GFTT50B2A1D','',0,0,'','','','','','','','','','','Y','','','','SI-GFTQ50B2A1D_thumb_01[1].jpg','<img title=\"25665.jpg\" src=\"/smart_editor/upload/25665.jpg\"><br style=\"clear: both;\"><br>','SI-GFTT50B2A1D_spec.png','주거조명','','','','','소비전력 : 50 W\r\n온도 : 4,000 K (온백색)\r\n빔각도 : 160 ˚','','','',NULL,'가족을 위한 건강조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'Y','Y','2020-09-10 15:14:40','2020-09-10 15:38:04','ko'),(1599718954,1,'',',,',',,','LED 거실등(네오) 50 W','LIH750Q86502D','',0,0,'','','','','','','','','','','Y','','','','LIH750Q86502D_thumb_01.jpg','<img title=\"909058.jpg\" src=\"/smart_editor/upload/909058.jpg\"><br style=\"clear: both;\"><br>','LIH750Q86502D_spec.png','주거조명','','','','','소비전력 : 50.0 W\r\n\r\n색온도 : 5,700 K (주광색)\r\n\r\n빔각도 : 160 ˚','','','',NULL,'가족을 위한 건강조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-10 15:22:34','2020-09-10 15:22:34','ko'),(1599719225,1,'',',,',',,','LED 거실등(할로) 50 W','LIH750Q80B11D','',0,0,'','','','','','','','','','','Y','','','','LIH750Q80B13D_thumb_01.jpg','<img title=\"761286.jpg\" src=\"/smart_editor/upload/761286.jpg\"><br style=\"clear: both;\"><br>','LIH750Q80B11D_spec[1].png','주거조명','','','','','소비전력 : 50.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'가족을 위한 건강조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-10 15:27:05','2020-09-14 14:31:28','ko'),(1599719548,1,'',',,',',,','LED 거실등(스타일렉) 50 W','LIH750Q80B13D','',0,0,'','','','','','','','','','','Y','','','','LIH750Q80B11D_thumb_01.jpg','<img title=\"320708.jpg\" src=\"/smart_editor/upload/320708.jpg\"><br style=\"clear: both;\"><br>','LIH750Q80B13D_spec.png','주거조명','','','','','소비전력 : 50.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'가족을 위한 건강조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-10 15:32:28','2020-09-14 13:03:41','ko'),(1600061798,1,'',',,',',,','LED 램프 LED MR16 7 W 3,000K','LIRM08V84001D','',0,0,'','','','','','','','','','','Y','','','','LIRM08V84001D_thumb01.jpg','<img title=\"226586.jpg\" src=\"/smart_editor/upload/226586.jpg\"><br style=\"clear: both;\"><br>','LIRM08V84001D_spec.png','LED 램프','','','','','소비전력 : 7 W\r\n색온도 : 3,000 K\r\n빔각도 : 40 ˚','','','',NULL,'화려한 분위기 속에 포인트를 주는 COB Spot램프','삼성전자 LED MR16은 고휘도 조명으로 넓은 공간에서 강조하고자 하는 아이템에 빛으로 포인트를 주는데 도움을 줍니다.','0','','','',NULL,'','Y','2020-09-14 14:36:38','2020-09-14 14:38:07','ko'),(1599790467,22,'',',,',',,','에어컨 세척 서비스(시스템 에어컨)','AI-MAINCLN01','',0,0,'','','','','','','','','','','Y','','','','AI-MAINCLN01_img.png','<img title=\"899845.jpg\" src=\"/smart_editor/upload/899845.jpg\"><br style=\"clear: both;\"><br>','','에어컨 세척 서비스','','','','','360cst\r\n4way\r\n4way 인테리어\r\n2way\r\n1way','','','',NULL,'에어컨 세척관리는 선택이 아닌 필수! 믿을 수 있는 전문 세척 서비스로 시작하세요','에어컨을 주기적으로 세척하지 않으면 성능 저하는 물론 전기료 부담, 소음 발생, 공기질 악화 등 큰 불편함을 가져올 수 있습니다. ','0','','','',NULL,'','Y','2020-09-11 11:14:27','2020-09-11 11:14:27','ko'),(1599803367,3,'',',,',',,','호텔 TV NJ570M 시리즈 123 cm','HG49NJ570MFXKR','',0,0,'','','','','','','','','','','Y','','','','prd_detailview_display.png','<img title=\"843174.png\" src=\"/smart_editor/upload/843174.png\"><br style=\"clear:both;\"><br>','','호텔 TV','','','','','놀라운 몰입감과 편리함\r\n쓰기 편리한 맞춤형 홈 메뉴\r\n효율적인 통합 네트워크 관리','','','',NULL,'완벽한 휴식을 위한 최적의 솔루션','삼성 비즈니스 TV는 호텔 관리자와 게스트가 원활하게 소통하여, 보다 수준 높은 서비스로 고객 만족을 극대화할 수 있도록 최적의 솔루션을 제공합니다. 게스트는 선명한 디스플레이 화질로 시청 몰입감을 높일 수 있으며, 편리하고 쾌적한 객실 서비스로 완벽한 휴식을 즐길 수 있습니다.','30','80cm;108cm;123cm','Y','Y',NULL,'Y','Y','2020-09-11 14:49:27','2020-09-14 16:28:29','ko'),(1599804391,8,'',',,',',,','전기레인지 인덕션 NZ63R7757SR','NZ63R7757SR','',0,0,'','','','','','','','','','','N','','','','prd_detailview_homeapp.png','<img src=\"/smart_editor/upload/859077.jpg\" title=\"859077.jpg\"><br style=\"clear:both;\"><br>','','인덕션','','','','','520*600*56 mm버너 3(1 써클, 2 플렉스존)조작 방식 터치, LED 칼라 아이스 블루','','','',NULL,'고화력 부스터로 빠르고 강력하게','모든 화구에 고화력 부스터가 적용되어 많은 음식도 짧은 시간에 조리할 수 있습니다. 고화력 부스터가 원하는 온도로 빠르게 높여주기 때문에 조리 시간을 단축할 수 있습니다.','10','검정:#000000;','Y','Y',NULL,'Y','Y','2020-09-11 15:06:31','2020-09-11 15:10:47','ko'),(1600056109,1,'',',,',',,','LED 방등 40 W 5,700K','SI-GFUQ40B1A1D','',0,0,'','','','','','','','','','','Y','','','','LIH640Q85502D_thumb_01.jpg','<img title=\"545130.jpg\" src=\"/smart_editor/upload/545130.jpg\"><br style=\"clear: both;\"><br>','SI-GFUQ40B1A1D_spec.png','주거조명','','','','','소비전력 : 40 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'눈의 피로가 적은 조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-14 13:01:49','2020-09-14 13:03:53','ko'),(1600056206,1,'',',,',',,','LED 방등 40 W 4,000K','SI-GFUT40B1A1D','',0,0,'','','','','','','','','','','Y','','','','LIH640Q85502D_thumb_01[1].jpg','<img title=\"188563.jpg\" src=\"/smart_editor/upload/188563.jpg\"><br style=\"clear: both;\"><br>','SI-GFUT40B1A1D_spec.png','주거조명','','','','','소비전력 : 40 W\r\n색온도 : 4,000 K (온백색)\r\n빔각도 : 160 ˚','','','',NULL,'눈의 피로가 적은 조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-14 13:03:26','2020-09-14 13:03:26','ko'),(1600056595,1,'',',,',',,','LED 방등(밴드) 50 W 5,700K','LIH650Q80113D','',0,0,'','','','','','','','','','','Y','','','','LIH640Q80112D_thumb_01.jpg','<img title=\"150351.jpg\" src=\"/smart_editor/upload/150351.jpg\"><br style=\"clear: both;\"><br>','LIH650Q80113D_spec.png','주거조명','','','','','소비전력 : 50.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'눈의 피로가 적은 조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-14 13:09:55','2020-09-14 13:09:55','ko'),(1600056734,1,'',',,',',,','LED 방등(침실등) 50 W 5,700K','SI-GFUQ50B1A1D','',0,0,'','','','','','','','','','','Y','','','','LIH640Q80114D_thumb_01.jpg','<img title=\"152079.jpg\" src=\"/smart_editor/upload/152079.jpg\"><br style=\"clear: both;\"><br>','SI-GFUQ50B1A1D_spec_5700k.png','주거조명','','','','','소비전력 : 50 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'눈의 피로가 적은 조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-14 13:12:14','2020-09-14 13:12:14','ko'),(1600056797,1,'',',,',',,','LED 방등(침실등) 50 W 4,000K','SI-GFUT50B1A1D','',0,0,'','','','','','','','','','','Y','','','','LIH640Q80114D_thumb_01[1].jpg','<img title=\"728068.jpg\" src=\"/smart_editor/upload/728068.jpg\"><br style=\"clear: both;\"><br>','SI-GFUT50B1A1D_spec_4000k.png','주거조명','','','','','소비전력 : 50 W\r\n색온도 : 4,000 K (온백색)\r\n빔각도 : 160 ˚','','','',NULL,'눈의 피로가 적은 조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-14 13:13:17','2020-09-14 13:13:17','ko'),(1600056896,1,'',',,',',,','LED 방등(할로) 37 W 5,700K','LIH640Q80112D','',0,0,'','','','','','','','','','','Y','','','','SI-GFUQ40B1A1D_thumb_01.jpg','<img title=\"975787.jpg\" src=\"/smart_editor/upload/975787.jpg\"><br style=\"clear: both;\"><br>','LIH640Q80112D_spec.png','주거조명','','','','','소비전력 : 37.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'눈의 피로가 적은 조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-14 13:14:56','2020-09-14 13:14:56','ko'),(1600056972,1,'',',,',',,','LED 방등(할로) 50 W 5,700K','LIH650Q80111D','',0,0,'','','','','','','','','','','Y','','','','SI-GFUT50B1A1D_thumb_01.jpg','<img title=\"194138.jpg\" src=\"/smart_editor/upload/194138.jpg\"><br style=\"clear: both;\"><br>','LIH650Q80111D_spec.png','주거조명','','','','','소비전력 : 50.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'눈의 피로가 적은 조명','다양한 공간과 조화를 이루는 모던한 디자인을 통해 공간을 고급스럽게 연출할 수 있습니다.','0','','','',NULL,'','','2020-09-14 13:16:12','2020-09-14 13:16:12','ko'),(1600057232,1,'',',,',',,','LED 식탁등(네이쳐) 21 W','LIH921T80111D','',0,0,'','','','','','','','','','','Y','','','','LIH921T80111D_thumb_01.jpg','<img title=\"802939.jpg\" src=\"/smart_editor/upload/802939.jpg\"><br style=\"clear: both;\"><br>','LIH921T80111D_spec.png','주거조명','','','','','소비전력 : 21.0 W\r\n색온도 : 4,000 K (온백색)\r\n빔각도 : 110 ˚','','','',NULL,'자연의 곡선을 형상화한 모던하고 고급스러운 디자인','조명 상단의 트레이에 다양한 생활소품을 담아 색다른 공간으로 인테리어 효과를 극대화 할 수 있습니다.','0','','','Y',NULL,'','Y','2020-09-14 13:20:32','2020-09-14 13:20:32','ko'),(1600057603,1,'',',,',',,','LED 현관 센서등(웰컴센서) 18 W','LIH818T80111D','',0,0,'','','','','','','','','','','Y','','','','LIH818T80111D_thumb_01.jpg','<img title=\"236838.jpg\" src=\"/smart_editor/upload/236838.jpg\"><br style=\"clear: both;\"><br>','LIH818T80111D_spec.png','주거조명','','','','','소비전력 : 18.0 W\r\n색온도 : 4,000 K (온백색)\r\n빔각도 : 110 ˚','','','',NULL,'심플하고 모던한 디자인','조명이 서서히 꺼지는 페이드 아웃 기능이 있고, 조도감지센서를 채용하여, 주변이 어두울 때만 작동을 하게 설정할 수 있는 편의기능을 탑재하였습니다.','0','','','',NULL,'','','2020-09-14 13:26:43','2020-09-14 13:26:43','ko'),(1600057812,1,'',',,',',,','LED 사각 방등/거실등(할로) 50 W 4,000K','LIH750T865B01D','',0,0,'','','','','','','','','','','Y','','','','LIH7A0T865B01D_thumb_01.jpg','<img title=\"63230.jpg\" src=\"/smart_editor/upload/63230.jpg\"><br style=\"clear: both;\"><br>','LIH750T865B01D_spec.png','주거조명','','','','','소비전력 : 50.0 W\r\n색온도 : 4,000 K (온백색)\r\n빔각도 : 160 ˚','','','',NULL,'자연빛을 닮아 생생한 컬러를 밝히는 조명','삼성 LED 조명 사각 거실/방등은 실내 공간에 자연스럽게 어울리면서 자연의 빛처럼 실내를 편안하고 안락하게 밝힙니다.','0','','','',NULL,'','','2020-09-14 13:30:12','2020-09-14 13:30:12','ko'),(1600057903,1,'',',,',',,','LED 사각 방등/거실등(할로) 50 W 5,700K','LIH750Q865B01D','',0,0,'','','','','','','','','','','Y','','','','LIH7A0T865B01D_thumb_01[1].jpg','<img title=\"844758.jpg\" src=\"/smart_editor/upload/844758.jpg\"><br style=\"clear: both;\"><br>','LIH750T865B01D_spec[1].png','주거조명','','','','','소비전력 : 50.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'자연빛을 닮아 생생한 컬러를 밝히는 조명','삼성 LED 조명 사각 거실/방등은 실내 공간에 자연스럽게 어울리면서 자연의 빛처럼 실내를 편안하고 안락하게 밝힙니다.','0','','','',NULL,'','','2020-09-14 13:31:43','2020-09-14 13:50:55','ko'),(1600057972,1,'',',,',',,','LED 사각 방등/거실등(할로) 100 W','LIH7A0Q865B01D','',0,0,'','','','','','','','','','','Y','','','','LIH750Q865B01D_thumb_01.jpg','<img title=\"332600.jpg\" src=\"/smart_editor/upload/332600.jpg\"><br style=\"clear: both;\"><br>','LIH7A0Q865B01D_spec.png','주거조명','','','','','소비전력 : 100.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 160 ˚','','','',NULL,'자연빛을 닮아 생생한 컬러를 밝히는 조명','삼성 LED 조명 사각 거실/방등은 실내 공간에 자연스럽게 어울리면서 자연의 빛처럼 실내를 편안하고 안락하게 밝힙니다.','0','','','',NULL,'','','2020-09-14 13:32:52','2020-09-14 13:51:04','ko'),(1600058792,1,'',',,',',,','슬림베젤 거실등 25 W ','SI-GFVQ25B2A2D','',0,0,'','','','','','','','','','','Y','','','','SI-GFVQ25B2A2D_thumb_01.jpg','<img title=\"22917.jpg\" src=\"/smart_editor/upload/22917.jpg\"><br style=\"clear: both;\"><br>','SI-GFVQ25B2A2D_spec_25w.png','주거조명','','','','','소비전력 : 25 W\r\n색온도 : 5,700 K\r\n빔각도 : 120 ⁰','','','',NULL,'모던하고 심플한 디자인','초슬림 베젤로 더 넓은 발광면적이 균일하게 빛을 비춰서 심미적인 효과를 극대화 할 수 있습니다.','30','310 × 610 x 24','','',NULL,'','','2020-09-14 13:46:32','2020-09-14 14:21:36','ko'),(1600059045,1,'',',,',',,','슬림베젤 욕실/주방등 20 W','SI-GFVQ20B2A5D','',0,0,'','','','','','','','','','','Y','','','','SI-GFVQ20B2A5D_thumb_01.jpg','<img title=\"28284.jpg\" src=\"/smart_editor/upload/28284.jpg\"><br style=\"clear: both;\"><br>','SI-GFVQ20B2A5D_spec.png','주거조명','','','','','소비전력 : 20 W\r\n색온도 : 5,700 K\r\n빔각도 : 120 ⁰','','','',NULL,'모던하고 심플한 디자인','초슬림 베젤로 더 넓은 발광면적이 균일하게 빛을 비춰서 심미적인 효과를 극대화 할 수 있습니다.','30','200 × 610 x 24','','',NULL,'','Y','2020-09-14 13:50:45','2020-09-14 14:21:13','ko'),(1600060570,1,'',',,',',,','슬림베젤 거실등 40 W 610 × 610 × 24','SI-GFVQ40B1A4D','',0,0,'','','','','','','','','','','Y','','','','SI-GFVQ40B1A4D_thumb_01.jpg','<img title=\"754986.jpg\" src=\"/smart_editor/upload/754986.jpg\"><br style=\"clear: both;\"><br>','SI-GFVQ40B1A4D_spec.png','주거조명','','','','','소비전력 : 40 W\r\n색온도 : 5,700 K\r\n빔각도 : 120 ⁰','','','',NULL,'모던하고 심플한 디자인','초슬림 베젤로 더 넓은 발광면적이 균일하게 빛을 비춰서 심미적인 효과를 극대화 할 수 있습니다.','30','610 × 610 × 24','','',NULL,'','Y','2020-09-14 14:16:10','2020-09-14 14:18:51','ko'),(1600060648,1,'',',,',',,','슬림베젤 욕실/주방등 40 W 200 × 1210 x 24','SI-GFVQ40C3A5D','',0,0,'','','','','','','','','','','Y','','','','SI-GFVQ40C3A5D_thumb_01.jpg','<img title=\"924384.jpg\" src=\"/smart_editor/upload/924384.jpg\"><br style=\"clear: both;\"><br>','SI-GFVQ40C3A5D_spec.png','주거조명','','','','','소비전력 : 40 W\r\n색온도 : 5,700 K\r\n빔각도 : 120 ⁰','','','',NULL,'모던하고 심플한 디자인','초슬림 베젤로 더 넓은 발광면적이 균일하게 빛을 비춰서 심미적인 효과를 극대화 할 수 있습니다.','30','200 × 1210 x 24','','',NULL,'','','2020-09-14 14:17:28','2020-09-14 14:18:23','ko'),(1600060993,1,'',',,',',,','슬림베젤 거실등 40 W 310 × 1210 × 24','SI-GFVQ40C3A4D','',0,0,'','','','','','','','','','','Y','','','','SI-GFVQ40C3A4D_thumb_01.jpg','<img title=\"729403.jpg\" src=\"/smart_editor/upload/729403.jpg\"><br style=\"clear: both;\"><br>','SI-GFVQ40C3A4D_spec.png','주거조명','','','','','소비전력 : 40 W\r\n색온도 : 5,700 K\r\n빔각도 : 120 ⁰','','','',NULL,'모던하고 심플한 디자인','초슬림 베젤로 더 넓은 발광면적이 균일하게 빛을 비춰서 심미적인 효과를 극대화 할 수 있습니다.','30','310 × 1210 × 24','','',NULL,'','','2020-09-14 14:23:13','2020-09-14 14:23:13','ko'),(1600061081,1,'',',,',',,','슬림베젤 안방/침실등 40 W','SI-GFVQ40B1A5D','',0,0,'','','','','','','','','','','Y','','','','SI-GFVQ40B1A5D_thumb_01.jpg','<img title=\"889042.jpg\" src=\"/smart_editor/upload/889042.jpg\"><br style=\"clear: both;\"><br>','SI-GFVQ40B1A5D_spec.png','주거조명','','','','','소비전력 : 40 W\r\n색온도 : 5,700 K\r\n빔각도 : 120 ⁰','','','',NULL,'모던하고 심플한 디자인','초슬림 베젤로 더 넓은 발광면적이 균일하게 빛을 비춰서 심미적인 효과를 극대화 할 수 있습니다.','30','510 × 510 x 24','','',NULL,'','','2020-09-14 14:24:41','2020-09-14 14:28:44','ko'),(1600061230,1,'',',,',',,','IoT 조명 50 W','SI-GFXC50B1A1D','',0,0,'','','','','','','','','','','Y','','','','SI-GFXC50B1A1D_thumb_01.jpg','<img title=\"561023.jpg\" src=\"/smart_editor/upload/561023.jpg\"><br style=\"clear: both;\"><br>','SI-GFXC50B1A1D_spec.png','IoT 조명','','','','','소비전력 : 50 W\r\n색온도 : 2700 ~ 6500 K\r\n빔각도 : 160 ˚','','','',NULL,'삼성 IoT LED 조명','스마트싱스(SmartThings)로 모든 IoT(사물인터넷)가전을 연결하고 빅스비(Bixby)를 통해 음성제어까지 할 수 있으며 밝기 제어부터 스케줄 제어까지 다양한 기능을 더욱 편리하게 사용할 수 있습니다.','0','','','',NULL,'','Y','2020-09-14 14:27:10','2020-09-14 14:52:14','ko'),(1600062043,1,'',',,',',,','LED 램프 LED MR16 7 W 5,000K','LIRM08R84001D','',0,0,'','','','','','','','','','','Y','','','','LIRM08R84001D_thumb01.jpg','<img title=\"184906.jpg\" src=\"/smart_editor/upload/184906.jpg\"><br style=\"clear: both;\"><br>','LIRM08R84001D_spec.png','LED 램프','','','','','소비전력 : 7 W\r\n색온도 : 5,000 K\r\n빔각도 : 40 ˚','','','',NULL,'화려한 분위기 속에 포인트를 주는 COB Spot 램프','삼성전자 LED MR16은 고휘도 조명으로 넓은 공간에서 강조하고자 하는 아이템에 빛으로 포인트를 주는데 도움을 줍니다.','0','','','',NULL,'','','2020-09-14 14:40:43','2020-09-14 14:40:43','ko'),(1600062281,1,'',',,',',,','LED 램프 G95 Bulb 11.5 W','LIRB12W8A6C01D','',0,0,'','','','','','','','','','','Y','','','','LIRB12W8A6C01D_thumb_01.jpg','<img title=\"658171.jpg\" src=\"/smart_editor/upload/658171.jpg\"><br style=\"clear: both;\"><br>','LIRB12W8A6C01D_spec.png','LED 램프','','','','','소비전력 : 11.5 W\r\n색온도 : 2,700 K (전구색)\r\n빔각도 : 180 ˚','','','',NULL,'다양한 인테리어 환경과 조화를 이룰 수 있는 백열램프 75 W 대체 LED 램프','다양한 공간에서의 활용 가능한 조명으로 인테리어 환경과 조화를 이룹니다.','0','','','',NULL,'','','2020-09-14 14:44:41','2020-09-14 14:44:41','ko'),(1600062511,1,'',',,',',,','LED 램프 Bulb 12.2 W 5,000K','GB8RH3012AF1KR','',0,0,'','','','','','','','','','','Y','','','','GB8WH3109AH1KR_thumb_01.jpg','<img title=\"343789.jpg\" src=\"/smart_editor/upload/343789.jpg\"><br style=\"clear: both;\"><br>','GB8RH3012AF1KR_spec_12.2w 5000k.png','LED 램프','','','','','소비전력 : 12.2 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 180 ˚','','','',NULL,'어디에나 어울리는 조명','일반적인 전구와 매우 유사해 보이는 매끄러운 finless 디자인을 갖추고 있습니다. 삼성 LED 조명 Bulb(E26 베이스)는 기존 전구를 빼고 그 자리에 바로 교체가 가능합니다.','0','','','',NULL,'','','2020-09-14 14:48:31','2020-09-14 14:48:31','ko'),(1600062600,1,'',',,',',,','LED 램프 Bulb 12.2 W 2,700K','GB8WH3012AF1KR','',0,0,'','','','','','','','','','','Y','','','','GB8WH3109AH1KR_thumb_02.jpg','<img title=\"389722.jpg\" src=\"/smart_editor/upload/389722.jpg\"><br style=\"clear: both;\"><br>','GB8WH3012AF1KR_spec_12.2w 2700k.png','LED 램프','','','','','소비전력 : 12.2 W\r\n색온도 : 2,700 K (전구색)\r\n빔각도 : 180 ˚','','','',NULL,'어디에나 어울리는 조명','일반적인 전구와 매우 유사해 보이는 매끄러운 finless 디자인을 갖추고 있습니다. 삼성 LED 조명 Bulb(E26 베이스)는 기존 전구를 빼고 그 자리에 바로 교체가 가능합니다.','0','','','',NULL,'','','2020-09-14 14:50:00','2020-09-14 15:11:43','ko'),(1600062659,1,'',',,',',,','LED 램프 Bulb 6.3 W','GB8WH3107AH1KR','',0,0,'','','','','','','','','','','Y','','','','GB8WH3109AH1KR_thumb_02[1].jpg','<img title=\"391482.jpg\" src=\"/smart_editor/upload/391482.jpg\"><br style=\"clear: both;\"><br>','GB8RH3012AF1KR_spec_6.3w 2700k.png','LED 램프','','','','','소비전력 : 6.3 W\r\n색온도 : 2,700 K (전구색)\r\n빔각도 : 180 ˚','','','',NULL,'어디에나 어울리는 조명','일반적인 전구와 매우 유사해 보이는 매끄러운 finless 디자인을 갖추고 있습니다. 삼성 LED 조명 Bulb(E26 베이스)는 기존 전구를 빼고 그 자리에 바로 교체가 가능합니다.','0','','','',NULL,'','','2020-09-14 14:50:59','2020-09-14 15:11:53','ko'),(1600062920,1,'',',,',',,','LED 램프 MR16 3 W 5,000K','GM8RH3003AD1KR','',0,0,'','','','','','','','','','','Y','','','','GM8RH3003AD1KR_thumb_01.jpg','<img title=\"926932.jpg\" src=\"/smart_editor/upload/926932.jpg\"><br style=\"clear: both;\"><br>','GM8RH3003AD1KR_spec_3w 5000k.png','LED 램프','','','','','소비전력 : 3.0 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 40 ˚','','','',NULL,'화려한 분위기 속에 포인트를 주는 조명','삼성 LED 조명 MR16은 고휘도 조명으로 넓은 공간에서 강조하고자 하는 아이템에 포인트를 주는데 도움을 줍니다. 자외선과 같은 유해파장이 없어 열에 민감한 대상을 비추는데 적합합니다.','0','','','',NULL,'','','2020-09-14 14:55:20','2020-09-14 14:55:20','ko'),(1600062995,1,'',',,',',,','LED 램프 MR16 3 W 2,700K','GM8WH3003AD1KR','',0,0,'','','','','','','','','','','Y','','','','GM8RH3003AD1KR_thumb_01[1].jpg','<img title=\"182245.jpg\" src=\"/smart_editor/upload/182245.jpg\"><br style=\"clear: both;\"><br>','GM8RH3003AD1KR_spec_3w 2700k.png','LED 램프','','','','','소비전력 : 3.0 W\r\n색온도 : 2,700 K (전구색)\r\n빔각도 : 40 ˚','','','',NULL,'화려한 분위기 속에 포인트를 주는 조명','삼성 LED 조명 MR16은 고휘도 조명으로 넓은 공간에서 강조하고자 하는 아이템에 포인트를 주는데 도움을 줍니다. 자외선과 같은 유해파장이 없어 열에 민감한 대상을 비추는데 적합합니다.','0','','','',NULL,'','','2020-09-14 14:56:35','2020-09-14 14:56:35','ko'),(1600063570,1,'',',,',',,','LED 램프 PAR30 12 W 5,000K 25 ˚','GD8RH5012BB2KR','',0,0,'','','','','','','','','','','Y','','','','GD8WH5012BB2KR_thumb_01.jpg','<img title=\"393429.jpg\" src=\"/smart_editor/upload/393429.jpg\"><br style=\"clear: both;\"><br>','GD8RH5012BB2KR_spec_12w 5000k 25.png','LED 램프','','','','','소비전력 : 12.0 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 25 ˚\r\n사이즈 (MM) : Φ95 x 113','','','',NULL,'다양한 사물의 전시효과를 높이는 최적의 전시 조명','UV가 없고 IR이 매우 적어 열에 민감한 대상(예술 작품, 음식, 섬유, 화장품 등)을 비추는데 적합합니다. 국부조명과 일반조명으로 미술관, 매장, 거실 등 전시환경에 맞도록 빔각도(25 ˚ / 40 ˚)를 선택하여 전시효과를 높일 수 있습니다.','0','','','',NULL,'','','2020-09-14 15:06:10','2020-09-14 15:10:00','ko'),(1600063680,1,'',',,',',,','LED 램프 PAR30 12 W 2,700K 25 ˚','GD8WH5012BB2KR','',0,0,'','','','','','','','','','','Y','','','','GD8WH5012BB2KR_thumb_01[1].jpg','<img title=\"188628.jpg\" src=\"/smart_editor/upload/188628.jpg\"><br style=\"clear: both;\"><br>','GD8WH5012BB2KR_spec_12w 2700k 25.png','LED 램프','','','','','소비전력 : 12.0 W\r\n색온도 : 2,700 K (전구색)\r\n빔각도 : 25 ˚\r\n사이즈 (MM) : Φ95 x 113','','','',NULL,'다양한 사물의 전시효과를 높이는 최적의 전시 조명','UV가 없고 IR이 매우 적어 열에 민감한 대상(예술 작품, 음식, 섬유, 화장품 등)을 비추는데 적합합니다. 국부조명과 일반조명으로 미술관, 매장, 거실 등 전시환경에 맞도록 빔각도(25 ˚ / 40 ˚)를 선택하여 전시효과를 높일 수 있습니다.','0','','','',NULL,'','','2020-09-14 15:08:00','2020-09-14 15:10:14','ko'),(1600063892,1,'',',,',',,','LED 램프 PAR30 12 W 5,000K 40 ˚','GD8RH5012BD2KR','',0,0,'','','','','','','','','','','Y','','','','GD8WH5012BB2KR_thumb_01[2].jpg','<img title=\"114052.jpg\" src=\"/smart_editor/upload/114052.jpg\"><br style=\"clear: both;\"><br>','GD8RH5012BD2KR_spec_12w 5000k 40.png','LED 램프','','','','','소비전력 : 12.0 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 40 ˚\r\n사이즈 (MM) : Φ95 x 113','','','',NULL,'다양한 사물의 전시효과를 높이는 최적의 전시 조명','UV가 없고 IR이 매우 적어 열에 민감한 대상(예술 작품, 음식, 섬유, 화장품 등)을 비추는데 적합합니다. 국부조명과 일반조명으로 미술관, 매장, 거실 등 전시환경에 맞도록 빔각도(25 ˚ / 40 ˚)를 선택하여 전시효과를 높일 수 있습니다.','0','','','',NULL,'','','2020-09-14 15:11:32','2020-09-14 15:11:32','ko'),(1600063986,1,'',',,',',,','LED 램프 PAR30 12 W 2,700K 40 ˚','GD8WH5012BD2KR','',0,0,'','','','','','','','','','','Y','','','','GD8WH5012BB2KR_thumb_01[3].jpg','<img title=\"335551.jpg\" src=\"/smart_editor/upload/335551.jpg\"><br style=\"clear: both;\"><br>','GD8WH5012BD2KR_spec_12w 2700k 40.png','LED 램프','','','','','소비전력 : 12.0 W\r\n색온도 : 2,700 K (전구색)\r\n빔각도 : 40 ˚\r\n사이즈 (MM) : Φ95 x 113','','','',NULL,'다양한 사물의 전시효과를 높이는 최적의 전시 조명','UV가 없고 IR이 매우 적어 열에 민감한 대상(예술 작품, 음식, 섬유, 화장품 등)을 비추는데 적합합니다. 국부조명과 일반조명으로 미술관, 매장, 거실 등 전시환경에 맞도록 빔각도(25 ˚ / 40 ˚)를 선택하여 전시효과를 높일 수 있습니다.','0','','','',NULL,'','','2020-09-14 15:13:06','2020-09-14 15:17:12','ko'),(1600064215,1,'',',,',',,','골프장 조명 1,200 W','SL-GFERL0B1A1D','',0,0,'','','','','','','','','','','Y','','','','SL-GFERL0B1A1D_thumb_01.jpg','<img title=\"830536.jpg\" src=\"/smart_editor/upload/830536.jpg\"><br style=\"clear: both;\"><br>','SL-GFERL0B1A1D_spec.png','스포츠조명','','','','','소비전력 : 1,200 W\r\n색온도 : 5,000K','','','',NULL,'야간골프의 새로운 시대를 열다','균일한 밝기를 구현하는 멀티 셀기술과 조명 반사판(Reflector) 기술로','0','','','',NULL,'','','2020-09-14 15:16:55','2020-09-14 15:16:55','ko'),(1600064416,1,'',',,',',,','골프장 조명 800 W','SL-GFEQH0B1A2D','',0,0,'','','','','','','','','','','Y','','','','SL-GFEQH0B1A2D_thumb_01.jpg','<img title=\"312214.jpg\" src=\"/smart_editor/upload/312214.jpg\"><br style=\"clear: both;\"><br>','SL-GFEQH0B1A2D_spec_800w.png','스포츠조명','','','','','소비전력 : 800 W<br>색온도 : 5,700 K<br>빔 각도 : 10,15,20,25,30,38,45,60 (°)','','','',NULL,'골프장 조명의 새로운 기준','국내 최고 수준의 광효율 140 lm/W로 고효율 인증을 취득, 에너지 절감 극대화 및 한전 LED효율향상 사업 지원금 혜택이 가능합니다.','0','','','',NULL,'','','2020-09-14 15:20:16','2020-09-14 16:09:57','ko'),(1600064675,1,'',',,',',,','골프장 조명 1,000 W','SL-GFEQJ0B1A2D','',0,0,'','','','','','','','','','','Y','','','','SL-GFEQJ0B1A2D_thumb_01.jpg','<img title=\"261135.jpg\" src=\"/smart_editor/upload/261135.jpg\"><br style=\"clear: both;\"><br>','SL-GFEQJ0B1A2D_spec_10002.png','스포츠조명','','','','','소비전력 : 1,000 W\r\n색온도 : 5,700 K\r\n빔 각도 : 10,15,20,25,30,38,45,60 (°)','','','',NULL,'골프장 조명의 새로운 기준','국내 최고 수준의 광효율 140 lm/W로 고효율 인증을 취득, 에너지 절감 극대화 및 한전 LED효율향상 사업 지원금 혜택이 가능합니다.','0','','','',NULL,'','','2020-09-14 15:24:35','2020-09-14 15:24:35','ko'),(1600065236,1,'',',,',',,','LED 고천장등 75 W 60 ˚','LIF575Q860C11D','',0,0,'','','','','','','','','','','Y','','','','LIF575Q8A1C11D_thumb_01.jpg','<img title=\"476186.jpg\" src=\"/smart_editor/upload/476186.jpg\"><br style=\"clear: both;\"><br>','LIF575Q860C11D_spec.png','산업/상업조명','','','','','소비전력 : 75.0 W\r\n색온도 : 5,700 K (주광색)\r\n사이즈 (MM) : Φ296 x 163\r\n빔각도 : 60 ˚','','','',NULL,'현장 공간에서의 업무능력 향상','충분한 밝기와 균일한 조명은 현장에서 업무 능력을 향상시키고 쾌적한 조명 환경은 사용자의 피로도 감소, 안전사고 방지에 기여합니다.','0','','','',NULL,'','','2020-09-14 15:33:56','2020-09-14 15:33:56','ko'),(1600065309,1,'',',,',',,','LED 고천장등 75 W 110 ˚','LIF575Q8A1C11D','',0,0,'','','','','','','','','','','Y','','','','LIF575Q8A1C11D_thumb_01[1].jpg','<img title=\"238374.jpg\" src=\"/smart_editor/upload/238374.jpg\"><br style=\"clear: both;\"><br>','LIF575Q860C11D_spec[1].png','산업/상업조명','','','','','소비전력 : 75.0 W\r\n색온도 : 5,700 K (주광색)\r\n사이즈 (MM) : Φ296 x 163\r\n빔각도 : 110 ˚','','','',NULL,'현장 공간에서의 업무능력 향상','충분한 밝기와 균일한 조명은 현장에서 업무 능력을 향상시키고 쾌적한 조명 환경은 사용자의 피로도 감소, 안전사고 방지에 기여합니다.','0','','','',NULL,'','','2020-09-14 15:35:09','2020-09-14 15:35:09','ko'),(1600065387,1,'',',,',',,','LED 고천장등 120 W 60 ˚','LIF5A2Q860C12D','',0,0,'','','','','','','','','','','Y','','','','LIF5A2Q860C12D_thumb_01.jpg','<img title=\"657330.jpg\" src=\"/smart_editor/upload/657330.jpg\"><br style=\"clear: both;\"><br>','LIF5A2Q860C12D_spec.png','산업/상업조명','','','','','소비전력 : 120.0 W\r\n색온도 : 5,700 K (주광색)\r\n사이즈 (MM) : Φ288 x 173\r\n빔각도 : 60 ˚','','','',NULL,'현장 공간에서의 업무능력 향상','충분한 밝기와 균일한 조명은 현장에서 업무 능력을 향상시키고 쾌적한 조명 환경은 사용자의 피로도 감소, 안전사고 방지에 기여합니다.','0','','','',NULL,'','','2020-09-14 15:36:27','2020-09-14 15:37:59','ko'),(1600065462,1,'',',,',',,','LED 고천장등 120 W 110 ˚','LIF5A2Q8A1C12D','',0,0,'','','','','','','','','','','Y','','','','LIF5A2Q860C12D_thumb_01[1].jpg','<img title=\"170118.jpg\" src=\"/smart_editor/upload/170118.jpg\"><br style=\"clear: both;\"><br>','LIF5A2Q860C12D_spec[1].png','산업/상업조명','','','','','소비전력 : 120.0 W\r\n색온도 : 5,700 K (주광색)\r\n사이즈 (MM) : Φ288 x 173\r\n빔각도 : 110 ˚','','','',NULL,'현장 공간에서의 업무능력 향상','충분한 밝기와 균일한 조명은 현장에서 업무 능력을 향상시키고 쾌적한 조명 환경은 사용자의 피로도 감소, 안전사고 방지에 기여합니다.','0','','','',NULL,'','','2020-09-14 15:37:42','2020-09-14 15:37:42','ko'),(1600065661,1,'',',,',',,','LED 다운라이트 10 W 4,000K','LID310T860C11D','',0,0,'','','','','','','','','','','Y','','','','LID323Q88C12D_thumb_01.jpg','<img title=\"804128.jpg\" src=\"/smart_editor/upload/804128.jpg\"><br style=\"clear: both;\"><br>','LID310T860C11D_spec_4000k.png','산업/상업조명','','','','','소비전력 : 10.0 W\r\n색온도 : 4,000 K (온백색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : Φ175 x 88','','','',NULL,'다양한 인테리어를 더욱 돋보이게 하는 LED조명','다양한 실내 공간에서 활용이 가능하여 공간 인테리어에 탁월할 뿐만 아니라 뛰어난 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 15:41:01','2020-09-14 15:41:01','ko'),(1600065745,1,'',',,',',,','LED 다운라이트 10 W 5,000K Φ175 x 88','LID310R860C11D','',0,0,'','','','','','','','','','','N','','','','LID323Q88C12D_thumb_01[1].jpg','<img title=\"890198.jpg\" src=\"/smart_editor/upload/890198.jpg\"><br style=\"clear: both;\"><br>','LID310R860C11D_spec_5000k 175.png','산업/상업조명','','','','','소비전력 : 10.0 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 110 ˚\r\n사이즈 (MM) : Φ175 x 88','','','',NULL,'다양한 인테리어를 더욱 돋보이게 하는 LED조명','다양한 실내 공간에서 활용이 가능하여 공간 인테리어에 탁월할 뿐만 아니라 뛰어난 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 15:42:25','2020-09-14 15:42:25','ko'),(1600065823,1,'',',,',',,','LED 다운라이트 10 W 5,000K Φ164 x 79','LID310R860C12D','',0,0,'','','','','','','','','','','Y','','','','LID323Q88C12D_thumb_01[2].jpg','<img title=\"86173.jpg\" src=\"/smart_editor/upload/86173.jpg\"><br style=\"clear: both;\"><br>','LID310R860C12D_spec_5000k 164.png','산업/상업조명','','','','','소비전력 : 10.0 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : Φ164 x 79\r\n','','','',NULL,'다양한 인테리어를 더욱 돋보이게 하는 LED조명','다양한 실내 공간에서 활용이 가능하여 공간 인테리어에 탁월할 뿐만 아니라 뛰어난 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 15:43:43','2020-09-14 15:43:43','ko'),(1600066286,1,'',',,',',,','LED 다운라이트 15 W 5,000K Φ164 x 79','LID315R860C12D','',0,0,'','','','','','','','','','','Y','','','','LID315R860C11D_thumb_01[3].jpg','<img title=\"745117.jpg\" src=\"/smart_editor/upload/745117.jpg\"><br style=\"clear: both;\"><br>','LID315R860C12D_spec_5000k 164[1].png','산업/상업조명','','','','','소비전력 : 15.0 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : Φ164 x 79','','','',NULL,'다양한 인테리어를 더욱 돋보이게 하는 LED조명','다양한 실내 공간에서 활용이 가능하여 공간 인테리어에 탁월할 뿐만 아니라 뛰어난 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 15:51:26','2020-09-14 15:51:26','ko'),(1600066209,1,'',',,',',,','LED 다운라이트 15 W 5,000K Φ175 x 88','LID315R860C11D','',0,0,'','','','','','','','','','','Y','','','','LID315R860C11D_thumb_01[2].jpg','<img title=\"716931.jpg\" src=\"/smart_editor/upload/716931.jpg\"><br style=\"clear: both;\"><br>','LID315R860C11D_spec_5000k 175[1].png','산업/상업조명','','','','','소비전력 : 15.0 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 110 ˚\r\n사이즈 (MM) : Φ175 x 88','','','',NULL,'다양한 인테리어를 더욱 돋보이게 하는 LED조명','다양한 실내 공간에서 활용이 가능하여 공간 인테리어에 탁월할 뿐만 아니라 뛰어난 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 15:50:09','2020-09-14 15:50:09','ko'),(1600067581,1,'',',,',',,','LED 다운라이트 15 W 4,000K','LID315T860C11D','',0,0,'','','','','','','','','','','Y','','','','LID315R860C11D_thumb_01[4].jpg','<img title=\"681739.jpg\" src=\"/smart_editor/upload/681739.jpg\"><br style=\"clear: both;\"><br>','LID315T860C11D_spec_4000k 175.png','산업/상업조명','','','','','소비전력 : 15.0 W\r\n색온도 : 4,000 K (온백색)\r\n빔각도 : 110 ˚\r\n사이즈 (MM) : Φ175 x 88','','','',NULL,'다양한 인테리어를 더욱 돋보이게 하는 LED조명','다양한 실내 공간에서 활용이 가능하여 공간 인테리어에 탁월할 뿐만 아니라 뛰어난 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 16:13:01','2020-09-14 16:13:01','ko'),(1600067693,1,'',',,',',,','LED 다운라이트 15 W 5,700K ','LID315Q860C12D','',0,0,'','','','','','','','','','','Y','','','','LID315R860C11D_thumb_01[5].jpg','<img src=\"/smart_editor/upload/447877.jpg\" title=\"447877.jpg\"><br style=\"clear:both;\"><br>','LID315Q860C12D_spec_5700k 164.png','산업/상업조명','','','','','소비전력 : 15.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : Φ164 x 79','','','',NULL,'다양한 인테리어를 더욱 돋보이게 하는 LED조명','다양한 실내 공간에서 활용이 가능하여 공간 인테리어에 탁월할 뿐만 아니라 뛰어난 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 16:14:53','2020-09-14 16:14:53','ko'),(1600067773,1,'',',,',',,','LED 다운라이트 20 W','LID320R860C12D','',0,0,'','','','','','','','','','','Y','','','','LID315Q860C12D_thumb_01.jpg','<img src=\"/smart_editor/upload/122598.jpg\" title=\"122598.jpg\"><br style=\"clear:both;\"><br>','LID320R860C12D_spec.png','산업/상업조명','','','','','소비전력 : 20.0 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : Φ164 x 79','','','',NULL,'다양한 인테리어를 더욱 돋보이게 하는 LED조명','다양한 실내 공간에서 활용이 가능하여 공간 인테리어에 탁월할 뿐만 아니라 뛰어난 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 16:16:13','2020-09-14 16:16:13','ko'),(1600067840,1,'',',,',',,','LED 다운라이트 23 W','LID323Q88C12D','',0,0,'','','','','','','','','','','Y','','','','LID310T860C11D_thumb_01.jpg','<img src=\"/smart_editor/upload/676058.jpg\" title=\"676058.jpg\"><br style=\"clear:both;\"><br>','LID323Q88C12D_spec.png','산업/상업조명','','','','','소비전력 : 23.0 W\r\n색온도 : 5,700 K (주광색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : Φ234 x 130','','','',NULL,'다양한 인테리어를 더욱 돋보이게 하는 LED조명','다양한 실내 공간에서 활용이 가능하여 공간 인테리어에 탁월할 뿐만 아니라 뛰어난 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 16:17:20','2020-09-14 16:17:20','ko'),(1600068124,1,'',',,',',,','LED 무타공 엣지 평판등(M바) 29.5 W 620 x 620 x 15.7','LIANH30R8B11PA','',0,0,'','','','','','','','','','','Y','','','','sec-commercial-lamp-non-hole-edge-flat-lianh30r8b11pa-82218659.webp','<img src=\"/smart_editor/upload/995100.jpg\" title=\"995100.jpg\"><br style=\"clear:both;\"><br>','LIANH30R8B11PA_spec.png','산업/상업조명','','','','','소비전력 : 29.5 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : 620 x 620 x 15.7\r\n거치형태 : M 바','','','',NULL,'타공이 필요 없는 초슬림 평판조명','슬림한 디자인(14.7 mm)으로 천장에 별도의 타공 없이 손쉽게 설치가 가능하며, 사무공간 뿐만 아니라 일반 가정에서도 이상적인 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 16:22:04','2020-09-14 16:22:04','ko'),(1600068242,1,'',',,',',,','LED 무타공 엣지 평판등(T바) 29.5 W 598 x 598 x 15.7','LIANH30R8B12PD','',0,0,'','','','','','','','','','','Y','','','','sec-commercial-lamp-non-hole-edge-flat-lianh30r8b12pd-82222450.webp','<img src=\"\" title=\"\"><img src=\"\" title=\"\"><img src=\"/smart_editor/upload/487276.jpg\" title=\"487276.jpg\"><br style=\"clear:both;\"><br>','LIANH30R8B12PD_spec.png','산업/상업조명','','','','','소비전력 : 29.5 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : 598 x 598 x 15.7\r\n거치형태 : T 바','','','',NULL,'타공이 필요 없는 초슬림 평판조명','슬림한 디자인(14.7 mm)으로 천장에 별도의 타공 없이 손쉽게 설치가 가능하며, 사무공간 뿐만 아니라 일반 가정에서도 이상적인 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 16:24:02','2020-09-14 16:24:17','ko'),(1600068345,1,'',',,',',,','LED 무타공 엣지 평판등(M바) 29.5 W 320 x 1,280 x 15.7','LIANH30R8C11PA','',0,0,'','','','','','','','','','','Y','','','','sec-commercial-lamp-non-hole-edge-flat-lianh30r8c11pa-82024100.webp','<img src=\"\" title=\"\"><img src=\"/smart_editor/upload/945035.jpg\" title=\"945035.jpg\"><br style=\"clear:both;\"><br>','LIANH30R8C11PA_spec.png','산업/상업조명','','','','','소비전력 : 29.5 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : 320 x 1,280 x 15.7\r\n거치형태 : M 바','','','',NULL,'타공이 필요 없는 초슬림 평판조명','슬림한 디자인(14.7 mm)으로 천장에 별도의 타공 없이 손쉽게 설치가 가능하며, 사무공간 뿐만 아니라 일반 가정에서도 이상적인 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 16:25:45','2020-09-14 16:25:45','ko'),(1600068444,1,'',',,',',,','LED 무타공 엣지 평판등(T바) 29.5 W 298 x 1,198 x 15.7','LIANH30R8C12PD','',0,0,'','','','','','','','','','','Y','','','','sec-commercial-lamp-non-hole-edge-flat-lianh30r8c12pd-82222334.jpg','<img src=\"\" title=\"\"><img src=\"/smart_editor/upload/46820.jpg\" title=\"46820.jpg\"><br style=\"clear:both;\"><br>','LIANH30R8C12PD_spec.png','산업/상업조명','','','','','소비전력 : 29.5 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : 298 x 1,198 x 15.7\r\n거치형태: T 바','','','',NULL,'타공이 필요 없는 초슬림 평판조명','슬림한 디자인(14.7 mm)으로 천장에 별도의 타공 없이 손쉽게 설치가 가능하며, 사무공간 뿐만 아니라 일반 가정에서도 이상적인 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 16:27:24','2020-09-14 16:27:24','ko'),(1600068446,1,'',',,',',,','LED 무타공 엣지 평판등(T바) 29.5 W 298 x 1,198 x 15.7','LIANH30R8C12PD','',0,0,'','','','','','','','','','','Y','','','','sec-commercial-lamp-non-hole-edge-flat-lianh30r8c12pd-82222334[2].jpg','<img src=\"\" title=\"\"><img src=\"/smart_editor/upload/46820.jpg\" title=\"46820.jpg\"><br style=\"clear:both;\"><br>','LIANH30R8C12PD_spec[2].png','산업/상업조명','','','','','소비전력 : 29.5 W\r\n색온도 : 5,000 K (주백색)\r\n빔각도 : 120 ˚\r\n사이즈 (MM) : 298 x 1,198 x 15.7\r\n거치형태: T 바','','','',NULL,'타공이 필요 없는 초슬림 평판조명','슬림한 디자인(14.7 mm)으로 천장에 별도의 타공 없이 손쉽게 설치가 가능하며, 사무공간 뿐만 아니라 일반 가정에서도 이상적인 조명 환경을 제공합니다.','0','','','',NULL,'','','2020-09-14 16:27:26','2020-09-14 16:27:26','ko');

--
-- Table structure for table `TB_PRODUCT_DETAIL`
--

CREATE TABLE `TB_PRODUCT_DETAIL` (
  `idx` int(11) NOT NULL,
  `prod_id` int(11) NOT NULL,
  `spec_type` varchar(20) NOT NULL,
  `spec_name` varchar(100) NOT NULL,
  `spec_value` varchar(100) NOT NULL,
  `spec_condition` varchar(100) NOT NULL,
  `spec_min` varchar(100) NOT NULL,
  `spec_typ` varchar(100) NOT NULL,
  `spec_max` varchar(100) NOT NULL,
  `spec_unit` varchar(10) NOT NULL,
  `seq` int(11) NOT NULL,
  `bbs_site` varchar(20) NOT NULL,
  `insert_date` datetime NOT NULL,
  `insert_empid` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_PRODUCT_DETAIL`
--


--
-- Table structure for table `TB_PRODUCT_FILE`
--

CREATE TABLE `TB_PRODUCT_FILE` (
  `file_id` int(11) NOT NULL DEFAULT '0',
  `file_name` varchar(100) DEFAULT NULL,
  `file_path` varchar(100) DEFAULT NULL,
  `file_size` varchar(20) DEFAULT NULL,
  `bbs_id` varchar(10) DEFAULT NULL,
  `mgr_id` varchar(20) DEFAULT NULL,
  `prod_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_PRODUCT_FILE`
--

INSERT INTO `TB_PRODUCT_FILE` VALUES (1,'957fa686edc1669b0acbd3cc121279a2_1516777795_9748[1].jpg','/var/www/html/upload/product','51000','1599281142',NULL,1599281142),(2,'forte-04[2].png','/var/www/html/upload/product','394177','1599281142',NULL,1599281142),(3,'LIA040Q8B2C11D_thumb_02.jpg','/var/www/html/upload/product','70717','1599622012',NULL,1599622012),(4,'SI-GFYT20B2A1D_thumb_02.jpg','/var/www/html/upload/product','56152','1599623205',NULL,1599623205),(5,'SI-GFYT20B2A1D_thumb_03.jpg','/var/www/html/upload/product','37715','1599623205',NULL,1599623205),(6,'SI-GFYT20B2A1D_thumb_04.jpg','/var/www/html/upload/product','53125','1599623205',NULL,1599623205),(7,'SI-GFYT40C3A1D_thumb_02.jpg','/var/www/html/upload/product','56138','1599625712',NULL,1599625712),(8,'SI-GFYT40C3A1D_thumb_03.jpg','/var/www/html/upload/product','37701','1599625712',NULL,1599625712),(9,'SI-GFYT40C3A1D_thumb_04.jpg','/var/www/html/upload/product','53111','1599625712',NULL,1599625712),(10,'SI-GFYT20B2A1D_thumb_02[1].jpg','/var/www/html/upload/product','56152','1599626341',NULL,1599626341),(11,'SI-GFYT20B2A1D_thumb_03[1].jpg','/var/www/html/upload/product','37715','1599626341',NULL,1599626341),(12,'SI-GFYT20B2A1D_thumb_04[1].jpg','/var/www/html/upload/product','53125','1599626341',NULL,1599626341),(13,'SI-GFYT40C3A1D_thumb_02[1].jpg','/var/www/html/upload/product','56138','1599626692',NULL,1599626692),(14,'SI-GFYT40C3A1D_thumb_03[1].jpg','/var/www/html/upload/product','37701','1599626692',NULL,1599626692),(15,'SI-GFYT40C3A1D_thumb_04[1].jpg','/var/www/html/upload/product','53111','1599626692',NULL,1599626692),(16,'SI-GFTQ50B2A1D_thumb_02.jpg','/var/www/html/upload/product','61947','1599717926',NULL,1599717926),(17,'SI-GFTQ50B2A1D_thumb_02[1].jpg','/var/www/html/upload/product','61947','1599718480',NULL,1599718480),(18,'LIH750Q86502D_thumb_02.jpg','/var/www/html/upload/product','66534','1599718954',NULL,1599718954),(19,'LIH750Q80B13D_thumb_02.jpg','/var/www/html/upload/product','91485','1599719225',NULL,1599719225),(20,'LIH750Q80B11D_thumb_02.jpg','/var/www/html/upload/product','109924','1599719548',NULL,1599719548),(21,'LIH640Q85502D_thumb_02.jpg','/var/www/html/upload/product','112178','1600056109',NULL,1600056109),(22,'LIH640Q85502D_thumb_02[1].jpg','/var/www/html/upload/product','112178','1600056206',NULL,1600056206),(23,'SI-GFUT40B1A1D_thumb_02.jpg','/var/www/html/upload/product','84616','1600056383',NULL,1600056383),(24,'SI-GFUQ50B1A1D_thumb_02.jpg','/var/www/html/upload/product','112284','1600056497',NULL,1600056497),(25,'LIH640Q80112D_thumb_02.jpg','/var/www/html/upload/product','102451','1600056595',NULL,1600056595),(26,'LIH640Q80114D_thumb_02.jpg','/var/www/html/upload/product','113965','1600056734',NULL,1600056734),(27,'LIH640Q80114D_thumb_02[1].jpg','/var/www/html/upload/product','113965','1600056797',NULL,1600056797),(28,'SI-GFUQ40B1A1D_thumb_02.jpg','/var/www/html/upload/product','90338','1600056896',NULL,1600056896),(29,'SI-GFUT50B1A1D_thumb_02.jpg','/var/www/html/upload/product','85104','1600056972',NULL,1600056972),(30,'LIH921T80111D_thumb_02.jpg','/var/www/html/upload/product','88464','1600057232',NULL,1600057232),(31,'LIH921T80111D_thumb_03.jpg','/var/www/html/upload/product','109279','1600057232',NULL,1600057232),(32,'LIH818T80111D_thumb_02.jpg','/var/www/html/upload/product','92674','1600057603',NULL,1600057603),(33,'LIH818T80111D_thumb_03.jpg','/var/www/html/upload/product','154210','1600057603',NULL,1600057603),(34,'LIH7A0T865B01D_thumb_02.jpg','/var/www/html/upload/product','92973','1600057812',NULL,1600057812),(35,'LIH7A0T865B01D_thumb_03.jpg','/var/www/html/upload/product','54864','1600057812',NULL,1600057812),(36,'LIH7A0T865B01D_thumb_04.jpg','/var/www/html/upload/product','46158','1600057812',NULL,1600057812),(37,'LIH7A0T865B01D_thumb_02[1].jpg','/var/www/html/upload/product','92973','1600057903',NULL,1600057903),(38,'LIH7A0T865B01D_thumb_03[1].jpg','/var/www/html/upload/product','54864','1600057903',NULL,1600057903),(39,'LIH7A0T865B01D_thumb_04[1].jpg','/var/www/html/upload/product','46158','1600057903',NULL,1600057903),(40,'LIH750Q865B01D_thumb_02.jpg','/var/www/html/upload/product','92973','1600057972',NULL,1600057972),(41,'LIH750Q865B01D_thumb_03.jpg','/var/www/html/upload/product','54864','1600057972',NULL,1600057972),(42,'LIH750Q865B01D_thumb_04.jpg','/var/www/html/upload/product','46158','1600057972',NULL,1600057972),(43,'SI-GFVQ25B2A2D_thumb_02.jpg','/var/www/html/upload/product','262174','1600058792',NULL,1600058792),(44,'SI-GFVQ25B2A2D_thumb_03.jpg','/var/www/html/upload/product','151643','1600058792',NULL,1600058792),(45,'SI-GFVQ25B2A2D_thumb_04.jpg','/var/www/html/upload/product','278001','1600058792',NULL,1600058792),(46,'SI-GFVQ20B2A5D_thumb_02.jpg','/var/www/html/upload/product','186171','1600059045',NULL,1600059045),(47,'SI-GFVQ20B2A5D_thumb_03.jpg','/var/www/html/upload/product','89710','1600059045',NULL,1600059045),(48,'SI-GFVQ20B2A5D_thumb_04.jpg','/var/www/html/upload/product','157090','1600059045',NULL,1600059045),(49,'SI-GFVQ40B1A4D_thumb_02.jpg','/var/www/html/upload/product','226888','1600060570',NULL,1600060570),(50,'SI-GFVQ40B1A4D_thumb_03.jpg','/var/www/html/upload/product','171047','1600060570',NULL,1600060570),(51,'SI-GFVQ40B1A4D_thumb_04.jpg','/var/www/html/upload/product','360180','1600060570',NULL,1600060570),(52,'SI-GFVQ40C3A5D_thumb_02.jpg','/var/www/html/upload/product','153579','1600060648',NULL,1600060648),(53,'SI-GFVQ40C3A5D_thumb_03.jpg','/var/www/html/upload/product','125529','1600060648',NULL,1600060648),(54,'SI-GFVQ40C3A5D_thumb_04.jpg','/var/www/html/upload/product','108640','1600060648',NULL,1600060648),(55,'SI-GFVQ40C3A4D_thumb_02.jpg','/var/www/html/upload/product','200499','1600060993',NULL,1600060993),(56,'SI-GFVQ40C3A4D_thumb_03.jpg','/var/www/html/upload/product','154813','1600060993',NULL,1600060993),(57,'SI-GFVQ40C3A4D_thumb_04.jpg','/var/www/html/upload/product','160881','1600060993',NULL,1600060993),(58,'SI-GFVQ40B1A5D_thumb_02.jpg','/var/www/html/upload/product','283192','1600061081',NULL,1600061081),(59,'SI-GFVQ40B1A5D_thumb_03.jpg','/var/www/html/upload/product','259652','1600061081',NULL,1600061081),(60,'SI-GFVQ40B1A5D_thumb_04.jpg','/var/www/html/upload/product','445571','1600061081',NULL,1600061081),(61,'SI-GFXC50B1A1D_thumb_02.jpg','/var/www/html/upload/product','158560','1600061230',NULL,1600061230),(62,'LIRM08V84001D_thumb02.jpg','/var/www/html/upload/product','150090','1600061798',NULL,1600061798),(63,'LIRM08V84001D_thumb03.jpg','/var/www/html/upload/product','282375','1600061798',NULL,1600061798),(64,'LIRM08V84001D_thumb04.jpg','/var/www/html/upload/product','498984','1600061798',NULL,1600061798),(65,'LIRM08R84001D_thumb02.jpg','/var/www/html/upload/product','150090','1600062043',NULL,1600062043),(66,'LIRM08R84001D_thumb03.jpg','/var/www/html/upload/product','282375','1600062043',NULL,1600062043),(67,'LIRM08R84001D_thumb04.jpg','/var/www/html/upload/product','498984','1600062043',NULL,1600062043),(68,'LIRB12W8A6C01D_thumb_02.jpg','/var/www/html/upload/product','92300','1600062281',NULL,1600062281),(69,'LIRB12W8A6C01D_thumb_03.jpg','/var/www/html/upload/product','146329','1600062281',NULL,1600062281),(70,'LIRB12W8A6C01D_thumb_04.jpg','/var/www/html/upload/product','198300','1600062281',NULL,1600062281),(71,'GB8WH3109AH1KR_thumb_03.jpg','/var/www/html/upload/product','92280','1600062511',NULL,1600062511),(72,'GB8WH3109AH1KR_thumb_04.jpg','/var/www/html/upload/product','102028','1600062511',NULL,1600062511),(73,'GB8WH3109AH1KR_thumb_03[1].jpg','/var/www/html/upload/product','92280','1600062600',NULL,1600062600),(74,'GB8WH3109AH1KR_thumb_04[1].jpg','/var/www/html/upload/product','102028','1600062600',NULL,1600062600),(75,'GB8WH3109AH1KR_thumb_03[2].jpg','/var/www/html/upload/product','92280','1600062659',NULL,1600062659),(76,'GB8WH3109AH1KR_thumb_04[2].jpg','/var/www/html/upload/product','102028','1600062659',NULL,1600062659),(77,'GM8RH3003AD1KR_thumb_02.jpg','/var/www/html/upload/product','89167','1600062920',NULL,1600062920),(78,'GM8RH3003AD1KR_thumb_03.jpg','/var/www/html/upload/product','387348','1600062920',NULL,1600062920),(79,'GM8RH3003AD1KR_thumb_04.jpg','/var/www/html/upload/product','172712','1600062920',NULL,1600062920),(80,'GM8RH3003AD1KR_thumb_05.jpg','/var/www/html/upload/product','224419','1600062920',NULL,1600062920),(81,'GM8RH3003AD1KR_thumb_02[1].jpg','/var/www/html/upload/product','89167','1600062995',NULL,1600062995),(82,'GM8RH3003AD1KR_thumb_03[1].jpg','/var/www/html/upload/product','387348','1600062995',NULL,1600062995),(83,'GM8RH3003AD1KR_thumb_04[1].jpg','/var/www/html/upload/product','172712','1600062995',NULL,1600062995),(84,'GM8RH3003AD1KR_thumb_05[1].jpg','/var/www/html/upload/product','224419','1600062995',NULL,1600062995),(85,'GD8WH5012BB2KR_thumb_02.jpg','/var/www/html/upload/product','317260','1600063570',NULL,1600063570),(86,'GD8WH5012BB2KR_thumb_03.jpg','/var/www/html/upload/product','183035','1600063570',NULL,1600063570),(87,'GD8WH5012BB2KR_thumb_02[1].jpg','/var/www/html/upload/product','317260','1600063680',NULL,1600063680),(88,'GD8WH5012BB2KR_thumb_03[1].jpg','/var/www/html/upload/product','183035','1600063680',NULL,1600063680),(89,'GD8WH5012BB2KR_thumb_02[2].jpg','/var/www/html/upload/product','317260','1600063892',NULL,1600063892),(90,'GD8WH5012BB2KR_thumb_03[2].jpg','/var/www/html/upload/product','183035','1600063892',NULL,1600063892),(91,'GD8WH5012BB2KR_thumb_02[3].jpg','/var/www/html/upload/product','317260','1600063986',NULL,1600063986),(92,'GD8WH5012BB2KR_thumb_03[3].jpg','/var/www/html/upload/product','183035','1600063986',NULL,1600063986),(93,'SL-GFERL0B1A1D_thumb_02.jpg','/var/www/html/upload/product','217973','1600064215',NULL,1600064215),(94,'SL-GFERL0B1A1D_thumb_03.jpg','/var/www/html/upload/product','182929','1600064215',NULL,1600064215),(95,'SL-GFEQH0B1A2D_thumb_02.jpg','/var/www/html/upload/product','216693','1600064416',NULL,1600064416),(96,'SL-GFEQH0B1A2D_thumb_03.jpg','/var/www/html/upload/product','191880','1600064416',NULL,1600064416),(97,'SL-GFEQH0B1A2D_thumb_04.jpg','/var/www/html/upload/product','332472','1600064416',NULL,1600064416),(98,'SL-GFEQH0B1A2D_thumb_05.jpg','/var/www/html/upload/product','267403','1600064416',NULL,1600064416),(99,'SL-GFEQH0B1A2D_thumb_03[1].jpg','/var/www/html/upload/product/','191880','','',1600064416),(100,'SL-GFEQH0B1A2D_thumb_04[1].jpg','/var/www/html/upload/product/','332472','','',1600064416),(101,'SL-GFEQH0B1A2D_thumb_05[1].jpg','/var/www/html/upload/product/','267403','','',1600064416),(102,'SL-GFEQJ0B1A2D_thumb_03.jpg','/var/www/html/upload/product','191880','1600064675',NULL,1600064675),(103,'SL-GFEQJ0B1A2D_thumb_04.jpg','/var/www/html/upload/product','332472','1600064675',NULL,1600064675),(104,'SL-GFEQJ0B1A2D_thumb_05.jpg','/var/www/html/upload/product','267403','1600064675',NULL,1600064675),(105,'LIF575Q8A1C11D_thumb_02.jpg','/var/www/html/upload/product','217768','1600065236',NULL,1600065236),(106,'LIF575Q8A1C11D_thumb_03.jpg','/var/www/html/upload/product','209010','1600065236',NULL,1600065236),(107,'LIF575Q8A1C11D_thumb_02[1].jpg','/var/www/html/upload/product','217768','1600065309',NULL,1600065309),(108,'LIF575Q8A1C11D_thumb_03[1].jpg','/var/www/html/upload/product','209010','1600065309',NULL,1600065309),(109,'LIF5A2Q860C12D_thumb_02.jpg','/var/www/html/upload/product','220018','1600065387',NULL,1600065387),(110,'LIF5A2Q860C12D_thumb_03.jpg','/var/www/html/upload/product','389676','1600065387',NULL,1600065387),(111,'LIF5A2Q860C12D_thumb_02[1].jpg','/var/www/html/upload/product','220018','1600065462',NULL,1600065462),(112,'LIF5A2Q860C12D_thumb_03[1].jpg','/var/www/html/upload/product','389676','1600065462',NULL,1600065462),(113,'LID323Q88C12D_thumb_02.jpg','/var/www/html/upload/product','126490','1600065661',NULL,1600065661),(114,'LID323Q88C12D_thumb_02[1].jpg','/var/www/html/upload/product','126490','1600065745',NULL,1600065745),(115,'LID323Q88C12D_thumb_02[2].jpg','/var/www/html/upload/product','126490','1600065823',NULL,1600065823),(116,'LID315R860C11D_thumb_02.jpg','/var/www/html/upload/product','125771','1600065910',NULL,1600065910),(117,'LID315R860C11D_thumb_02[1].jpg','/var/www/html/upload/product','125771','1600066010',NULL,1600066010),(118,'LID315R860C11D_thumb_02[2].jpg','/var/www/html/upload/product','125771','1600066209',NULL,1600066209),(119,'LID315R860C11D_thumb_02[3].jpg','/var/www/html/upload/product','125771','1600066286',NULL,1600066286),(120,'LID315R860C11D_thumb_02[4].jpg','/var/www/html/upload/product','125771','1600067581',NULL,1600067581),(121,'LID315R860C11D_thumb_02[5].jpg','/var/www/html/upload/product','125771','1600067693',NULL,1600067693),(122,'LID315Q860C12D_thumb_02.jpg','/var/www/html/upload/product','122493','1600067773',NULL,1600067773),(123,'LID310T860C11D_thumb_02.jpg','/var/www/html/upload/product','135313','1600067840',NULL,1600067840),(124,'sec-commercial-lamp-non-hole-edge-flat-lianh30r8b11pa-82218663.webp','/var/www/html/upload/product','1832','1600068124',NULL,1600068124),(125,'sec-commercial-lamp-non-hole-edge-flat-lianh30r8b11pa-82220692.webp','/var/www/html/upload/product','1452','1600068124',NULL,1600068124),(126,'sec-commercial-lamp-non-hole-edge-flat-lianh30r8b12pd-82222458.webp','/var/www/html/upload/product','1832','1600068242',NULL,1600068242),(127,'sec-commercial-lamp-non-hole-edge-flat-lianh30r8b12pd-82222464.webp','/var/www/html/upload/product','1452','1600068242',NULL,1600068242),(128,'sec-commercial-lamp-non-hole-edge-flat-lianh30r8c11pa-82024107.webp','/var/www/html/upload/product','1776','1600068345',NULL,1600068345),(129,'sec-commercial-lamp-non-hole-edge-flat-lianh30r8c11pa-82024125.webp','/var/www/html/upload/product','1338','1600068345',NULL,1600068345),(130,'sec-commercial-lamp-non-hole-edge-flat-lianh30r8c12pd-82222339.webp','/var/www/html/upload/product','1840','1600068444',NULL,1600068444),(131,'sec-commercial-lamp-non-hole-edge-flat-lianh30r8c12pd-82222366.webp','/var/www/html/upload/product','1300','1600068444',NULL,1600068444),(132,'sec-commercial-lamp-non-hole-edge-flat-lianh30r8c12pd-82222339[1].webp','/var/www/html/upload/product','1840','1600068446',NULL,1600068446),(133,'sec-commercial-lamp-non-hole-edge-flat-lianh30r8c12pd-82222366[1].webp','/var/www/html/upload/product','1300','1600068446',NULL,1600068446);

--
-- Table structure for table `TB_TRADE`
--

CREATE TABLE `TB_TRADE` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `trade_code` varchar(20) DEFAULT NULL,
  `trade_day` date DEFAULT NULL,
  `trade_total_price` int(11) DEFAULT NULL,
  `trade_price` int(11) DEFAULT NULL,
  `trade_deliv_price` int(11) DEFAULT NULL,
  `trade_stat` varchar(20) DEFAULT NULL,
  `trade_order_date` datetime DEFAULT NULL,
  `trade_money_date` datetime DEFAULT NULL,
  `trade_start_date` datetime DEFAULT NULL,
  `trade_end_date` datetime DEFAULT NULL,
  `trade_cancel_date` datetime DEFAULT NULL,
  `prod_type` varchar(20) DEFAULT NULL,
  `order_userid` varchar(20) DEFAULT NULL,
  `order_name` varchar(100) DEFAULT NULL,
  `order_place` varchar(100) DEFAULT NULL,
  `order_email` varchar(100) DEFAULT NULL,
  `order_phone` varchar(20) DEFAULT NULL,
  `deliv_zipcode` varchar(20) DEFAULT NULL,
  `deliv_addr1` varchar(200) DEFAULT NULL,
  `deliv_addr2` varchar(200) DEFAULT NULL,
  `deliv_pree_day` varchar(100) DEFAULT NULL,
  `deliv_content` varchar(200) DEFAULT NULL,
  `trade_courier` varchar(20) DEFAULT NULL,
  `trade_number` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_TRADE`
--

INSERT INTO `TB_TRADE` VALUES (1,'200911-1036-522669','2020-09-11',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'','2',NULL,'10@11','4-5-6',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'200911-1043-095970','2020-09-11',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'','2',NULL,'10@11','4-5-6',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'200911-1043-522057','2020-09-11',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'','2',NULL,'10@11','4-5-6',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'200911-1045-132710','2020-09-11',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'','2',NULL,'10@11','4-5-6',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'200911-1045-569896','2020-09-11',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'','2',NULL,'10@11','4-5-6',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'200911-1046-475838','2020-09-11',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'','22',NULL,'1010@1111','44-55-66',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'200911-1047-378820','2020-09-11',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'','22',NULL,'1010@1111','44-55-66',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'200914-1405-285267','2020-09-14',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'','test',NULL,'test@test.com','010-0000-0000',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'200914-1732-315796','2020-09-14',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'','2',NULL,'9@0','4-5-6',NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `TB_TRADE_GOODS`
--

CREATE TABLE `TB_TRADE_GOODS` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `trade_code` varchar(20) DEFAULT NULL,
  `prod_id` int(11) DEFAULT NULL,
  `goods_code` varchar(20) DEFAULT NULL,
  `goods_name` varchar(200) DEFAULT NULL,
  `goods_opt` varchar(100) DEFAULT NULL,
  `goods_price` int(11) DEFAULT NULL,
  `goods_cnt` int(11) DEFAULT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_TRADE_GOODS`
--

INSERT INTO `TB_TRADE_GOODS` VALUES (1,'200911-1046-475838',1599626341,'1599626341','','',0,1),(2,'200911-1047-378820',1599626341,'1599626341','','',0,1),(3,'200911-1047-378820',1599626341,'1599626341','','',0,9),(4,'200914-1405-285267',1600056383,'1600056383','','',0,1),(5,'200914-1405-285267',1599625712,'1599625712','','',0,1),(6,'200914-1732-315796',1599803367,'1599803367','','',0,2);

--
-- Table structure for table `TB_USER_GRP`
--

CREATE TABLE `TB_USER_GRP` (
  `grp_id` varchar(20) NOT NULL DEFAULT '',
  `grp_name` varchar(50) NOT NULL DEFAULT '',
  `grp_desc` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_USER_GRP`
--

INSERT INTO `TB_USER_GRP` VALUES ('1','관리자','관리자'),('A','비회원','비회원'),('0','관리자','관리자');

--
-- Table structure for table `TB_USER_LEVEL`
--

CREATE TABLE `TB_USER_LEVEL` (
  `level_id` varchar(10) NOT NULL DEFAULT '',
  `level_name` varchar(50) DEFAULT NULL,
  `level_desc` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TB_USER_LEVEL`
--

INSERT INTO `TB_USER_LEVEL` VALUES ('0','관리자','관리자'),('A','비회원','비회원'),('1','관리자','관리자');


