CREATE TABLE S(SNO CHAR(5) PRIMARY KEY,
SNAME CHAR(10),
STATUS SMALLINT,
CITY CHAR(10))
CREATE TABLE P(PNO CHAR(5) PRIMARY KEY,
PNAME CHAR(10),
COLOR CHAR (5),
WEIGHT INT)
CREATE TABLE J(JNO CHAR(5) PRIMARY KEY,
JNAME CHAR(10),
CITY CHAR(10))
CREATE TABLE SPJ(
SNO CHAR(5) FOREIGN KEY REFERENCES S(SNO),
PNO CHAR(5) FOREIGN KEY REFERENCES P(PNO),
JNP CHAR(5) FOREIGN KEY REFERENCES J(JNO),
QTY INT
);
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024