问题遇到的现象和发生背景
不能这么写吗?TABLE transactions 报错建立不成功。可是之前成功过
用代码块功能插入代码,请勿粘贴截图
CREATE TABLE Customers(birth_day DATE, first_name VARCHAR(20), last_name VARCHAR(20), c_id INT,
CONSTRAINT PK_Customers PRIMARY KEY (c_id));
CREATE TABLE Employees(birth_day DATE, first_name VARCHAR(20), last_name VARCHAR(20), e_id INT,
CONSTRAINT PK_Employees PRIMARY KEY (e_id));
CREATE TABLE Transactions(e_id*
INT, c_id*
INT, date DATE, t_id INT,
CONSTRAINT PK_Transactions PRIMARY KEY (t_id),
CONSTRAINT FK_Transactions FOREIGN KEY(e_id*
) REFERENCES Employees(e_id),
CONSTRAINT FK_Transactions FOREIGN KEY(c_id*
) REFERENCES Customers(c_id));
我的解答思路和尝试过的方法
删过库和表,重新弄也没什么效果