【正文】 me] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Manufacturer] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [Model] [char](30) COLLATE Chinese_PRC_CI_AS NULL, [Standard] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [Quantity] [int] NOT NULL, [Date] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [SUName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [DeliverymanName] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Receipt_table] PRIMARY KEY CLUSTERED ( [ReceiptID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])： CREATE TABLE [dbo].[Outbound_table]( [OutboundID] [int] NOT NULL, [UserID] [int] NOT NULL, [TradeName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Manufacturer] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [Model] [char](30) COLLATE Chinese_PRC_CI_AS NULL, [Standard] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [Quantity] [int] NOT NULL, [Date] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [OUName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [PgName] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Outbound_table] PRIMARY KEY CLUSTERED ( [OutboundID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])： CREATE TABLE [dbo].[Lend_out_table]( [LendoutID] [int] NOT NULL, [UserID] [int] NOT NULL, [TradeName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Manufacturer] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [Model] [char](30) COLLATE Chinese_PRC_CI_AS NULL, [Standard] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [Quantity] [int] NOT NULL, [Borrowdate] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Returndate] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [LendersName] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Lend_out_table] PRIMARY KEY CLUSTERED ( [LendoutID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])： CREATE TABLE [dbo].[Goods_table]( [GoodsID] [int] NOT NULL, [TradeName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Manufacturer] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [Model] [char](30) COLLATE Chinese_PRC_CI_AS NULL, [Standard] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [Quantity] [int] NOT NULL, CONSTRAINT [PK_Goods_table] PRIMARY KEY CLUSTERED ( [GoodsID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])：CREATE TABLE [dbo].[Warehouse_keeper_table]( [WarehouseKeeperID] [int] NOT NULL, [WarehouseKeepername] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Sex] [char](16) COLLATE Chinese_PRC_CI_AS NOT NULL, [Age] [int] NOT NULL, [Tel] [char](16) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Warehouse_keeper_table] PRIMARY KEY CLUSTERED ( [WarehouseKeeperID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])：CREATE TABLE [dbo].[Storage_table]( [WarehouseID] [int] NOT NULL, [Trade name] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [GoodsID] [int] NULL, [Quantity] [int] NOT NULL, [Address] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Storage_table] PRIMARY KEY CLUSTERED ( [WarehouseID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])8. 索引用SQL語言建立的代碼ALTER TABLE [dbo].[Goods_table] ADD CONSTRAINT [PK_Goods_table] PRIMARY KEY CLUSTERED ( [GoodsID] ASC)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) 9. 管理員對用戶信息表的操作：① 插入SQL語言建立的代碼USE storageINSERT INTO Users VALUES(7,39。1. 能夠初始庫存設(shè)置，設(shè)置庫存的初始值，庫存的上下警戒線。數(shù)據(jù)流來源：用戶數(shù)據(jù)流組成：貨物編號+貨物品名+貨物規(guī)格+貨物數(shù)量+貨物售價+貨物種類+客戶類型+客戶編號+客戶名稱+本次出貨時間+貨物產(chǎn)地⑩數(shù)據(jù)流名稱：借出信息說明：銷售后即將出庫的貨物的信息數(shù)據(jù)流流向：倉庫情況管理說明：對倉庫中的所有貨物修改或查詢的信息數(shù)據(jù)流組成：貨物編號+貨物品名+貨物規(guī)格+貨物數(shù)量+貨物進價+貨物種類+客戶類型+客戶編號+客戶名稱+本次入庫時間+貨物產(chǎn)地④數(shù)據(jù)流名稱：貨物信息說明：即將裝入倉庫的貨物的信息 處理需求系統(tǒng)具有的功能模塊，：倉庫物資管理系統(tǒng)入庫信息管理庫存信息管理出庫信息管理借出信息管理圖1 系統(tǒng)總功能模塊圖 數(shù)據(jù)流圖及數(shù)據(jù)字