CREATE TABLE userInfo(
customerID INT PRIMARY KEY ,
customerName VARCHAR(10) ,
customerBorn VARCHAR(50) ,
customerIncome VARCHAR(20),
customerBalance VARCHAR(20),
PID CHAR(18) ,
telephone CHAR(11) ,
address VARCHAR(50)
)
INSERT INTO userInfo
Values('11111111','XXX','1111年11月11日','2000','1500','123456789012345678','12345678901','XXXXXX')
CREATE TABLE workerInfo(
workerID INT PRIMARY KEY,
workerName VARCHAR(10) ,
workerBorn VARCHAR(50) ,
)
INSERT INTO workerInfo
Values('1001','小明','2001年01月01日')
CREATE TABLE accessInfo(
workerID INT PRIMARY KEY,
service CHAR(3) ,
servemonth CHAR(5) ,
FOREIGN KEY(workerID)REFERENCES workerinfo(workerID),
)
INSERT INTO accessInfo
Values('1001','15',1)
CREATE TABLE tradeinfo(
tradeID INT ,
tradetime VARCHAR(50) ,
trademoney VARCHAR(20) ,
workerID INT,
PRIMARY KEY(tradeID)
)
INSERT INTO tradeInfo
Values('100001','2021年6月10日20:32:34','30000','1001')
CREATE TABLE bankInfo(
customerID INT ,
tradeID INT ,
workerID INT ,
belongBank VARCHAR(50),
PRIMARY KEY(customerID,tradeID,workerID),
FOREIGN KEY(customerID)REFERENCES userinfo(customerID),
FOREIGN KEY(workerID)REFERENCES workerinfo(workerID),
FOREIGN KEY(tradeID)REFERENCES tradeinfo(tradeID)
)
INSERT INTO bankInfo
Values('11111111','100001','1001','中国银行XXXX支行')
根据您提供的信息,我对您的MySQL银行数据库建表提出以下建议和修改意见:
另外,对于数据表的INSERT INTO语句,需要注意字段和值的对应关系,应该按照表中字段的顺序依次对应对应的值,否则会出现数据插入错误的情况。