电脑销售数据库设计
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),
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读,免费范文网,提供经典小说教育文库数据库课程设计之电脑销售信息管理系统(18)在线全文阅读。
相关推荐: