电脑销售数据库设计
aID CHAR(6), gID CHAR(6), sellQUA CHAR(10), sellTIME DATETIME,
PRIMARY KEY(sellID,aID,gID)
FOREIGN KEY (aID) REFERENCES assistant(aID), FOREIGN KEY (gID) REFERENCES goods(gID) ) 配送表:
CREATE TABLE Send (sendID CHAR(6), shID CHAR(6), sendNAME VARCHAR(10), sendQUA CHAR(10) sendTIME DATETIME, PRIMARY KEY(sendID,shID)
FOREIGN KEY (shID) REFERENCES shop(shID) ) 存储表:
CREATE TABLE Storage (sD CHAR(6), gID CHAR(6), storageQUA INT, storageTIME DATETIME, safetystorageQUA CHAR(10), PRIMARY KEY(sID,gID)
FOREIGN KEY (sID) REFERENCES store(sID),