CREATE TABLE CK
(
id int PRIMARY KEY,
number varchar(50),
place varchar(50),
area varchar(50),
)
CREATE TABLE SP
(
id int primary key,
number varchar(50),
name varchar(50),
price varchar(50),
ckid int,
constraint fk1 foreign key (ckid) references ck(id)
)
E-R图
That's all.
袁隆辉
