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

要求：

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

-- 创建用户表 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) ); -- 创建银行卡表 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) ); -- 创建交易记录表 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(id,transDate,cardNo,type,money,remark)values ('1','2019-06-20 14:30:30','002','转入','7234','工资'); insert into transInfo(id,transDate,cardNo,type,money,remark)values ('2','2019-06-20 16:46:49','003','转入','8326','工资'); insert into transInfo(id,transDate,cardNo,type,money,remark)values ('3','2019-07-02 15:09:55','001','支取','500','' ); insert into transInfo(id,transDate,cardNo,type,money,remark)values ('4','2019-07-02 17:18:22','005','支取','1000','' ); insert into transInfo(id,transDate,cardNo,type,money,remark)values ('5','2019-07-03 09:40:04','006','转出','127','支付宝'); insert into transInfo(id,transDate,cardNo,type,money,remark)values ('6','2019-07-05 17:19:34','007','存入','1000','' ); insert into transInfo(id,transDate,cardNo,type,money,remark)values ('7','2019-07-02 17:49:23','008','转出','800','还钱'); insert into transInfo(id,transDate,cardNo,type,money,remark)values ('8','2019-07-03 19:22:28','009','转出','512','超市购物'); insert into transInfo(id,transDate,cardNo,type,money,remark)values ('9','2019-07-05 22:42:08','002','支取','300',''); insert into transInfo(id,transDate,cardNo,type,money,remark)values ('10','2019-07-23 04:58:59','003','转出','421','支付宝');