CREATE TABLE CUSTOMERS ( ID BIGINT NOT NULL, NAME VARCHAR(15) NOT NULL, AGE INT, PRIMARY KEY (ID) ) CREATE TABLE ORDERS ( ID BIGINT NOT NULL PRIMARY KEY, ORDER_NUMBER VARCHAR(15) NOT NULL, PRICE DOUBLE PRECISION, CUSTOMER_ID BIGINT not null )alter table CUSTOMERS add constraint test foreign key references ORDERS(CUSTOMER_ID)
alter table CUSTOMERS add constraint test foreign key(ID) references ORDERS(ID)
--应该这样 CREATE TABLE CUSTOMERS ( ID BIGINT NOT NULL, NAME VARCHAR(15) NOT NULL, AGE INT, PRIMARY KEY (ID) ) CREATE TABLE ORDERS ( ID BIGINT NOT NULL PRIMARY KEY, ORDER_NUMBER VARCHAR(15) NOT NULL, PRICE DOUBLE PRECISION, CUSTOMER_ID BIGINT not null FOREIGN KEY REFERENCES CUSTOMERS(ID) )
alter table CUSTOMERS add constraint FK_KKK foreign key(ID) references ORDERS(ID)
ID BIGINT NOT NULL,
NAME VARCHAR(15) NOT NULL,
AGE INT,
PRIMARY KEY (ID)
)
CREATE TABLE ORDERS (
ID BIGINT NOT NULL PRIMARY KEY,
ORDER_NUMBER VARCHAR(15) NOT NULL,
PRICE DOUBLE PRECISION,
CUSTOMER_ID BIGINT not null
)alter table CUSTOMERS add constraint test foreign key references ORDERS(CUSTOMER_ID)
CREATE TABLE CUSTOMERS (
ID BIGINT NOT NULL,
NAME VARCHAR(15) NOT NULL,
AGE INT,
PRIMARY KEY (ID)
)
CREATE TABLE ORDERS (
ID BIGINT NOT NULL PRIMARY KEY,
ORDER_NUMBER VARCHAR(15) NOT NULL,
PRICE DOUBLE PRECISION,
CUSTOMER_ID BIGINT not null FOREIGN KEY REFERENCES CUSTOMERS(ID)
)