有啊。。子表语句如下,而且也建好了表 导入了数据啊: Create table Property ( prono varchar(5) NOT NULL, income numeric(8,3) NOT NULL, outcome numeric(8,3) NOT NULL, profit numeric(8,3) NOT NULL, primary key(prono) );父表语句如下,也都有prono属性啊CREATE TABLE branch( branchno varchar(4) NOT NULL, street varchar(10) NOT NULL, city varchar(7) NOT NULL, postcode decimal(8,0) NOT NULL, prono varchar(5) NOT NULL, PRIMARY KEY (branchno), FOREIGN KEY (prono) REFERENCES Property (prono) ) ;
Create table Property
(
prono varchar(5) NOT NULL,
income numeric(8,3) NOT NULL,
outcome numeric(8,3) NOT NULL,
profit numeric(8,3) NOT NULL,
primary key(prono)
);父表语句如下,也都有prono属性啊CREATE TABLE branch(
branchno varchar(4) NOT NULL,
street varchar(10) NOT NULL,
city varchar(7) NOT NULL,
postcode decimal(8,0) NOT NULL,
prono varchar(5) NOT NULL,
PRIMARY KEY (branchno),
FOREIGN KEY (prono) REFERENCES Property (prono)
) ;