--
-- Host: 13.124.190.96    Database: userDB_JI
-- ------------------------------------------------------


--
-- Table structure for table `coupon`
--

CREATE TABLE `coupon` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `coupon_tag` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `rewardIds` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `rewardAmounts` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `coupon_uid` (`coupon_tag`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coupon`
--


--
-- Table structure for table `coupon_common`
--

CREATE TABLE `coupon_common` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `coupon_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `coupon_uid` int NOT NULL DEFAULT '-1',
  `rewardIds` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `rewardAmounts` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `join_date` date NOT NULL DEFAULT '1970-01-01',
  `start_date` date NOT NULL DEFAULT '1970-01-01',
  `end_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`id`),
  UNIQUE KEY `coupon_name` (`coupon_name`),
  KEY `coupon_uid` (`coupon_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coupon_common`
--

INSERT INTO `coupon_common` VALUES (1,'TEST',1,'item_dia','10000','2025-09-24 15:21:00','1970-01-01','2025-09-24','2030-09-24');

--
-- Table structure for table `coupon_common_used`
--

CREATE TABLE `coupon_common_used` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `coupon_id` int NOT NULL DEFAULT '-1',
  `coupon_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `used_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`id`),
  KEY `playerId` (`playerId`)
) ENGINE=InnoDB AUTO_INCREMENT=5352 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coupon_common_used`
--

INSERT INTO `coupon_common_used` VALUES (5351,1,'코드네오_1',1,'TEST','2025-09-24 15:22:57');

--
-- Table structure for table `coupon_unique`
--

CREATE TABLE `coupon_unique` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `coupon_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `coupon_uid` int NOT NULL DEFAULT '-1',
  `rewardIds` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `rewardAmounts` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `start_date` date NOT NULL DEFAULT '1970-01-01',
  `end_date` date NOT NULL DEFAULT '1970-01-01',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `used_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `use` tinyint NOT NULL DEFAULT '0' COMMENT '0 : 미사용, 1 :사용',
  `used_user_nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `used_user_playerId` int NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `coupon_name` (`coupon_name`),
  KEY `coupon_uid` (`coupon_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=285027 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coupon_unique`
--


--
-- Table structure for table `coupon_unique_used`
--

CREATE TABLE `coupon_unique_used` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `coupon_id` int NOT NULL DEFAULT '-1',
  `coupon_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `used_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `coupon_name` (`coupon_name`),
  KEY `playerId` (`playerId`)
) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='유니크 쿠폰 사용 기록';

--
-- Dumping data for table `coupon_unique_used`
--


--
-- Table structure for table `deleted_user_account`
--

CREATE TABLE `deleted_user_account` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_account_id` bigint NOT NULL DEFAULT '-1',
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `mail_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `platform` tinyint NOT NULL DEFAULT '0',
  `deleted_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `user_create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='삭제 유저 계정 모임';

--
-- Dumping data for table `deleted_user_account`
--

INSERT INTO `deleted_user_account` VALUES (54,147,'YNY7rLVcNqQWbfDTyKQ8V7xrlrO2','전우치_147','studiodragonheart@gmail.com',0,'2025-10-12 13:08:38','2025-09-26 14:50:51'),(55,183,'aoJXAUcfSmeHlQ5DTcRAjmEAui73','전우치_183','studiodragonheart@gmail.com',0,'2025-10-12 13:36:52','2025-10-12 13:17:06'),(56,184,'sqtK6MURWNcv0uUsMAemap3DZW73','전우치_184','studiodragonheart@gmail.com',0,'2025-10-12 14:46:21','2025-10-12 14:45:44'),(57,185,'q3iiPBy0yWR9srdyOhDA3gZoHEj2','전우치_185','studiodragonheart@gmail.com',0,'2025-10-12 14:48:36','2025-10-12 14:48:21'),(58,186,'GgnOrrxkNLPfImUqBnIyl4kmhZt1','전우치_186','studiodragonheart@gmail.com',0,'2025-10-12 14:59:40','2025-10-12 14:59:23'),(59,187,'Vx3FC0rOkJW5pUewauXpR6VFs5l2','전우치_187','studiodragonheart@gmail.com',0,'2025-10-20 23:45:53','2025-10-12 15:00:28');

--
-- Dumping events for database 'userDB_JI'
--

--
-- Dumping routines for database 'userDB_JI'
--


