Oracle11gSQL错误: ORA-00904："CUST_ID"：标识符无效

Question

我是一个新手，正在试着设置一些基本的桌子。我已经创建了一个名为Customer的表名为Customer，主键为Cust_ID，表名为City，PK为Zip_Code。当我尝试创建一个名为Address的表并将这些PK作为FK包含进来时，我得到了下面的错误。任何帮助都非常感谢，因为已经尝试了几个web解决方案。下面的代码和错误。谢谢，理查德。

CREATE TABLE ADDRESS
( ADDR_ID INTEGER NOT NULL,
Addr_Ln1 VARCHAR2(100) NOT NULL,    
Addr_Ln2 VARCHAR2(100) NOT NULL,    
CONSTRAINT ADDRESS_PK PRIMARY KEY (ADDR_ID),
 CONSTRAINT fk_customer FOREIGN KEY(Cust_ID) REFERENCES CUSTOMER (Cust_ID) ON DELETE CASCADE,
 CONSTRAINT fk_city FOREIGN KEY (Zip_Code) REFERENCES CITY (Zip_Code) ON DELETE CASCADE
);

这会产生以下错误：

Error starting at line : 1 in command -
CREATE TABLE ADDRESS
( ADDR_ID INTEGER NOT NULL,
Addr_Ln1 VARCHAR2(100) NOT NULL,    
Addr_Ln2 VARCHAR2(100) NOT NULL,    
CONSTRAINT ADDRESS_PK PRIMARY KEY (ADDR_ID),
 CONSTRAINT fk_customer FOREIGN KEY(Cust_ID) REFERENCES CUSTOMER (Cust_ID) ON DELETE CASCADE,
 CONSTRAINT fk_city FOREIGN KEY (Zip_Code) REFERENCES CITY (Zip_Code) ON DELETE CASCADE
)
Error at Command Line : 6 Column : 37
Error report -
SQL Error: ORA-00904: "CUST_ID": invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:    
*Action:

Answer 1

检查脚本，因为create语句中不存在列"Cust_ID“。您只创建了三个列(ADDR_ID、Addr_Ln1、Addr_Ln2)