-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: localhost    Database: mydb_betgo
-- ------------------------------------------------------
-- Server version	5.5.5-10.4.28-MariaDB-1:10.4.28+maria~ubu1804-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 SET NAMES utf8 ;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `personal_account_number`
--

DROP TABLE IF EXISTS `personal_account_number`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `personal_account_number` (
  `member_idx` int(11) NOT NULL DEFAULT 0,
  `account_number_1` varchar(45) DEFAULT '',
  `account_name_1` varchar(45) DEFAULT '',
  `account_bank_1` varchar(45) DEFAULT '',
  `account_number_2` varchar(45) DEFAULT '',
  `account_name_2` varchar(45) DEFAULT '',
  `account_bank_2` varchar(45) DEFAULT '',
  `update_dt` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `create_dt` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`member_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `personal_account_number`
--

LOCK TABLES `personal_account_number` WRITE;
/*!40000 ALTER TABLE `personal_account_number` DISABLE KEYS */;
INSERT INTO `personal_account_number` VALUES (36,'9545010147130','박동호','광주은행','','','','2023-11-12 07:33:08','2023-07-15 18:53:27'),(47,'9545010234655','CHENG PEI LUEN','광주은행','','','','2023-09-02 09:20:41','2023-09-02 09:20:41'),(67,'8008082147139','이재두','경남은행','','','','2023-07-25 16:33:04','2023-07-25 16:33:04'),(110,'9545010553497','김재현','광주은행','','','','2023-09-16 13:02:18','2023-09-16 13:02:18'),(195,'9545010898530','유현철','광주은행','','','','2023-11-12 07:33:08','2023-07-15 13:52:49'),(199,'9545010860730','임용묵','광주은행','','','','2023-11-12 07:33:08','2023-07-15 16:29:29'),(227,'9545010163522','김영훈','광주은행','','','','2023-09-12 16:49:50','2023-09-12 16:49:50'),(404,'777-000-538034','윤지훈','케이뱅크','','','','2023-11-12 07:33:08','2023-07-16 00:59:39'),(412,'9545010867389','안형준','광주은행','','','','2023-11-12 07:33:08','2023-07-15 16:18:52'),(431,'9545010134561','민경무','광주은행','','','','2023-11-12 07:33:08','2023-07-17 22:16:46'),(531,'9545010708078','허광명','광주은행','','','','2023-08-24 08:00:51','2023-08-24 08:00:51'),(864,'9545010219719','유필봉','광주은행','','','','2023-09-11 23:16:59','2023-07-25 18:38:35'),(1181,'4534534','44','경남은행','','','','2023-07-15 08:51:35','2023-07-15 08:51:35'),(1220,'9573010023412','이상현','광주은행','','','','2023-11-12 07:33:08','2023-10-24 21:28:20'),(1558,'9545010276489','김태웅','광주은행','','','','2023-11-12 07:33:08','2023-07-21 19:50:47'),(1692,'9574010150954','송철민','광주은행','50902000963050','송철민','제주은행','2023-12-16 21:28:33','2023-07-25 16:24:02'),(1765,'8008077973339','공현중','경남은행','','','','2023-07-31 15:56:38','2023-07-31 15:56:38'),(2378,'9545010629688','황주환','광주은행','','','','2023-09-02 21:11:04','2023-09-02 21:11:04'),(2484,'8008079987039','윤성진','경남은행','','','','2023-11-12 07:33:08','2023-07-16 14:59:01'),(2619,'8008079710239','정의석','경남은행','','','','2023-07-16 00:22:51','2023-07-16 00:22:51'),(2677,'8001-0217-54227','김대성','케이뱅크','','','','2023-09-16 06:58:48','2023-07-25 18:34:54'),(2685,'9573010101168','이상일','광주은행','','','','2023-10-14 17:05:02','2023-07-22 17:43:09'),(3070,'9545010723306','박선용','광주은행','','','','2023-11-12 07:33:08','2023-08-10 17:47:51'),(18794,'9545010858441','노광신','광주은행','','','','2023-11-12 07:33:08','2023-07-15 08:16:55'),(19164,'8008080073739','장석우','경남은행','','','','2023-11-12 07:33:08','2023-07-16 17:48:18'),(19262,'8008082745339','오기영','경남은행','','','','2023-07-28 17:07:44','2023-07-28 17:07:44'),(19321,'8008081507539','최준호','경남은행','','','','2023-07-22 16:05:02','2023-07-22 16:04:32'),(19359,'8008080660639','나현성','경남은행','','','','2023-07-19 03:02:01','2023-07-19 03:02:01'),(19475,'8008078185239','오혜성','경남은행','','','','2023-08-04 03:09:44','2023-08-04 03:09:44'),(19604,'9545010903239','이상우','광주은행','','','','2023-08-22 17:37:36','2023-08-22 17:37:36'),(19621,'8008078248739','임필요','경남은행','','','','2023-08-04 22:15:51','2023-08-04 22:15:51'),(19644,'8008078365639','소순명','경남은행','','','','2023-08-08 17:05:35','2023-08-08 17:05:35'),(19662,'','','','','','','2023-11-12 07:33:08','2023-08-11 18:22:53'),(20383,'9545010994664','권도윤','광주은행','','','','2023-08-22 17:54:00','2023-08-22 17:54:00'),(20674,'9545010915697','김예라','광주은행','','','','2023-08-26 18:37:58','2023-08-26 18:37:58'),(20868,'9545010578537','김문환','광주은행','','','','2023-08-23 17:53:48','2023-08-23 17:53:48'),(21009,'9545010784882','서경상','광주은행','','','','2023-08-29 19:25:44','2023-08-29 19:25:44'),(21087,'9545010909887','원정연','광주은행','','','','2023-09-10 06:08:50','2023-08-26 13:33:31'),(21649,'9545010882639','나영훈','광주은행','','','','2023-08-22 17:51:52','2023-08-22 17:51:52'),(21756,'9545010850283','홍정순','광주은행','','','','2023-08-22 17:16:53','2023-08-22 17:16:53'),(22832,'9545010920581','김도윤','광주은행','','','','2023-08-25 20:35:26','2023-08-25 20:35:26'),(23159,'9545010171083','강태영','광주은행','','','','2023-08-24 21:54:51','2023-08-24 21:54:51'),(23169,'9545010487604','안병하','광주은행','','','','2023-08-27 15:57:03','2023-08-27 15:57:03'),(23354,'9545010515219','조다빈','광주은행','','','','2023-08-22 17:07:48','2023-08-22 17:07:48'),(23543,'9545010208437','임훈','광주은행','','','','2023-08-22 17:25:03','2023-08-22 17:25:03'),(23643,'9545010752367','김건령','광주은행','','','','2023-08-24 05:02:33','2023-08-24 05:02:33'),(23705,'9545010555568','김선영','광주은행','','','','2023-08-23 10:55:06','2023-08-23 10:55:06'),(23751,'9545011006580','곽영서','광주은행','','','','2023-08-22 16:51:44','2023-08-22 16:51:44'),(23790,'9545010149706','김태양','광주은행','','','','2023-08-27 17:46:09','2023-08-27 17:46:09'),(23864,'9545010106705','이철주','광주은행','','','','2023-08-22 17:45:20','2023-08-22 17:45:20'),(24252,'0','0','광주은행','','','','2023-08-22 21:35:41','2023-08-22 21:11:06'),(24359,'9545010965578','변재성','광주은행','','','','2023-09-06 17:16:30','2023-09-06 17:16:30'),(24370,'9545010834750','윤남기','광주은행','','','','2023-09-08 20:03:53','2023-09-08 20:03:53'),(24373,'9545010469276','이준범','광주은행','','','','2023-09-10 13:12:11','2023-09-10 13:12:11'),(24375,'9545010132042','최진수','광주은행','','','','2023-09-15 20:07:44','2023-09-15 20:07:44'),(24635,'9573010101710','이형래','광주은행','','','','2023-10-14 20:10:56','2023-10-14 20:10:56'),(24769,'9573010098552','이창현','광주은행','','','','2023-10-13 18:29:19','2023-10-13 18:29:19'),(24770,'9573010099973','유정훈','광주은행','','','','2023-10-14 11:08:07','2023-10-14 11:08:07'),(24787,'9573010103013','이어진','광주은행','','','','2023-10-15 13:18:56','2023-10-15 13:13:28'),(24788,'9573010100167','최대호','광주은행','','','','2023-10-14 12:15:57','2023-10-14 12:15:57'),(24789,'9573010101099','이원규','광주은행','','','','2023-10-14 16:46:58','2023-10-14 16:46:39'),(24796,'9573010103201','강진수','광주은행','','','','2023-10-15 15:33:41','2023-10-15 15:33:41'),(24797,'9573010105087','임도훈','광주은행','','','','2023-10-16 13:17:43','2023-10-16 13:17:43'),(24800,'9573010103364','이진경','광주은행','','','','2023-10-15 16:28:09','2023-10-15 15:22:14'),(24801,'9573010103370','최승용','광주은행','','','','2023-10-15 16:28:27','2023-10-15 16:28:27'),(24803,'9573010106204','정우철','광주은행','','','','2023-10-16 19:14:46','2023-10-16 17:01:05'),(24804,'9573010105388','김희준','광주은행','','','','2023-10-16 14:57:34','2023-10-16 14:57:34'),(24808,'9573010109354','홍광훈','광주은행','','','','2023-10-17 18:32:44','2023-10-17 18:32:44'),(24813,'9573010942694','민준기','광주은행','','','','2023-11-01 11:25:30','2023-10-17 11:39:31'),(24816,'9573010108159','홍대준','광주은행','','','','2023-10-17 13:50:41','2023-10-17 13:50:41'),(24827,'0000','ㅇ','광주은행','50902000838712','정영오','제주은행','2023-12-15 16:25:29','2023-10-19 01:24:30'),(24869,'9573010521001','이병길','광주은행','','','','2023-11-19 12:56:47','2023-10-21 19:40:30'),(24871,'9573010111922','조문수','광주은행','','','','2023-10-21 23:17:05','2023-10-21 23:17:05'),(24874,'9573010119453','한범진','광주은행','','','','2023-10-23 01:53:43','2023-10-23 01:53:43'),(24886,'9573010109144','조기성','광주은행','','','','2023-10-23 19:31:48','2023-10-23 19:31:48'),(24896,'9573010035905','한찬희','광주은행','','','','2023-10-25 07:58:10','2023-10-25 07:58:10'),(25148,'9573010494306','김호성','광주은행','','','','2023-11-08 21:53:35','2023-11-08 21:53:35'),(25168,'9573010088613','서원준','광주은행','','','','2023-11-09 18:40:31','2023-11-09 18:40:31'),(25169,'9573010039266','신창용','광주은행','','','','2023-11-13 22:58:23','2023-11-13 22:58:23'),(25206,'9573010038306','이수한','광주은행','','','','2023-11-13 22:11:28','2023-11-13 22:11:28'),(25208,'9573010049597','추현수','광주은행','','','','2023-11-13 19:47:44','2023-11-13 19:47:44'),(25234,'1','김복수','제주은행','50902000790497','김복수','제주은행','2023-12-14 16:46:07','2023-11-16 09:17:54'),(25254,'9573010465345','서종배','광주은행','9574010240983','서종배','광주은행','2023-11-21 18:22:00','2023-11-17 12:23:28'),(25264,'9573010469101','이승용','광주은행','','','','2023-11-18 16:10:42','2023-11-18 16:10:42'),(25293,'','','','50902000786599','조우빈','제주은행','2023-12-15 18:00:32','2023-11-25 21:05:45'),(25419,'9545010951635','박순범','광주은행','50902000845195','박순범','제주은행','2024-01-21 10:00:27','2023-12-04 16:43:39'),(25458,'','','','1111','고객센터로 문의 바랍니다.','광주은행','2023-12-06 20:52:34','2023-12-06 17:37:18'),(25506,'','','','50902000965847','김규연','제주은행','2023-12-08 21:32:09','2023-12-08 21:32:09'),(25508,'','','','50902000727223','이윤승','제주은행','2023-12-10 21:20:37','2023-12-10 21:20:37'),(25599,'1','1','제주은행','50902000872301','오동찬','제주은행','2023-12-21 02:17:35','2023-12-20 04:28:41'),(25626,'50902000859500','김민석','제주은행','50902000843620','김민석','제주은행','2023-12-28 13:57:44','2023-12-28 13:47:47'),(25658,'50902000813580','백창훈','제주은행','50902000813580','백창훈','제주은행','2023-12-30 11:08:30','2023-12-30 11:08:22'),(25726,'9545010482449','박성곤','광주은행','50902000958957','박성곤','제주은행','2024-01-19 06:45:38','2024-01-04 15:58:13'),(25775,'50902000873400','황상준','제주은행','50902000873400','황상준','제주은행','2024-01-12 22:27:42','2024-01-12 22:05:26'),(26498,'','','','50902000815548','이종민','제주은행','2024-01-17 23:26:01','2024-01-17 23:26:01'),(26500,'','','','50902000702560','오성기','제주은행','2024-01-17 22:34:24','2024-01-17 22:34:24'),(26515,'9545010507350','민세일','광주은행','50902000695364','민세일','제주은행','2024-01-18 14:44:52','2024-01-17 18:50:55'),(26517,'','','','50902000867102','배형률','제주은행','2024-01-17 19:44:38','2024-01-17 19:44:38'),(26525,'','','','50902000853071','강재구','제주은행','2024-01-17 19:58:44','2024-01-17 19:58:44'),(26531,'9545010940604','김은상','광주은행','9545010940604','김은상','광주은행','2024-01-19 01:07:05','2024-01-18 03:52:59'),(26538,'','','','50902000773454','문현우','제주은행','2024-01-17 18:33:25','2024-01-17 18:33:25'),(26542,'','','','50902000807631','박재성','제주은행','2024-01-17 17:54:24','2024-01-17 17:54:24'),(26552,'','','','50902000846554','송대영','제주은행','2024-01-17 18:21:18','2024-01-17 18:21:18'),(26555,'','','','50902000743112','양인철','제주은행','2024-01-18 07:00:09','2024-01-18 07:00:09'),(26556,'','','','50902000829155','신승철','제주은행','2024-01-17 17:55:38','2024-01-17 17:55:38'),(26563,'','','','50902000821839','하운용','제주은행','2024-01-17 20:50:30','2024-01-17 20:50:30'),(26565,'','','','50902000838178','이기안','제주은행','2024-01-17 18:19:54','2024-01-17 18:19:54'),(26571,'','','','50902000731563','이종욱','제주은행','2024-01-17 17:19:37','2024-01-17 17:19:37'),(26572,'','','','50902000883135','유한일','제주은행','2024-01-17 18:06:31','2024-01-17 18:06:31'),(26582,'','','','50902000893168','문송현','제주은행','2024-01-17 19:11:20','2024-01-17 19:11:20'),(26601,'9545010033482','이덕용','광주은행','','','','2024-01-20 20:55:46','2024-01-20 20:55:46'),(26602,'','','','50902000724255','김상철','제주은행','2024-01-17 17:54:57','2024-01-17 17:54:57'),(26603,'','','','50902000736842','안성호','제주은행','2024-01-17 18:29:03','2024-01-17 18:29:03'),(26607,'','','','50902000807939','김광희','제주은행','2024-01-17 18:22:34','2024-01-17 18:22:34'),(26611,'','','','50902000780180','김정현','제주은행','2024-01-17 22:19:08','2024-01-17 22:19:08'),(26630,'','','','50902000818650','신춘식','제주은행','2024-01-17 17:59:26','2024-01-17 17:59:26'),(26634,'','','','50902000709321','김선래','제주은행','2024-01-17 17:39:21','2024-01-17 17:39:21'),(26640,'','','','50902000781892','임세혁','제주은행','2024-01-17 18:02:19','2024-01-17 18:02:19'),(26646,'50902000745543','이장원','제주은행','50902000745543','이장원','제주은행','2024-01-18 01:27:08','2024-01-18 01:23:50'),(26651,'','','','50902000859151','이승진','제주은행','2024-01-17 18:18:51','2024-01-17 18:18:51'),(26656,'9545010177380','김동찬','광주은행','0000','0000','광주은행','2024-01-20 20:47:31','2024-01-20 20:41:54');
/*!40000 ALTER TABLE `personal_account_number` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-01-21 22:06:34
