數(shù)據(jù)庫原理及應(yīng)用課程設(shè)計(jì)-庫存管理系統(tǒng)-文庫吧資料
2024-09-01 12:39本頁面
【正文】 varchar(50) not null, TypeId int, Pstyle varchar(50), Punit varchar(10), Pprice decimal(15,2), Plow int, Phigh int, 12 Valid int, AlarmDays int ) Go （ 7）創(chuàng)建入庫操作信息表 StoreIn create table StoreIn ( SiType varchar(20), Pid int, MakeDate char(10), Pprice decimal(15,2), Pnum int, Cid int, Sid int, EmpName varchar(50), OptDate char(10), CONSTRAINT PK_STOREIN PRIMARY KEY ClUSTERED(Cid,Pid,Sid), CONSTRAINT FK_STOREIN_CLIENT FOREIGN KEY(Cid) REFERENCES Client(Cid), CONSTRAINT FK_STOREIN_PRODUCT FOREIGN KEY(Pid) REFERENCES Product(Pid), CONSTRAINT FK_STOREIN_STORE FOREIGN KEY(Sid) REFERENCES Storehouse(Sid)) Go （ 8）創(chuàng)建出 庫 操作信息表 TakeOut create table TakeOut ( Ttype varchar(20) not null, Pid int, Pprice decimal(15,2), Pnum int, Cid int, Sid int, EmpName varchar(50), OptDate char(20), CONSTRAINT PK_TAKEOUOT PRIMARY KEY ClUSTERED(Cid,Pid,Sid), CONSTRAINT FK_TAKEOUT_CLIENT FOREIGN KEY(Cid) REFERENCES Client(Cid), CONSTRAINT FK_TAKEOUT_PRODUCT FOREIGN KEY(Pid) REFERENCES Product(Pid), CONSTRAINT FK_TAKEOUT_STORE FOREIGN KEY(Sid) REFERENCES Storehouse(Sid)) （ 9）創(chuàng)建庫存產(chǎn)品信息表 ProInStore create table ProInStore ( SpId int primary key CLUSTERED, 13 Pid int not null, Pprice decimal(15,2), Pnum int, MakeDate char(10), Sid int ) Go （ 10） 創(chuàng)建存儲(chǔ)過程實(shí)現(xiàn)插入、刪除、更新 //存儲(chǔ)過程實(shí)現(xiàn)客戶信息表 Client 的信息插入 CREATE proc Client_insert Cname varchar(50), Ctype tinyint, Contact varchar(30), Address varchar(50), Postcode varchar(10), Phone varchar(30), Fax varchar(30), Memo varchar(100) as insert into Client values(Cname,Ctype,Contact,Address,Postcode,Phone,Fax,Memo) GO //存儲(chǔ)過程實(shí)現(xiàn)客戶信息表 Client 的信息
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1