數(shù)據(jù)庫實(shí)用技術(shù)課程設(shè)計(jì)--倉庫管理系統(tǒng)(編輯修改稿)
2025-02-12 08:16 本頁面
【文章內(nèi)容簡介】 0) primary key NOT NULL,cangku_name varchar(10)NOT NULL,cangku_type varchar(10)NOT NULL,staff_no varchar(10)NOT NULL,foreign key(staff_no) references staff(staff_no),)Go庫存表create table cunhuo(cangku_no varchar(10),material_no varchar(10),qty bigint,primary key(cangku_no,material_no),foreign key(cangku_no) references cangku(cangku_no),foreign key(material_no) references material(material_no),)GO供應(yīng)商表create table supplier(supplier_no varchar(10),material_no varchar(10),supplier_name varchar(10)NOT NULL,supplier_phone char(15)NOT NULL,supplier_address varchar(50)NOT NULL,primary key(supplier_no,material_no),foreign key(material_no) references material(material_no),)GO進(jìn)倉表create table material_in(rudan_no int NOT NULL,supplier_no varchar(10) NOT NULL,material_no varchar(10) NOT NULL,in_data datetime NOT NULL,ru_qty bigint NOT NULL,supp_pay bigint NOT NULL,staff_no varchar(10) NOT NULL,foreign key(supplier_no,material_no) references supplier(supplier_no,material_no),foreign key(staff_no) references staff(staff_no),)GO客戶表create table kehu(kehu_no varchar(10) primary key NOT NULL,kehu_name varchar(10)NOT NULL,kehu_password varchar(10)NULL,kehu_phone char(15)NULL,kehu_address varchar(50),)GO出倉表create table material_out(chudan_no int NOT NULL,kehu_no varchar(10) NOT NULL,material_no varchar(10) NOT NULL,out_data datetime NOT NULL,chu_qty bigint NOT NULL,kehu_pay bigint NOT NULL,staff_no varchar(10) NOT NULL,foreign key(kehu_no) references kehu(kehu_no),foreign key(material_no) references material(material_no),foreign key(staff_no) references staff(staff_no),)GO盤庫表create table panku ( panku_no varchar(10) NOT NULL, staff_no varchar(10) NOT NULL,panku_date datetime, material_no varchar(10)NOT NULL, panku_qty bigint, foreign key(material_no) references material(material_no),foreign key(staff_no) references staff(staff_no), )Go建立進(jìn)出倉的存儲過程入倉:create procedure material_in_pro@rudan_no int,@supplier_no varchar(10),@material_no varchar(10),@in_data datetime,@ru_qty bigint,@supp_pay bigint,@staff_no varchar(10),@out varchar(20)=39。039。 outputas DECLARE @n1 int select @n1=count(material_no) from material where material_no=@material_no if (@n1=0) be
高考資料相關(guān)推薦
鄂ICP備17016276號-1