數(shù)據(jù)庫課程設(shè)計-物資管理系統(tǒng)設(shè)計-全文預(yù)覽
【正文】 op table [dbo].[msurplus] GO if exists (select * from where id = object_id(N39。) = 1) drop table [dbo].[muse] GO CREATE TABLE [dbo].[material] ( [wzid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [wzname] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [wzspec] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [wzkind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [wzunit] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[msave] ( [rkno] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL , [rkid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [rkname] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [rkspec] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [rkkind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [rkunit] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [rkaccount] [numeric](5, 0) NOT NULL , [rkprice] [numeric](8, 2) NOT NULL , [rkvalue] [numeric](10, 2) NOT NULL , [rkdate] [datetime] NOT NULL , [rkdeal_person] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [rksave_person] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [rkbase] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [rkmemo] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[msurplus] ( [yeid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [yename] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [yespec] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [yekind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [yeunit] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [yeaccount] [numeric](5, 0) NOT NULL , [yevalue] [numeric](10, 2) NOT NULL , [yebase] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [yememo] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[muse] ( [lyno] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL , [lyid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [lyname] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [lyspec] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [lykind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [lyunit] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [lyaccount] [numeric](5, 0) NOT NULL , [lyprice] [numeric](8, 2) NULL , [lyvalue] [numeric](10, 2) NULL , [lydate]
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1