You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
126 lines
6.4 KiB
126 lines
6.4 KiB
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : atm
|
|
Source Server Version : 80033
|
|
Source Host : localhost:3306
|
|
Source Database : atm
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 80033
|
|
File Encoding : 65001
|
|
|
|
Date: 2024-05-31 14:54:56
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
-- ----------------------------
|
|
-- Table structure for `bank`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `bank`;
|
|
CREATE TABLE `bank` (
|
|
`bank_key` int NOT NULL,
|
|
`银行名称` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
PRIMARY KEY (`bank_key`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
|
|
-- ----------------------------
|
|
-- Records of bank
|
|
-- ----------------------------
|
|
INSERT INTO bank VALUES ('1', '中国银行');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `bill`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `bill`;
|
|
CREATE TABLE `bill` (
|
|
`时间` datetime NOT NULL,
|
|
`订单ID` int NOT NULL,
|
|
`银行` char(50) NOT NULL,
|
|
`操作方式` char(50) NOT NULL,
|
|
`金额` float NOT NULL,
|
|
`银行卡号` char(30) NOT NULL,
|
|
`目标账户` char(30) DEFAULT NULL,
|
|
PRIMARY KEY (`时间`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
|
|
-- ----------------------------
|
|
-- Records of bill
|
|
-- ----------------------------
|
|
INSERT INTO bill VALUES ('2024-05-31 11:05:53', '10744925', '中国银行', '取款', '111', '111', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:09:08', '10788140', '中国银行', '存款', '1', '111', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:09:39', '10939119', '中国银行', '存款', '111', '111', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:09:42', '10613347', '中国银行', '取款', '1', '111', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:10:57', '10946847', '中国银行', '转账', '0', '111', '222');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:13:31', '10074488', '', '转账', '1', '222', '111');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:19:10', '10516740', '中国银行', '存款', '33333', '111', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:20:42', '10517518', '中国银行', '转账', '0', '111', '333');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:22:47', '10019783', '中国银行', '存款', '22', '111', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:23:47', '10431147', '中国银行', '存款', '3333', '333', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:23:54', '10390544', '中国银行', '转账', '1', '333', '111');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:24:03', '10284427', '中国银行', '转账', '22', '333', '111');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:24:20', '10429608', '', '转账', '22', '222', '111');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:24:42', '10548491', '中国银行', '转账', '111', '111', '333');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:25:58', '10599121', '中国银行', '转账', '111', '333', '111');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:27:57', '10451816', '', '转账', '111', '222', '333');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:28:07', '10920179', '', '转账', '222', '222', '111');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:28:10', '10317065', '', '转账', '2222', '222', '111');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:30:29', '10919022', '中国银行', '转账', '1', '111', '222');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:31:07', '10283188', '', '转账', '1', '444', '111');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:31:20', '10528188', '', '存款', '111', '444', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:31:27', '10851448', '', '取款', '11', '444', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:31:41', '10858951', '', '转账', '1', '444', '111');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:32:28', '10417171', '中国银行', '转账', '1', '111', '222');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:36:32', '10530239', '中国银行', '转账', '11', '111', '222');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:36:49', '10442202', '中国银行', '转账', '111', '111', '333');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:37:23', '10051895', '中国银行', '转账', '111', '111', '222');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:43:27', '10163236', '中国银行', '转账', '1', '111', '222');
|
|
INSERT INTO bill VALUES ('2024-05-31 11:44:37', '10549313', '中国银行', '转账', '111', '111', '222');
|
|
INSERT INTO bill VALUES ('2024-05-31 12:05:07', '10871814', '中国银行', '转账', '1', '111', '222');
|
|
INSERT INTO bill VALUES ('2024-05-31 13:36:13', '10654129', '', '转账', '1', '000', '111');
|
|
INSERT INTO bill VALUES ('2024-05-31 13:43:53', '10097456', '', '存款', '2999', '888', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 13:43:57', '10663217', '', '取款', '2', '888', '无');
|
|
INSERT INTO bill VALUES ('2024-05-31 13:44:12', '10549945', '', '转账', '11', '888', '111');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `card`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `card`;
|
|
CREATE TABLE `card` (
|
|
`Card_Number` char(30) NOT NULL,
|
|
`持卡人姓名` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'yonghu',
|
|
`身份证号` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`余额` float NOT NULL DEFAULT '0',
|
|
`card类型` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`password` int NOT NULL,
|
|
PRIMARY KEY (`Card_Number`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
|
|
-- ----------------------------
|
|
-- Records of card
|
|
-- ----------------------------
|
|
INSERT INTO card VALUES ('000', '用户', '37000000000', '-1', '', '0');
|
|
INSERT INTO card VALUES ('111', '小明', '111111', '1666', '中国银行', '111');
|
|
INSERT INTO card VALUES ('222', '小华', '333333', '2237', '', '222');
|
|
INSERT INTO card VALUES ('333', '小东', '666666', '2111', '中国银行', '333');
|
|
INSERT INTO card VALUES ('444', '用户', '37000000000', '98', '', '444');
|
|
INSERT INTO card VALUES ('777', '用户', '37000000000', '0', '', '777');
|
|
INSERT INTO card VALUES ('888', '用户', '37000000000', '2986', '', '888');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `user`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `user`;
|
|
CREATE TABLE `user` (
|
|
`User_key` int NOT NULL,
|
|
`姓名` char(50) NOT NULL,
|
|
`性别` char(20) NOT NULL,
|
|
`身份证号` char(30) NOT NULL,
|
|
PRIMARY KEY (`User_key`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
|
|
-- ----------------------------
|
|
-- Records of user
|
|
-- ----------------------------
|
|
INSERT INTO user VALUES ('1', '小明', '男', '111111');
|