數(shù)據(jù)庫網(wǎng)上購物系統(tǒng)設(shè)計(jì)-文庫吧資料
2025-07-06 01:23本頁面
【正文】 nchar(10) not null, manufacturename nchar(10) not null, other nvarchar(20) not null,) go創(chuàng)建客戶信息表customerinfocreate table customerinfo( customerid nchar(10) primary key, name nvarchar(20) not null, sex nchar(1) not null, nchar(20) not null, postcode nchar(10) not null, phonenumber nchar(11) not null, address nvarchar(50) not null) go創(chuàng)建訂單信息表orderinfocreate table orderinfo( orderid nchar(10) primary key, customerid nchar(10) not null, orderdate datetime not null, taddress nvarchar(50) not null, foreign key (customerid) references customerinfo(customerid))go創(chuàng)建訂單明細(xì)信息表orderdetailinfocreate table orderdetailinfo( orderid nchar(10) not null, productid nchar(10) not null, quantity nchar(10) not null, totalprice nchar(20) not null, primary key (orderid,productid), foreign key (orderid) references orderinfo(orderid), foreign key (productid) references productinfo(productid))go創(chuàng)建生產(chǎn)廠商信息表manufactureinfocreate table manufactureinfo( manufactureid nchar(10) not null primary key , manufacturename nchar(26) not null, productid nchar(10) not null, foreign key (productid) references productinfo(productid)) go創(chuàng)建生產(chǎn)明細(xì)信息表producedetailinfocreate table producedetailinfo( manufactureid nchar(10) not null, productid nchar(10) not null, Pquantity nchar(10) not null, lquantity nchar(10) not null, primary key(manufactureid,productid), foreign key (manufactureid) references manufactureinfo (manufactureid), foreign key (productid) references productinfo(productid)) go創(chuàng)建評(píng)論信息表mentinfocreate table mentinfo( mentid nchar(10) not null primary key , ment
畢業(yè)設(shè)計(jì)相關(guān)推薦
鄂ICP備17016276號(hào)-1