按照教材中的说明创建user、card、transInfo三张表

要求：

1. 写出三张表的建表sql
2. 按照教材中的数据，为三张表写出插入数据的sql

-- 删除表
DROP table if exists transinfo;
DROP table if exists card;
DROP table if exists user;
-- 创建用户表
create table user(
userID VARCHAR(3) not null,
name VARCHAR(3) not null,
ename VARCHAR(10),
personID VARCHAR(18),
sex VARCHAR(1),
credit int(8),
city VARCHAR(10),
PRIMARY key(userID)
);
-- 创建银行卡card表
create table card(
cardNo VARCHAR(3) not null,
openDate date,
money DECIMAL(10,2),
password VARCHAR(6),
isLock TINYINT(1),
userID VARCHAR(3),
PRIMARY key(cardNo)
);
-- 创建交易记录transinfo表
create table transinfo(
id int(11) not null auto_increment,
transDate datetime,
cardNo VARCHAR(3),
type VARCHAR(4),
money DECIMAL(10,2),
remark VARCHAR(10),
PRIMARY key(id)
);
-- 向user表插入数据
insert into user(userID,name,ename,personID,sex,credit,city) values
('101','王鹤','tom','110113197901318695','男',328,'北京');
insert into user(userID,name,ename,personID,sex,credit,city) values
('102','李崇','bill','642117199205316578','男',214,'深圳');
insert into user(userID,name,ename,personID,sex,credit,city) values
('103','郭玉','lucy','250106199309307773','女',426,'上海');
insert into user(userID,name,ename,personID,sex,credit,city) values
('104','张赫','Aaron','110117199205316578','男',722,'北京');
insert into user(userID,name,ename,personID,sex,credit,city) values
('105','李文婷','niki','112566199904303876','女',123,'北京');
insert into user(userID,name,ename,personID,sex,credit,city) values
('106','李峰','kate','130115199704300375','男',273,'上海');
insert into user(userID,name,ename,personID,sex,credit,city) values
('107','海涛',null,'830115198811303497','男',285,'长沙');


-- 向card表插入数据
insert into card(cardNo,openDate,money,password,isLock,userId)values('001','2019-03-08','12300','123456','0','102');
insert into card(cardNo,openDate,money,password,isLock,userId)values('002','2019-02-12','15029','634573','0','106');
insert into card(cardNo,openDate,money,password,isLock,userId)values('003','2019-01-22','20000','329847','0','101');
insert into card(cardNo,openDate,money,password,isLock,userId)values('004','2019-03-31','2000','248593','1','104');
insert into card(cardNo,openDate,money,password,isLock,userId)values('005','2019-04-02','11500','268952','0','103');
insert into card(cardNo,openDate,money,password,isLock,userId)values('006','2019-04-27','3212','656573','0','107');
insert into card(cardNo,openDate,money,password,isLock,userId)values('007','2019-05-23','15634','356345','0','106');
insert into card(cardNo,openDate,money,password,isLock,userId)values('008','2019-04-18','23823','567764','0','105');
insert into card(cardNo,openDate,money,password,isLock,userId)values('009','2019-03-19','12343','567878','0','106');
-- 向transinfo表插入数据
insert into transinfo(transDate,cardNo,type,money,remark)VALUES('2019-06-20 14:30:30','002','转入',7234,'工资');
insert into transinfo(transDate,cardNo,type,money,remark)VALUES('2019-06-20 16:46:49','003','转入',326,'工资');
INSERT into transinfo(transDate,cardNo,type,money,remark)
values('2019-07-02 15:09:55','001','支取',500,'');
INSERT into transinfo(transDate,cardNo,type,money,remark)
values('2019-07-02 17:18:22','005','支取',1000,'');
INSERT into transinfo(transDate,cardNo,type,money,remark)
values('2019-07-03 09:40:04','006','转出',127,'支付宝');
INSERT into transinfo(transDate,cardNo,type,money,remark)
values('2019-07-05 17:19:34','007','存入',1000,'');
INSERT into transinfo(transDate,cardNo,type,money,remark)
values('2019-07-02 17:49:23','008','转出',800,'还钱');INSERT into transinfo(transDate,cardNo,type,money,remark)
values('2019-07-03 19:22:28','009','转出',512,'超市购物');
INSERT into transinfo(transDate,cardNo,type,money,remark)
values('2019-07-05 22:42:08','002','支取',300,'');INSERT into transinfo(transDate,cardNo,type,money,remark)
values('2019-07-23 04:58:59','003','转出',421,'支付宝');