CREATE DATABASE `db_bank`;

# 客户信息
CREATE TABLE `client`(
`NameId` INT COMMENT '顾客编号' auto_increment PRIMARY KEY NOT NULL,
`Name` VARCHAR(10) COMMENT '开户名称' NOT NULL,
`ID_number` VARCHAR(18) COMMENT '身份证号',
`Phone` VARCHAR(11) COMMENT '联系电话',
`Address` VARCHAR(20) COMMENT '居住地址'
);
# 银行卡信息
CREATE TABLE `Account`(
`card_number` VARCHAR(16) COMMENT '卡号' NOT NULL PRIMARY KEY,
`NameId` INT COMMENT '顾客编号' NOT NULL,
FOREIGN KEY(`NameId`) REFERENCES client(`NameId`),
`password` VARCHAR(20) COMMENT '密码',
`currency_ID` INT COMMENT '货币种类编号'NOT NULL,
FOREIGN KEY(`currency_ID`) REFERENCES currency_type(`currency_ID`),
`deposit_type` VARCHAR(20) COMMENT '存款类型' NOT NULL,
`open_date` TIMESTAMP COMMENT '开户日期' NOT NULL,
`initial_deposit` DECIMAL COMMENT '开户金额',
`balance` DECIMAL COMMENT '余额',
`report` int(1) COMMENT '是否挂失' DEFAULT 0
);
# 货币类型
CREATE TABLE `currency_type`(
`currency_ID` INT COMMENT '货币种类号' NOT NULL PRIMARY KEY,
`currency_name` VARCHAR(20) COMMENT '货币种类名称' 
);
# 交易信息
CREATE TABLE `deal_message`(
`id_number` VARCHAR(16) COMMENT '卡号' NOT NULL,
FOREIGN KEY(`id_number`) REFERENCES account(`card_number`),
`deal_data` TIMESTAMP COMMENT '交易日期' NOT NULL,
`deal_money` DECIMAL COMMENT '交易金额',
`note` VARCHAR(50) COMMENT '备注'
)
INSERT into client VALUES(1,'张三','189642198407089634','10080','记挂市');
INSERT into client VALUES(2,'李四','152364197702341234','10040','大航州');
INSERT into client VALUES(3,'王五','987654200010012233','10010','大俗州');
INSERT into client VALUES(4,'赵六','123456200104045656','119','这将');
INSERT into client VALUES(5,'郑七','146529199405012648','120','伤嗨');

INSERT INTO currency_type VALUES(1,'美元');
INSERT INTO currency_type VALUES(2,'人民币');
INSERT INTO currency_type VALUES(3,'英镑');
INSERT INTO currency_type VALUES(4,'日元');
INSERT INTO currency_type VALUES(5,'意大利里拉');
INSERT INTO currency_type VALUES(6,'瑞士法郎');
INSERT INTO currency_type VALUES(7,'荷兰盾');
INSERT INTO currency_type VALUES(8,'比利时法郎');

INSERT into Account VALUES('1562384923486512',1,'123456',2,'定期存款','2021-01-05',3000,300,0);
INSERT into Account VALUES('1562348953152463',3,'888888',4,'活期存款','2020-10-01',300000,26000,0);
INSERT into Account VALUES('1562315624895655',2,'471825',1,'活期存款','2009-02-25',2000,1500,1);
INSERT into Account VALUES('1562314562548759',5,'123456',7,'定期存款','2021-02-05',300.5,200.6,1);
INSERT into Account VALUES('1562345865977555',4,'123456',6,'活期存款','2019-08-05',400,350,0);

INSERT into deal_message VALUES('1562384923486512','2021-03-08',200,'');
INSERT into deal_message VALUES('1562348953152463','2020-02-12',200,'casdca');
INSERT into deal_message VALUES('1562315624895655','2019-01-18',200,'vzxcvzcdad');
INSERT into deal_message VALUES('1562345865977555','2018-03-03',200,'vsdfvadcasd');
INSERT into deal_message VALUES('1562314562548759','2020-01-07',200,'vdssdcsadcadcda');

代码作业省略 作业自己写