Untitled

-- CHATANDPAY.account_api_log definition

CREATE TABLE `account_api_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `account_id` bigint DEFAULT NULL,
  `attempt_cd` int DEFAULT NULL,
  `final_amount` int DEFAULT NULL,
  `initial_amount` int DEFAULT NULL,
  `requester` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- CHATANDPAY.`member` definition

CREATE TABLE `member` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `cellphone` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `verification_id` bigint NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `userId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `verificationId` int DEFAULT NULL,
  `ulid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=103220180 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- CHATANDPAY.open_api_access_token definition

CREATE TABLE `open_api_access_token` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `access_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `client_use_code` varchar(255) NOT NULL,
  `expires_in` varchar(255) NOT NULL,
  `scope` varchar(255) NOT NULL,
  `token_type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- CHATANDPAY.sms_auth definition

CREATE TABLE `sms_auth` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `auth_number` varchar(255) DEFAULT NULL,
  `is_verified` bit(1) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `confirm_time` datetime DEFAULT NULL,
  `request_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6235 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- CHATANDPAY.pay_member definition

CREATE TABLE `pay_member` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `birth_date` varchar(255) DEFAULT NULL,
  `ci` varchar(255) DEFAULT NULL,
  `user_seq_no` varchar(255) DEFAULT NULL,
  `user_id` bigint DEFAULT NULL,
  `withdrawn_yn` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_01` (`ci`),
  KEY `pay_member_user_id_IDX` (`user_id`) USING BTREE,
  CONSTRAINT `FK_01` FOREIGN KEY (`user_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- CHATANDPAY.transfer definition

CREATE TABLE `transfer` (
  `uuid` binary(16) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `amount` int NOT NULL,
  `transferred_yn` bit(1) DEFAULT NULL,
  `receiver_id` bigint DEFAULT NULL,
  `sender_id` bigint DEFAULT NULL,
  `transfer_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uuid`),
  KEY `KEY_receiver_id` (`receiver_id`),
  KEY `KEY_sender_id` (`sender_id`),
  CONSTRAINT `KEY_receiver_id` FOREIGN KEY (`receiver_id`) REFERENCES `pay_member` (`id`),
  CONSTRAINT `KEY_sender_id` FOREIGN KEY (`sender_id`) REFERENCES `pay_member` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- CHATANDPAY.wallet definition

CREATE TABLE `wallet` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `money` int NOT NULL,
  `pay_user_id` bigint DEFAULT NULL,
  `version` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `KEY_pay_user_id` (`pay_user_id`),
  CONSTRAINT `KEY_pay_user_id` FOREIGN KEY (`pay_user_id`) REFERENCES `pay_member` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- CHATANDPAY.other_bank_account definition

CREATE TABLE `other_bank_account` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `account_name` varchar(255) DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `auto_debit_agree` varchar(255) DEFAULT NULL,
  `bank_code` varchar(255) DEFAULT NULL,
  `pay_member_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_other_bank_account` (`bank_code`,`account_number`),
  KEY `KEY_pay_member_id2` (`pay_member_id`),
  CONSTRAINT `KEY_pay_member_id2` FOREIGN KEY (`pay_member_id`) REFERENCES `pay_member` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- CHATANDPAY.other_bank_transfer definition

CREATE TABLE `other_bank_transfer` (
  `uuid` binary(16) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `amount` int NOT NULL,
  `transfer_type` varchar(255) DEFAULT NULL,
  `transferred_yn` bit(1) DEFAULT NULL,
  `receiver_account` bigint DEFAULT NULL,
  `sender_id` bigint DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `bank_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uuid`),
  KEY `KEY_receiver_account` (`receiver_account`),
  KEY `KEY_sender_id2` (`sender_id`),
  CONSTRAINT `KEY_sender_id2` FOREIGN KEY (`sender_id`) REFERENCES `pay_member` (`id`),
  CONSTRAINT `KEY_receiver_account` FOREIGN KEY (`receiver_account`) REFERENCES `other_bank_account` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;